v3.11.2

Changelog

• Add validate command to help and readme in #512
• fix: use global table name in store queries in #515. Fixes a regression reported in #514
• build: upgrade deps in #516

Full Changelog: v3.11.0...v3.11.2

v3.11.0

Changelog

• ba6e5fb: Add 'sqlserver' to dialects as an alias of mssql (#510) (@ffaen)
• 3e0905a: build(deps): bump github.com/opencontainers/runc from 1.1.4 to 1.1.5 (#488) (@dependabot[bot])
• 4eee07f: build(deps): bump github.com/ory/dockertest/v3 from 3.9.1 to 3.10.0 (#504) (@dependabot[bot])
• 86f779a: build: add Linux ARM64 arch support (#499) (@jesusprubio)
• 0bc0034: build: upgrade deps and update workflows (#500) (@mfridman)
• 99204d2: build: upgrade to github.com/jackc/pgx/v5 (#475) (@dahu33)
• 15ef2bc: chore: fix comment typos (#480) (@deining)
• 33106fc: chore: update annotation comments (#478) (@mfridman)
• 0d1296b: feat(mssql): update driver to microsoft/go-mssqldb (#501) (@mfridman)
• 49c55f0: feat: add support for azuresql dialect (#487) (@sblackstone)
• e2ecb28: fix: clickhouse tests (@mfridman)
• c462979: refactor: create a generic store and stub out dialect queries (#477) (@mfridman)
• baaec13: refactor: dialectquery (#482) (@mfridman)
• 8574431: refactor: remove deprecated ioutil (@mfridman)

v3.10.0

Changelog (for humans)

• Bumps the minimum Go version to 1.18
• Add a new command: goose validate .. enables you to validate your SQL / Go migrations. Very handy for catching errors in CI when the migration is first written
• Removes hard coded tls override in MySQL DSN
• ClickHouse down migrations (deleting version) now uses set mutations_sync 2 for synchronization

Changelog

• 2a6d7c0: build: bump minimum Go version to 1.18 (update CI) (#458) (@mfridman)
• 935e883: build: golangci-lint add skip-pkg-cache: true (@mfridman)
• 7e6e512: build: update CI go version references and upgrade deps (#473) (@mfridman)
• 0af59c1: build: upgrade dependencies (#471) (@mfridman)
• c2f9bcb: ci: drop 1.17 tests and add 1.20-rc.3 (#455) (@mfridman)
• ad90652: clickhouse: set mutations_sync 2 for delete version (#454) (@chapsuk)
• 8c25e3b: feat: goose validate command (#449) (@mfridman)
• b4af752: fix test race condition and remove verbose global in parser (#457) (@mfridman)
• b62288d: fix: exclude Go test files from migrations (#474) (@ipoerner)
• 60610d3: remove tls override from mysql dsn normalizing (#468) (@jonas-jonas)

v3.9.0

Changelog

Added

• Add support for *sql.DB-registered Go migrations (#450). Kudos to @cbodonnell for helping with this feature.

There are 2 new func types:

// GoMigration is a Go migration func that is run within a transaction.
type GoMigration func(tx *sql.Tx) error

// GoMigrationNoTx is a Go migration func that is run outside a transaction.
type GoMigrationNoTx func(db *sql.DB) error

And 2 new functions to register Go migrations:

// AddMigrationNoTx adds Go migrations that will be run outside transaction.
func AddMigrationNoTx(up, down GoMigrationNoTx) { ... }

// AddNamedMigrationNoTx adds named Go migrations that will be run outside transaction.
func AddNamedMigrationNoTx(filename string, up, down GoMigrationNoTx) { ... }

• Add goose env command to expose set environment variables (#443)
• Add golangci-lint to enforce standards within the project (#456)

Fixed

• The SQL parser better handles leading/trailing empty lines and comments (#446). Additional tests have been added to capture edge cases with the parser.

v3.8.0

Changelog

• 5a6c34e: Add NO_COLOR (-no-color) support (#409) (@mfridman)
• b582641: Adds vertica driver support (#393) (@bobpace)
• b6c15b9: Bump modernc.org/sqlite from 1.18.1 to 1.19.1 (#406) (@dependabot[bot])
• 73e53f9: Changing Sprintf to Sprint if there is no formatting (#417) (@sashamelentyev)
• 28113a2: Print duration of execution time of each migration (#410) (@mfridman)
• 1c15215: Remove deprecated package ioutil and upgrade deps (#411) (@mfridman)
• f30eb6d: Update deprecated query in createVersionTableSQL for new ClickHouse versions since 22.7 (#408) (@Systemnick)
• 9823e00: Upgrade golang.org/x/text (#421) (@brandon-leapyear)
• 1939e61: build: upgrade dependencies (#442) (@mfridman)
• 436452d: ci: bump goreleaser/goreleaser-action from 3 to 4 (#430) (@dependabot[bot])
• 81d44b3: refactor: Use math.MaxInt64 const as MaxVersion instead of hardcode number (#441) (@sashamelentyev)

v3.7.0

Changelog

• 45a192f: Add a credit notation for Gopher image in README (#375) (@ryokotmng)
• 4826c03: Bump github.com/ClickHouse/clickhouse-go/v2 from 2.1.0 to 2.2.0 (#377) (@dependabot[bot])
• 8abd890: Exit with error 1 without required arguments (#399) (@el4v)
• 7792d04: Update GH workflow to include go version 1.19.0-rc.1 (#381) (@mfridman)
• 2278d75: Upgrade direct and indirect deps (#391) (@mfridman)
• 0a72970: logger: add nop logger (#384) (@mfridman)
• 496d7cd: parser: preserve empty lines in SQL statements (#372) (@iktakahiro)
• bc72e78: postgres: switch from lib/pq to jackc/pgx (#382) (@craigpastro)

v3.6.1

Changelog

• bfd4286: Fix example index out of range error (#368) (@slavick)
• f3d569f: Remove pkg/errors in favor of std lib (#373, #328) (@oussama4)
• 4ec294d: clickhouse: remove hard-coded verb in dialect (#370) (@mfridman)
• d04c088: e2e: move db container helpers to internal/testdb (#371) (@mfridman)

v3.6.0

Breaking change

The ClickHouse driver has been upgraded from /v1 to /v2. See comment here and a short blog post.

See comment here for new format: #369 (comment)

Changelog

• 1311a0e: Add GOOSE_MIGRATION_DIR env variable (#337) (@mfridman)
• b7c7a8d: Add gofmt formatting check to CI (@mfridman)
• b51d501: Add goose init command (#313) (@mfridman)
• 8d29bfc: Bump goreleaser/goreleaser-action from 2 to 3 (#357) (@dependabot[bot])
• 0995b69: Bump modernc.org/sqlite from 1.14.8 to 1.15.4 (#326) (@dependabot[bot])
• 8f53c35: Bump modernc.org/sqlite from 1.15.4 to 1.16.0 (#327) (@dependabot[bot])
• b44efc3: Bump modernc.org/sqlite from 1.16.0 to 1.17.0 (#342) (@dependabot[bot])
• b1fc11a: Cleanup go modules (@mfridman)
• 630ef77: DownTo returns error if no matching migration file is found (#314) (@schparky)
• fbd200b: Fix misspelling in README.md (#323) (@jsanc623)
• c05d337: Fixing clickhouse dialect placeholders (#333) (@kafkiansky)
• 33487e4: Make NumericComponent errors more understandable (#334) (@zealws)
• e7c5f69: Periodic output for long running migrations (#364) (@nikitacrit)
• 4a10c2c: Remove matryer/is replace with simple internal lib (#356) (@mfridman)
• 205faf5: Update CI to support go1.18 (#320) (@mfridman)
• 5cb7ab6: Update README.md (#316) (@fwielstra)
• dc83fe7: Update go dependencies (@mfridman)
• 6fc031a: Update ory/dockertest dependency (#330) (@nadinelyab)
• e8d93a0: clickhouse: Fixed get db version query (#240) (@chapsuk)
• 1b45f37: e2e: add clickhouse and update v2 (#369) (@mfridman)

v3.5.3

Changelog

• 5f1f43c: Add dependabot ignore and update deps (@mfridman)

v3.5.2

Changelog

• b2a7e51: Add dependabot.yml (#306) (@mfridman)
• e310f14: Add script to simplify macOS and linux install (@mfridman)
• 050c5e0: Update Go dependencies (#305) (@mfridman)
• f263417: readme: update installation indtructions (@mfridman)