Lines Matching refs:cur
191 cur = self.con.cursor()
192 cur.execute("select reftest()")
195 cur = self.con.cursor()
196 cur.execute("select returntext()")
197 val = cur.fetchone()[0]
202 cur = self.con.cursor()
203 res = cur.execute("select returntextwithnull()").fetchone()[0]
208 cur = self.con.cursor()
209 cur.execute("select returnunicode()")
210 val = cur.fetchone()[0]
215 cur = self.con.cursor()
216 cur.execute("select returnint()")
217 val = cur.fetchone()[0]
222 cur = self.con.cursor()
223 cur.execute("select returnfloat()")
224 val = cur.fetchone()[0]
230 cur = self.con.cursor()
231 cur.execute("select returnnull()")
232 val = cur.fetchone()[0]
237 cur = self.con.cursor()
238 cur.execute("select returnblob()")
239 val = cur.fetchone()[0]
244 cur = self.con.cursor()
245 cur.execute("select returnlonglong()")
246 val = cur.fetchone()[0]
250 cur = self.con.cursor()
252 cur.execute("select raiseexception()")
253 cur.fetchone()
257 cur = self.con.cursor()
260 cur.execute("select isstring(?)", (text,))
261 val = cur.fetchone()[0]
265 cur = self.con.cursor()
266 cur.execute("select isint(?)", (42,))
267 val = cur.fetchone()[0]
271 cur = self.con.cursor()
272 cur.execute("select isfloat(?)", (3.14,))
273 val = cur.fetchone()[0]
277 cur = self.con.cursor()
278 cur.execute("select isnone(?)", (None,))
279 val = cur.fetchone()[0]
283 cur = self.con.cursor()
284 cur.execute("select isblob(?)", (memoryview(b"blob"),))
285 val = cur.fetchone()[0]
289 cur = self.con.cursor()
290 cur.execute("select islonglong(?)", (1<<42,))
291 val = cur.fetchone()[0]
295 cur = self.con.cursor()
296 cur.execute("select spam(?, ?)", (1, 2))
297 val = cur.fetchone()[0]
301 cur = self.con.execute("select isblob(x'')")
302 self.assertTrue(cur.fetchone()[0])
364 cur = self.con.cursor()
365 cur.execute("""
374 cur.execute("insert into test(t, i, f, n, b) values (?, ?, ?, ?, ?)",
397 cur = self.con.cursor()
399 cur.execute("select nostep(t) from test")
403 cur = self.con.cursor()
405 cur.execute("select nofinalize(t) from test")
406 val = cur.fetchone()[0]
410 cur = self.con.cursor()
412 cur.execute("select excInit(t) from test")
413 val = cur.fetchone()[0]
417 cur = self.con.cursor()
419 cur.execute("select excStep(t) from test")
420 val = cur.fetchone()[0]
424 cur = self.con.cursor()
426 cur.execute("select excFinalize(t) from test")
427 val = cur.fetchone()[0]
431 cur = self.con.cursor()
432 cur.execute("select checkTypes('str', ?, ?)", ("foo", str()))
433 val = cur.fetchone()[0]
437 cur = self.con.cursor()
438 cur.execute("select checkType('int', ?)", (42,))
439 val = cur.fetchone()[0]
443 cur = self.con.cursor()
444 cur.execute("select checkTypes('int', ?, ?)", (42, 24))
445 val = cur.fetchone()[0]
449 cur = self.con.cursor()
450 cur.execute("select checkType('float', ?)", (3.14,))
451 val = cur.fetchone()[0]
455 cur = self.con.cursor()
456 cur.execute("select checkType('None', ?)", (None,))
457 val = cur.fetchone()[0]
461 cur = self.con.cursor()
462 cur.execute("select checkType('blob', ?)", (memoryview(b"blob"),))
463 val = cur.fetchone()[0]
467 cur = self.con.cursor()
468 cur.execute("delete from test")
469 cur.executemany("insert into test(i) values (?)", [(10,), (20,), (30,)])
470 cur.execute("select mysum(i) from test")
471 val = cur.fetchone()[0]
475 cur = self.con.execute("select mysum(i) from (select 1 as i) where i == 0")
476 val = cur.fetchone()[0]
480 cur = self.con.cursor()
483 cur.execute("select aggtxt(?) from test", (txt,))
484 val = cur.fetchone()[0]