diff options
Diffstat (limited to '.gitlab')
| -rw-r--r-- | .gitlab/scripts/install_db.sh | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/.gitlab/scripts/install_db.sh b/.gitlab/scripts/install_db.sh new file mode 100644 index 0000000..0f2f554 --- /dev/null +++ b/.gitlab/scripts/install_db.sh @@ -0,0 +1,29 @@ +#!/bin/bash +set -e + +if [ $(mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE -e "show tables;" --batch | wc -l) -eq 0 ]; then + + # Setup mysql database + echo "INSTALL DB" + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip.sql + echo "INSTALL DEFAULT DATA" + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip_default_data.sql + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip_resources_default_data.sql + + echo "INSTALL ROOTUSER" + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip_root_user.sql + + # Check if demodata is required + if [ ! -z $DEMO_DATA ]; then + echo "INSTALL DEMODATA" + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip_demo_data.sql + echo "INSTALL MVV_DEMODATA" + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip_mvv_demo_data.sql + echo "INSTALL RESOURCES-DEMODATA" + mysql -f -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE < ./db/studip_resources_demo_data.sql + fi + + echo "INSTALLATION FINISHED" +else + echo "Found some SQL table. Skipping installation" +fi |