Lines Matching refs:execsql

23   set v [catch {execsql {DELETE FROM test1}} msg]
30   set v [catch {execsql {DELETE FROM sqlite_master}} msg]
37   execsql {CREATE TABLE table1(f1 int, f2 int)}
38   execsql {INSERT INTO table1 VALUES(1,2)}
39   execsql {INSERT INTO table1 VALUES(2,4)}
40   execsql {INSERT INTO table1 VALUES(3,8)}
41   execsql {INSERT INTO table1 VALUES(4,16)}
42   execsql {SELECT * FROM table1 ORDER BY f1}
45   execsql {DELETE FROM table1 WHERE f1=3}
48   execsql {SELECT * FROM table1 ORDER BY f1}
51   execsql {CREATE INDEX index1 ON table1(f1)}
52   execsql {PRAGMA count_changes=on}
53   execsql {DELETE FROM 'table1' WHERE f1=3}
56   execsql {SELECT * FROM table1 ORDER BY f1}
59   execsql {DELETE FROM table1 WHERE f1=2}
62   execsql {SELECT * FROM table1 ORDER BY f1}
70   execsql {CREATE TABLE table2(f1 int, f2 int)}
71   set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
76   set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
84   execsql {DELETE FROM table1}
87   execsql {SELECT count(*) FROM table1}
90   execsql {BEGIN TRANSACTION}
92      execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
94   execsql {COMMIT}
95   execsql {SELECT count(*) FROM table1}
98   execsql {DELETE FROM table1}
101   execsql {BEGIN TRANSACTION}
103      execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
105   execsql {COMMIT}
106   execsql {SELECT count(*) FROM table1}
109   execsql {PRAGMA count_changes=off}
110   execsql {DELETE FROM table1}
113   execsql {SELECT count(*) FROM table1}
116   execsql {BEGIN TRANSACTION}
118      execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
120   execsql {COMMIT}
121   execsql {SELECT count(*) FROM table1}
125      execsql "DELETE FROM table1 WHERE f1==$i"
127   execsql {SELECT count(*) FROM table1}
130   execsql "DELETE FROM table1 WHERE f1>50"
131   execsql {SELECT count(*) FROM table1}
135      execsql "DELETE FROM table1 WHERE f1==$i"
137   execsql {SELECT f1 FROM table1 ORDER BY f1}
141      execsql "DELETE FROM table1 WHERE f1==$i"
143   execsql {SELECT f1 FROM table1 ORDER BY f1}
146   execsql "DELETE FROM table1 WHERE f1!=48"
147   execsql {SELECT f1 FROM table1 ORDER BY f1}
161   execsql {DELETE FROM table1}
162   execsql {COPY table1 FROM 'data1.txt'}
163   execsql {DELETE FROM table2}
164   execsql {COPY table2 FROM 'data1.txt'}
166   execsql {SELECT count(*) FROM table1}
169   execsql {SELECT count(*) FROM table2}
172   execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
175   execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
178   execsql {DELETE FROM table1 WHERE f1>7}
179   execsql {SELECT f1 FROM table1 ORDER BY f1}
182   execsql {DELETE FROM table2 WHERE f1>7}
183   execsql {SELECT f1 FROM table2 ORDER BY f1}
186   execsql {DELETE FROM table1}
187   execsql {SELECT f1 FROM table1}
190   execsql {INSERT INTO table1 VALUES(2,3)}
191   execsql {SELECT f1 FROM table1}
194   execsql {DELETE FROM table2}
195   execsql {SELECT f1 FROM table2}
198   execsql {INSERT INTO table2 VALUES(2,3)}
199   execsql {SELECT f1 FROM table2}
204   execsql {
213   execsql {
224   execsql {
229   execsql {
235   execsql {
240   execsql {
256   execsql {
272   execsql {SELECT * FROM t3}
280   execsql {SELECT * FROM t3}
288   execsql {SELECT * FROM t3}