aboutsummaryrefslogtreecommitdiff
path: root/.gitlab/scripts/install_db.sh
blob: 60939425db70bafb35b38675fcc7dd7116c34ee7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
#!/bin/bash
set -e

importSQLFile() {
    mysql --default-character-set=utf8mb4\
        --init-command="SET NAMES UTF8;"\
        -u $MYSQL_USER\
        -h $MYSQL_HOST\
        -p$MYSQL_PASSWORD\
        $MYSQL_DATABASE\
        < $1

}

if [ $(mysql -u $MYSQL_USER -h $MYSQL_HOST -p$MYSQL_PASSWORD $MYSQL_DATABASE -e "show tables;" --batch | wc -l) -eq 0 ]; then

    # Check if demodata is required
    if [ ! -z $DEMO_DATA ]; then
        echo "INSTALL DEMODATA"
        importSQLFile ./db/studip-demo-installation.sql
    else
        echo "INSTALL DB"
        importSQLFile ./db/studip-basic-installation.sql

        echo "INSTALL ROOTUSER"
        importSQLFile ./db/studip-root-user.sql
    fi

    echo "INSTALLATION FINISHED"
else
    echo "Found some SQL table. Skipping installation"
fi