summaryrefslogtreecommitdiff
path: root/test/orm/eager_relations.py
diff options
context:
space:
mode:
authorJason Kirtland <jek@discorporate.us>2008-01-10 02:37:39 +0000
committerJason Kirtland <jek@discorporate.us>2008-01-10 02:37:39 +0000
commitbf36c648f2ef304f77cbde803453b0075ca6dcde (patch)
tree058ac03ea0818588629e35cf333274d8cd4cb995 /test/orm/eager_relations.py
parent84576e3258ea05b044f90463e8a59541661d5931 (diff)
downloadsqlalchemy-bf36c648f2ef304f77cbde803453b0075ca6dcde.tar.gz
Reworked r4042- undeclared deprecation warnings are now *fatal* to tests. No surprises.
Diffstat (limited to 'test/orm/eager_relations.py')
-rw-r--r--test/orm/eager_relations.py66
1 files changed, 33 insertions, 33 deletions
diff --git a/test/orm/eager_relations.py b/test/orm/eager_relations.py
index bef4ecffc..73d5b11dc 100644
--- a/test/orm/eager_relations.py
+++ b/test/orm/eager_relations.py
@@ -10,7 +10,7 @@ from query import QueryTest
class EagerTest(FixtureTest):
keep_mappers = False
keep_data = True
-
+
def test_basic(self):
mapper(User, users, properties={
'addresses':relation(mapper(Address, addresses), lazy=False)
@@ -62,15 +62,15 @@ class EagerTest(FixtureTest):
assert [
User(id=7, addresses=[
Address(id=1)
- ]),
+ ]),
User(id=8, addresses=[
Address(id=3, email_address='ed@bettyboop.com'),
Address(id=4, email_address='ed@lala.com'),
Address(id=2, email_address='ed@wood.com')
- ]),
+ ]),
User(id=9, addresses=[
Address(id=5)
- ]),
+ ]),
User(id=10, addresses=[])
] == q.all()
@@ -140,7 +140,7 @@ class EagerTest(FixtureTest):
# assert that the eager loader added 'user_id' to the row
# and deferred loading of that col was disabled
self.assert_sql_count(testbase.db, go, 0)
-
+
# do the mapping in reverse
# (we would have just used an "addresses" backref but the test fixtures then require the whole
# backref to be set up, lazy loaders trigger, etc.)
@@ -162,9 +162,9 @@ class EagerTest(FixtureTest):
# assert that the eager loader didn't have to affect 'user_id' here
# and that its still deferred
self.assert_sql_count(testbase.db, go, 1)
-
+
clear_mappers()
-
+
mapper(User, users, properties={'addresses':relation(Address, lazy=False)})
mapper(Address, addresses, properties={
'user_id':deferred(addresses.c.user_id),
@@ -178,7 +178,7 @@ class EagerTest(FixtureTest):
u = sess.query(User).limit(1).get(8)
assert User(id=8, addresses=[Address(id=2, dingalings=[Dingaling(id=1)]), Address(id=3), Address(id=4)]) == u
self.assert_sql_count(testbase.db, go, 1)
-
+
def test_many_to_many(self):
mapper(Keyword, keywords)
@@ -425,16 +425,16 @@ class EagerTest(FixtureTest):
'orders':relation(Order, primaryjoin=sel.c.id==orders.c.user_id, lazy=False)
})
mapper(Order, orders)
-
+
sess = create_session()
- self.assertEquals(sess.query(User).first(),
+ self.assertEquals(sess.query(User).first(),
User(name=u'jack',orders=[
- Order(address_id=1,description=u'order 1',isopen=0,user_id=7,id=1),
- Order(address_id=1,description=u'order 3',isopen=1,user_id=7,id=3),
+ Order(address_id=1,description=u'order 1',isopen=0,user_id=7,id=1),
+ Order(address_id=1,description=u'order 3',isopen=1,user_id=7,id=3),
Order(address_id=None,description=u'order 5',isopen=0,user_id=7,id=5)],
email_address=u'jack@bean.com',id=7)
)
-
+
def test_one_to_many_scalar(self):
mapper(User, users, properties = dict(
address = relation(mapper(Address, addresses), lazy=False, uselist=False)
@@ -520,7 +520,7 @@ class EagerTest(FixtureTest):
orders = relation(Order, lazy = False),
))
q = create_session().query(User)
- l = q.select()
+ l = q.all()
assert fixtures.user_all_result == q.all()
def test_against_select(self):
@@ -562,47 +562,47 @@ class AddEntityTest(FixtureTest):
def _assert_result(self):
return [
(
- User(id=7,
+ User(id=7,
addresses=[Address(id=1)]
),
- Order(id=1,
+ Order(id=1,
items=[Item(id=1), Item(id=2), Item(id=3)]
),
),
(
- User(id=7,
+ User(id=7,
addresses=[Address(id=1)]
),
- Order(id=3,
+ Order(id=3,
items=[Item(id=3), Item(id=4), Item(id=5)]
),
),
(
- User(id=7,
+ User(id=7,
addresses=[Address(id=1)]
),
- Order(id=5,
+ Order(id=5,
items=[Item(id=5)]
),
),
(
- User(id=9,
+ User(id=9,
addresses=[Address(id=5)]
),
- Order(id=2,
+ Order(id=2,
items=[Item(id=1), Item(id=2), Item(id=3)]
),
),
(
- User(id=9,
+ User(id=9,
addresses=[Address(id=5)]
),
- Order(id=4,
+ Order(id=4,
items=[Item(id=1), Item(id=5)]
),
)
]
-
+
def test_basic(self):
mapper(User, users, properties={
'addresses':relation(Address, lazy=False),
@@ -686,7 +686,7 @@ class SelfReferentialEagerTest(ORMTest):
]) == d
self.assert_sql_count(testbase.db, go, 1)
-
+
def test_lazy_fallback_doesnt_affect_eager(self):
class Node(Base):
def append(self, node):
@@ -727,7 +727,7 @@ class SelfReferentialEagerTest(ORMTest):
Node(data='n123')
] == list(n12.children)
self.assert_sql_count(testbase.db, go, 1)
-
+
def test_with_deferred(self):
class Node(Base):
def append(self, node):
@@ -748,7 +748,7 @@ class SelfReferentialEagerTest(ORMTest):
def go():
assert Node(data='n1', children=[Node(data='n11'), Node(data='n12')]) == sess.query(Node).first()
self.assert_sql_count(testbase.db, go, 4)
-
+
sess.clear()
def go():
@@ -756,13 +756,13 @@ class SelfReferentialEagerTest(ORMTest):
self.assert_sql_count(testbase.db, go, 3)
sess.clear()
-
+
def go():
assert Node(data='n1', children=[Node(data='n11'), Node(data='n12')]) == sess.query(Node).options(undefer('data'), undefer('children.data')).first()
self.assert_sql_count(testbase.db, go, 1)
-
-
-
+
+
+
def test_options(self):
class Node(Base):
def append(self, node):
@@ -808,7 +808,7 @@ class SelfReferentialEagerTest(ORMTest):
{'nodes_data_1': 'n1'}
),
])
-
+
@testing.fails_on('maxdb')
def test_no_depth(self):
class Node(Base):