@ECHO OFF
SETLOCAL

WHERE azure >nul 2>nul
IF %ERRORLEVEL% NEQ 0 ECHO Check if you have installed the `azure` CLI

WHERE mssql >nul 2>nul
IF %ERRORLEVEL% NEQ 0 ECHO Check if you have installed the `azure` CLI


SET AZURE_STORAGE_ACCOUNT=<acc-name>
SET AZURE_STORAGE_ACCESS_KEY=<acc-key>
SET AZURE_SQL_SERVER=<sql-server>
SET AZURE_SQL_USER=<sql-user>
SET AZURE_SQL_PASS=<sql-pass>
SET AZURE_SQL_DB=<sql-db>
SET BLOB_CONTAINER=session-states

REM azure storage blob download %BLOB_CONTAINER% lol.png

mssql -s %AZURE_SQL_SERVER% -u %AZURE_SQL_USER% -p %AZURE_SQL_PASS% -d %AZURE_SQL_DB% -e