baking...

• add intermediate representation step
  • write representation during introspect
  • read representation during generate
  • define & validate json schema in both cases
• add command line interface using cobra
• improve error handle / error message reporting
• add support for insert batching
• add ability to anotate table fields
• add support for foreign keys (1:1, 1:N, N:M)
• add support for composite primary keys
• add support for composite foregin keys
• paralelise value generating (v1 - just use number of CPUs and split the workload)
• paralelise value generating (v2 - add configurable number of parallel generators and db connections - batching X goroutines)
• add test suite (integration test with live postgres via docker & test containers)
• add charmbracelet to improve the user experience while waiting
• add support for additional/missing PostgreSQL types (e.g., serial, bigserial, numeric, money, json, jsonb, bytea, inet, cidr, macaddr, bit, bit varying, interval, arrays, enums, geometric, range, xml, OID types)

1. Start a local Postgres instance and initialize it with test/init/init-tables.sql (already done by docker-compose).
2. Run the introspection step to generate the recipe (replace credentials as needed):

dbaker introspect \
  --host localhost \
  --port 5432 \
  --database postgres \
  --username postgres \
  --password password \
  --tables public.users \
  --tables public.groups \
  --tables public.numbers_test \
  --tables public.special_test \
  --tables public.datetime_test

3. Generate and insert fake data into the tables:

dbaker generate \
  --host localhost \
  --port 5432 \
  --database postgres \
  --username postgres \
  --password password \
  --size 100

This will introspect the schema and populate the supported test tables with fake data.