Lines Matching refs:execute
40 cur.execute("pragma user_version")
47 cur.execute("pragma schema_version")
58 cursors[0].execute("create table test(x)")
63 cursors[i].execute(" " * i + "select x from test")
69 cur.execute('select 1 as "foo bar [datetime]"')
72 cur.execute('select 1 as "foo baz"')
86 cur.execute("select 1 x union select " + str(i))
93 con.execute("create table foo(x, unique(x) on conflict rollback)")
94 con.execute("insert into foo(x) values (1)")
96 con.execute("insert into foo(x) values (1)")
99 con.execute("insert into foo(x) values (2)")
110 self.con.execute("create table foo(bar)")
111 self.con.execute("drop table foo")
112 self.con.execute("create table foo(bar)")
119 self.con.execute("")
140 con.execute("create table foo(bar timestamp)")
141 con.execute("insert into foo(bar) values (?)", (datetime.datetime.now(),))
142 con.execute(SELECT)
143 con.execute("drop table foo")
144 con.execute("create table foo(bar integer)")
145 con.execute("insert into foo(bar) values (5)")
146 con.execute(SELECT)
174 cur.execute("select 4+5").fetchall()
217 cur.execute("create table foo(x)")
219 cur.execute("select x from foo")
243 cur.execute("create table foo(bar)")
244 cur.execute("insert into foo(bar) values (5)")
246 cur.execute("pragma page_size")
284 cur.execute("create table a (bar)")
285 cur.execute("create table b (baz)")
288 cur.execute("insert into a (bar) values (?)", (1,))
305 cur.execute("CREATE TABLE t (x TIMESTAMP)")
308 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')")
311 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')")
313 cur.execute("SELECT * FROM t")
333 self.assertRaises(ValueError, cur.execute, " \0select 2")
334 self.assertRaises(ValueError, cur.execute, "select 2\0")
354 for i, row in enumerate(con.execute("select c from t")):
355 con.execute("insert into t2(c) values (?)", (i,))