Works like a charm the first try, thx a lot. Speaks for my variable-names then
;D.
We should somewhere build a catalog of mapper patterns or something.
Cheers,
Florian
Quoting Michael Bayer <[EMAIL PROTECTED]>:
> these would be a lot easier if you gave me a conceptual overview
> instead of my psychically reverse-engineering your classes from your
> variable names, but here goes....
>
> product_mapper = mapper(Product, products, properties = {
> 'artist' : relation(participant_mapper, participant_activity,
> primaryjoin=participant_activity.c.product_id==products.c.id,
> secondaryjoin=and_(
> participant_activity.c.activity_id==activity.c.id,
> participant_activity.c.participant_id==participant.c.id,
> activity.c.name=='artist'
> ),
> uselist=False
> )
> })
>
>
> what will be interesting to see will be if the relation manages to
> pull in the "activity" table into the SQL correctly (i dont see why
> it wouldnt but I havent tested this scenario yet).
>
> On Mar 16, 2006, at 11:38 AM, Florian Boesch wrote:
>
> > In short, I want to do a proper relation definition for that
> >
> > @property
> > def artist(self):
> > on_act_val = activity.c.name == 'artist'
> > on_track = participant_activity.c.product_id == self.id
> > on_act_join = participant_activity.c.activity_id == activity.c.id
> > on_part_join = participant_activity.c.participant_id ==
> > participant.c.id
> > return participants.selectone(on_track & on_act_join &
> > on_part_join &
> > on_act_val)
> >
> > any idea?
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> > language
> > that extends applications into web and mobile media. Attend the
> > live webcast
> > and join the prime developer group breaking into this new coding
> > territory!
> > http://sel.as-us.falkag.net/sel?
> > cmd=lnk&kid=110944&bid=241720&dat=121642
> > _______________________________________________
> > Sqlalchemy-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>
>
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
