Lines Matching refs:execute

56         self.cur1.execute("create table test(i)")
57         self.cur1.execute("insert into test(i) values (5)")
58         self.cur1.execute("create table test2(j)")
59         self.cur2.execute("select i from test")
64         self.cur1.execute("create table test(i)")
65         self.cur1.execute("insert into test(i) values (5)")
66         self.cur2.execute("select i from test")
71         self.cur1.execute("create table test(i)")
72         self.cur1.execute("insert into test(i) values (5)")
74         self.cur1.execute("update test set i=6")
75         self.cur2.execute("select i from test")
80         self.cur1.execute("create table test(i)")
81         self.cur1.execute("insert into test(i) values (5)")
83         self.cur1.execute("delete from test")
84         self.cur2.execute("select i from test")
89         self.cur1.execute("create table test(i)")
90         self.cur1.execute("insert into test(i) values (5)")
92         self.cur1.execute("replace into test(i) values (6)")
93         self.cur2.execute("select i from test")
99         self.cur1.execute("create table test(i)")
100         self.cur1.execute("insert into test(i) values (5)")
103         self.cur2.execute("select i from test")
109         self.cur1.execute("insert into test(i) values (5)")
110         self.cur2.execute("select i from test")
117         self.cur1.execute("create table test(i)")
118         self.cur1.execute("insert into test(i) values (5)")
120             self.cur2.execute("insert into test(i) values (5)")
129         self.cur1.execute("create table test(i)")
130         self.cur1.execute("insert into test(i) values (5)")
132             self.cur2.execute("insert into test(i) values (5)")
143         cur.execute("create table test(x)")
144         cur.execute("insert into test(x) values (5)")
145         cur.execute("select 1 union select 2 union select 3")
157         self.cur.execute("create table test(i)")
158         self.cur.execute("insert into test(i) values (5)")
159         self.cur.execute("drop table test")
162         self.cur.execute("create table test(i)")
163         self.cur.execute("insert into test(i) values (5)")
164         self.cur.execute("pragma count_changes=1")
177         self.con.execute("create table test(i)")
179         result = self.con.execute("select * from test").fetchall()
185         self.con.execute("begin immediate")
186         self.con.execute("create table test(i)")
189             self.con.execute("select * from test")
194         self.con.execute("begin")
195         self.con.execute("create table test(i)")
198             self.con.execute("select * from test")