Synthesized TDK MySQL Demo

Sakila is a sample database schema that can be used in MySQL tutorials, articles, demos, etc.

Clone this repo:

git clone https://github.com/synthesized-io/pagila-tdk-demo
cd pagila-tdk-demo/mysql

Generation based on the empty schema

Run TDK:

export CONFIG_FILE=config_generation_from_scratch.tdk.yaml
docker compose run tdk

Check the ORIGINAL database with control sql-query:

usql mysql://root:admin@localhost:6000/sakila -f control_query.sql

Check the RESULTED database with control sql-query:

usql mysql://root:admin@localhost:6001/sakila -f control_query.sql

Run TDK:

export CONFIG_FILE=config_generation.tdk.yaml
docker compose -f docker-compose.yaml -f docker-compose-input-db.yaml run tdk

Check the ORIGINAL database with control sql-query:

usql mysql://root:admin@localhost:6000/sakila -f control_query.sql

Check the RESULTED database with control sql-query:

usql mysql://root:admin@localhost:6001/sakila -f control_query.sql

Run TDK:

export CONFIG_FILE=config_masking.tdk.yaml
docker compose -f docker-compose.yaml -f docker-compose-input-db.yaml run tdk

Check the ORIGINAL database with control sql-query:

usql mysql://root:admin@localhost:6000/sakila -f control_query.sql

Check the RESULTED database with control sql-query:

usql mysql://root:admin@localhost:6001/sakila -f control_query.sql

Run TDK using Docker image:

export CONFIG_FILE=config_subsetting.tdk.yaml
docker compose -f docker-compose.yaml -f docker-compose-input-db.yaml run tdk

Check the ORIGINAL database with control sql-query:

usql mysql://root:admin@localhost:6000/sakila -f control_query.sql

Check the RESULTED database with control sql-query:

usql mysql://root:admin@localhost:6001/sakila -f control_query.sql