This repo was used in a blog post about pressly/goose.
Post can be found here:
https://pressly.github.io/goose/blog/2021/embed-sql-migrations/
To run the example, clone this repository and run:
$ go run ./cmd/custom-goose
For demonstration purposes we're using a sqlite3 database, but goose supports many other databases.
- Migration 1 (sql) creates a users table Migration
- Migration 2 (go) inserts 10 users into the users table
- Migration 3 (go) counts the number of users and prints them out to the console
The output should be:
=== migration list ===
sql 1 00001_users_table.sql
go 2 00002_add_users.go
go 3 00003_count_users.go
=== migration status ===
sql 1 pending
go 2 pending
go 3 pending
=== log migration output ===
User: 7, affectionate_buck4
User: 5, angry_mclaren3
User: 8, friendly_thompson6
User: 10, funny_babbage8
User: 2, funny_gagarin9
User: 4, infallible_pare9
User: 3, priceless_margulis7
User: 6, silly_lovelace0
User: 1, sleepy_easley0
User: 9, tender_mcclintock0
=== migration results ===
sql 1 completed in: 763µs
go 2 completed in: 612.417µs
go 3 completed in: 489.042µs