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:


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.

Source Distribution

migranto-0.1.9.tar.gz (5.2 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page