-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathdb-updates.sh
More file actions
executable file
·16 lines (12 loc) · 2.12 KB
/
Copy pathdb-updates.sh
File metadata and controls
executable file
·16 lines (12 loc) · 2.12 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
#!/usr/bin/env bash
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "update customer set name = 'Customer 1' where id = 1;"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "update customer set name = 'customer 2' where id = 2;"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "insert into customer (name) values ('Insert Customer');"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "update sale set total = 1550 where id = 1;"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "update sale set total = 3000 where id = 2;"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "delete from customer where id = 4;"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "INSERT INTO sale (customer_id, identifier, product, total) VALUES ((select id from customer where name = 'Customer 3'), '1010', 'Product Z', 200);"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "INSERT INTO sale (customer_id, identifier, product, total) VALUES ((select id from customer where name = 'Customer 3'), '1011', 'Product Y', 100.15);"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "INSERT INTO sale (customer_id, identifier, product, total) VALUES ((select id from customer where name = 'Customer 3'), '1012', 'Product Z', 110);"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "INSERT INTO sale (customer_id, identifier, product, total) VALUES ((select id from customer where name = 'Insert Customer'), '1092', 'Product Y', 2000);"
docker exec -it db /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P '!Password1' -d 'salesCdc' -Q "INSERT INTO sale (customer_id, identifier, product, total) VALUES ((select id from customer where name = 'Insert Customer'), '1092', 'Product Y', 3000);"