Lines Matching full:execute
107 cu.execute("create table test(id integer primary key, name text)")
108 cu.execute("insert into test(name) values (?)", ("foo",))
162 cu.execute("create table transactiontest(id integer primary key, name text)")
164 cu.execute("insert into transactiontest(name) values (?)", ("foo",))
166 cu.execute("select name from transactiontest where name=?", ["foo"])
171 cu.execute("select name from transactiontest where name=?", ["foo"])
188 cx.execute('create table test(id integer)')
193 cx.execute('create table test(id integer)')
195 cx.execute('insert into test(id) values(0)')
198 cx.execute('insert into test(id) values(1)')
225 self.cu.execute(
229 self.cu.execute("insert into test(name) values (?)", ("foo",))
236 self.cu.execute("delete from test")
240 self.cu.execute("select asdf")
244 self.cu.execute("select 5+4; select 4+5")
247 self.cu.execute("select 5+4; -- foo bar")
250 self.cu.execute("""
260 self.cu.execute(42)
263 self.cu.execute("insert into test(id) values (?)", (42,))
266 self.cu.execute("insert into test(income) values (?)", (2500.32,))
269 self.cu.execute("insert into test(name) values (?)", ("Hugo",))
272 self.cu.execute("insert into test(name) values (?)", ("Hu\x00go",))
274 self.cu.execute("select name from test where id=?", (self.cu.lastrowid,))
280 self.cu.execute("insert into test(id) values (?)", 42)
286 self.cu.execute("insert into test(id) values (?)", (17, "Egon"))
291 self.cu.execute("insert into test(id) values (?)")
296 self.cu.execute("insert into test(id) values (?)")
299 self.cu.execute("insert into test(name) values ('foo')")
300 self.cu.execute("select name from test where name=?", ["foo"])
312 self.cu.execute("insert into test(name) values ('foo')")
313 self.cu.execute("select name from test where name=?", L())
325 self.cu.execute("insert into test(name) values ('foo')")
327 self.cu.execute("select name from test where name=?", L())
330 self.cu.execute("insert into test(name) values ('foo')")
331 self.cu.execute("select name from test where name=:name", {"name": "foo"})
340 self.cu.execute("insert into test(name) values ('foo')")
341 self.cu.execute("select name from test where name=:name", D())
346 self.cu.execute("insert into test(name) values ('foo')")
348 self.cu.execute("select name from test where name=:name and id=:id", {"name": "foo"})
351 self.cu.execute("insert into test(name) values ('foo')")
353 self.cu.execute("select name from test where name=:name")
356 self.cu.execute("insert into test(name) values ('foo')")
358 self.cu.execute("select name from test where name=?", {"name": "foo"})
364 self.cu.execute("delete from test")
365 self.cu.execute("insert into test(name) values ('foo')")
366 self.cu.execute("insert into test(name) values ('foo')")
367 self.cu.execute("update test set name='bar'")
376 self.cu.execute("select 5 union select 6")
380 self.cu.execute("delete from test")
385 self.cu.execute("insert into test(name) values ('foo')")
386 self.cu.execute("insert into test(name) values ('foo')")
434 self.cu.execute("delete from test")
435 self.cu.execute("insert into test(id) values (?)", (5,))
436 self.cu.execute("insert into test(id) values (?)", (6,))
437 self.cu.execute("select id from test order by id")
445 self.cu.execute("select name from test")
464 self.cu.execute("delete from test")
465 self.cu.execute("insert into test(name) values ('A')")
466 self.cu.execute("insert into test(name) values ('B')")
467 self.cu.execute("insert into test(name) values ('C')")
468 self.cu.execute("select name from test")
474 self.cu.execute("select name from test")
482 self.cu.execute("select name from test")
487 self.cu.execute("select name from test")
524 self.cu.execute(sql.format(statement), (1, 'foo'))
528 self.cu.execute(
532 self.cu.execute(
542 self.cu.execute(sql.format(statement), (statement,))
545 self.cu.execute(sql.format(statement), (statement,))
559 …self.cur.execute("create table test(id integer primary key, name text, bin binary, ratio number, t…
640 cur.execute("insert into test(name) values ('a')")
676 cur.execute("select name from test")
685 self.cur.execute("insert into test(name) values ('a')")
704 self.cur.execute("insert into test(name) values ('a')")
705 self.cur.execute("select name from test")
744 cur.execute("select i from a")
769 result = con.execute("select 5").fetchone()[0]
770 self.assertEqual(result, 5, "Basic test of Connection.execute")
774 con.execute("create table test(foo)")
776 result = con.execute("select foo from test order by foo").fetchall()
783 result = con.execute("select foo from test").fetchone()[0]
810 cur.execute("select 4")
859 …for method_name in ("execute", "executemany", "executescript", "fetchall", "fetchmany", "fetchone"…
860 if method_name in ("execute", "executescript"):
882 self.cu.execute("""
896 self.cu.execute("BEGIN")
897 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
898 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
900 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
903 self.cu.execute("SELECT name, unique_name from test")
913 self.cu.execute("BEGIN")
914 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
915 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
917 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
919 self.cu.execute("SELECT name, unique_name FROM test")
925 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
926 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
928 self.cu.execute("INSERT OR ROLLBACK INTO test(unique_name) VALUES ('foo')")
929 self.cu.execute("SELECT name, unique_name FROM test")
936 self.cu.execute("INSERT INTO test(name) VALUES ('abort_test')")
937 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
939 self.cu.execute("INSERT OR ABORT INTO test(unique_name) VALUES ('foo')")
941 self.cu.execute("SELECT name, unique_name FROM test")
945 self.cu.execute("INSERT OR FAIL INTO test(unique_name) VALUES ('foo')")
947 self.cu.execute("INSERT OR FAIL INTO test(unique_name) VALUES ('foo')")
951 self.cu.execute("INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')")
953 self.cu.execute("INSERT OR IGNORE INTO test(unique_name) VALUES ('foo')")
954 self.cu.execute("SELECT unique_name FROM test")
958 self.cu.execute("INSERT OR REPLACE INTO test(name, unique_name) VALUES ('Data!', 'foo')")
960 …self.cu.execute("INSERT OR REPLACE INTO test(name, unique_name) VALUES ('Very different data!', 'f…
961 self.cu.execute("SELECT name, unique_name FROM test")
982 cx.execute("create table t(t)")
984 # execute two transactions; both will try to lock the db
1017 cx.execute("insert into t values('test')")