Lines Matching full: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))
91 con.execute("create table foo(x, unique(x) on conflict rollback)")
92 con.execute("insert into foo(x) values (1)")
94 con.execute("insert into foo(x) values (1)")
97 con.execute("insert into foo(x) values (2)")
108 self.con.execute("create table foo(bar)")
109 self.con.execute("drop table foo")
110 self.con.execute("create table foo(bar)")
117 self.con.execute("")
126 con.execute("create table foo(bar timestamp)")
127 con.execute("insert into foo(bar) values (?)", (datetime.datetime.now(),))
128 con.execute(SELECT).close()
129 con.execute("drop table foo")
130 con.execute("create table foo(bar integer)")
131 con.execute("insert into foo(bar) values (5)")
132 con.execute(SELECT).close()
142 con.execute("create table foo(bar X, baz integer)")
145 con.execute("insert into foo(bar, baz) values (?, ?)", parameters)
151 self.con.execute("select 'xxx' || ? || 'yyy' colname",
204 cur.execute("select 4+5").fetchall()
214 self.con.execute("select ?", (MyStr("abc"),))
244 cur.execute("create table foo(x)")
246 cur.execute("select x from foo")
265 cur.execute("create table foo(bar)")
266 cur.execute("insert into foo(bar) values (5)")
268 cur.execute("pragma page_size")
295 cur.execute("create table a (bar)")
296 cur.execute("create table b (baz)")
299 cur.execute("insert into a (bar) values (?)", (1,))
316 cur.execute("CREATE TABLE t (x TIMESTAMP)")
319 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.456')")
322 cur.execute("INSERT INTO t (x) VALUES ('2012-04-04 15:06:00.123456789')")
324 cur.execute("SELECT * FROM t")
344 self.assertRaises(ValueError, cur.execute, " \0select 2")
345 self.assertRaises(ValueError, cur.execute, "select 2\0")
365 for i, row in enumerate(con.execute("select c from t")):
367 con.execute("insert into t2(c) values (?)", (i,))
409 self.con.execute("select 1") # trigger seg fault
413 cur = self.con.execute("select X''")