Simple migration framework / infra-structure for SQL based databases.
Installation
pip install migratore
Execution
HOST=${HOST} DB=${DB_NAME} USERNAME=${DB_USER} PASSWORD=${DB_PASS} migratore upgrade
Variables
HOST- Hostname or IP address of the database system for migrationPORT- TCP port to be used in the connection with the database systemUNIX_SOCKET- Filesystem path to the UNIX socket file to be used in connectionDB- Name of the database used as the migration targetUSERNAME- Username for authentication in databaseUSERNAME- Password to be used for authentication in databaseFS- Base file system path for file migration (may depend on migration context)
Commands
help- Prints a help message about the CLI interfaceversion- Prints the current version of migratoreenviron- Displays the current environment in the standard outputlist- Lists the executed migrations on the current databaseerrors- Lists the various errors from migration of the databasetrace [id]- Prints the traceback for the error execution with the provided idrebuild [id]- Run the partial execution of the migration with the given idupgrade [path]- Executes the pending migrations using the defined directory or currentgenerate [path]- Generates a new migration file into the target path
Examples
database = Migratore.get_database()
table = database.get_table("users")
table.add_column("username", type = "text")
License
Migratore is currently licensed under the Apache License, Version 2.0.
Build Automation
Metadata
Release files for migratore 0.4.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| migratore-0.4.1.tar.gz | 13.3 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| migratore-0.4.1-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 31.3 kB
Release files / migratore-0.4.1.tar.gz
| Download URL | migratore-0.4.1.tar.gz |
|---|---|
| Size | 13.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
41f88fb65b41d01aa8744ce67d3a2017ebf8edc07f92210315eb0232c98a32fa
|
|
BLAKE2b-256 checksum How to use checksums |
05cb5d854e7b3d5fcf0a0cad8f56c94578b9898cd87f8b809382ddece44ae677
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.15.0 pkginfo/1.8.3 requests/2.27.1 setuptools/44.1.0 requests-toolbelt/0.10.1 tqdm/4.64.1 CPython/2.7.18
|
Release files / migratore-0.4.1-py2.py3-none-any.whl
| Download URL | migratore-0.4.1-py2.py3-none-any.whl |
|---|---|
| Size | 17.9 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
7f6dfd96d12c5b734d17b0be766ffc5c2bd8e94a11f83063fec16ab02961d0fa
|
|
BLAKE2b-256 checksum How to use checksums |
187bab01fdbdf10a5aad44a11904d1623e7c8e610dd15ba768ffadf9745a4f98
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/1.15.0 pkginfo/1.8.3 requests/2.27.1 setuptools/44.1.0 requests-toolbelt/0.10.1 tqdm/4.64.1 CPython/2.7.18
|