Skip to main content

A fork of yoyo that's designed to support the 3.10+ python versions, you probably shoul not use this

Project description

Yoyo database migrations

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

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

yoyox-2023.3.16.0.tar.gz (40.7 kB view details)

Uploaded Source

Built Distribution

yoyox-2023.3.16.0-py3-none-any.whl (36.3 kB view details)

Uploaded Python 3

File details

Details for the file yoyox-2023.3.16.0.tar.gz.

File metadata

  • Download URL: yoyox-2023.3.16.0.tar.gz
  • Upload date:
  • Size: 40.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.9.16

File hashes

Hashes for yoyox-2023.3.16.0.tar.gz
Algorithm Hash digest
SHA256 9bc5ca51e2359748ad405931b0f6eba5f251f454bb31fdb94d94f8e4e2210112
MD5 0ede22e67349fd67ac534514e653d212
BLAKE2b-256 abf6466c53daa07d6b85c3e3c6391d67a5b6d3a54e52007531cec64424cb498d

See more details on using hashes here.

File details

Details for the file yoyox-2023.3.16.0-py3-none-any.whl.

File metadata

  • Download URL: yoyox-2023.3.16.0-py3-none-any.whl
  • Upload date:
  • Size: 36.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.2 CPython/3.9.16

File hashes

Hashes for yoyox-2023.3.16.0-py3-none-any.whl
Algorithm Hash digest
SHA256 e9bc5b75ec18dd0cacd7589de6f2c69cf5462ca2b8767a5b426f9059ba897726
MD5 3ee9a16a9b8ef04958b1e1d980e0f6b1
BLAKE2b-256 1a84d969c17c5d9b82b718dbd4926b7373af9fc40cd39337512d3e5efb30eb73

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page