Lines Matching refs:cur
234 cur = self.con.cursor()
235 cur.execute("select reftest()")
238 cur = self.con.cursor()
239 cur.execute("select returntext()")
240 val = cur.fetchone()[0]
245 cur = self.con.cursor()
246 res = cur.execute("select returntextwithnull()").fetchone()[0]
251 cur = self.con.cursor()
252 cur.execute("select returnunicode()")
253 val = cur.fetchone()[0]
258 cur = self.con.cursor()
259 cur.execute("select returnint()")
260 val = cur.fetchone()[0]
265 cur = self.con.cursor()
266 cur.execute("select returnfloat()")
267 val = cur.fetchone()[0]
273 cur = self.con.cursor()
274 cur.execute("select returnnull()")
275 val = cur.fetchone()[0]
280 cur = self.con.cursor()
281 cur.execute("select returnblob()")
282 val = cur.fetchone()[0]
287 cur = self.con.cursor()
288 cur.execute("select returnlonglong()")
289 val = cur.fetchone()[0]
293 cur = self.con.cursor()
294 cur.execute("select returnnan()")
295 self.assertIsNone(cur.fetchone()[0])
298 cur = self.con.cursor()
304 cur = self.con.cursor()
306 cur.execute("select raiseexception()")
307 cur.fetchone()
312 cur = self.con.cursor()
314 cur.execute("select memoryerror()")
315 cur.fetchone()
319 cur = self.con.cursor()
321 cur.execute("select overflowerror()")
322 cur.fetchone()
325 cur = self.con.cursor()
326 cur.execute("select spam(?, ?)", (1, 2))
327 val = cur.fetchone()[0]
331 cur = self.con.execute("select isblob(x'')")
332 self.assertTrue(cur.fetchone()[0])
335 cur = self.con.execute("select isnone(?)", (float("nan"),))
337 self.assertTrue(cur.fetchone()[0])
353 cur = self.con.execute("select return_noncont_blob()")
354 cur.fetchone()
383 cur = self.con.execute("select test_params(?)", (val,))
384 cur.fetchone()
446 cur = self.con.cursor()
450 cur.execute("select largeint()")
454 cur = self.con.cursor()
458 cur.execute("select pychr(?)", (value,))
463 cur = self.con.cursor()
467 cur.execute("select largetext()")
472 cur = self.con.cursor()
476 cur.execute("select largeblob()")
510 self.cur = self.con.cursor()
539 self.cur.execute(self.query % "sumint")
540 self.assertEqual(self.cur.fetchall(), self.expected)
556 self.cur.execute(self.query % name)
557 self.cur.fetchall()
567 self.cur.execute(self.query % name)
568 self.cur.fetchall()
598 self.cur.execute(self.query % name)
599 self.cur.fetchall()
613 self.cur.execute(self.query % name)
614 self.cur.fetchall()
618 self.assertRaises(sqlite.OperationalError, self.cur.execute,
629 self.cur.execute(self.query % "sumint")
630 self.assertEqual(self.cur.fetchall(), expected)
640 self.cur.execute, self.query % "err_val_ret")
646 cur = self.con.cursor()
647 cur.execute("""
656 cur.execute("insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)",
670 #self.cur.close()
680 cur = self.con.cursor()
682 cur.execute("select nostep(t) from test")
687 cur = self.con.cursor()
690 cur.execute("select nofinalize(t) from test")
691 val = cur.fetchone()[0]
695 cur = self.con.cursor()
697 cur.execute("select excInit(t) from test")
698 val = cur.fetchone()[0]
703 cur = self.con.cursor()
705 cur.execute("select excStep(t) from test")
706 val = cur.fetchone()[0]
711 cur = self.con.cursor()
713 cur.execute("select excFinalize(t) from test")
714 val = cur.fetchone()[0]
718 cur = self.con.cursor()
719 cur.execute("select checkTypes('str', ?, ?)", ("foo", str()))
720 val = cur.fetchone()[0]
724 cur = self.con.cursor()
725 cur.execute("select checkType('int', ?)", (42,))
726 val = cur.fetchone()[0]
730 cur = self.con.cursor()
731 cur.execute("select checkTypes('int', ?, ?)", (42, 24))
732 val = cur.fetchone()[0]
736 cur = self.con.cursor()
737 cur.execute("select checkType('float', ?)", (3.14,))
738 val = cur.fetchone()[0]
742 cur = self.con.cursor()
743 cur.execute("select checkType('None', ?)", (None,))
744 val = cur.fetchone()[0]
748 cur = self.con.cursor()
749 cur.execute("select checkType('blob', ?)", (memoryview(b"blob"),))
750 val = cur.fetchone()[0]
754 cur = self.con.cursor()
755 cur.execute("delete from test")
756 cur.executemany("insert into test(i) values (?)", [(10,), (20,), (30,)])
757 cur.execute("select mysum(i) from test")
758 val = cur.fetchone()[0]
762 cur = self.con.execute("select mysum(i) from (select 1 as i) where i == 0")
763 val = cur.fetchone()[0]
767 cur = self.con.cursor()
770 cur.execute("select aggtxt(?) from test", (txt,))
771 val = cur.fetchone()[0]