diff options
Diffstat (limited to 'test/sql/case_statement.py')
| -rw-r--r-- | test/sql/case_statement.py | 16 |
1 files changed, 9 insertions, 7 deletions
diff --git a/test/sql/case_statement.py b/test/sql/case_statement.py index 946279b9d..493545b22 100644 --- a/test/sql/case_statement.py +++ b/test/sql/case_statement.py @@ -1,13 +1,15 @@ -import sys import testbase +import sys from sqlalchemy import * +from testlib import * -class CaseTest(testbase.PersistTest): +class CaseTest(PersistTest): def setUpAll(self): + metadata = MetaData(testbase.db) global info_table - info_table = Table('infos', testbase.db, + info_table = Table('infos', metadata, Column('pk', Integer, primary_key=True), Column('info', String(30))) @@ -26,9 +28,9 @@ class CaseTest(testbase.PersistTest): def testcase(self): inner = select([case([ [info_table.c.pk < 3, - literal('lessthan3', type=String)], + literal('lessthan3', type_=String)], [and_(info_table.c.pk >= 3, info_table.c.pk < 7), - literal('gt3', type=String)]]).label('x'), + literal('gt3', type_=String)]]).label('x'), info_table.c.pk, info_table.c.info], from_obj=[info_table]).alias('q_inner') @@ -65,9 +67,9 @@ class CaseTest(testbase.PersistTest): w_else = select([case([ [info_table.c.pk < 3, - literal(3, type=Integer)], + literal(3, type_=Integer)], [and_(info_table.c.pk >= 3, info_table.c.pk < 6), - literal(6, type=Integer)]], + literal(6, type_=Integer)]], else_ = 0).label('x'), info_table.c.pk, info_table.c.info], from_obj=[info_table]).alias('q_inner') |