Re: [sqlalchemy] selects, mappers and foreign keys

2014-05-11 Thread Richard Gerd Kuesters
thanks Mike! the problem is that the other side is also a selectable, so: foo = relationship(Remote, primaryjoin=myselect.c.foo == myotherselect.c.bar) myselect.c.foo *is* a foreign key to some table primary key that is the value of myotherselect.c.bar, but i can't figure out why or how

Re: [sqlalchemy] selects, mappers and foreign keys

2014-05-11 Thread Michael Bayer
On May 11, 2014, at 10:38 AM, Richard Gerd Kuesters rich...@humantech.com.br wrote: thanks Mike! the problem is that the other side is also a selectable, so: foo = relationship(Remote, primaryjoin=myselect.c.foo == myotherselect.c.bar) so again, i can see this might have issues,

Re: [sqlalchemy] selects, mappers and foreign keys

2014-05-11 Thread Richard Gerd Kuesters
thanks Mike, that worked fine. my code, though, didn't went further (i'll have to debug a little bit more) :) best regards, richard. Em 2014-05-11 14:43, Michael Bayer escreveu: On May 11, 2014, at 10:38 AM, Richard Gerd Kuesters rich...@humantech.com.br wrote: thanks Mike!

[sqlalchemy] selects, mappers and foreign keys

2014-05-10 Thread Richard Gerd Kuesters
hi all! situation: i'm mapping a select as a class, using mapper. so far so good. problem: some of my selected columns *are* foreign keys in their respective tables, but i would like to say to sqla that they're foreign keys to another mapped class, which have the pks from which those fks

Re: [sqlalchemy] selects, mappers and foreign keys

2014-05-10 Thread Michael Bayer
On May 10, 2014, at 7:13 PM, Richard Gerd Kuesters rich...@humantech.com.br wrote: hi all! situation: i'm mapping a select as a class, using mapper. so far so good. problem: some of my selected columns *are* foreign keys in their respective tables, but i would like to say to sqla that