Lines Matching refs:execute
91 cu.execute("create table test(id integer primary key, name text)")
92 cu.execute("insert into test(name) values (?)", ("foo",))
146 cu.execute("create table transactiontest(id integer primary key, name text)")
148 cu.execute("insert into transactiontest(name) values (?)", ("foo",))
150 cu.execute("select name from transactiontest where name=?", ["foo"])
155 cu.execute("select name from transactiontest where name=?", ["foo"])
172 cx.execute('create table test(id integer)')
181 cx.execute('create table test(id integer)')
183 cx.execute('insert into test(id) values(0)')
186 cx.execute('insert into test(id) values(1)')
199 self.cu.execute(
203 self.cu.execute("insert into test(name) values (?)", ("foo",))
210 self.cu.execute("delete from test")
214 self.cu.execute("select asdf")
218 self.cu.execute("select 5+4; select 4+5")
221 self.cu.execute("select 5+4; -- foo bar")
224 self.cu.execute("""
234 self.cu.execute(42)
237 self.cu.execute("insert into test(id) values (?)", (42,))
240 self.cu.execute("insert into test(income) values (?)", (2500.32,))
243 self.cu.execute("insert into test(name) values (?)", ("Hugo",))
246 self.cu.execute("insert into test(name) values (?)", ("Hu\x00go",))
248 self.cu.execute("select name from test where id=?", (self.cu.lastrowid,))
254 self.cu.execute("insert into test(id) values (?)", 42)
260 self.cu.execute("insert into test(id) values (?)", (17, "Egon"))
265 self.cu.execute("insert into test(id) values (?)")
270 self.cu.execute("insert into test(id) values (?)")
273 self.cu.execute("insert into test(name) values ('foo')")
274 self.cu.execute("select name from test where name=?", ["foo"])
286 self.cu.execute("insert into test(name) values ('foo')")
287 self.cu.execute("select name from test where name=?", L())
299 self.cu.execute("insert into test(name) values ('foo')")
301 self.cu.execute("select name from test where name=?", L())
304 self.cu.execute("insert into test(name) values ('foo')")
305 self.cu.execute("select name from test where name=:name", {"name": "foo"})
314 self.cu.execute("insert into test(name) values ('foo')")
315 self.cu.execute("select name from test where name=:name", D())
320 self.cu.execute("insert into test(name) values ('foo')")
322 self.cu.execute("select name from test where name=:name and id=:id", {"name": "foo"})
325 self.cu.execute("insert into test(name) values ('foo')")
327 self.cu.execute("select name from test where name=:name")
330 self.cu.execute("insert into test(name) values ('foo')")
332 self.cu.execute("select name from test where name=?", {"name": "foo"})
338 self.cu.execute("delete from test")
339 self.cu.execute("insert into test(name) values ('foo')")
340 self.cu.execute("insert into test(name) values ('foo')")
341 self.cu.execute("update test set name='bar'")
350 self.cu.execute("select 5 union select 6")
354 self.cu.execute("delete from test")
359 self.cu.execute("insert into test(name) values ('foo')")
360 self.cu.execute("insert into test(name) values ('foo')")
405 self.cu.execute("delete from test")
406 self.cu.execute("insert into test(id) values (?)", (5,))
407 self.cu.execute("insert into test(id) values (?)", (6,))
408 self.cu.execute("select id from test order by id")
416 self.cu.execute("select name from test")
435 self.cu.execute("delete from test")
436 self.cu.execute("insert into test(name) values ('A')")
437 self.cu.execute("insert into test(name) values ('B')")
438 self.cu.execute("insert into test(name) values ('C')")
439 self.cu.execute("select name from test")
445 self.cu.execute("select name from test")
453 self.cu.execute("select name from test")
458 self.cu.execute("select name from test")
495 self.cu.execute(sql.format(statement), (1, 'foo'))
499 self.cu.execute(
503 self.cu.execute(
513 self.cu.execute(sql.format(statement), (statement,))
516 self.cu.execute(sql.format(statement), (statement,))
530 …self.cur.execute("create table test(id integer primary key, name text, bin binary, ratio number, t…
611 cur.execute("insert into test(name) values ('a')")
647 cur.execute("select name from test")
656 self.cur.execute("insert into test(name) values ('a')")
675 self.cur.execute("insert into test(name) values ('a')")
676 self.cur.execute("select name from test")
715 cur.execute("select i from a")
740 result = con.execute("select 5").fetchone()[0]
745 con.execute("create table test(foo)")
747 result = con.execute("select foo from test order by foo").fetchall()
754 result = con.execute("select foo from test").fetchone()[0]
781 cur.execute("select 4")
853 self.cu.execute("""
867 self.cu.execute("BEGIN")
868 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
869 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
871 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
874 self.cu.execute("SELECT name, unique_name from test")
884 self.cu.execute("BEGIN")
885 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
886 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
888 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
890 self.cu.execute("SELECT name, unique_name FROM test")
896 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
897 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
899 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
900 self.cu.execute("SELECT name, unique_name FROM test")
907 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
908 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
910 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
912 self.cu.execute("SELECT name, unique_name FROM test")
916 self.cu.execute("INSERT OR FAIL INTO test(unique_name) VALUES ('foo')")
918 self.cu.execute("INSERT OR FAIL INTO test(unique_name) VALUES ('foo')")
922 self.cu.execute("INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')")
924 self.cu.execute("INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')")
925 self.cu.execute("SELECT unique_name FROM test")
929 self.cu.execute("INSERT OR REPLACE INTO test(name, unique_name) VALUES ('Data!', 'foo')")
931 …self.cu.execute("INSERT OR REPLACE INTO test(name, unique_name) VALUES ('Very different data!', 'f…
932 self.cu.execute("SELECT name, unique_name FROM test")