alembic_utils

alembic_utils copied to clipboard

Can't create migration for views that depend on other objects in the migration

5

When generating a migration for a view that depends on a _new_ *table*, alembic_utils triggers a Postgres error as the dependency doesn't exist yet. This is caused by the code...

mjpieters

[Question] How to add a unique index to definition for PGMaterializedView

4

Hi there I have a materialized view defined using `PGMaterializedView` in a views.py file. The views had already been created in the database. I want to now add a unique...

MeganBeckett

gracefully handle when a migrator needs to modify a column that a view depends on

8

Alembic version: 1.7.7 Alembic_utils version: 0.7.7 db: postgres 12 Here's a basic setup: ```sql -- pretend I have SQLAlchemy classes set up to create these CREATE TABLE A ( id...

nstrong-scw

Duplicated ReplaceableEntity on every migration

5

All ReplaceableEntities that are defined in `env.py` are added on every auto generated migration. Even if there are no change in those entities. Maybe add some sort of checksum? Anyway,...

erakli

olirice

Fix typo in `PGTrigger.from_sql` docstring * [x] #83

olirice

Move all the things to pyproject.toml

olirice

Can't create trigger on the table from the same migration

11

As title suggest, these seems to be a bug when creating trigger on a table that doesn't exist yet and is part of the same migration. In such case autogenerated...

LKay

Update pg_materialized_view.py

5

I had problems using this to create materialized views with indizes cause of alembic migration tried to replace the views without indizes every time a new autogenerate has to be...

onkel-uwe

Proposed PGSchema object

1

Hello @olirice! I am back with another issue. For my use case, I wanted to be able to manage schemas through alembic as well as all of the views, functions...

quoimec