Lines Matching refs:file
11 # This file implements regression tests for SQLite library. The
12 # focus of this file is testing the operation of the library in
16 set testdir [file dirname $argv0]
50 return [expr [file exists $logfile]==0]
72 file size test.db
80 list [file exists test.db-journal] \
81 [file exists test.db-wal] \
82 [file size test.db]
86 list [file exists test.db-journal] [file exists test.db-wal]
90 file size test.db-wal
180 list [execsql { SELECT * FROM t1 }] [file size test.db-wal]
205 set logsize [file size test.db-wal]
210 expr { $logsize == [file size test.db-wal] }
236 list [execsql { SELECT * FROM t1 }] [file size test.db-wal]
262 set logsize [file size test.db-wal]
268 expr { $logsize == [file size test.db-wal] }
352 file size test.db
369 list [file size test.db] [file size test.db-wal]
373 list [file size test.db] [file size test.db-wal]
376 # Execute some transactions in auto-vacuum mode to test database file
405 file size test.db
412 file size test.db
433 file size test.db
676 # if frames must be written to the log file before a transaction is
686 list [expr [file size test.db]/1024] [expr [file size test.db-wal]/1044]
690 list [expr [file size test.db]/1024] [file size test.db-wal]
694 list [expr [file size test.db]/1024] [file size test.db-wal]
705 list [expr [file size test.db]/1024] [file size test.db-wal]
715 list [expr [file size test.db]/1024] [file size test.db-wal]
725 list [expr [file size test.db]/1024] [file size test.db-wal]
729 list [expr [file size test.db]/1024] [log_deleted test.db-wal]
734 # frame in the WAL-file with revised content, the size of the WAL file
749 list [expr [file size test.db]/1024] [file size test.db-wal]
759 list [expr [file size test.db]/1024] [file size test.db-wal]
769 list [expr [file size test.db]/1024] [file size test.db-wal]
776 # into a reused log file.
786 list [expr [file size test.db]/1024] [file size test.db-wal]
795 list [expr [file size test.db]/1024] [expr [file size test.db-wal]/1044]
799 list [expr [file size test.db]/1024] [expr [file size test.db-wal]/1044]
949 file size test.db
998 list [file size test.db] [file size test.db-wal]
1001 list [file size test2.db] [file size test2.db-wal]
1007 list [file size test.db] [file size test.db-wal]
1011 list [file size test2.db] [file size test2.db-wal]
1019 # number of "padding" frames are appended to the log file when a transaction
1024 # produces a log file of:
1031 # WAL code should write the 90300 bytes of log file containing the
1033 # log file so that no part of the next transaction will be written into
1068 file size test.db-wal
1072 file size test.db
1077 file size test.db
1084 # may be encountered while recovering a log file are handled correctly:
1090 # file is a power of 2 greater than 16384 or smaller than 512.
1113 list [file size testX.db] [file size testX.db-wal]
1152 # Since the magic number at the start of the -wal file header is
1190 # that there is no associated wal file.
1192 do_test wal-18.2.$tn.$pg.1 { file exists test.db-wal } 0
1193 do_test wal-18.2.$tn.$pg.2 { file exists test.db } 1
1194 do_test wal-18.2.$tn.$pg.3 { file size test.db } [expr 1024*3]
1198 # Create a wal file that contains a single frame (database page
1202 # The page-size in the log file header is set to $pgsz. If the
1203 # WAL code considers $pgsz to be a valid SQLite database file page-size,
1206 # or too large), the db will not be corrupt as the log file will
1228 file size test.db-wal
1246 # EXCLUSIVE lock on the database file. If the lock is obtained, the
1274 file exists test.db-wal
1299 # file in step 3 and the checkpoint was corrupting the database file.
1401 expr {[file size test.db] % %PGSZ%}
1408 # Test that when 1 or more pages are recovered from a WAL file,
1412 set walfile [file nativename [file join [get_pwd] test.db-wal]]
1445 "recovered 2 frames from WAL file $walfile"]
1451 # data is written to the WAL file for the truncated pages as part
1453 # to N pages, data for page N+1 should not be written to the WAL file
1478 file exists test.db-wal
1481 file size test.db
1489 file size test.db
1492 # WAL file now contains a single frame - the new root page for table t1.
1496 file size test.db-wal
1520 file delete test.db
1525 file delete attached-$i.db
1532 expr {[file size attached-$i.db-wal]>10000}
1538 file size attached-$i.db-wal
1542 expr {[file size attached-$j.db-wal]>10000}