Skip to main content

Yoyo database migrations

Build Status License codecov

This project has been clone from 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:

# 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

Metadata

Release files for yoyo-database-migrations 0.1.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for yoyo-database-migrations 0.1.0
File Size Uploaded Provenance Actions
yoyo-database-migrations-0.1.0.tar.gz 41.2 kB Without provenance Details for yoyo-database-migrations-0.1.0.tar.gz

Release files / yoyo-database-migrations-0.1.0.tar.gz

Download URL yoyo-database-migrations-0.1.0.tar.gz
Size 41.2 kB
Tags Source
SHA-256 checksum
How to use checksums
024854398cdb34ac35ea1176998be73cfaa2874fce97417094ec3576ed268201
BLAKE2b-256 checksum
How to use checksums
055809d06778b057cdff37738181d7a53c6203403205e028753da63e81bb037c
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.1.1 pkginfo/1.5.0.1 requests/2.22.0 setuptools/45.1.0 requests-toolbelt/0.9.1 tqdm/4.41.1 CPython/3.8.1

Security for yoyo-database-migrations 0.1.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page