回答編集履歴
1
シェル変数定義したのに使ってないところがあったので修正。誤字訂正。
test
CHANGED
|
@@ -65,10 +65,10 @@
|
|
|
65
65
|
echo "INSERT INTO User SELECT cast((cast(id as signed)+${num}) as char), concat('UserName', cast((cast(id as signed)+${num}) as char)) FROM User;"
|
|
66
66
|
num=$(echo $num + $num | bc)
|
|
67
67
|
done >>hoge.sql
|
|
68
|
-
echo "INSERT INTO Question VALUES(NULL, '1', 'QustionContent1');" >>hoge.sql
|
|
68
|
+
echo "INSERT INTO Question VALUES(NULL, '1', 'QuestionContent1');" >>hoge.sql
|
|
69
69
|
num=1
|
|
70
70
|
for i in $(seq 19); do
|
|
71
|
-
echo "INSERT INTO Question select NULL, cast(mod(id+${num}-1, 262144)+1 as char), concat('QustionContent', cast(id+${num} as char)) from Question;"
|
|
71
|
+
echo "INSERT INTO Question select NULL, cast(mod(id+${num}-1, 262144)+1 as char), concat('QuestionContent', cast(id+${num} as char)) from Question;"
|
|
72
72
|
num=$(echo $num + $num | bc)
|
|
73
73
|
done >>hoge.sql
|
|
74
74
|
echo "INSERT INTO Answer VALUES(NULL, 1, 1, 'AnswerContent1');" >>hoge.sql
|
|
@@ -91,14 +91,14 @@
|
|
|
91
91
|
EOF
|
|
92
92
|
docker run -d --rm --name hoge_mysql -v $(pwd)/data:/var/lib/mysql -v $(pwd):/home/mysql -e MYSQL_ROOT_PASSWORD=${PASS} mysql:8
|
|
93
93
|
docker exec -i -w /home/mysql hoge_mysql bash <<EOF
|
|
94
|
-
while ! mysql -u root --password=
|
|
94
|
+
while ! mysql -u root --password=${PASS} </dev/null;do
|
|
95
95
|
sleep 1
|
|
96
96
|
done
|
|
97
|
-
mysql -u root --password=
|
|
97
|
+
mysql -u root --password=${PASS} --verbose --table <<EOF2
|
|
98
98
|
create database hoge;
|
|
99
99
|
exit;
|
|
100
100
|
EOF2
|
|
101
|
-
LC_CTYPE=C.UTF-8 mysql -u root --password=
|
|
101
|
+
LC_CTYPE=C.UTF-8 mysql -u root --password=${PASS} --database=hoge --verbose --table <hoge.sql
|
|
102
102
|
exit
|
|
103
103
|
EOF
|
|
104
104
|
docker stop hoge_mysql
|