Remove unused update queries

Merge pull request #133 from pressly/fix_dialect

Remove unused update query

down command now removes version row record

This will resolve dangling records when deploying different version codebases to the same DB

Fix missing return statement for fix command

Merge pull request #126 from pressly/add-fix-return

add return here

Fix panic when goose is ran without any arguments

#124

Thanks to @jstrohm-triller for catching this regression

Build tags to exclude drivers

We now support build tags to exclude DB drivers such as no_mysql, no_sqlite, and no_psql. This will provide users with the flexibility to exclude drivers they don't need. This design will still include all drivers by default for ease of use.

Hybrid migration versioning

We came up with a solution to the versioning problem.

Hybrid Versioning

We strongly recommend adopting a hybrid versioning approach, using both timestamps and sequential numbers. Migrations created during the development process are timestamped and sequential versions are ran on production. We believe this method will prevent the problem of conflicting versions when writing software in a team environment.
To help you adopt this approach, create will use the current timestamp as the migration version. When you're ready to deploy your migrations in a production environment, we also provide a helpful fix command to convert your migrations into sequential order, while preserving the timestamp ordering. We recommend running fix in the CI pipeline, and only when the migrations are ready for production.

Make goose_db_version table name configurable

goose.SetTableName("your_table_to_track_the_db_schema_versions")

Contributed by @chapsuk, see #104.

Added logger interface and SetLogger

Merge pull request #105 from chapsuk/logger

Added logger interface and SetLogger func for redefine package output

Add reset command

reset calls goose down for each applied migration, until it reaches the oldest migration.

• Useful when switching between different development branches (you can rewind WIP migrations from the previous branch and apply yours).
• Also very useful for CI tests (you can run goose up && goose reset && goose up to double check your migrations are in good shape in both directions.

Kudos to @smacker

v2.0.0

• support for --+goose NO TRANSACTION
• goose create [name] - create command enhancements
• golang/dep vendoring
• clean-up & refactor
• better examples, especially the Go migrations
• move .travis.yml tests to goose_test.go