Yoyo database migrations
========================
Yoyo-migrations is a database schema migration tool.
Database migrations can be written as SQL files or Python scripts.
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 raw SQL or Python containing
SQL statements to migrate your database schema to a new version.
A simple migration script looks like this:
.. code::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).
Documentation and code
----------------------
`Yoyo migrations documentation <https://ollycope.com/software/yoyo/>`_
\| `Repository and issue tracker <https://sr.ht/~olly/yoyo/>`_
Raw data
{
"_id": null,
"home_page": "https://ollycope.com/software/yoyo/latest/",
"name": "yoyo-migrations",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "migrations migrate database alembic south",
"author": "Oliver Cope",
"author_email": "oliver@redgecko.org",
"download_url": null,
"platform": null,
"description": "Yoyo database migrations\n========================\n\nYoyo-migrations is a database schema migration tool.\nDatabase migrations can be written as SQL files or Python scripts.\n\nWhat does yoyo-migrations do?\n-----------------------------\n\nAs your database application evolves, changes to the database schema may be\nrequired. Yoyo lets you write migration scripts in raw SQL or Python containing\nSQL statements to migrate your database schema to a new version.\n\nA simple migration script looks like this:\n\n.. code::python\n\n # file: migrations/0001.create-foo.py\n from yoyo import step\n step(\n \"CREATE TABLE foo (id INT, bar VARCHAR(20), PRIMARY KEY (id))\",\n \"DROP TABLE foo\",\n )\n\nYoyo manages these database migration scripts,\ngives you command line tools to apply and rollback migrations,\nand manages dependencies between migrations.\n\nDatabase support\n----------------\n\nPostgreSQL, MySQL and SQLite databases are supported.\nODBC and Oracle database backends are available (but unsupported).\n\nDocumentation and code\n----------------------\n\n`Yoyo migrations documentation <https://ollycope.com/software/yoyo/>`_\n\\| `Repository and issue tracker <https://sr.ht/~olly/yoyo/>`_\n",
"bugtrack_url": null,
"license": "Apache",
"summary": "Database migrations with SQL",
"version": "9.0.0",
"project_urls": {
"Homepage": "https://ollycope.com/software/yoyo/latest/"
},
"split_keywords": [
"migrations",
"migrate",
"database",
"alembic",
"south"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "8c5d9ef7f808ea955eca9f08043c65bdc81a4694e784c978b24ad72022974a97",
"md5": "8dd833dbf3ef620940e0c53823a131b8",
"sha256": "fc65d3a6d9449c1c54d64ff2ff98e32a27da356057c60e3471010bfb19ede081"
},
"downloads": -1,
"filename": "yoyo_migrations-9.0.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "8dd833dbf3ef620940e0c53823a131b8",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 49002,
"upload_time": "2024-08-10T09:43:50",
"upload_time_iso_8601": "2024-08-10T09:43:50.388897Z",
"url": "https://files.pythonhosted.org/packages/8c/5d/9ef7f808ea955eca9f08043c65bdc81a4694e784c978b24ad72022974a97/yoyo_migrations-9.0.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-08-10 09:43:50",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "yoyo-migrations"
}
JSON