Re: [sqlalchemy] DeferredReflection with optional tables

2016-09-09 Thread bsdz
Thank you very much. That worked :) On Wednesday, 7 September 2016 14:56:25 UTC+1, Mike Bayer wrote: > > > > On 09/07/2016 05:08 AM, bsdz wrote: > > No worries and thanks for the suggestions/advice so far. > > > > Tbh I tried the mixin approach first as

Re: [sqlalchemy] DeferredReflection with optional tables

2016-09-07 Thread bsdz
entity expected - got '' I'm pretty sure I also tried the abstract approach with similar results. Perhaps I'm binding incorrectly? On Tuesday, 6 September 2016 18:37:14 UTC+1, Mike Bayer wrote: > > > > On 09/06/2016 12:50 PM, bsdz wrote: > > Thanks for your reply. > > &

Re: [sqlalchemy] DeferredReflection with optional tables

2016-09-06 Thread bsdz
Thanks for your reply. I think you misread my code. The method "remove" does exist. It's a method of MetaData and not tables. See http://docs.sqlalchemy.org/en/rel_1_0/core/metadata.html#sqlalchemy.schema.MetaData. I'm not sure about automap. I'm not keen on reflecting all the tables in my

[sqlalchemy] DeferredReflection with optional tables

2016-09-06 Thread bsdz
Hi I am trying to implement optional tables with DeferredReflection. The idea is in different environments certain tables might exist while not in others. I have tried removing the tables from the metadata for the declarative base if the table's info doesn't list the environment (see below)

Re: [sqlalchemy] relationship with DeferredReflection raises NoForeignKeysError

2016-07-30 Thread bsdz
Yes, that worked - thanks! :) > -- 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] relationship with DeferredReflection raises NoForeignKeysError

2016-07-29 Thread bsdz
Hi I'm trying to use DeferredReflection to encapsulate my data model so that it can easily be instantiated for different environments. However, I am having trouble creating relationships with a NoForeignKeysError being raised. I am guessing it is because the table metadata generation is being