Database migrations with SQL
Project description
Yoyo database migrations
========================
[![Build Status](https://travis-ci.org/marcosschroh/yoyo-database-migrations.svg?branch=master)](https://travis-ci.org/marcosschroh/yoyo-database-migrations)
![License](https://img.shields.io/github/license/marcosschroh/yoyo-database-migrations.svg)
[![codecov](https://codecov.io/gh/marcosschroh/yoyo-database-migrations/branch/master/graph/badge.svg)](https://codecov.io/gh/marcosschroh/yoyo-database-migrations)
This project has been clone from [ollyc/yoyo](https://bitbucket.org/ollyc/yoyo). Thanks Ollyc!!
Why this repository?
* To improve project documentation
* To fix bugs related to different python versions
* I had different issues on Mac but not on Linux, so fix them
* To add full support for Python 3.6/3.7 (annotations, async/io databases drivers)
* To add new Features
* To add full code coverage
Yoyo is a database schema migration tool. You write database migrations
as Python scripts containing raw SQL statements or Python functions.
Installation:
------------
```
pip install yoyo-database-migrations
```
Documentation:
--------------
https://marcosschroh.github.io/yoyo-database-migrations/
What does yoyo-migrations do?
-----------------------------
As your database application evolves, changes to the database schema may be
required. Yoyo lets you write migration scripts in Python containing
SQL statements to migrate your database schema to a new version.
A simple migration script looks like this:
```python
# file: migrations/0001.create-foo.py
from yoyo import step
step(
"CREATE TABLE foo (id INT, bar VARCHAR(20), PRIMARY KEY (id))",
"DROP TABLE foo",
)
```
Yoyo manages these database migration scripts,
gives you command line tools to apply and rollback migrations,
and manages dependencies between migrations.
Database support
----------------
PostgreSQL, MySQL and SQLite databases are supported.
ODBC and Oracle database backends are available (but unsupported).
Improvements
------------
* Command `yoyo showmigrations` added
========================
[![Build Status](https://travis-ci.org/marcosschroh/yoyo-database-migrations.svg?branch=master)](https://travis-ci.org/marcosschroh/yoyo-database-migrations)
![License](https://img.shields.io/github/license/marcosschroh/yoyo-database-migrations.svg)
[![codecov](https://codecov.io/gh/marcosschroh/yoyo-database-migrations/branch/master/graph/badge.svg)](https://codecov.io/gh/marcosschroh/yoyo-database-migrations)
This project has been clone from [ollyc/yoyo](https://bitbucket.org/ollyc/yoyo). Thanks Ollyc!!
Why this repository?
* To improve project documentation
* To fix bugs related to different python versions
* I had different issues on Mac but not on Linux, so fix them
* To add full support for Python 3.6/3.7 (annotations, async/io databases drivers)
* To add new Features
* To add full code coverage
Yoyo is a database schema migration tool. You write database migrations
as Python scripts containing raw SQL statements or Python functions.
Installation:
------------
```
pip install yoyo-database-migrations
```
Documentation:
--------------
https://marcosschroh.github.io/yoyo-database-migrations/
What does yoyo-migrations do?
-----------------------------
As your database application evolves, changes to the database schema may be
required. Yoyo lets you write migration scripts in Python containing
SQL statements to migrate your database schema to a new version.
A simple migration script looks like this:
```python
# file: migrations/0001.create-foo.py
from yoyo import step
step(
"CREATE TABLE foo (id INT, bar VARCHAR(20), PRIMARY KEY (id))",
"DROP TABLE foo",
)
```
Yoyo manages these database migration scripts,
gives you command line tools to apply and rollback migrations,
and manages dependencies between migrations.
Database support
----------------
PostgreSQL, MySQL and SQLite databases are supported.
ODBC and Oracle database backends are available (but unsupported).
Improvements
------------
* Command `yoyo showmigrations` added
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Close
Hashes for yoyo-database-migrations-0.0.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | f71b202daed2bc2ef534d83934e169bc04b4e3c74f433047928361eff4fdeb05 |
|
MD5 | fdfd49703a29e96683532820ab099da4 |
|
BLAKE2b-256 | fcf0827359c0052d9eb1fccc198ead8bdd34f3f67af7263aac7782b54639a299 |