From 052d4aba35a574429c691196c9a253e66eae1f5d Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 8 Jul 2005 02:23:54 +0000 Subject: [PATCH] --- test/select.py | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) diff --git a/test/select.py b/test/select.py index fe6a57f700..796806c9cd 100644 --- a/test/select.py +++ b/test/select.py @@ -314,6 +314,13 @@ FROM mytable, myothertable WHERE mytable.myid = myothertable.otherid AND mytable insert(self.table, select([self.table2])), "" ) + + def testupdate(self): + self.runtest(update(self.table, self.table.c.id == 7), "UPDATE mytable SET name=:name WHERE mytable.myid = :mytable_myid", params = {self.table.c.name:'fred'}) + self.runtest(update(self.table, self.table.c.id == 7), "UPDATE mytable SET name=:name WHERE mytable.myid = :mytable_myid", params = {'name':'fred'}) + + def testdelete(self): + self.runtest(delete(self.table, self.table.c.id == 7), "DELETE FROM mytable WHERE mytable.myid = :mytable_myid") def footestupdate(self): self.runtest( @@ -399,8 +406,8 @@ FROM mytable, myothertable WHERE mytable.myid = myothertable.otherid AND mytable u2 = alias(table, 'u2') - def runtest(self, clause, result, engine = None): - c = clause.compile(engine) + def runtest(self, clause, result, engine = None, params = None): + c = clause.compile(engine, params) print "\n" + str(c) + repr(c.get_params()) self.assert_(str(c) == result) -- 2.47.2