Paritioned Table Migration

2019-08-29 Thread Stephan Gerhard
Hi, I am wondering whether it is possible to use Alembic to define a migration where I add a partitioned table - a feature that is supported in Postgres 12 - e.g. using range partitions. https://www.2ndquadrant.com/en/blog/partitioning-enhancements-in-postgresql-12/ How would I write this as an

Re: How to rename column on MySQL without deleting existing data?

2019-08-29 Thread Mike
Thanks it worked! *models.py* class Experiments(db.Model): id = db.Column(db.Integer, primary_key=True) kountry = db.Column(db.String(100)) #countryland = db.Column(db.String(100)) *migration file* from alembic import op import sqlalchemy as sa from sqlalchemy.dialects import

Re: Paritioned Table Migration

2019-08-29 Thread Mike Bayer
On Thu, Aug 29, 2019, at 8:55 AM, Stephan Gerhard wrote: > Hi, > > I am wondering whether it is possible to use Alembic to define a migration > where I add a partitioned table - a feature that is supported in Postgres 12 > - e.g. using range partitions. > https://www.2ndquadrant.com/en/blog/pa

Re: Paritioned Table Migration

2019-08-29 Thread Stephan Gerhard
Thanks! Am Donnerstag, 29. August 2019 16:16:28 UTC+2 schrieb Mike Bayer: > > > > On Thu, Aug 29, 2019, at 8:55 AM, Stephan Gerhard wrote: > > Hi, > > I am wondering whether it is possible to use Alembic to define a migration > where I add a partitioned table - a feature that is supported in Post