Re: [sqlalchemy] Listing all the tables that a query uses

2019-06-26 Thread Brian Maissy
You and sqlalchemy never cease to impress. Thank you very much! On Wed, Jun 26, 2019, 22:14 Mike Bayer wrote: > > > On Wed, Jun 26, 2019, at 1:51 PM, Brian Maissy wrote: > > Background: I have a bunch of materialized views (postgres) that are > dependent on each other. When I want to change one

Re: [sqlalchemy] Listing all the tables that a query uses

2019-06-26 Thread Mike Bayer
On Wed, Jun 26, 2019, at 1:51 PM, Brian Maissy wrote: > Background: I have a bunch of materialized views (postgres) that are > dependent on each other. When I want to change one of them, I drop cascade it > (postgres does not provide a way to modify the query of an existing > materialized

[sqlalchemy] Listing all the tables that a query uses

2019-06-26 Thread Brian Maissy
Background: I have a bunch of materialized views (postgres) that are dependent on each other. When I want to change one of them, I drop cascade it (postgres does not provide a way to modify the query of an existing materialized view) and recreate it and all of its dependents (which are dropped