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 original table--a little tedious because each one has to be re-added b) Creating a new object that's the result of joining the two tables--main problem is I have to update all the app code to use the new object Curious to hear what others do. ᐧ On Wed, Dec 2, 2015 at 7:18 AM, Jonathan Vanasco <jonat...@findmeon.com> 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 there was any "shortcut" in sqlalchemy to automatically > handle stuff like this, or a common pattern. > > The best I could think of is using an association proxy to map the columns > back -- but that must be done for every column, and doesn't handle the > creation of the new table as a dependency. > > My current manual solution works, just wondering if there are better ways. > > -- > 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 sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- *Jeff Widman* jeffwidman.com <http://www.jeffwidman.com/> | 740-WIDMAN-J (943-6265) <>< -- 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 sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.