From 05a693fcb7a57f0362e06da1517cb35279bfaad1 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 11 Jan 2008 21:30:02 +0000 Subject: fixed NOT ILIKE --- test/sql/select.py | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'test/sql/select.py') diff --git a/test/sql/select.py b/test/sql/select.py index b922c5c22..4c15bfb1b 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -527,9 +527,13 @@ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") A def testilike(self): stmt = table1.select(table1.c.name.ilike('%something%')) - self.assert_compile(stmt, "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE lower(mytable.name) LIKE :mytable_name_1") + self.assert_compile(stmt, "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE lower(mytable.name) LIKE lower(:mytable_name_1)") self.assert_compile(stmt, "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.name ILIKE %(mytable_name_1)s", dialect=postgres.PGDialect()) + stmt = table1.select(~table1.c.name.ilike('%something%')) + self.assert_compile(stmt, "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE lower(mytable.name) NOT LIKE lower(:mytable_name_1)") + self.assert_compile(stmt, "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.name NOT ILIKE %(mytable_name_1)s", dialect=postgres.PGDialect()) + def testforupdate(self): self.assert_compile(table1.select(table1.c.myid==7, for_update=True), "SELECT mytable.myid, mytable.name, mytable.description FROM mytable WHERE mytable.myid = :mytable_myid_1 FOR UPDATE") -- cgit v1.2.1