Lines Matching refs:run_sql
127 static void run_sql(WorkerInfo *p, const char *zFormat, ...){ in run_sql() function
198 run_sql(p, "PRAGMA read_uncommitted=ON;"); in worker_open_connection()
200 run_sql(p, "PRAGMA synchronous=OFF;"); in worker_open_connection()
201 run_sql(p, "ATTACH 'tt4-test%d.db' AS aux1", aOrder[x][1]); in worker_open_connection()
202 run_sql(p, "ATTACH 'tt4-test%d.db' AS aux2", aOrder[x][2]); in worker_open_connection()
225 run_sql(p, "BEGIN"); in worker_delete_all_content()
226 run_sql(p, "DELETE FROM t1 WHERE tid=%d", p->tid); in worker_delete_all_content()
227 run_sql(p, "DELETE FROM t2 WHERE tid=%d", p->tid); in worker_delete_all_content()
228 run_sql(p, "DELETE FROM t3 WHERE tid=%d", p->tid); in worker_delete_all_content()
229 run_sql(p, "COMMIT"); in worker_delete_all_content()
234 run_sql(p, "DELETE FROM t1 WHERE tid=%d", p->tid); in worker_delete_all_content()
238 run_sql(p, "DELETE FROM t2 WHERE tid=%d", p->tid); in worker_delete_all_content()
242 run_sql(p, "DELETE FROM t3 WHERE tid=%d", p->tid); in worker_delete_all_content()
259 run_sql(p, in worker_add_content()
317 run_sql(p, "BEGIN;"); in worker_thread()
318 run_sql(p, "UPDATE t1 SET c=NULL WHERE a=55"); in worker_thread()
319 run_sql(p, "UPDATE t2 SET f=NULL WHERE d=42"); in worker_thread()
320 run_sql(p, "UPDATE t3 SET z=NULL WHERE x=31"); in worker_thread()
321 run_sql(p, "ROLLBACK;"); in worker_thread()
328 run_sql(p, "VACUUM"); in worker_thread()
438 run_sql(p, "PRAGMA journal_mode=WAL"); in main()
440 run_sql(p, "PRAGMA synchronous=OFF"); in main()
441 run_sql(p, "CREATE TABLE IF NOT EXISTS t1(tid INTEGER, sp, a, b, c)"); in main()
442 run_sql(p, "CREATE INDEX t1tid ON t1(tid)"); in main()
443 run_sql(p, "CREATE INDEX t1ab ON t1(a,b)"); in main()
444 run_sql(p, "ATTACH 'tt4-test2.db' AS 'test2'"); in main()
445 run_sql(p, "CREATE TABLE IF NOT EXISTS test2.t2(tid INTEGER, sp, d, e, f)"); in main()
446 run_sql(p, "CREATE INDEX test2.t2tid ON t2(tid)"); in main()
447 run_sql(p, "CREATE INDEX test2.t2de ON t2(d,e)"); in main()
448 run_sql(p, "ATTACH 'tt4-test3.db' AS 'test3'"); in main()
449 run_sql(p, "CREATE TABLE IF NOT EXISTS test3.t3(tid INTEGER, sp, x, y, z)"); in main()
450 run_sql(p, "CREATE INDEX test3.t3tid ON t3(tid)"); in main()
451 run_sql(p, "CREATE INDEX test3.t3xy ON t3(x,y)"); in main()