5.1: adjust gitlab ci pipeline configuring to include checks and tests, re #2116biest-02063

Merge request studip/studip!1372

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