Lines Matching full:execute

157         self.con.execute("create table test(t text)")
176         cur.execute("select reftest()")
180         cur.execute("select returntext()")
187         res = cur.execute("select returntextwithnull()").fetchone()[0]
193         cur.execute("select returnunicode()")
200         cur.execute("select returnint()")
207         cur.execute("select returnfloat()")
215         cur.execute("select returnnull()")
222         cur.execute("select returnblob()")
229         cur.execute("select returnlonglong()")
235         cur.execute("select returnnan()")
241             self.con.execute("select returntoolargeint()")
246             cur.execute("select raiseexception()")
252         cur.execute("select spam(?, ?)", (1, 2))
257         cur = self.con.execute("select isblob(x'')")
261         cur = self.con.execute("select isnone(?)", (float("nan"),))
267         self.assertRaisesRegex(OverflowError, err, self.con.execute,
272                                self.con.execute, "select spam(?)",
277                                self.con.execute, "select spam(?)",
302             cur = self.con.execute("select test_params(?)", (val,))
318             self.con.execute("select nondeterministic() = nondeterministic()")
322                 self.con.execute("create index t on test(t) where nondeterministic() is not null")
329             self.con.execute("select deterministic() = deterministic()")
333                 self.con.execute("create index t on test(t) where deterministic() is not null")
367         cur.execute("""
376         cur.execute("insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)",
401             cur.execute("select nostep(t) from test")
407             cur.execute("select nofinalize(t) from test")
414             cur.execute("select excInit(t) from test")
421             cur.execute("select excStep(t) from test")
428             cur.execute("select excFinalize(t) from test")
434         cur.execute("select checkTypes('str', ?, ?)", ("foo", str()))
440         cur.execute("select checkType('int', ?)", (42,))
446         cur.execute("select checkTypes('int', ?, ?)", (42, 24))
452         cur.execute("select checkType('float', ?)", (3.14,))
458         cur.execute("select checkType('None', ?)", (None,))
464         cur.execute("select checkType('blob', ?)", (memoryview(b"blob"),))
470         cur.execute("delete from test")
472         cur.execute("select mysum(i) from test")
477         cur = self.con.execute("select mysum(i) from (select 1 as i) where i == 0")
485                 cur.execute("select aggtxt(?) from test", (txt,))
509         self.con.execute("select c2 from t2")
518             self.con.execute("select * from t2")
523             self.con.execute("select c2 from t1")