migrations

Overview ¶

Package migrations embeds the SQL migration files used by goose to manage the sqi-server SQLite schema.

The embedded FS is passed to goose via [goose.SetBaseFS] so that migration files are included in the binary and do not need to be present on disk at runtime.

Migration files follow the goose naming convention:

<version>_<description>.sql

where <version> is a zero-padded integer and each file contains "-- +goose Up" and "-- +goose Down" sections.

The full schema lives in the numbered migration files; this package is wired up by the migrate subcommand so the CLI is operational from the start.