On May 10, 2014, at 3:34 PM, Joseph Casale <jcas...@gmail.com> wrote:
> I have about a dozen tables with an id PK column and a single column > with some unique string. I then have a single table that composes 13 > rows with an id PK field and all FK refs to rows in the other 12 tables. > > Bulk inserting data into the initial 12 tables is simple but I am not certain > how to setup the final table so I can pass just actual values that otherwise > would exist in the earlier 12 tables without passing in their PK id's. > > How do you setup the relationship in final table to facilitate passing in > actual values, allowing them to bypass a lookup for their PK id? standard relationship mechanics would allow this: myobject.some_relationship = some_related_object there's no need to worry about the actual PK or FK values. if that's not your question then perhaps provide more specifics. -- 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.