[sqlalchemy] Splitting a table ?

2015-12-02 Thread Jonathan Vanasco
I recently had to "split" or partition another table into 2 -- one of high write and low write access. The new table is just the high-write columns fkey'd onto the original table, and handled with a relationship. I was wondering if there was any "shortcut" in sqlalchemy to automatically

Re: [sqlalchemy] Splitting a table ?

2015-12-02 Thread Jeff Widman
I've also been dealing with a similar problem of managing a parent/child table that is the result of splitting an original table, and also curious to hear suggested solutions. Solutions I've thought about so far: a) using a hybrid property or column_property to map the columns back onto the

Re: [sqlalchemy] post_update issue

2015-12-02 Thread Mike Bayer
On 12/01/2015 07:24 PM, Thorsten von Stein wrote: > The following issue, which puzzled for several days, exists in several > versions. I verified that it applies to version 1.0.9 > > In my understanding, the post_update flag is required on a relationship > between to classes A and B if there is

Re: [sqlalchemy] post_update issue

2015-12-02 Thread Thorsten von Stein
Great! Thanks a lot. Thorsten -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [sqlalchemy] Splitting a table ?

2015-12-02 Thread Mike Bayer
On 12/02/2015 10:18 AM, Jonathan Vanasco wrote: > > I recently had to "split" or partition another table into 2 -- one of high > write and low write access. The new table is just the high-write columns > fkey'd onto the original table, and handled with a relationship. > > I was wondering if

[sqlalchemy] Insert new column in an existing database

2015-12-02 Thread Jothybasu Selvaraj
Dear All I just started to use sqlalchemy and I am also quite new to databases. I have a sqlite database saved with a table with name "Table1" and now I want to insert a colum with PickleType. The below code works for TEXT, INTEGER, etc... but not for PickleType.

Re: [sqlalchemy] non-table DDL elements and MetaData objects

2015-12-02 Thread Mike Bayer
On 12/02/2015 02:13 AM, Chris Withers wrote: > On 02/12/2015 00:08, Mike Bayer wrote: >> On 12/01/2015 02:49 PM, Chris Withers wrote: >>> - once at 'database creation' time, so set up some stored >>> procedures. (I know SQLAlchemy doesn't create databases itself, so >>> interested in