Lines Matching refs:file
12 # The focus of this file is testing some specific characteristics of the
17 set testdir [file dirname $argv0]
33 # fsync() calls on the journal file).
37 # fsync() calls on the journal file, no need to set nRec
93 # are written to the db file - the two leaf pages, the root
136 # 1) The directory in which the journal file is created,
137 # 2) The journal file (to sync the page data),
138 # 3) The journal file (to sync the journal file header),
139 # 4) The database file.
150 # The single fsync() is the database file. Only one page is reported as
164 # Test that the journal file is not created and the change-counter is
176 file exists test.db-journal
184 # Test that the journal file is created and sync()d if the transaction
195 file exists test.db-journal
199 file exists test.db-journal
206 # Test that the journal file is created and sync()d if the transaction
207 # modifies a single database page and also appends a page to the file.
209 # journal file is not actually created until the 'COMMIT' statement
214 # is immediately modified and the journal file immediately comes into
223 file exists test.db-journal
226 # Create a file at "test.db-journal". This will prevent SQLite from
230 file mkdir test.db-journal
235 } {1 {unable to open database file}}
244 # Test that if the database modification is part of multi-file commit,
245 # the journal file is always created. In this case, the journal file
259 file exists test.db-journal
263 file exists test2.db-journal
269 file mkdir test2.db-journal
271 } {1 {unable to open database file}}
281 # Try an explicit ROLLBACK before the journal file is created.
288 file exists test.db-journal
311 file exists test.db-journal
327 file exists test.db-journal
342 file exists test.db-journal
351 file exists test.db-journal
367 file exists test.db-journal
375 file exists test.db-journal
394 expr {[file size test.db]>1}
417 # have been no calls to fsync(). The file is probably about 30KB.
420 # that the file is now greater than 20000 bytes in size.
421 list [expr [file size test.db]>20000] [nSync]
424 # The COMMIT requires a single fsync() - to the database file.
426 list [file size test.db] [nSync]
438 # 1) The directory in which the journal file is created, (unix only)
439 # 2) The journal file (to sync the page data),
440 # 3) The database file.
443 # on the journal file between steps (2) and (3) above.
459 # With SAFE_APPEND set, the nRec field of the journal file header should
461 # occupies bytes 8-11 of the journal file.
466 file exists test.db-journal
496 expr {[file size test.db]/1024}
512 file exists test.db-journal
515 # This test is not run on symbian because the file-buffer makes it
516 # difficult to predict the exact size of the file as reported by
517 # [file size].
523 # to the journal file after the cache-spill, then the size of the
524 # journal file is give by:
526 # <jrnl file size> = <jrnl header size> + nPage * (<page-size> + 8)
528 # If the journal file contains additional headers, this formula
529 # will not predict the size of the journal file.
531 file size test.db-journal
569 expr {[file size test.db]/2}
632 # Corrupt the database file on disk. This should not matter for the