{"repo":"olirice/alembic_utils","free":true,"listed":false,"github":"https://github.com/olirice/alembic_utils","clone":"git clone https://github.com/olirice/alembic_utils.git","description":"An alembic/sqlalchemy extension for migrating sql views, functions, triggers, and policies","language":"Python","stars":300,"topics":["alembic","sqlalchemy","migration","postgresql","postgres"],"license":"MIT","category":"databases-storage","readme_excerpt":"Alembic Utils --- Documentation : https://olirice.github.io/alembic utils Source Code : https://github.com/olirice/alembic utils --- Autogenerate Support for PostgreSQL Functions, Views, Materialized View, Triggers, and Policies Alembic is the defacto migration tool for use with SQLAlchemy. Without extensions, alembic can detect local changes to SQLAlchemy models and autogenerate a database migration or \"revision\" script. That revision can be applied to update the database's schema to match the SQLAlchemy model definitions. Alembic Utils is an extension to alembic that adds support for autogenerating a larger number of PostgreSQL entity types, including functions, views, materialized views, triggers, and policies. TL;DR Update alembic's env.py to register a function or view: You're done! The next time you autogenerate a revision with Alembic will detect if your entities are new, updated, or removed & populate the revison's upgrade and downgrade sections automatically. For example: Visit the quickstart guide for usage instructions. —— —— Contributing To run the tests To invoke the linter automated formatting and generally make use of precommit checks:","default_branch":null,"files":null,"tree":[],"storefront":"/r/olirice","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/olirice/alembic_utils/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}