diff options
| author | Ants Aasma <ants.aasma@gmail.com> | 2007-10-16 22:57:05 +0000 |
|---|---|---|
| committer | Ants Aasma <ants.aasma@gmail.com> | 2007-10-16 22:57:05 +0000 |
| commit | 6bbc7dd157faf5b513852286ba656fa6723cd2d6 (patch) | |
| tree | 805fc72fd0053fa4eeedc1b72e9ab55651a177c2 /test/dialect/mssql.py | |
| parent | cc0e7c796f61e17cb7050de0701905c65ce558eb (diff) | |
| download | sqlalchemy-6bbc7dd157faf5b513852286ba656fa6723cd2d6.tar.gz | |
change the in_ API to accept a sequence or a selectable [ticket:750]
Diffstat (limited to 'test/dialect/mssql.py')
| -rwxr-xr-x | test/dialect/mssql.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/test/dialect/mssql.py b/test/dialect/mssql.py index eeadde2ff..b750e8ecd 100755 --- a/test/dialect/mssql.py +++ b/test/dialect/mssql.py @@ -36,8 +36,8 @@ class CompileTest(SQLCompileTest): column('col4')) (s1, s2) = ( - select([t1.c.col3.label('col3'), t1.c.col4.label('col4')], t1.c.col2.in_("t1col2r1", "t1col2r2")), - select([t2.c.col3.label('col3'), t2.c.col4.label('col4')], t2.c.col2.in_("t2col2r2", "t2col2r3")) + select([t1.c.col3.label('col3'), t1.c.col4.label('col4')], t1.c.col2.in_(["t1col2r1", "t1col2r2"])), + select([t2.c.col3.label('col3'), t2.c.col4.label('col4')], t2.c.col2.in_(["t2col2r2", "t2col2r3"])) ) u = union(s1, s2, order_by=['col3', 'col4']) self.assert_compile(u, "SELECT t1.col3 AS col3, t1.col4 AS col4 FROM t1 WHERE t1.col2 IN (:t1_col2, :t1_col2_1) UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:t2_col2, :t2_col2_1) ORDER BY col3, col4") |