There should be a way to get the schema for a datasource

[matt2e]

Basically I want dbmate dump though it looks like we'd also need a db client to calculate it.

We should also expose this to goose to avoid this:

Let me also check the SQL files to see the database schema and queries:
─── shell | developer ──────────────────────────
command: ls -R /Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb


queries
schema

/Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb/queries:
queries.sql

/Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb/schema:
20241103205514_init.sql
20241103205515_init.sql
20241103205516_init.sql
20241103205517_init.sql


Let me check the queries and schema:
─── Read | ftl ─────────────────────────
path: ...


Read contents of /Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb/queries/queries.sql

─── Read | ftl ──────────────────────────
path: ...


Read contents of /Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb/schema/20241103205517_init.sql

─── Read | ftl ──────────────────────────
path: ...


Read contents of /Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb/schema/20241103205516_init.sql

─── Read | ftl ──────────────────────────
path: ...


Read contents of /Users/mtoohey/Code/ftl/examples/go/mysql/db/mysql/testdb/schema/20241103205515_init.sql

─── Read | ftl ──────────────────────────
path: ...

[stuartwdouglas]

I think we would also want this to work for prod clusters, which complicates things as I don't think we would want to connect to the DB to do this dump.

One option would be to store it on the database as runtime metadata and just have the provisioner populate it, which would be cool but could start to bloat the schema size for large databases.

[bradleydwyer]

Look at https://github.com/sqldef/sqldef