run.sh 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. #!/bin/bash
  2. set -eo pipefail
  3. dir="$(dirname "$(readlink -f "$BASH_SOURCE")")"
  4. image="$1"
  5. export MYSQL_ROOT_PASSWORD='this is an example test password'
  6. export MYSQL_USER='0123456789012345' # "ERROR: 1470 String 'my cool mysql user' is too long for user name (should be no longer than 16)"
  7. export MYSQL_PASSWORD='my cool mysql password'
  8. export MYSQL_DATABASE='my cool mysql database'
  9. VERSION=$(docker run --rm "$image" --version | awk '{print$3}')
  10. if [[ $VERSION =~ ^5.[56] ]]; then
  11. echo [skipped] no RocksDB support in 5.5, 5.6
  12. exit 0
  13. fi
  14. cname="mysql-container-$RANDOM-$RANDOM"
  15. cid="$(
  16. docker run -d \
  17. -e INIT_ROCKSDB=1 \
  18. -e MYSQL_ROOT_PASSWORD \
  19. -e MYSQL_USER \
  20. -e MYSQL_PASSWORD \
  21. -e MYSQL_DATABASE \
  22. --name "$cname" \
  23. "$image"
  24. )"
  25. trap "docker rm -vf $cid > /dev/null" EXIT
  26. mysql() {
  27. docker run --rm -i \
  28. --link "$cname":mysql \
  29. --entrypoint mysql \
  30. -e MYSQL_PWD="$MYSQL_PASSWORD" \
  31. "$image" \
  32. -hmysql \
  33. -u"$MYSQL_USER" \
  34. --silent \
  35. "$@" \
  36. "$MYSQL_DATABASE"
  37. }
  38. . "$dir/../../retry.sh" --tries 20 "echo 'SELECT 1' | mysql"
  39. echo 'CREATE TABLE test (a INT, b INT, c VARCHAR(255)) ENGINE=RocksDB' | mysql
  40. [ "$(echo 'SELECT COUNT(*) FROM test' | mysql)" = 0 ]