sqlmigrate

func DumpSchema ¶

func DumpSchema(db *sql.DB) (string, error)

DumpSchema returns a normalized, deterministic description of db's user-visible schema: one line per table column and per index. Built for the per-store schema-identity tests (goose-migrated database ≡ schema.sql), which is what keeps sqlc's input honest against what actually runs.

Tables are described structurally (pragma_table_info) because SQLite rewrites a table's stored CREATE text on every ALTER, making text comparison meaningless once real migrations exist. Index DDL is never rewritten, so indexes compare by normalized statement text — which also covers partial-index WHERE clauses that pragmas can't see. CHECK constraints are invisible to both views; the Atlas sync check in CI (`make migrations-check`) covers those semantically.

func Up ¶

func Up(ctx context.Context, db *sql.DB, migrations fs.FS) error

Up applies every pending migration to db, in order. migrations must be a filesystem whose root contains the goose-format .sql files. Safe to call on every open: applied versions are tracked per-migration in the goose_db_version table, so reruns are no-ops.