11 lines
682 B
Bash
Executable File
11 lines
682 B
Bash
Executable File
# This script creates lots of tables in a database. It is used to test the handling of large schemas.
|
|
# Pre-requisite: follow https://airbyte.com/tutorials/postgres-replication to create the source container.
|
|
|
|
for i in {1..15000}
|
|
do
|
|
docker exec -it airbyte-source psql -U postgres -c "CREATE TABLE users$i(id SERIAL PRIMARY KEY, col1 VARCHAR(200));";
|
|
docker exec -it airbyte-source psql -U postgres -c "INSERT INTO public.users$i(col1) VALUES('record1');";
|
|
docker exec -it airbyte-source psql -U postgres -c "INSERT INTO public.users$i(col1) VALUES('record2');";
|
|
docker exec -it airbyte-source psql -U postgres -c "INSERT INTO public.users$i(col1) VALUES('record3');";
|
|
done
|