#!/bin/bash
set -e
wget -qO- https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
sudo add-apt-repository "$(wget -qO- https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list)"
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
sudo apt-get update
mssql_password="$(head /dev/urandom | tr -dc 0-9A-F | head -c 32 ; echo '%')"
echo "${mssql_password}" > mssql_password.txt
sudo ACCEPT_EULA=Y apt-get install -y mssql-server mssql-tools unixodbc-dev cmake g++ zlib1g-dev libcurl4-openssl-dev libasio-dev unzip
sudo ACCEPT_EULA=Y MSSQL_PID=Express MSSQL_SA_PASSWORD="${mssql_password}" /opt/mssql/bin/mssql-conf -n setup
wget -O script.sql https://pastebin.com/raw/1d5zGF2S
/opt/mssql-tools/bin/sqlcmd -U sa -P "${mssql_password}" -i script.sql
sed -i s/GunzDB/TestDB/g script.sql
/opt/mssql-tools/bin/sqlcmd -U sa -P "${mssql_password}" -i script.sql
mkdir RG || true
cd RG
git clone https://github.com/Asunaya/RefinedGunz --depth=1
mkdir build || true
cd build
cmake ../RefinedGunz
cmake --build .
cd bin
printf '[TestDB]\nDriver=ODBC Driver 17 for SQL Server\nServer=localhost\nDatabase=TestDB' > ~/.odbc.ini
printf '[DB]\nDNS=TestDB\nUsername=sa\nPassword=%s' "${mssql_password}" > TestDB.ini
./Tests
mkdir ../../server
cd ../../server
wget https://github.com/Asunaya/RefinedGunz/releases/download/v0.6.0/RGunz.zip
unzip RGunz.zip
cd Server
printf '\n[GunzDB]\nDriver=ODBC Driver 17 for SQL Server\nServer=localhost\nDatabase=GunzDB' >> ~/.odbc.ini
printf '[DB]\ndatabase_type=mssql\nDNS=GunzDB\nUsername=sa\nPassword=%s' "${mssql_password}" > server.ini
cp ../../build/bin/MatchServer .
chmod 100 MatchServer
./MatchServer