summaryrefslogtreecommitdiff
path: root/test/sql/test_case_statement.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2010-09-05 14:44:58 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2010-09-05 14:44:58 -0400
commit703ce7f1791c1143eb983c38e3bd627984ea1953 (patch)
treed52e3cc51041b96985e96b58f2340be233fc3600 /test/sql/test_case_statement.py
parent1f65ac6679298c7f18e8ff3b13d6694e357ed5d5 (diff)
downloadsqlalchemy-703ce7f1791c1143eb983c38e3bd627984ea1953.tar.gz
- rewrote the "connections" section
- improved pool docs - typos etc. - ClauseElement.execute() and scalar() make no sense - these are depreacted. The official home is Executable. - alias() is not executable, allowing it is sloppy so this goes under the deprecated umbrella
Diffstat (limited to 'test/sql/test_case_statement.py')
-rw-r--r--test/sql/test_case_statement.py8
1 files changed, 4 insertions, 4 deletions
diff --git a/test/sql/test_case_statement.py b/test/sql/test_case_statement.py
index 645822fa7..1a106ee5e 100644
--- a/test/sql/test_case_statement.py
+++ b/test/sql/test_case_statement.py
@@ -32,14 +32,14 @@ class CaseTest(TestBase, AssertsCompiledSQL):
@testing.fails_on('firebird', 'FIXME: unknown')
@testing.fails_on('maxdb', 'FIXME: unknown')
@testing.requires.subqueries
- def testcase(self):
+ def test_case(self):
inner = select([case([
[info_table.c.pk < 3,
'lessthan3'],
[and_(info_table.c.pk >= 3, info_table.c.pk < 7),
'gt3']]).label('x'),
info_table.c.pk, info_table.c.info],
- from_obj=[info_table]).alias('q_inner')
+ from_obj=[info_table])
inner_result = inner.execute().fetchall()
@@ -59,7 +59,7 @@ class CaseTest(TestBase, AssertsCompiledSQL):
('gt3', 6, 'pk_6_data')
]
- outer = select([inner])
+ outer = select([inner.alias('q_inner')])
outer_result = outer.execute().fetchall()
@@ -79,7 +79,7 @@ class CaseTest(TestBase, AssertsCompiledSQL):
6]],
else_ = 0).label('x'),
info_table.c.pk, info_table.c.info],
- from_obj=[info_table]).alias('q_inner')
+ from_obj=[info_table])
else_result = w_else.execute().fetchall()