Bash script to start a local MS SQL Server

mssql.sh

#!/usr/bin/env bash

set -euo pipefail
shopt -s globstar
# for extended case patterns:
shopt -s extglob

echo_pretty() {
    echo ">>> $(tput setaf 2)$1$(tput sgr0)"
}
echo_error() {
    echo ">>> $(tput setaf 1)$1$(tput sgr0)"
}
echo_warn() {
    echo ">>> $(tput setaf 3)$1$(tput sgr0)"
}

######################
#    Configuration   #
######################

if [ "$MODE" = "test" ]; then
  MSSQL_PORT=31433
else
  MSSQL_PORT=21433
fi

MSSQL_RUNNING=0
MSSQL_HOST=127.0.0.1
MSSQL_PASSWORD=hasuraMSSQL1
MSSQL_VOLUME_NAME='hasura-dev-mssql'
MSSQL_CONTAINER_NAME="hasura-dev-mssql-$MSSQL_PORT"
# shellcheck disable=SC2034  # this variable is used in scripts sourcing this one
MSSQL_CONN_STR="DRIVER={ODBC Driver 18 for SQL Server};Server=$MSSQL_HOST,$MSSQL_PORT;Uid=sa;Pwd=$MSSQL_PASSWORD;TrustServerCertificate=true"

if [[ "$(uname -m)" == 'arm64' ]]; then
  MSSQL_PLATFORM=linux/arm64
  MSSQL_CONTAINER_IMAGE=mcr.microsoft.com/azure-sql-edge
else
  MSSQL_PLATFORM=linux/amd64
  MSSQL_CONTAINER_IMAGE=mcr.microsoft.com/mssql/server:2019-latest
fi

######################
#     Functions      #
######################

function mssql_launch_container {
  echo_pretty "Launching MSSQL container: $MSSQL_CONTAINER_NAME"
  docker volume create "$MSSQL_VOLUME_NAME"
  docker run \
    --name $MSSQL_CONTAINER_NAME \
    --platform "$MSSQL_PLATFORM" \
    --publish="${MSSQL_HOST}:${MSSQL_PORT}:1433" \
    --volume="${MSSQL_VOLUME_NAME}:/var/opt/mssql" \
    --env=ACCEPT_EULA=1 \
    --env="MSSQL_SA_PASSWORD=$MSSQL_PASSWORD" \
    --detach \
    "$MSSQL_CONTAINER_IMAGE"
}

function mssql_wait {
  echo -n "Waiting for mssql to come up"
  until ( docker run --rm -it --net=host mcr.microsoft.com/mssql-tools /opt/mssql-tools/bin/sqlcmd -S "${MSSQL_HOST},${MSSQL_PORT}" -U SA -P "$MSSQL_PASSWORD" -Q 'SELECT 1' ) &>/dev/null; do
    echo -n '.' && sleep 0.2
  done
  echo " Ok"
}

function mssql_start {
  if [ $MSSQL_RUNNING -eq 0 ]; then
    mssql_launch_container
    MSSQL_RUNNING=1
    mssql_wait
  fi
  echo_pretty "MSSQL running...connection string: $MSSQL_CONN_STR"
}

function mssql_cleanup {
  echo_pretty "Removing $MSSQL_CONTAINER_NAME and its volumes in 5 seconds!"
  echo_pretty "  PRESS CTRL-C TO ABORT removal of all containers, or ENTER to clean up right away"
  read -rt5 || true
  docker stop "$MSSQL_CONTAINER_NAME"
  docker rm -v "$MSSQL_CONTAINER_NAME"
  docker volume rm "$MSSQL_VOLUME_NAME"
}

Usage:

$ source mssql.sh
$ mssql_start