Re: [sqlalchemy] How to best integrate executing against a pandas dataframe in a custom dialect.

Hi Mike. Thank you for taking the time to respond. Responses inline On Thu, Aug 29, 2019 at 10:35 AM Mike Bayer wrote: > > hi there, responses inline > > On Wed, Aug 28, 2019, at 11:39 PM, Varun Madiath wrote: > > Hi. > > I'm working to extend the Turbodbc >

[sqlalchemy] Polymorphic relationships to different classes

Suppose I have two distinct and unrelated ORM classes, call them Powers, and Dominions (which are in tables "powers" and "dominions", both having an "id" field), and I want them both to have relationships to their own subclass of a single-table polymorphic setup, call it Things. class

Re: Paritioned Table Migration

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

Re: [sqlalchemy] How to best integrate executing against a pandas dataframe in a custom dialect.

hi there, responses inline On Wed, Aug 28, 2019, at 11:39 PM, Varun Madiath wrote: > Hi. > > I'm working to extend the Turbodbc > dialect of the sqlalchemy_exasol > project to support > executing

Re: Paritioned Table Migration

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. >

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

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

Paritioned Table Migration

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