[ticket:280] statement execution supports using the same BindParam

object more than once in an expression; simplified handling of positional
parameters.  nice job by Bill Noon figuring out the basic idea.

1 files changed, 10 insertions, 0 deletions

diff --git a/test/sql/query.py b/test/sql/query.py
index 2148aae67..ccb998e9e 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -115,6 +115,16 @@ class QueryTest(PersistTest):
         finally:
             test_table.drop()
 
+    def test_repeated_bindparams(self):
+        """test that a BindParam can be used more than once.  
+        this should be run for dbs with both positional and named paramstyles."""
+        self.users.insert().execute(user_id = 7, user_name = 'jack')
+        self.users.insert().execute(user_id = 8, user_name = 'fred')
+
+        u = bindparam('uid')
+        s = self.users.select(or_(self.users.c.user_name==u, self.users.c.user_name==u))
+        r = s.execute(uid='fred').fetchall()
+        assert len(r) == 1
         
     def testdelete(self):
         self.users.insert().execute(user_id = 7, user_name = 'jack')