migranto Simple SQL migration tool for SQLite and PostgreSQL
Download

migranto Ranking & Summary

migranto Tags

SQLite SQL migration PostgreSQL migration

migranto Description

migranto is a simple SQL migration tool for SQLite and PostgreSQL.Instalation pip install migrantoMigrationsAll 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.sqlMigranto checks migrations directory and apply sql files to database. That's it. Simple enough.Usage:`./migranto --database URL --name NAME --path PATH `* __--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* __--fake, -f__ — fake migration (no sql applied to database, except migration number)Product's homepage

migranto Related Software