| /sqlite-3.40.0/test/ |
| H A D | e_uri.test | 13 set testdir [file dirname $argv0]
39 set ::uri_open [list $file $arglist]
68 forcedelete file:test.db test.db
70 list [file exists file:test.db] [file exists test.db]
77 list [file exists file:test.db2] [file exists test.db2]
83 list [file exists file:test.db] [file exists test.db]
90 list [file exists file:test.db2] [file exists test.db2]
102 list [file exists file:test.db] [file exists test.db]
109 list [file exists file:test.db2] [file exists test.db2]
115 list [file exists file:test.db] [file exists test.db]
[all …]
|
| H A D | uri.test | 13 set testdir [file dirname $argv0]
35 foreach {tn uri file} {
46 11 file file
87 if {[file isdir $file]} {error "$file is a directory"}
88 forcedelete $file
89 do_test 1.$tn.1 { file exists $file } 0
91 do_test 1.$tn.2 { file exists $file } 1
93 forcedelete $file
95 do_test 1.$tn.3 { file exists $file } 0
98 do_test 1.$tn.4 { file exists $file } 1
[all …]
|
| H A D | symlink.test | 66 file exists test.db
70 file exists test.db
137 list [file exists test2.db-wal] [file exists test3.db-wal]
163 file mkdir x
164 file mkdir y
165 file mkdir z
182 list [file exists x/test.db-wal] [file exists y/test.db-wal]
191 list [file exists x/test.db-wal] [file exists y/test.db-wal] \
197 file mkdir w
198 file link w/test.db [file join [pwd] x/test.db]
[all …]
|
| H A D | io.test | 17 set testdir [file dirname $argv0]
138 # 3) The journal file (to sync the journal file header),
139 # 4) The database file.
176 file exists test.db-journal
195 file exists test.db-journal
199 file exists test.db-journal
223 file exists test.db-journal
230 file mkdir test.db-journal
245 # the journal file is always created. In this case, the journal file
440 # 3) The database file.
[all …]
|
| H A D | walpersist.test | 12 # This file contains tests for using WAL with persistent WAL file mode.
15 set testdir [file dirname $argv0]
31 file exists test.db-wal
34 file exists test.db-shm
38 list [file exists test.db] [file exists test.db-wal] [file exists test.db-shm]
45 list [file exists test.db] [file exists test.db-wal] [file exists test.db-shm]
67 list [file exists test.db] [file exists test.db-wal] [file exists test.db-shm]
71 # persisted wal file. In persistent-wal mode, any non-negative
86 expr {[file size test.db-wal]>100000}
91 concat [file exists test.db-wal] [file size test.db-wal]
[all …]
|
| H A D | crash.test | 22 set testdir [file dirname $argv0]
82 crashsql -delay 1 -file test.db {
111 crashsql -delay 2 -file test.db {
146 expr ([file size test.db] / 1024)>16
157 crashsql -delay 1 -file test.db {
186 expr ([file size test.db] / 1024) > 450
214 # journal file.
333 expr [file size test.db] / 1024
355 # database file and the journal file does not contain trustworthy rollback
379 crashsql -delay 1 -file test.db {
[all …]
|
| H A D | incrvacuum2.test | 20 # whole file.
39 file size test.db
48 file size test.db
57 file size test.db
66 file size test.db
83 list [file size test.db] [file size test2.db]
89 list [file size test.db] [file size test2.db]
95 list [file size test.db] [file size test2.db]
101 list [file size test.db] [file size test2.db]
107 list [file size test.db] [file size test2.db]
[all …]
|
| H A D | walro2.test | 15 set testdir [file dirname $argv0]
34 seek $fd [expr [file size test.db-shm]-1]
52 set MINSHMSZ [file size test.db-shm]
87 file exists test.db-shm
122 file exists test.db-shm
166 list [file exists test.db-wal] [file exists test.db-shm]
178 list [file size test.db-wal] [file size test.db-shm]
188 list [file size test.db-wal] [file size test.db-shm]
200 list [file size test.db-wal] [file size test.db-shm]
214 list [file size test.db-wal] [file size test.db-shm]
[all …]
|
| H A D | fallocate.test | 24 file size test.db
29 file size test.db
34 file size test.db
39 file size test.db
44 file size test.db
53 # the database file based on the size of the file on disk, not the actual
104 file size test.db
110 file size test.db
116 file size test.db
121 file size test.db
[all …]
|
| H A D | vacuum5.test | 15 set testdir [file dirname $argv0]
20 # the tests in this file.
48 set size1 [file size test.db]
49 set size2 [file size test2.db]
59 file size test2.db
62 file size test3.db
64 set size1 [file size test.db]
74 file size test.db
80 file size test3.db
92 file size test.db
[all …]
|
| H A D | tkt3457.test | 11 # This file implements regression tests for SQLite library.
15 set testdir [file dirname $argv0]
34 # the hot-journal file. Result: SQLITE_CANTOPEN.
43 # file. Result: SQLITE_OK.
79 file attributes test.db-journal -permissions ---------
81 } {1 {unable to open database file}}
84 file attributes test.db-journal -permissions -w--w--w-
86 } {1 {unable to open database file}}
89 file attributes test.db-journal -permissions r--r--r--
91 } {1 {unable to open database file}}
[all …]
|
| H A D | wal.test | 72 file size test.db
86 list [file exists test.db-journal] [file exists test.db-wal]
369 list [file size test.db] [file size test.db-wal]
373 list [file size test.db] [file size test.db-wal]
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]
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]
[all …]
|
| H A D | nockpt.test | 11 # This file implements regression tests for SQLite library. The
16 set testdir [file dirname $argv0]
37 do_test 1.1 { file exists test.db-wal } 1
38 do_test 1.2 { file size test.db-wal } [wal_file_size 3 1024]
40 do_test 1.4 { file exists test.db-wal } 0
47 do_test 1.6 { file exists test.db-wal } 1
51 do_test 1.10 { file exists test.db-wal } 1
62 do_test 1.15 { file exists test.db-wal } {0}
80 # not try to delete the wal file from the file-system as part of step
107 # Open and populate a new database file at the same file-system location
[all …]
|
| H A D | shell8.test | 15 set testdir [file dirname $argv0]
32 file delete -force $dirname
35 file mkdir $dirname
40 file mkdir [file dirname $path]
56 set mtime [file mtime $f]
62 set relpath [file join {*}[lrange [file split $f] $n end]]
64 if {[file isdirectory $f]} {
141 file delete -force ar1
147 file delete -force ar3
154 file delete -force ar3
[all …]
|
| H A D | walro.test | 15 set testdir [file dirname $argv0]
55 file mkdir walro
65 file exists test.db-shm
70 code1 { sqlite3 db file:test.db?readonly_shm=1 }
102 list [file exists test.db-wal] [file exists test.db-shm]
157 file exists test.db-shm
162 } {1 {unable to open database file}}
180 file exists test.db-shm
219 file size test.db-wal
261 proc tv_hook {x file args} {
[all …]
|
| H A D | 8_3_names.test | 18 set testdir [file dirname $argv0]
40 file exists test.db-journal
43 file exists test.nal
64 file exists test.db-journal
67 file exists test.nal
98 file exists test.db-journal
101 file exists test.nal
171 file exists test.db-wal
174 file exists test.wal
177 file exists test.db-shm
[all …]
|
| H A D | jrnlmode2.test | 13 set testdir [file dirname $argv0]
27 # The tests in this file check that the following two bugs (both now fixed)
34 # * There is a persistent journal in the file-system, AND
35 # * there exists a connection with a shared lock on the db file,
40 # database file. If this fails because another connection has a shared
46 # unix file descriptor on the database file is opened in O_RDONLY mode.
50 # attempts to obtain an exclusive lock on the database file (this is a
65 file exists test.db-journal
85 file exists test.db-journal
106 file exists test.db-journal
[all …]
|
| H A D | jrnlmode.test | 16 set testdir [file dirname $argv0]
227 list [file exists test.db-journal] [file exists test2.db-journal]
231 file size test.db-journal
241 file size test.db-journal
406 file size test.db-journal
418 file size test2.db-journal
464 list [file exists test.db-journal] [file size test.db-journal]
485 file exists test.db-journal
494 file exists test.db-journal
502 file exists test.db-journal
[all …]
|
| H A D | async3.test | 18 set testdir [file dirname $argv0]
34 chocolate/banana/vanilla/file.db
35 chocolate//banana/vanilla/file.db
36 chocolate/./banana//vanilla/file.db
37 chocolate/banana/./vanilla/file.db
38 chocolate/banana/../banana/vanilla/file.db
39 chocolate/banana/./vanilla/extra_bit/../file.db
43 file mkdir [file join chocolate banana vanilla]
44 forcedelete chocolate/banana/vanilla/file.db
45 forcedelete chocolate/banana/vanilla/file.db-journal
[all …]
|
| H A D | zerodamage.test | 15 # The name of this file comes from the fact that we used to call the
19 set testdir [file dirname $argv0]
53 sqlite3 db file:test.db?psow=TRUE -uri 1
56 proc xDeleteCallback {method file args} {
57 set sz [file size $file]
85 sqlite3 db file:test.db?psow=FALSE -uri 1
94 # WAL file does not get too big.
101 sqlite3 db file:test.db?psow=TRUE -uri 1
105 file size test.db-wal
113 sqlite3 db file:test.db?psow=FALSE -uri 1
[all …]
|
| H A D | wal9.test | 14 # of the *shm file mapped rolled back a transaction begun after the
15 # entire WAL file was checkpointed into the db file (i.e. a transaction
16 # that would have restarted the WAL file from the beginning).
19 set testdir [file dirname $argv0]
61 # Check file sizes are as expected. The real requirement here is that
62 # the *shm file is now more than one chunk (>32KiB).
66 do_test 1.3 { file size test.db } {1024}
67 do_test 1.4 { expr {[file size test.db-wal]>(1500*1024)} } {1}
68 do_test 1.5 { expr {[file size test.db-shm]>32768} } {1}
75 # only. Because the entire WAL file has been checkpointed, it is not
[all …]
|
| H A D | symlink2.test | 11 # This file implements regression tests for SQLite library. The
15 set testdir [file dirname $argv0]
27 [file nativename $link] [file nativename $target]
32 exec -- $::env(ComSpec) /c del [file nativename $link]
37 set link [file join $::testdir lnk[pid].sym]
38 if {[file exists $link]} { return 0 }
65 file exists test.db
69 file exists link.db
95 } {1 {unable to open database file}}
105 file exists test.db
[all …]
|
| H A D | avfs.test | 34 set testdir [file dirname $argv0]
68 # Return file offset of appendvfs portion of a file, or {} if none such.
70 if {[file size $fname] < 25} {
106 sqlite3 adb "file:$::fza?mode=rw$::vf" -uri 1
120 set adbSz [file size $::fa]
131 set adaSz [file size $::fa]
138 sqlite3 adb "file:$::fa?mode=rw$::vf" -uri 1
197 set adbSz [file size $::fa]
208 set adaSz [file size $::fa]
261 set adbsz [file size $::fa]
[all …]
|
| /sqlite-3.40.0/doc/ |
| H A D | pager-invariants.txt | 4 is called successfully on the file containing the page.
6 *** Definition: A page of the database file is said to be "overwriteable" if
16 the database file at the start of the transaction.
18 (1) A page of the database file is never overwritten unless one of the
32 (3) Writes to the database file are an integer multiple of the page size
37 first 100 bytes of the database file.
42 (6) If a master journal file is used, then all writes to the database file
57 is called to restore the database file to the same size it was at
72 (12) An EXCLUSIVE lock must be held on the database file before making
73 any changes to the database file.
[all …]
|
| /sqlite-3.40.0/ |
| H A D | README.md | 55 executable file and put that file someplace on your $PATH.)
130 The **src/** also contains the "shell.c" file
133 the "tclsqlite.c" file which implements the
146 smaller, single-file extensions, such as a REGEXP operator.
183 file is generated by scanning the src/vdbe.c source file. The
199 **pragma.h** header file.
226 individual source file exceeds 32K lines in length.
309 The `manifest` file at the root directory of the source tree
311 older files) for every source file in the repository.
313 SHA3-256 hash of the `manifest` file itself, possibly with the
[all …]
|