Lines Matching refs:execute
92 cu.execute("create table test(id integer primary key, name text)")
93 cu.execute("insert into test(name) values (?)", ("foo",))
149 self.cu.execute("create table test(id integer primary key, name text, income number)")
150 self.cu.execute("insert into test(name) values (?)", ("foo",))
157 self.cu.execute("delete from test")
161 self.cu.execute("select asdf")
170 self.cu.execute("select 5+4; select 4+5")
178 self.cu.execute("select 5+4; -- foo bar")
181 self.cu.execute("""
191 self.cu.execute(42)
199 self.cu.execute("insert into test(id) values (?)", (42,))
202 self.cu.execute("insert into test(income) values (?)", (2500.32,))
205 self.cu.execute("insert into test(name) values (?)", ("Hugo",))
208 self.cu.execute("insert into test(name) values (?)", ("Hu\x00go",))
210 self.cu.execute("select name from test where id=?", (self.cu.lastrowid,))
217 self.cu.execute("insert into test(id) values (?)", (17, "Egon"))
225 self.cu.execute("insert into test(id) values (?)")
233 self.cu.execute("insert into test(id) values (?)")
239 self.cu.execute("insert into test(name) values ('foo')")
240 self.cu.execute("select name from test where name=?", ["foo"])
252 self.cu.execute("insert into test(name) values ('foo')")
253 self.cu.execute("select name from test where name=?", L())
258 self.cu.execute("insert into test(name) values ('foo')")
259 self.cu.execute("select name from test where name=:name", {"name": "foo"})
272 self.cu.execute("insert into test(name) values ('foo')")
273 self.cu.execute("select name from test where name=:name", D())
278 self.cu.execute("insert into test(name) values ('foo')")
280 self.cu.execute("select name from test where name=:name and id=:id", {"name": "foo"})
286 self.cu.execute("insert into test(name) values ('foo')")
288 self.cu.execute("select name from test where name=:name")
294 self.cu.execute("insert into test(name) values ('foo')")
296 self.cu.execute("select name from test where name=?", {"name": "foo"})
305 self.cu.execute("delete from test")
306 self.cu.execute("insert into test(name) values ('foo')")
307 self.cu.execute("insert into test(name) values ('foo')")
308 self.cu.execute("update test set name='bar'")
317 self.cu.execute("select 5 union select 6")
321 self.cu.execute("delete from test")
326 self.cu.execute("insert into test(name) values ('foo')")
327 self.cu.execute("insert into test(name) values ('foo')")
389 self.cu.execute("delete from test")
390 self.cu.execute("insert into test(id) values (?)", (5,))
391 self.cu.execute("insert into test(id) values (?)", (6,))
392 self.cu.execute("select id from test order by id")
400 self.cu.execute("select name from test")
419 self.cu.execute("delete from test")
420 self.cu.execute("insert into test(name) values ('A')")
421 self.cu.execute("insert into test(name) values ('B')")
422 self.cu.execute("insert into test(name) values ('C')")
423 self.cu.execute("select name from test")
429 self.cu.execute("select name from test")
437 self.cu.execute("select name from test")
442 self.cu.execute("select name from test")
484 …self.cur.execute("create table test(id integer primary key, name text, bin binary, ratio number, t…
565 cur.execute("insert into test(name) values ('a')")
601 cur.execute("select name from test")
610 self.cur.execute("insert into test(name) values ('a')")
629 self.cur.execute("insert into test(name) values ('a')")
630 self.cur.execute("select name from test")
670 cur.execute("select i from a")
684 cur.execute("select i from a")
710 result = con.execute("select 5").fetchone()[0]
715 con.execute("create table test(foo)")
717 result = con.execute("select foo from test order by foo").fetchall()
724 result = con.execute("select foo from test").fetchone()[0]
772 cur.execute("select 4")