Lines Matching refs:execsql
30 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
33 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name} db2
36 execsql {CREATE TABLE t1(a int, b int)}
37 execsql {SELECT name FROM sqlite_master WHERE type='table' ORDER BY name}
46 execsql {INSERT INTO t1 VALUES(1,2)}
47 execsql {SELECT * FROM t1}
57 execsql {UPDATE t1 SET a=b, b=a} db2
58 execsql {SELECT * FROM t1} db2
61 execsql {SELECT * FROM t1}
64 execsql {BEGIN TRANSACTION}
65 execsql {UPDATE t1 SET a = 0 WHERE 0}
66 execsql {SELECT * FROM t1}
72 execsql {ROLLBACK}
77 execsql {CREATE TABLE t2(x int, y int)}
78 execsql {INSERT INTO t2 VALUES(8,9)}
79 execsql {SELECT * FROM t2}
129 execsql {SELECT * FROM t2}
164 execsql {BEGIN TRANSACTION}
165 execsql {UPDATE t1 SET a = 0 WHERE 0}
166 execsql {BEGIN TRANSACTION} db2
167 set r [catch {execsql {UPDATE t1 SET a = 0 WHERE 0} db2} msg]
168 execsql {ROLLBACK} db2
190 set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
196 execsql {BEGIN; SELECT rowid FROM sqlite_master LIMIT 1} db2
198 set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
202 catch {execsql {ROLLBACK} db2}
211 set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
222 execsql {BEGIN; SELECT rowid FROM sqlite_master LIMIT 1} db2
224 set r [catch {execsql {UPDATE t1 SET a=b, b=a} db2} msg]
228 catch {execsql {ROLLBACK} db2}
236 set r [catch {execsql {SELECT * FROM t1} db2} msg]
240 execsql {ROLLBACK}
249 execsql BEGIN
250 execsql {UPDATE t1 SET a = 0 WHERE 0}
258 execsql COMMIT
266 execsql BEGIN
267 execsql {UPDATE t1 SET a = 0 WHERE 0}
275 execsql COMMIT
285 execsql {BEGIN TRANSACTION}
286 set r [catch {execsql {BEGIN TRANSACTION}} msg]
287 execsql {ROLLBACK}
318 execsql {ROLLBACK}
329 execsql {
342 execsql {
353 execsql {
363 execsql {
373 execsql {
380 execsql {
390 execsql { DELETE FROM t4 }
391 execsql { SELECT * FROM sqlite_master } db2
392 execsql { SELECT * FROM t4 } db2
396 execsql {
404 execsql { SELECT * FROM t4 } db2
408 execsql { SELECT a FROM t4 ORDER BY a } db2
412 execsql { PRAGMA integrity_check } db2
434 execsql { PRAGMA lock_status }
437 execsql {
443 execsql { PRAGMA lock_status }