Re: [sqlalchemy] Eager Loading of AssociationProxy (Generic Association with Discriminator on Association)

2014-11-24 Thread Michael Bayer
On Nov 24, 2014, at 1:00 AM, Victor Reichert vfr...@gmail.com wrote: I've taken another look at trying to eager load the address.parent. Is it possible to do that? Unfortuntately not really. It should be in theory but I’m not able to work out an eager load that goes to both Customer

Re: [sqlalchemy] Eager Loading of AssociationProxy (Generic Association with Discriminator on Association)

2014-11-24 Thread Michael Bayer
On Nov 24, 2014, at 12:31 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Nov 24, 2014, at 1:00 AM, Victor Reichert vfr...@gmail.com mailto:vfr...@gmail.com wrote: I've taken another look at trying to eager load the address.parent. Is it possible to do that? Unfortuntately

Re: [sqlalchemy] Eager Loading of AssociationProxy (Generic Association with Discriminator on Association)

2014-11-24 Thread Michael Bayer
On Nov 24, 2014, at 5:16 PM, Michael Bayer mike...@zzzcomputing.com wrote: On Nov 24, 2014, at 12:31 PM, Michael Bayer mike...@zzzcomputing.com mailto:mike...@zzzcomputing.com wrote: On Nov 24, 2014, at 1:00 AM, Victor Reichert vfr...@gmail.com mailto:vfr...@gmail.com wrote:

[sqlalchemy] Re: Migrating databases: Alembic vs. Liquibase, Flyway, ??

2014-11-24 Thread nedda
I will give you one very good reason to go with liquibase - technology independence. Alembic ties your db management to python and besides requires more manual work. Say tomorrow you decide to have multiple services implemented in different languages, alembic is not going to cut it. Just my

Re: [sqlalchemy] Migrating databases: Alembic vs. Liquibase, Flyway, ??

2014-11-24 Thread Michael Bayer
last I checked, XML was still a language. On Nov 24, 2014, at 9:05 PM, ne...@powertofly.com wrote: I will give you one very good reason to go with liquibase - technology independence. Alembic ties your db management to python and besides requires more manual work. Say tomorrow you

Re: [sqlalchemy] Eager Loading of AssociationProxy (Generic Association with Discriminator on Association)

2014-11-24 Thread Victor Reichert
Thank you! You are not an SQL alchemist, you are a SQL Wizard! Thank you again! For bonus points, an order by is possible on the discriminator like objects are returned consecutively: poly = with_polymorphic( AddressAssociation, [Customer.assoc_cls, Supplier.assoc_cls],

Re: [sqlalchemy] Eager Loading of AssociationProxy (Generic Association with Discriminator on Association)

2014-11-24 Thread Victor Reichert
I should add the final version of my file ist at: https://gist.github.com/vfr292/3330037cf5bc621d3d4b should anyone want to reference it. Thank you again Mr. Bayer! On Monday, November 24, 2014 11:00:06 PM UTC-8, Victor Reichert wrote: Thank you! You are not an SQL alchemist, you are a SQL