Dear List.
How do I do this more ormish?
The statement is supposed to find the latest messages which havent yet
been answered
by 123456, assuming a later message is an answer;-)
def play4():
print ############### play4 #################
engine=create_engine(dburi)
result=engine.execute("""
select m.fromid, s.name, m.sent from person s,message m
where toid=123456 and
s.personid = m.fromid and not exists (
select 1 from message k where
k.toid=m.fromid and k.fromid=m.toid
and k.sent > m.sent
)
order by m.sent desc
""")
...
I completely fail to grasp how I get from the straight sql-
representation to the part where i
can actually benefit from the orm
Here am I: I have created a mapper where each message knows it's
sender and receiver by foreign key and attribute like this (and this I
like very much):
message_mapper=mapper(
Message,
message_table,
properties={
"sender": relation(Person,
primaryjoin=(message_table.c.fromid==Person.c.personid)),
"receiver": relation(Person,
primaryjoin=(message_table.c.toid==Person.c.personid))
}
)
kind regards
jorgen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
