Lines Matching refs:PRAGMA

13 # "PRAGMA journal_mode=WAL" mode.
41   [lindex $args 0] eval { PRAGMA auto_vacuum = 0 }
42   [lindex $args 0] eval { PRAGMA page_size = 1024 }
43   [lindex $args 0] eval { PRAGMA journal_mode = wal }
44   [lindex $args 0] eval { PRAGMA synchronous = normal }
67   execsql { PRAGMA auto_vacuum = 0 }
68   execsql { PRAGMA synchronous = normal }
69   execsql { PRAGMA journal_mode = wal }
183   execsql { PRAGMA cache_size = 10 }
222   execsql { PRAGMA integrity_check } db2
230     PRAGMA journal_mode = WAL;
239   execsql { PRAGMA cache_size = 10 }
280   execsql { PRAGMA integrity_check } db2
287     PRAGMA wal_checkpoint;
343         PRAGMA page_size = $pgsz;
344         PRAGMA auto_vacuum = 0;
345         PRAGMA journal_mode = wal;
365     PRAGMA page_size = 1024;
372   execsql { PRAGMA wal_checkpoint }
387     PRAGMA auto_vacuum = 1;
388     PRAGMA journal_mode = wal;
389     PRAGMA auto_vacuum;
394     PRAGMA page_size = 1024;
403     PRAGMA wal_checkpoint;
410     PRAGMA wal_checkpoint;
421     PRAGMA cache_size=2000;
437   execsql {PRAGMA integrity_check } db2
445   execsql {PRAGMA integrity_check } db3
450   execsql { PRAGMA wal_checkpoint }
453   execsql {PRAGMA integrity_check } db2
471       PRAGMA auto_vacuum = 0;
472       PRAGMA journal_mode = wal;
550     catchsql { PRAGMA wal_checkpoint } 
560     catchsql { PRAGMA wal_checkpoint } 
570     catchsql { PRAGMA wal_checkpoint } 
573     execsql { PRAGMA wal_checkpoint } 
596     execsql { PRAGMA wal_checkpoint }
602     execsql { PRAGMA wal_checkpoint }
619     catchsql { PRAGMA wal_checkpoint }
623     execsql { PRAGMA wal_checkpoint }
662     catchsql { PRAGMA wal_checkpoint }
670     execsql { PRAGMA wal_checkpoint }
682     PRAGMA cache_size = 10;
683     PRAGMA page_size = 1024;
689   execsql { PRAGMA wal_checkpoint }
710     PRAGMA integrity_check;
720     PRAGMA integrity_check;
724   execsql { PRAGMA wal_checkpoint }
744     PRAGMA cache_size = 10;
765     PRAGMA integrity_check;
781     PRAGMA page_size = 1024;
792     PRAGMA synchronous = normal;
810     PRAGMA wal_checkpoint;
812     PRAGMA wal_checkpoint;
814     PRAGMA wal_checkpoint;
844     PRAGMA journal_mode = WAL;
859   # After executing the "PRAGMA wal_checkpoint", connection [db] was being
863     PRAGMA wal_checkpoint;
867   db2 eval { PRAGMA integrity_check }
881     PRAGMA auto_vacuum = 0;
882     PRAGMA page_size = 1024;
883     PRAGMA journal_mode = WAL;
963   3 {db eval "PRAGMA wal_checkpoint"}        {0 10 10}     1 1
968   7 {db eval "PRAGMA main.wal_checkpoint"}   {0 10 10}     1 0
969   8 {db eval "PRAGMA aux.wal_checkpoint"}    {0 13 13}     0 1
970   9 {db eval "PRAGMA temp.wal_checkpoint"}   {0 -1 -1}     0 0
979       PRAGMA main.auto_vacuum = 0;
980       PRAGMA aux.auto_vacuum = 0;
981       PRAGMA main.journal_mode = WAL;
982       PRAGMA aux.journal_mode = WAL;
983       PRAGMA main.synchronous = NORMAL;
984       PRAGMA aux.synchronous = NORMAL;
1053       PRAGMA auto_vacuum = 0;
1054       PRAGMA page_size = 512;
1055       PRAGMA cache_size = -2000;
1056       PRAGMA journal_mode = WAL;
1057       PRAGMA synchronous = FULL;
1096     PRAGMA page_size = 1024;
1097     PRAGMA auto_vacuum = 0;
1098     PRAGMA journal_mode = WAL;
1099     PRAGMA synchronous = OFF;
1103     PRAGMA wal_checkpoint;
1135       PRAGMA integrity_check; 
1233       set rc [catch { db one {PRAGMA integrity_check} } msg]
1258     PRAGMA journal_mode = WAL;
1307       PRAGMA journal_mode = WAL;
1318         PRAGMA wal_autocheckpoint = 0;
1338     execsql { PRAGMA wal_checkpoint }
1355     PRAGMA journal_mode = WAL;
1367     PRAGMA cache_size = 10;
1368     PRAGMA wal_checkpoint;
1378   execsql { PRAGMA integrity_check }
1389         PRAGMA main.page_size = %PGSZ%;
1390         PRAGMA auto_vacuum = 0;
1391         PRAGMA journal_mode = WAL;
1398     do_test wal-22.%PGSZ%.$tn.2 { sql2 { PRAGMA integrity_check } } {ok}
1400       sql1 {PRAGMA wal_checkpoint}
1422     PRAGMA journal_mode = WAL;
1461     PRAGMA auto_vacuum = 2;
1462     PRAGMA journal_mode = WAL;
1463     PRAGMA page_size = 1024;
1474       PRAGMA wal_checkpoint;
1485       PRAGMA cache_size = 200;
1486       PRAGMA incremental_vacuum;
1487       PRAGMA wal_checkpoint;
1505 # Make sure PRAGMA journal_mode=WAL works with ATTACHED databases in
1512     db eval "PRAGMA journal_mode=$mode"
1513     db eval {ATTACH 'test2.db' AS t2; PRAGMA journal_mode=WAL;}
1522 db eval {PRAGMA journal_mode=WAL}
1527     db eval "PRAGMA a$i.journal_mode=WAL;"
1537     db eval "PRAGMA a$i.wal_checkpoint(TRUNCATE);"