Skip to main content
Help us improve PyPI by participating in user testing. All experience levels needed!

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


Release history Release notifications

This version
History Node

0.1.9

History Node

0.1.8

History Node

0.1.7

History Node

0.1.6

History Node

0.1.5

History Node

0.1.4

History Node

0.1.3

History Node

0.1.2

History Node

0.1.1

History Node

0.1.0

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
migranto-0.1.9.tar.gz (5.2 kB) Copy SHA256 hash SHA256 Source None Sep 6, 2012

Supported by

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