Pyway is a database versioning and migration tool inspired by Flyway

To install use pip:

$ pip install pyway

Or clone the repo:

$ git clone https://github.com/jasondcamp/pyway.git
$ python setup.py install

Priority is env variables -> config file -> command args

Pyway supports a configuration file with the default file as .pyway.conf. A sample config file is below:

database_type: postgres
database_username: postgres
database_password: 123456
database_host: localhost
database_port: 5432
database_database: postgres
general:
database_migration_dir: schema
datbase_table: public.pyway

Files are raw SQL files that are named like the following:

V{major}_{minor}__{description}.sql

Example: V01_01__initial_schema.sql

Note that the description needs to match the word regexp [A-Za-z0-9_]

Information lets you know where you are. At first glance, you will see which migrations have already been applied, which others are still pending, and whether there is a discrepancy between the checksum of the local file and the database schema table.

$ pyway info

Validate helps you verify that the migrations applied to the database match the ones available locally. This compares the checksums to validate that what is in the migration on disk is what was committed into the database.

$ pyway validate

After validate, it will scan the Database migration dir for available migrations. It will compare them to the migrations that have been applied to the database. If any new migration is found, it will migrate the database to close the gap.

$ pyway migrate

This allows the user to import a schema file into the migration, for example if the base schema has already been applied, then the user can import that file in so they can then apply subsequent migrations.

$ pyway import --schema-file V01_01__initial_schema.sql