def testQueryWithParameter(self):
        """testing query by parameter"""
        c = self.cursor()
        try:
            c.execute("select name from zxtesting where state = ?", [("il",)], {0:zxJDBC.VARCHAR})
            data = c.fetchall()
            assert len(data) == 2, "expected [2] rows, got [%d]" % (len(data))
            c.execute("select name from zxtesting where state = ?", [("co",)], {0:zxJDBC.VARCHAR})
            data = c.fetchall()
            assert len(data) == 1, "expected [1] row, got [%d]" % (len(data))
        finally:
            c.close()
dataset/ETHPy150Open azoft-dev-team/imagrium/env/Lib/test/zxjdbc/zxtest.py/zxAPITestCase.testQueryWithParameter/original