v3.13.3

Fixed a bunch of build issues, see https://github.com/pressly/goose/releases/tag/v3.13.4 for correct changelog.

v3.13.1

• Add pre-built binaries with GoReleaser and update the build process.

Release v3.13.0

Changelog

• Fix up and up -allowing-missing behavior.
• Fix empty version in log output.
• Add new context.Context-aware functions and methods, for both sql and go migrations.
• Return error when no migration files found or dir is not a directory.

Note, tags v3.12.0, v3.12.1, v3.12.2 have been retracted because they contained the wrong module reference, please use the current release v3.13.0 onwards. Apologies for the inconvenience.

Full Changelog: v3.11.2...v3.13.0

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)