{"repo":"DanCardin/sqlalchemy-declarative-extensions","free":true,"listed":false,"github":"https://github.com/DanCardin/sqlalchemy-declarative-extensions","clone":"git clone https://github.com/DanCardin/sqlalchemy-declarative-extensions.git","description":"Library to declare additional kinds of objects not natively supported by SqlAlchemy/Alembic.","language":"Python","stars":51,"topics":["alembic","declarative","postgresql","sqlalchemy","autogenerate","database","grant","role","trigger"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"SQLAlchemy Declarative Extensions See the full documentation here. Adds extensions to SQLAlchemy (and/or Alembic) which allows declaratively stating the existence of additional kinds of objects about your database not natively supported by SQLAlchemy/Alembic. The primary function(s) of this library include: - Registering onto the SQLAlchemy event system such that metadata.create all creates these objects. - (Optionally) Registers into Alembic such that alembic revision --autogenerate automatically creates/updates/deletes declared objects. Object support includes: Postgres MySQL SQLite Snowflake -------------- -------- ----- ------ --------- Schemas ✓ N/A ✓ ✓ Views ✓ ✓ ✓ ✓ Roles ✓ N/A ✓ Grants ✓ N/A Default Grants ✓ N/A Functions ✓ ✓ Procedures ✓ ✓ Triggers ✓ ✓ Databases ✓ N/A ✓ Rows (data) ✓ ✓ ✓ ✓ \"Audit Tables\" ✓ Notes: - \"Row\" is implemented with pure SQLAlchemy concepts, so should work for any dialect that you can use SQLAlchemy to connect to. - \"Audit Tables\" are a higher-level set of functions/triggers which record data changes against some source table. In principle, this library can absolutely support any database supported by SQLAlchemy, and capable of being introspected enough to support detection of different kinds of objects. In reality, the existence of implementations are going to be purely driven by actual usage/contributions/requests. See docs on dialect support for information on how to improve support for a given dialect. Also feel free to submit an issue! Ki","default_branch":null,"files":null,"tree":[],"storefront":"/r/DanCardin","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/DanCardin/sqlalchemy-declarative-extensions/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."}