a database migration tool
Project description
AQ-DBMigration
a db migration tool in python
home
github: nanshens/AQ-DBMigration
install
pip install aq-dbmigration
how to use
config = MigrationConfig("db_name", "db_user", "db_password", "db_host", "db_port", DBConstant.Type.PostgreSQL, "db file path")
db = DBMigration(config)
db.migration()
if you want to skip migration, you can set skip is True in db.migration(), like this:
db.migration(True)
sql file
file format: V{version}__{description}.sql
example: V1__test.sql, V2__issue1.sql, V2.1__issue11.sql, V2.12__issue12.sql
version: version = main sequence + . + sub sequence, so order by main first, then sub. example: V1.2 run first and V1.13 second, because 2 < 13.
please start from V1
MigrationConfig
file path
please use absolute path.
if you use flask, you can set db_path in flask config,
like this app.config['DB_MIGRATION_PATH'] = os.path.join(app.root_path, 'resource', 'db_migration')
and use MigrationConfig("db_name", "db_user", "db_password", "db_host", "db_port", DBConstant.Type.PostgreSQL, app.config['DB_MIGRATION_PATH'])
to init
baseline
When used for the first time, it will set the baseline, and subsequent changes will not take effect.
Only read sql files larger than baseline.
database support
- postgresql(tested pass)
- mysql(in testing)
- maria(in testing)
- sqlite(in testing)
License
This project is licensed under the terms of the GNU General Public License v3.0.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for aq_dbmigration-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bb04a52461222bd9c2d7898aa60dd1275b67db29c1fd2ff25091ca8759e06750 |
|
MD5 | 8778e0facf52eb6dbf65587c4e830a1f |
|
BLAKE2b-256 | 28128dde99fb658cc7b46e72b24aae4fd404a311cfaa18cbe689d9f550da470a |