please forward an runnable example test case, preferably a single file with <200 lines if possible.
you're also making usage of Column instances directly off the selectable youre mapping, right ? On Mar 5, 2007, at 1:55 PM, Pete Taylor wrote: > > in regard to post-2309 revisions and the foreignkey keyword > deprecation... > > I know this conversation seems to have terminated as of 2/21, but it's > the only thread that was tracing through a problem i'm having. I'm > certain my problem is just one of my own lack of understanding on how > to use foreign_keys now, but I'll lay it out there... > > I have a legacy table that, in effect, maps to two classes. A > container-style class and a line items class, which for convenience > we'll just call Container and LineItem. A Container has_many > LineItem, as you might imagine. The issue, however, is that the > Container class is mapped against a select statement from that table, > not the table directly, while the LineItem class is mapped against the > table, largely because there's an incrementing LineItem id that's a > primary key on the table, but has no meaning to the Container. > > before 2309, I was able to map the lineItem relationship back to the > container class using an explicit primary join and a foreignkey > statement. > > I've read through the self-referential example rather a lot, and the > two mailing list threads, and have tried all the combinations and > permutations of primaryjoin, foreign_keys, and remote_side that I can > think of (obviously not all of them or it would have worked ;) ), from > the mappers and relationships on both classes, and I can't seem to > figure out the right way to make it work. I can send along a > simplified mockup of the relationships and what I've got currently if > anyone has time to take a look, but I may in fact just be heading the > wrong direction... > > Any help would be greatly appreciated! > Pete Taylor > > -- > "All guilt is relative, loyalty counts, and never let your conscience > be your guide." > - Lucas Buck, American Gothic > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
