#!/bin/bash

/opt/mssql/bin/sqlservr &
/scripts/wait-for-it.sh 127.0.0.1:1433

for i in {1..50};
do
    /opt/mssql-tools18/bin/sqlcmd -C -S localhost -U sa -P $SA_PASSWORD -d master -Q "CREATE DATABASE openfire;"
    /opt/mssql-tools18/bin/sqlcmd -C -S localhost -U sa -P $SA_PASSWORD -d openfire -i /openfiredb/openfire_sqlserver.sql
    if [ $? -eq 0 ]
    then
        echo "openfire sql import"
        break
    else
        echo "not ready yet..."
        sleep 1
    fi
    if [ $i -eq 50 ]
    then
	echo "Aborting after 50 failed attempts"
	exit 1
    fi
done

sleep infinity # Keep the container running forever