Lines Matching refs:PRAGMA

13 # "PRAGMA journal_mode=WAL" mode.
40     PRAGMA synchronous = NORMAL;
41     PRAGMA page_size = 1024;
42     PRAGMA auto_vacuum = 0;
43     PRAGMA journal_mode = wal;
59     PRAGMA main.journal_mode;
63   execsql { PRAGMA integrity_check } db2
72     PRAGMA main.journal_mode;
79   execsql { PRAGMA wal_checkpoint }
98   execsql { PRAGMA wal_checkpoint }
107     PRAGMA integrity_check;
115   execsql { PRAGMA journal_mode = WAL }
149   execsql { PRAGMA cache_size = 10 }
172   execsql { PRAGMA cache_size = 10 }
213     db  eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }
214     db2 eval { PRAGMA page_size = 1024 }
220     db  eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }
221     db2 eval { PRAGMA page_size = 1024 }
227     db  eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }
228     db2 eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = PERSIST }
234     db  eval { PRAGMA page_size = 1024 ; PRAGMA journal_mode = WAL }
236       PRAGMA page_size = 2048;
237       PRAGMA journal_mode = PERSIST;
281     execsql { PRAGMA journal_mode }
284     execsql { PRAGMA wal_checkpoint }
292       execsql { PRAGMA journal_mode } db2
295       execsql { PRAGMA wal_checkpoint }
326     db eval "PRAGMA journal_mode = $src"
334     db2 eval "PRAGMA journal_mode = $dest"
342   do_test walbak-4.$tn.2 { execsql { PRAGMA journal_mode } db  } $src
343   do_test walbak-4.$tn.3 { execsql { PRAGMA journal_mode } db2 } $dest
349   do_test walbak-4.$tn.5 { execsql { PRAGMA journal_mode } db2 } $dest_final
355   do_test walbak-4.$tn.7 { execsql { PRAGMA journal_mode } db2 } $dest_final