Lines Matching refs:execsql

22   set v [catch {execsql {DELETE FROM test1}} msg]
29   set v [catch {execsql {DELETE FROM sqlite_master}} msg]
36   execsql {CREATE TABLE table1(f1 int, f2 int)}
37   execsql {INSERT INTO table1 VALUES(1,2)}
38   execsql {INSERT INTO table1 VALUES(2,4)}
39   execsql {INSERT INTO table1 VALUES(3,8)}
40   execsql {INSERT INTO table1 VALUES(4,16)}
41   execsql {SELECT * FROM table1 ORDER BY f1}
44   execsql {DELETE FROM table1 WHERE f1=3}
47   execsql {SELECT * FROM table1 ORDER BY f1}
50   execsql {CREATE INDEX index1 ON table1(f1)}
51   execsql {PRAGMA count_changes=on}
53     execsql {EXPLAIN DELETE FROM table1 WHERE f1=3}
55   execsql {DELETE FROM 'table1' WHERE f1=3}
58   execsql {SELECT * FROM table1 ORDER BY f1}
61   execsql {DELETE FROM table1 WHERE f1=2}
67   execsql {SELECT * FROM table1 ORDER BY f1}
74   execsql {CREATE TABLE table2(f1 int, f2 int)}
75   set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
80   set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
88   execsql {DELETE FROM table1}
91   execsql {SELECT count(*) FROM table1}
94   execsql {BEGIN TRANSACTION}
96      execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
98   execsql {COMMIT}
99   execsql {SELECT count(*) FROM table1}
102   execsql {DELETE FROM table1}
105   execsql {BEGIN TRANSACTION}
107      execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
109   execsql {COMMIT}
110   execsql {SELECT count(*) FROM table1}
113   execsql {PRAGMA count_changes=off}
114   execsql {DELETE FROM table1}
117   execsql {SELECT count(*) FROM table1}
120   execsql {BEGIN TRANSACTION}
122      execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
124   execsql {COMMIT}
125   execsql {SELECT count(*) FROM table1}
129      execsql "DELETE FROM table1 WHERE f1==$i"
131   execsql {SELECT count(*) FROM table1}
134   execsql "DELETE FROM table1 WHERE f1>50"
138   execsql {SELECT count(*) FROM table1}
142      execsql "DELETE FROM table1 WHERE f1==$i"
144   execsql {SELECT f1 FROM table1 ORDER BY f1}
148      execsql "DELETE FROM table1 WHERE f1==$i"
150   execsql {SELECT f1 FROM table1 ORDER BY f1}
153   execsql "DELETE FROM table1 WHERE f1!=48"
154   execsql {SELECT f1 FROM table1 ORDER BY f1}
163   execsql {BEGIN; DELETE FROM table1}
165     execsql "INSERT INTO table1 VALUES($i,[expr {$i*$i}])"
167   execsql {DELETE FROM table2}
169     execsql "INSERT INTO table2 VALUES($i,[expr {$i*$i}])"
171   execsql {COMMIT}
172   execsql {SELECT count(*) FROM table1}
175   execsql {SELECT count(*) FROM table2}
178   execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
181   execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
184   execsql {DELETE FROM table1 WHERE f1>7}
188   execsql {SELECT f1 FROM table1 ORDER BY f1}
191   execsql {DELETE FROM table2 WHERE f1>7}
192   execsql {SELECT f1 FROM table2 ORDER BY f1}
195   execsql {DELETE FROM table1}
196   execsql {SELECT f1 FROM table1}
199   execsql {INSERT INTO table1 VALUES(2,3)}
200   execsql {SELECT f1 FROM table1}
203   execsql {DELETE FROM table2}
204   execsql {SELECT f1 FROM table2}
207   execsql {INSERT INTO table2 VALUES(2,3)}
208   execsql {SELECT f1 FROM table2}
213   execsql {
223     execsql {
234     execsql {
239     execsql {
245     execsql {
250     execsql {
262   execsql {DELETE FROM t3}
270   execsql {
288   execsql {SELECT * FROM t3} 
296   execsql {SELECT * FROM t3} 
309   execsql {SELECT * FROM t3}
330   execsql {
351   execsql {
364   execsql {
378   execsql {