49 lines
1.3 KiB
Bash
Executable File
49 lines
1.3 KiB
Bash
Executable File
#!/bin/bash
|
|
set -eo pipefail
|
|
|
|
dir="$(dirname "$(readlink -f "$BASH_SOURCE")")"
|
|
|
|
image="$1"
|
|
|
|
serverImage="$("$dir/../image-name.sh" librarytest/mysql-initdb "$image")"
|
|
"$dir/../docker-build.sh" "$dir" "$serverImage" <<EOD
|
|
FROM $image
|
|
COPY dir/initdb.sql /docker-entrypoint-initdb.d/
|
|
EOD
|
|
|
|
export MYSQL_ROOT_PASSWORD='this is an example test password'
|
|
export MYSQL_USER='0123456789012345' # "ERROR: 1470 String 'my cool mysql user' is too long for user name (should be no longer than 16)"
|
|
export MYSQL_PASSWORD='my cool mysql password'
|
|
export MYSQL_DATABASE='my cool mysql database'
|
|
|
|
cname="mysql-container-$RANDOM-$RANDOM"
|
|
cid="$(
|
|
docker run -d \
|
|
-e MYSQL_ROOT_PASSWORD \
|
|
-e MYSQL_USER \
|
|
-e MYSQL_PASSWORD \
|
|
-e MYSQL_DATABASE \
|
|
--name "$cname" \
|
|
"$serverImage"
|
|
)"
|
|
trap "docker rm -vf $cid > /dev/null" EXIT
|
|
|
|
mysql() {
|
|
docker run --rm -i \
|
|
--link "$cname":mysql \
|
|
--entrypoint sh \
|
|
-e MYSQL_PWD="$MYSQL_PASSWORD" \
|
|
"$image" \
|
|
-euc 'if command -v mariadb > /dev/null; then exec mariadb "$@"; else exec mysql "$@"; fi' -- \
|
|
-hmysql \
|
|
-u"$MYSQL_USER" \
|
|
--silent \
|
|
"$@" \
|
|
"$MYSQL_DATABASE"
|
|
}
|
|
|
|
. "$dir/../../retry.sh" --tries 30 "echo 'SELECT 1' | mysql"
|
|
|
|
[ "$(echo 'SELECT COUNT(*) FROM test' | mysql)" = 1 ]
|
|
[ "$(echo 'SELECT c FROM test' | mysql)" = 'goodbye!' ]
|