mirror of
https://github.com/therootcompany/golib.git
synced 2026-11-04 06:55:00 +00:00
AJ ONeal
de227bcaaf
Example CLI todo app demonstrating sqlmigrate + pgmigrate for running migrations directly via pgx/v5 instead of shelling out to psql. Uses embed.FS for migration files, auto-migrates on startup, and includes full CRUD for todos and folders with sqlc-ready query files.
8 lines
210 B
SQL
8 lines
210 B
SQL
-- add-todo-fields (down)
|
|
|
|
ALTER TABLE todos DROP COLUMN IF EXISTS priority;
|
|
ALTER TABLE todos DROP COLUMN IF EXISTS completed_at;
|
|
|
|
-- leave this as the last line
|
|
DELETE FROM _migrations WHERE id = 'd4e5f6a7';
|