diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-12-08 18:38:18 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-12-08 18:38:18 +0000 |
| commit | 78bb82a44b7f382c6cfeab0cfc7f932e68c4de86 (patch) | |
| tree | c427edb118c468133d50d45bbbf2b3f9bab71baf /test/dialect/mssql.py | |
| parent | 377a57ea8d485d6ec8c0c6e91d64f10982450e70 (diff) | |
| download | sqlalchemy-78bb82a44b7f382c6cfeab0cfc7f932e68c4de86.tar.gz | |
changed the anonymous numbering scheme to be more appealing
got tests running
Diffstat (limited to 'test/dialect/mssql.py')
| -rwxr-xr-x | test/dialect/mssql.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/test/dialect/mssql.py b/test/dialect/mssql.py index 1a8504701..3207abaa3 100755 --- a/test/dialect/mssql.py +++ b/test/dialect/mssql.py @@ -40,9 +40,11 @@ class CompileTest(SQLCompileTest): 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_1, :t1_col2_2) UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:t2_col2_3, :t2_col2_4) 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_1, :t1_col2_2) "\ + "UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:t2_col2_1, :t2_col2_2) ORDER BY col3, col4") - self.assert_compile(u.alias('bar').select(), "SELECT bar.col3, bar.col4 FROM (SELECT t1.col3 AS col3, t1.col4 AS col4 FROM t1 WHERE t1.col2 IN (:t1_col2_1, :t1_col2_2) UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:t2_col2_3, :t2_col2_4)) AS bar") + self.assert_compile(u.alias('bar').select(), "SELECT bar.col3, bar.col4 FROM (SELECT t1.col3 AS col3, t1.col4 AS col4 FROM t1 WHERE "\ + "t1.col2 IN (:t1_col2_1, :t1_col2_2) UNION SELECT t2.col3 AS col3, t2.col4 AS col4 FROM t2 WHERE t2.col2 IN (:t2_col2_1, :t2_col2_2)) AS bar") def test_function(self): self.assert_compile(func.foo(1, 2), "foo(:foo_1, :foo_2)") |