Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

Simple SQL migration tool for SQLite and PostgreSQL

Project description

# Migranto
Simple SQL migration tool for SQLite and PostgreSQL

## Instalation

pip install migranto

## 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 [--storage NAME] [--name NAME] `

shows migrations status

`./migranto [-h] --database URL --name NAME --path PATH [--migration N] [--storage NAME] [--verbose] [--fake] [--out] `

* __--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
* __--out, -o__ — output sql to standard output. nothing applied to database.
* __--fake, -f__ — fake migration (no sql applied to database, except migration number)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for migranto, version 0.1.9
Filename, size File type Python version Upload date Hashes
Filename, size migranto-0.1.9.tar.gz (5.2 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page