content-templates/templates/Commerce.Empty/Docker/create-db.sh at ff3241f81780a73bc66f3c68fffae5ba7ef92c06 · cherie-optimizely/content-templates · GitHub

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
33
34
35
#!/bin/bash

echo "Creating databases..."

let cmsresult=1
let commerceresult=1

for i in {1..100}; do
    if test -f /var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME}.mdf; then
        echo "Restoring CMS DB from .mdf/.ldf"

        /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "$SA_PASSWORD" -Q "IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = '${DB_NAME}') CREATE DATABASE [${DB_NAME}] ON (NAME=[${DB_NAME}_data], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME}.mdf') LOG ON (NAME=[${DB_NAME}_log], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME}_log.ldf') FOR ATTACH;" -C
        let cmsresult=$?
    else
        /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "$SA_PASSWORD" -Q "IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = '${DB_NAME}') CREATE DATABASE [${DB_NAME}] ON (NAME=[${DB_NAME}_data], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME}.mdf') LOG ON (NAME=[${DB_NAME}_log], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME}_log.ldf');" -C
        let cmsresult=$?
    fi

    if test -f /var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME_COMMERCE}.mdf; then
        echo "Restoring Commerce DB from .mdf/.ldf"
        /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "$SA_PASSWORD" -Q "IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = '${DB_NAME_COMMERCE}') CREATE DATABASE [${DB_NAME_COMMERCE}] ON (NAME=[${DB_NAME_COMMERCE}_data], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME_COMMERCE}.mdf') LOG ON (NAME=[${DB_NAME_COMMERCE}_log], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME_COMMERCE}_log.ldf') FOR ATTACH;" -C
        let commerceresult=$?
    else
        /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "$SA_PASSWORD" -Q "IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = '${DB_NAME_COMMERCE}') CREATE DATABASE [${DB_NAME_COMMERCE}] ON (NAME=[${DB_NAME_COMMERCE}_data], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME_COMMERCE}.mdf') LOG ON (NAME=[${DB_NAME_COMMERCE}_log], FILENAME='/var/opt/mssql/host_data/${DB_DIRECTORY}/${DB_NAME_COMMERCE}_log.ldf')" -C
        let commerceresult=$?
    fi

    if [ $cmsresult -eq 0 ] && [ $commerceresult -eq 0 ]; then
        echo "Creating databases completed"
        break
    else
        echo "Creating databases. Not ready yet..."
        sleep 1
    fi
done