Hello
I've following problem. I've two tables (t1, t2) and relation t1 (one)
- t2 (many):
mapper(T1, t1, properties={"t2s": relation(T2, lazy=False)})
mapper(T2, t2, properties={"t1": relation(T1, lazy=False)})
When I add row to t1, then to t2, and then run query for first row in
t1, I see one
element in collection t2s - it is ok.
Then when I add second row to t2, the collection in t1 object is not
updated.
It still contains only one element.
Example below.
Could you tell me how to refresh collection in one-to-many relation???
Regards
Michal Nowikowski
from sqlalchemy import *
md = MetaData('sqlite:///a.db', echo=False)
t1 = Table("t1", md,
Column("id", Integer, primary_key=True),
Column("version", Integer))
t2 = Table("t2", md,
Column("id", Integer, primary_key=True),
Column("name", String),
Column("t1_id", Integer, ForeignKey("t1.id")))
md.create_all()
s = create_session()
class T1(object):
pass
class T2(object):
pass
mapper(T1, t1, properties={"t2s": relation(T2, lazy=False)})
mapper(T2, t2, properties={"t1": relation(T1, lazy=False)})
a1 = T1()
s.save(a1)
s.flush()
a2 = T2()
a2.t1_id = a1.id
a2.name = "AAA"
s.save(a2)
s.flush()
ra1 = s.query(T1).first()
print [ a.name for a in ra1.t2s ]
a22 = T2()
a22.t1_id = a1.id
a22.name = "BBB"
s.save(a22)
s.flush()
rra1 = s.query(T1).first()
print [ a.name for a in rra1.t2s ]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
