Lines Matching refs:cur
37 cur = self.con.cursor()
38 cur.execute("pragma user_version")
44 cur = self.con.cursor()
45 cur.execute("pragma schema_version")
47 cur.close()
66 cur = self.con.cursor()
67 cur.execute('select 1 as "foo bar [datetime]"')
68 self.assertEqual(cur.description[0][0], "foo bar")
70 cur.execute('select 1 as "foo baz"')
71 self.assertEqual(cur.description[0][0], "foo baz")
82 cur = con.cursor()
83 cursors.append(cur)
84 cur.execute("select 1 x union select " + str(i))
169 cur = Cursor(con)
171 cur.execute("select 4+5").fetchall()
188 cur = con.cursor()
209 cur = con.cursor()
210 cur.execute("create table foo(x)")
211 cur.executemany("insert into foo(x) values (?)", [(3,), (4,), (5,)])
212 cur.execute("select x from foo")
215 cur.fetchall()
235 cur = self.con.cursor()
236 cur.execute("create table foo(bar)")
237 cur.execute("insert into foo(bar) values (5)")
239 cur.execute("pragma page_size")
240 row = cur.fetchone()
276 cur = con.cursor()
277 cur.execute("create table a (bar)")
278 cur.execute("create table b (baz)")
281 cur.execute("insert into a (bar) values (?)", (1,))
285 cur.executemany("insert into b (baz) values (?)",
297 cur = con.cursor()
298 cur.execute("CREATE TABLE t (x TIMESTAMP)")
301 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')")
304 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')")
306 cur.execute("SELECT * FROM t")
307 values = [x[0] for x in cur.fetchall()]
