Splicer: A beat sequencer

pull docker container with sql server

docker pull microsoft/mssql-server-linux:2017-latest

start docker container (1433 host port/ 1535 container port)

sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=internship_user'
-p 1535:1433 --name sql1
-d microsoft/mssql-server-linux:2017-latest

view docker containers

docker ps -a

change sa user's password

sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd
-S localhost -U sa -P 'intership_user'
-Q 'ALTER LOGIN SA WITH PASSWORD="internship_user_NEW_PASSWORD"'

connect to sql server

docker exec -it sql1 'bash'

connect inside the container with sqlcmd

/opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'internship_user'

working with sql from terminal (type GO after each statement)

CREATE DATABASE InternshipProject
USE InternshipProject

SELECT Name from sys.Databases
SELECT Name from sys.Tables

CREATE TABLE test ( id INT, name NVARCHAR(50), quantity INT )
CREATE TABLE audio ( id INT IDENTITY(1,1) PRIMARY KEY, name NVARCHAR(50), blobdata VARBINARY(MAX))
INSERT INTO test values (1, 'sasha', 10)
GO

exit from sql terminal

quit exit

remove container

docker stop sql1
docker rm sql1

remove docker image

docker images -a
docker rmi <hashid>

copy files from your machine to docker container

cd /backend/db_scripts
tar -c * | docker exec -i sql1 /bin/tar -C /tmp -x

how to run the script from the docker container with bash

move in /tmp folder where the files where copied and run

../opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'P@ssw0rd' -i ./UpdateDb.sql

make a shell script to run this automatically

1. apt-get update (to update linux advance package tool)
2. apt-get install vim
3. use vim to write in the seed.sh script file: '../opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P 'internship_user' -i ./UpdateDb.sql' command
4. chmod +x seed.sh (to give permission to execute file)
5. run the files: ./script.sh