root/golib

mirror of https://github.com/therootcompany/golib.git synced 2026-11-04 06:55:00 +00:00

History

feat(sqlmigrate): match applied migrations by name or ID

Add ID field to Migration (parsed from INSERT INTO _migrations in Collect),
AppliedMigration type with ID+Name, and update Migrator.Applied() to return
[]AppliedMigration across all 5 backends. Matching in Up/Down/GetStatus now
checks both name and ID, so renamed migration files are still recognized as
applied if the 8-char hex ID matches.

2026-04-06 08:58:05 -06:00

litemigrate

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

msmigrate

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

mymigrate

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

pgmigrate

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

shmigrate

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

go.mod

feat(database/sqlmigrate): add migration library with multi-backend support

2026-04-06 00:40:11 -06:00

README.md

fix(sqlmigrate): Down n=0 means rollback all, add tests and docs

2026-04-06 00:40:12 -06:00

sqlmigrate_test.go

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

sqlmigrate.go

feat(sqlmigrate): match applied migrations by name or ID

2026-04-06 08:58:05 -06:00

README.md

sqlmigrate

Database-agnostic SQL migration library for Go.

Backend packages

Each backend is a separate Go module to avoid pulling unnecessary drivers:

Package	Database	Driver
pgmigrate	PostgreSQL	pgx/v5
mymigrate	MySQL / MariaDB	go-sql-driver/mysql
litemigrate	SQLite	database/sql (caller imports driver)
msmigrate	SQL Server	go-mssqldb
shmigrate	Shell scripts	(generates POSIX sh)

CLI

The sql-migrate CLI uses shmigrate to generate shell scripts for managing migrations without a Go dependency at runtime.