add gitlab-ci, closes #606

Closes #606

Merge request studip/studip!574

1 files changed, 25 insertions, 0 deletions

diff --git a/.gitlab/scripts/install_db.sh b/.gitlab/scripts/install_db.sh
new file mode 100644
index 0000000..e6cce3b
--- /dev/null
+++ b/.gitlab/scripts/install_db.sh
@@ -0,0 +1,25 @@
+#!/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
+    fi
+
+    echo "INSTALLATION FINISHED"
+else
+    echo "Found some SQL table. Skipping installation"
+fi
\ No newline at end of file