v1.7.0

Changelog

• cd2c45d update module name temporarily
• 4cd081e Setup goreleaser
• 17cb6ad use stderr instead of stdout for ui error writer
• 29b22c8 add HelpWriter and ErrorWriter (#2)
• 5fd3db0 Test against Go 1.22
• 0c312ab Bump google.golang.org/protobuf from 1.30.0 to 1.33.0
• bc5e259 update sql-migrate
• 4c7bdce Appease goimports
• a7298de Allow dot imports where idiomatic
• efb3a99 Avoid use of deprecated io/ioutil
• 6d3e3af Update golangci-lint to 1.55.2, update depguard config
• 9f03b5b Drop toolchain line
• 62777b5 Fix dependencies
• cea42be Bump golang.org/x/crypto from 0.5.0 to 0.17.0
• 32f29a2 Drop bunch of dependencies that are no longer needed
• f4a7ae3 Point out that embed is the way to go now
• 791a117 Revert "Remove Go 1.16 specific tests"
• 215fa43 Remove packr tests that break linting
• db6e9e6 Remove Go 1.16 specific tests
• e103454 Add Go 1.21
• 9e20e0b Upgrade release action
• cdab5c3 Merge pull request rubenv#250 from scop/chore/remove-go116
• ac85431 Remove Go 1.16 support remainders, bump builds to 1.20
• e61d17e Drop support for pre-1.17 Go versions
• 1b7f060 Update badges
• 96cde33 Rename CI workflow
• 345d0b1 Merge pull request rubenv#242 from peterldowns/patch-1
• 7393377 Merge branch 'master' into patch-1
• 61ee1bf Merge pull request rubenv#247 from sarajmunjal/saraj/ctx
• fda37a1 Merge branch 'master' into saraj/ctx
• 7084132 Merge pull request rubenv#243 from peterldowns/ci-and-format
• 1c8d7ac Add context support to Exec methods
• 4339ec7 Add integration test workflow.
• 86c7d37 Fix all linter errors.
• b6ed53c Fix builds for versions <= 1.17
• e584461 Add building, linting, and testing to CI.
• 074b27e Fix DisableCreateTable for MigrationSet instances.
• 4e602c7 Merge pull request rubenv#241 from TakabayaP/Fix--README.md-config-example
• d43da29 fix: config example sslmode to require, not required
• bbfb254 Merge pull request rubenv#227 from tobischo/feature/add-snowflake-support
• 5b1e942 Add snowflake support and upgrade gorp dependency to v3.1.0
• d1cfa62 Bump dependency to fix vulnerabilities in dependencies
• 4e43fea Update github.com/mitchellh/cli
• 787b907 add comment
• 298319d add ApplyMigrationToVersion
• 04d833d fix default value
• f60dec2 change function applyMigrations to private
• ea3443e add test cases for PlanMigration with Version
• dd8ba19 add ExecVersion; wrap apply migration logic;
• d1911d2 optimize to quit search target index when things go wrong
• 8b621e7 fix typo
• f549406 fix typo
• 9b8075c change up/down command option version to Int64Var
• f7a19e8 add migrate up/down to a specific version
• 3c76295 Merge pull request rubenv#230 from guettli/patch-1
• 2e92677 Merge pull request rubenv#231 from guettli/patch-2
• 2e23dbb Remove link to modl
• b2a7fb1 Added "Questions or Feedback?"
• eee2762 Merge pull request rubenv#223 from asartalo/master
• 29e1b00 Update go-sqlite3 so DROP COLUMN can work
• c8fb611 Update dependency
• 28ddc0e Merge pull request rubenv#215 from MrXavier/patch-1
• 2324c18 Merge pull request rubenv#219 from ptravers/master
• e2d9e33 add parameter for ignore unknown to cli
• 7aeab11 Merge pull request rubenv#218 from t-oki/version
• deb4934 delete unnecessary import
• 6923345 use runtime/debug
• 57b5fb3 add version file for cli
• 97780ff update
• 63881dc Update installation instructions for go 1.18
• 524fb2b Merge pull request rubenv#209 from shubham1172/shubham1172/upgrade-gobuffalo-packr
• f152734 Upgrade dependency and run go mod tidy
• f205e13 Merge pull request rubenv#206 from idcmp/gorp_v3
• e560c4f Merge pull request rubenv#207 from blyoa/close-db
• 1737047 Close the database before exiting
• 2b0ef71 - bump gorp to v3 - gofmt - goimports
• 9f02b1e Merge pull request rubenv#199 from akhorsi/master
• aad1dd2 Add disable option to avoid creating migration table on getting db map
• 55d5740 Merge pull request rubenv#195 from fredericobormann/master
• 6f4e493 Fix Windows filepath separator bug
• 81188d5 Fix deprecation warning
• f17eeb0 Bump
• a7cb556 Add support for Go1.16 embed.FS
• a32ed26 Test with newer Go versions
• 6a7ef36 Merge pull request rubenv#192 from insidieux/release-assets
• ce91807 Release assets
• f842348 Merge pull request rubenv#188 from koleo/fix-readme
• ccd6bc4 Fix README sql and links
• 8d140a1 Merge pull request rubenv#179 from sobolevn/patch-1
• b39ad41 Updates README.md with svg badge
• ae26b21 Merge pull request rubenv#172 from jufemaiz/bugfix/171/file-does-not-exist
• 011dc47 Feedback from @rubenv
• 531fb8a Merge pull request rubenv#175 from jufemaiz/chore/readme-update
• 9c110bc Update README.md to support pkger.Dir as a migrate.HttpFileSystemMigrationSource
• 1876455 migrate.go to resolve rubenv#171
• eef9d3b Merge pull request rubenv#173 from zzet/patch-1
• dd1b571 fix: Quote id column as it described in dialect definition
• 435005d Clean up go.sum
• 797e86f Merge pull request rubenv#170 from gunsluo/master
• a7acd32 modify README and remove errors.Unwrap
• 1eaca86 modify tag to oci8
• c55d259 dialect godror for oracle
• baf4e4b Add Go 1.14
• 2091bc0 Remove older Go versions
• 757ebe5 Add CGO build check
• 64f95ea Merge pull request rubenv#166 from gunsluo/master
• 6817a62 Slightly improve title
• 6a356c3 support for oracle in command line pargarm
• ba2b119 fix ORA-00922 issue - missing or invalid option in database oracle
• c8d4be6 Merge pull request rubenv#164 from fanpei91/master
• 5ae6ff7 fixed 'CreateTablesIfNotExists' error logic
• f6e5886 fix: oracle database does support 'if not exists' and 'text' data type
• 8794cec Merge pull request rubenv#162 from bbkane/patch-1
• d0d7b93 Update README.md with http.FileSystem docs
• 0633851 Add unit test for new IgnoreUnknown flag
• 03a1114 Fix typo
• 5a9264f Fix typo
• 031b8ee Add a comment to iterate that IgnoreUnknown should be used sparingly
• 514cd20 Add ability to skip unknown migrations in database
• 737decc Merge pull request rubenv#160 from dixonwille/close_file
• 49434c4 Close the file when finished parsing them
• da1cb18 Lower Go version requirement
• a2f5135 Go mod tidy
• eb18766 Merge branch 'master' into gomod
• 8960597 Add go 1.13 to travis, use latest release of each go version
• ea37a2c Add go modules
• 0d68dd7 Test with Go 1.13
• 7c4b0a9 Merge pull request rubenv#156 from marema31/MigrationSet
• cac4cff Test that the tableName is really taken in account and the default value
• df6f689 Use directly the type MigrationSet and create getTableName()
• 9d446b4 Add type MigrationSet to allow concurrent usage of sql-migrate
• ce2300b Merge pull request rubenv#154 from codestation/feature-packr2
• d787e50 Use packr v2 on examples and tests
• 9355dd0 Merge pull request rubenv#152 from alexandear/fix-typos
• f4907a9 Fix typos in variables
• 5cdff0d Bump
• 5e4ecdc Merge pull request rubenv#150 from jecepeda/fix-error-message-on-redo
• 5addc8d print error message on redo commmand
• 8926f37 Merge pull request rubenv#145 from muya/add-detailed-mysql-example
• dfaab78 Restore original credentials for Travis
• 24b42ec Add detailed MySQL example
• 87ce952 Merge pull request rubenv#143 from risentveber/master
• 33e3f27 document expand env feature for datasource field in config
• f4d34ea Merge pull request rubenv#141 from shintarosakata/master
• a804a9c fix skip message
• 54bad0a Stick to 1.12 for now
• 343a81a Merge pull request rubenv#136 from opensas/patch-1
• 3f186eb Update Go versions
• e23439a Fix inconsistent naming of config files rubenv#107
• 1007f53 Add sqlx to features, to clear this up
• cbaec82 Add note about sqlx
• 5a8808c Merge pull request rubenv#124 from clyphub/slurp-mostly-unactionable-errors
• 93c63ba Run errcheck on project as part of Travis check
• 1d85250 Handle error on gz.Close()
• 6fba80d Slurp errors to keep errcheck happy
• ba2c6a7 Update MySQL error for Go 1.11
• 29a6046 Revert "Split integration test to investigate output during CI"
• e84cf09 Split integration test to investigate output during CI
• c89b9ce Go for newer Go versions
• 7b676de Fix packr deprecation
• 3f452fc Merge pull request rubenv#103 from ironsmile/fail-with-strange-migrations
• aff46b6 Merge pull request rubenv#115 from whilei/gofmt-2018-Jun-16-22-58
• e000191 all: gofmt
• 76bfa91 Use in-memory sqlite database during testing
• dd5fcca Return error from PlanMigration when unknown migration in the database
• 081fe17 Test with modern Go
• ae998f0 Fix header in docs
• 6a1157e Update doc.go
• 10fe3dd Add support for packr
• 7067d4c Fix go get example
• f337346 Merge pull request rubenv#101 from evert0n/update-readme
• 1dea322 Adds verbose(-v) flag to install command line
• e4e0e88 Merge pull request rubenv#100 from grab/add-skip-command
• 2e94838 Merge branch 'add-skip-command' of github.com:grab/sql-migrate into add-skip-command
• c33be3b Add unit tests, cleanup code
• dece4e9 Cleanup unused code, improve message strings
• a35821e Add skip command
• 41bceb1 Merge pull request rubenv#99 from hellais/patch-1
• 33a6666 jteeuwen/go-bindata is no longer active
• 6edbfbd Merge pull request rubenv#96 from ironsmile/bugfix/fix-race-condition
• de2dfac Fix a race condition in the sql-migrate memory migration struct
• e2c068b Merge pull request rubenv#95 from MEDIGO/master
• bb4d300 Fix rubenv#90 - Increase Scanner buffer size
• 5c081eb Merge pull request rubenv#94 from MEDIGO/master
• b26f255 Fix rubenv#90 - Increase Scanner buffer size
• 27ebce5 Merge pull request rubenv#93 from bongnv/fix-panic-file-missing
• a62a3ff Fix panic when migration file removed
• 79fe99e Stop testing old Go versions
• 7ca67d4 Make things slightly more Go-ish
• 72a5478 Stop testing old Go versions
• 96825bd Merge pull request rubenv#77 from dmaze/rollback-on-insert-error
• 7bae004 Merge pull request rubenv#76 from yesnault/allow-only-comment
• a439660 Merge pull request rubenv#74 from gsalingu/master
• 5a1ca16 Move colons
• 06556f0 Make it more clear which migration causes a parse error
• abc6cf8 Don't leak transactions if there is a failure writing to the migrations table.
• 48fb62e feat: allow only comment
• 42c30aa Merge pull request rubenv#75 from omeid/master
• afa8420 Add HttpFileSystemSource support.
• bb076d2 feat: added more detailed error message upon which migration is actually invalid while discovering/parsing them
• 38004e7 Merge pull request rubenv#69 from HRMsimon/patch-2
• f7944b6 Output the path to the new migration on creation
• a3e2963 Merge pull request rubenv#66 from lion-man44/patch-1
• 1d09835 Refactor time.Now().Format("20060201150405")
• 3aa09aa Merge pull request rubenv#64 from nicklaw5/mysql-caveat
• cecb625 Include MySQL parseTime caveat to docs
• 49e7c1c Test for Go versions 1.3 through 1.8
• b97f05d Run MySQL ENV test
• f5b76a4 Handle newer error, should unbreak flag test on newer Go
• 1be3bd2 Unbreak test again
• 34ac594 Update noflag test
• 4d11f87 Merge pull request rubenv#63 from nicklaw5/move-licenses
• bd4385b Link to licenses
• dd1a598 Use correct FlagSet name
• 807aa91 Merge pull request rubenv#60 from HRMsimon/patch-1
• a4e4f9a Create a migration from the first non-flag arg
• f64b608 Merge pull request rubenv#56 from yageek/feature/yaml.v2
• 499358e Update to yaml.v2.
• 54c99be Merge pull request rubenv#54 from yageek/feature/23_new_command
• e69d2e9 Update README
• 8b28fae Update time format. Fix SQL creation location.
• 6f41686 Bring different copies of license info in sync
• 7f91ee2 Merge pull request rubenv#46 from lucasmoten/patch-1
• cdc2342 Merge pull request rubenv#55 from freakingawesome/allow-custom-line-terminator
• 91d84b0 Allow custom line separator
• 93fea10 Update README.md.
• ba19c14 Add new command as specify in rubenv#23
• 7fd185e Force termination of every sql statement
• 1ed7996 Merge pull request rubenv#47 from bradleyfalzon/escape-tableName
• 74c2f63 Quote tableName when querying migrations
• a3ed23a Merge pull request rubenv#48 from russellhaering/document_notransaction_mode
• c94d908 Document notransaction mode
• ff04059 Merge pull request rubenv#35 from russellhaering/support_notransaction_mode
• 8fed98f Create LICENSE
• 97b3969 Fix a typo introduced in 75cb1
• 9705e6b Update sqlparse tests
• 75cb1ca Add support for running migrations outside of a transaction
• dfaa8f8 Add parser support for "notransaction" option
• f5d0a0d Refactor sqlparse to support passing options to commands
• 6f47575 Revert "Test with Go 1.6"
• d4cbbaf Test with Go 1.6
• 119b0c1 Merge pull request rubenv#34 from stxml/master
• 1ad0b33 added support for environment variable expansion in datasource
• 1911909 Merge pull request rubenv#25 from larsmoa/master
• 51aa4ca Merge pull request rubenv#32 from vlkv/master
• de435ae FIXED "go vet ./..." error: unresolvable package for gorp.MySQLDialect literal
• b52b10a Merge pull request rubenv#31 from oinume/travisci-faster-build
• b850bff Add "sudo: false" for faster startup
• 6831c51 Add more test cases for Migration.Less()
• 3c91f41 Improve readability for not-equal VersionInt() check
• d33a96d Add support for comparing timestamps with separators by falling back to string comparison when VersionInt() of two migration steps are equal.
• 6e94351 Generalise location of test database file by using ioutil.TempFile().
• 969836b Merge pull request rubenv#24 from daved/add/mig_id_to_err0
• 27a4a8d Replace duplicate txerror literals with new func.
• ee7cc65 Add custom TxError to add clarity to tx-related error messages.
• 8dc77fb Only test stable Go versions
• 4c159cf Modernize Go versions
• 275a67e Bump
• 53184e1 Use gopkg.in/gorp.v1
• 803b4ea Merge pull request rubenv#17 from nadams/schema-support
• 63b1fec Adding schema support
• 493e520 Update
• 99b07bf Add a link to modl-migrate.
• ef401a0 Merge pull request rubenv#16 from pschyska/master
• 1aa4565 Join 2 subsequent ifs into one
• a8bcd23 Account for "holes" in the existing migrations in PlanMigration
• 12b7097 Fix import path of gorp in test
• 0ab1fcf Test 1.4 as well.
• 956ebe5 Switch to go-gorp.
• f1ae5df Fix table handling in command-line util.
• 7bb8b6b Move Regexp so that we only compile it once.
• f2d2c24 Correctly identifies most recent migration
• d10a142 Fixes issue where ToApply was not applying valid migrations
• a3c02ad Fixes an issue with sorting migrations
• 09d124b Align doc.go with README.md (rubenv#4).
• 816c02e Add documentation string for SetTable (rubenv#10).
• 165aeca Run sqlite test (rubenv#10).
• 9b49bb0 Ignore generated database.
• d1f927a Add a test for rubenv#10.
• fb84fa1 Merge branch 'master' of github.com:ShawnMilo/sql-migrate
• 2d1cbca doc updates for customizable table name
• eb3eb03 get migration table from config file
• c3071cf Revert "Allows setting migration table by environment var."
• 90b4bd4 Reformat error.
• f2b9ac3 Add a test for #2.
• 93c7d46 Check if parseTime is supplied when using MySQL.
• b1efe1a Split MySQL test into own file.
• 363ea27 Re-add MySQL parameter.
• f7bd5b3 Add MySQL username.
• 61f1f7d Add missing parseTime parameter.
• e2f0e8a Add MySQL test.
• 52ba6c8 Add second status call.
• 0954c1f Test some more scenarios.
• 52ad23b Test postgres connection on clean DB.
• 6680674 Make sure we always have a gorp_migrations table.
• afa9793 Merge pull request rubenv#11 from lluchs/fix-readme-extending
• b70fa28 Adjust README to changes in PR rubenv#4
• e64c88e Allows setting migration table by environment var.
• 12f2b5e Revert "Puts migration table in a variable."
• c8612b6 Revert "Adds command-line flag for migration tablename."
• 9e54837 Adds command-line flag for migration tablename.
• 7d0c84f Puts migration table in a variable.
• 8c0ad4c Comment command until there's actually something to do.
• a1d1d66 Hardcode Travis bin path.
• 9b045b1 Fix script path.
• f2d8edc Run integration script during travis build.
• c9747ca Add a stub E2E test script.
• 15f3e77 Split out script.
• f69d7ce Drop "IF NOT EXISTS" for psql.
• 3861bc3 Setup integration test databases.
• 3745ca8 Remove unneeded whitespace.
• 8605c91 Add note to MigrationSource on how result should be sorted.
• 246ddf8 Merge pull request rubenv#4 from lluchs/sorted-status
• 6dbd76b Sort migrations by id in FindMigrations()
• 28b1a38 Also fix the command-line tool.
• 6044354 Set MySQL dialect options.
• 27caf7a Fix migrate examples.
• 3bce3ce Add installation note.
• b4ef6a4 Add doc.go.
• e16887c Slightly more usage docs.
• 56f6edf Document writing migrations.
• 41b82ca Update sqlparse copyright notice.
• 21ad9d1 Document bindata usage.
• 69bec39 Some more documentation.
• 92d83a2 Start adding documentation.
• 958e1c2 Fix help strings.
• 891bc1d Don't use DbMap as the main interface.
• 430cab3 Update bindata migrations.
• b48b25f Fix imports
• b8f3a25 Rename to sql-migrate.
• d355be1 Explicitly roll back failed transactions to release any locks.
• e95163d Run migrations in a transaction.
• b73d4cd Default to development environment.
• 741d9cd Add status command.
• 6c5c997 Add redo command.
• f13ecd1 Add "migrate down" to CLI.
• 0e0e598 One more test.
• 9b3fa2b Add a couple of down tests.
• 18da3c6 Add downward migrations to the library.
• f9e50ff Remove unneeded test.
• dfd3897 Add dry-run mode.
• db47ec4 Allow planning a migration.
• 4df57b7 Move everything together.
• f3e04bd Add limit parameter.
• 55d5bb0 Remove some debug output
• 67fdd98 Try to support MSSQL again in combination with Go 1.2.
• d315d17 MSSQL doesn't support Go 1.2, drop it.
• ec1d45b Add test files.
• e9ab352 Start adding a CLI tool.
• a02e3d7 Fix comments in tests.
• e8378e9 Test ExecMax.
• dfa80ad Allow setting migration direction + limit.
• 2bef9f5 Correct type check.
• 9a263ac Support embedding of bindata migrations.
• 82bc790 Read migrations from SQL files.
• de4357a Make byId private to avoid cluttering godoc.
• c7da82d Add Travis badge.
• dbc8243 Small piece of doc to trigger Travis.
• e8d93d6 Add README.
• 726e96f Add Travis.
• 317fb94 Fix the tests.
• 42b46df Initial Up migrations.
• 73c4872 Add .gitignore.
• 2f0ca01 Initial commit