def testOrderOfArgs(self):
        """testing execute with different argument orderings"""
        c = self.cursor()
        try:

            # bindings and params flipped
            c.execute("select * from zxtesting where id = ?", bindings={0:zxJDBC.INTEGER}, params=[(3,)])
            f = c.fetchall()
            assert len(f) == 1, "expected length [1], got [%d]" % (len(f))

            # bindings and params flipped, empty params
            c.execute("select * from zxtesting where id = ?", bindings={}, params=[(3,)])
            f = c.fetchall()
            assert len(f) == 1, "expected length [1], got [%d]" % (len(f))

            # bindings and params flipped, empty params, empty bindings
            c.execute("select * from zxtesting where id = 3", bindings={}, params=[])
            f = c.fetchall()
            assert len(f) == 1, "expected length [1], got [%d]" % (len(f))

        finally:
            c.close()
            self.db.commit()
dataset/ETHPy150Open azoft-dev-team/imagrium/env/Lib/test/zxjdbc/zxtest.py/zxAPITestCase.testOrderOfArgs/original