Lines Matching refs:cur
43 cur = self.con.cursor()
44 cur.execute("pragma user_version")
50 cur = self.con.cursor()
51 cur.execute("pragma schema_version")
53 cur.close()
72 cur = self.con.cursor()
73 cur.execute('select 1 as "foo bar [datetime]"')
74 self.assertEqual(cur.description[0][0], "foo bar [datetime]")
76 cur.execute('select 1 as "foo baz"')
77 self.assertEqual(cur.description[0][0], "foo baz")
88 cur = con.cursor()
89 cursors.append(cur)
90 cur.execute("select 1 x union select " + str(i))
130 cur = con.cursor()
131 cur.execute("create table foo(bar timestamp)")
132 cur.execute("insert into foo(bar) values (?)", (datetime.datetime.now(),))
133 cur.execute(SELECT)
134 cur.execute("drop table foo")
135 cur.execute("create table foo(bar integer)")
136 cur.execute("insert into foo(bar) values (5)")
137 cur.execute(SELECT)
207 cur = Cursor(con)
209 cur.execute("select 4+5").fetchall()
212 cur.close()
232 cur = con.cursor()
247 cur = self.con.cursor()
248 cur.execute("create table foo(bar)")
249 cur.execute("insert into foo(bar) values (5)")
251 cur.execute("pragma page_size")
252 row = cur.fetchone()
277 cur = con.cursor()
278 cur.execute("create table a (bar)")
279 cur.execute("create table b (baz)")
282 cur.execute("insert into a (bar) values (?)", (1,))
286 cur.executemany("insert into b (baz) values (?)",
298 cur = con.cursor()
299 cur.execute("CREATE TABLE t (x TIMESTAMP)")
302 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')")
305 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')")
307 cur.execute("SELECT * FROM t")
308 values = [x[0] for x in cur.fetchall()]
323 cur = self.con.cursor()
331 cur.execute, query)
337 cur = con.cursor()
338 self.assertRaises(UnicodeEncodeError, cur.execute, "select '\ud8ff'")
339 self.assertRaises(UnicodeEncodeError, cur.execute, "select '\udcff'")
393 cur = sqlite.Cursor(con)
394 ref = weakref.ref(cur, callback)
395 cur.__init__(con)
396 del cur
420 cur = self.con.execute("select X''")
421 val = cur.fetchone()[0]
426 cur = con.cursor()
427 cur.execute("create table t(t)")
428 cur.executemany("insert into t values(?)",
431 cur.execute("select t from t")
432 cur.execute("drop table t")
441 cur = con.execute("select t from t")
442 del cur
456 cur = con.execute("select dup(t) from t")
457 del cur
481 cur = con.cursor(MyCursor)
482 cur.close()
483 del cur
492 self.cur = self.con.cursor()
493 self.cur.execute("create table test(x foo)")
494 self.cur.executemany("insert into test(x) values (?)",
498 self.cur.close()
502 conv = lambda x: self.cur.__init__(self.con)
504 self.cur.execute(f'select x as "x [INIT]", x from test')
506 self.cur.fetchall)
509 conv = lambda x: self.cur.close()
511 self.cur.execute(f'select x as "x [CLOSE]", x from test')
513 self.cur.fetchall)
516 conv = lambda x, l=[]: self.cur.fetchone() if l else l.append(None)
518 self.cur.execute(f'select x as "x [ITER]", x from test')
520 self.cur.fetchall)