Skip to main content

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 --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

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

This version
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.4.tar.gz (4.3 kB) Copy SHA256 hash SHA256 Source None Aug 13, 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