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
Sqlalchemy-users@lists.sourceforge.net
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
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
