summaryrefslogtreecommitdiff
path: root/test/orm/inheritance/test_basic.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2010-12-09 19:06:22 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2010-12-09 19:06:22 -0500
commit5622cfd5ecd5efe5e8c737be6b2ba0100aaf86b0 (patch)
tree72558e291ebc958b1061404713eccbb3ee74074a /test/orm/inheritance/test_basic.py
parent6e4515948f87a2299461003c709393b68453d2d0 (diff)
downloadsqlalchemy-5622cfd5ecd5efe5e8c737be6b2ba0100aaf86b0.tar.gz
callcount destructo engage
Diffstat (limited to 'test/orm/inheritance/test_basic.py')
-rw-r--r--test/orm/inheritance/test_basic.py43
1 files changed, 28 insertions, 15 deletions
diff --git a/test/orm/inheritance/test_basic.py b/test/orm/inheritance/test_basic.py
index 57c40ccc1..095434999 100644
--- a/test/orm/inheritance/test_basic.py
+++ b/test/orm/inheritance/test_basic.py
@@ -1327,17 +1327,23 @@ class OptimizedLoadTest(_base.MappedTest):
[{'data':'s1','type':'sub'}]
),
CompiledSQL(
- "SELECT sub.counter AS sub_counter, base.counter AS "
- "base_counter FROM base JOIN sub ON base.id = "
- "sub.id WHERE base.id = :param_1",
- lambda ctx:{'param_1':s1.id}
- ),
- CompiledSQL(
"INSERT INTO sub (id, sub) VALUES (:id, :sub)",
lambda ctx:{'id':s1.id, 'sub':None}
),
)
-
+ def go():
+ eq_( s1.counter2, 1 )
+ self.assert_sql_execution(
+ testing.db,
+ go,
+ CompiledSQL(
+ "SELECT sub.counter AS sub_counter, base.counter AS base_counter, "
+ "sub.counter2 AS sub_counter2 FROM base JOIN sub ON "
+ "base.id = sub.id WHERE base.id = :param_1",
+ lambda ctx:{u'param_1': s1.id}
+ ),
+ )
+
@testing.resolve_artifact_names
def test_dont_generate_on_none(self):
class Base(_base.ComparableEntity):
@@ -1394,18 +1400,25 @@ class OptimizedLoadTest(_base.MappedTest):
lambda ctx:[{'counter': 1, 'sub': None, 'id': s1.id}]
),
CompiledSQL(
- "SELECT subsub.counter2 AS subsub_counter2, sub.counter2 AS "
- "sub_counter2 FROM base JOIN sub ON base.id = sub.id JOIN "
- "subsub ON sub.id = subsub.id WHERE base.id = :param_1",
- lambda ctx:{u'param_1': s1.id}
- ),
- CompiledSQL(
"INSERT INTO subsub (id) VALUES (:id)",
lambda ctx:{'id':s1.id}
),
)
-
-
+
+ def go():
+ eq_(
+ s1.counter2, 1
+ )
+ self.assert_sql_execution(
+ testing.db,
+ go,
+ CompiledSQL(
+ "SELECT subsub.counter2 AS subsub_counter2, "
+ "sub.counter2 AS sub_counter2 FROM subsub, sub "
+ "WHERE :param_1 = sub.id AND sub.id = subsub.id",
+ lambda ctx:{u'param_1': s1.id}
+ ),
+ )
class PKDiscriminatorTest(_base.MappedTest):
@classmethod