Simple SQL migration tool for SQLite and PostgreSQL
Project description
# Migranto
Simple SQL migration tool for SQLite and PostgreSQL
## Migrations
All migrations exist in one directory with names like:
0001_some_useful_name.sql
0001_some_useful_name_rollback.sql
0002_some_other_useful_name.sql
0002_some_other_useful_name_rollback.sql
Migranto checks migrations directory and apply sql files to database.
That's it. Simple enough.
## Usage:
`./migranto [-h] --database URL --name NAME --path PATH [--migration N] [--storage NAME] [--verbose]`
* __--help, -h__ — show this help message and exit
* __--database URL, -d URL__ — database url (pgsql://user:password@host:port/dbname or sqlite://path/to/data.base)
* __--name NAME, -n NAME__ — migration set name
* __--path PATH, -p PATH__ — path to migrations dir
* __--migration N, -m N__ — migration step (last migration if omitted, 0 - before first migration)
* __--storage NAME, -s NAME__ — migranto table name for data (default is migranto)
* __--verbose, -v__ — verbose mode
Simple SQL migration tool for SQLite and PostgreSQL
## Migrations
All migrations exist in one directory with names like:
0001_some_useful_name.sql
0001_some_useful_name_rollback.sql
0002_some_other_useful_name.sql
0002_some_other_useful_name_rollback.sql
Migranto checks migrations directory and apply sql files to database.
That's it. Simple enough.
## Usage:
`./migranto [-h] --database URL --name NAME --path PATH [--migration N] [--storage NAME] [--verbose]`
* __--help, -h__ — show this help message and exit
* __--database URL, -d URL__ — database url (pgsql://user:password@host:port/dbname or sqlite://path/to/data.base)
* __--name NAME, -n NAME__ — migration set name
* __--path PATH, -p PATH__ — path to migrations dir
* __--migration N, -m N__ — migration step (last migration if omitted, 0 - before first migration)
* __--storage NAME, -s NAME__ — migranto table name for data (default is migranto)
* __--verbose, -v__ — verbose mode
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
migranto-0.1.0.tar.gz
(4.2 kB
view hashes)