Warning, file /sdk/codevis/thirdparty/soci/scripts/ci/before_build_mysql.sh was not indexed or was modified since last indexation (in which case cross-reference links may be missing, inaccurate or erroneous).

0001 #!/usr/bin/env bash
0002 # Sets up environment for SOCI backend MySQL in CI builds
0003 #
0004 # Mateusz Loskot <mateusz@loskot.net>, http://github.com/SOCI
0005 #
0006 source ${SOCI_SOURCE_DIR}/scripts/ci/common.sh
0007 
0008 SOCI_MYSQL_USER=$(id -un)
0009 
0010 if [ -n "${SOCI_MYSQL_ROOT_PASSWORD}" ]; then
0011     sudo systemctl start mysql.service
0012     SOCI_MYSQL_PASSWORD_OPT="-p${SOCI_MYSQL_ROOT_PASSWORD}"
0013     mysql -u root ${SOCI_MYSQL_PASSWORD_OPT} -e "CREATE USER '${SOCI_MYSQL_USER}';"
0014 fi
0015 
0016 mysql --version
0017 mysql -u root ${SOCI_MYSQL_PASSWORD_OPT} -e "CREATE DATABASE soci_test;"
0018 mysql -u root ${SOCI_MYSQL_PASSWORD_OPT} -e "GRANT ALL PRIVILEGES ON soci_test.* TO '${SOCI_MYSQL_USER}'@'%';";
0019 
0020 # This is necessary for MySQL stored procedure unit test to work.
0021 mysql -u root ${SOCI_MYSQL_PASSWORD_OPT} -e "SET GLOBAL log_bin_trust_function_creators=1";
0022 
0023 echo 'Testing connection to the database:'
0024 echo 'SELECT USER();' | mysql --database=soci_test