Home
last modified time | relevance | path

Searched refs:db1 (Results 1 – 25 of 45) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dshared6.test39 # 1.2.2: If [db1] has an exclusive lock, [db1] can read.
55 } db1
64 # 1.3.1: If [db1] has a write-lock on t1, [db1] can read from t1.
75 } db1
92 } db1
116 } db1
128 } db1
133 db1 close
173 db1 close
232 db1 close
[all …]
H A Dshared9.test35 db1 eval {
77 db1 close
95 db1 eval {
101 db1 close
123 db1 eval {
127 db1 close
147 db1 eval {
151 db1 close
176 db1 busy [list busyhandler db1]
220 } {db1}
[all …]
H A DsharedA.test37 sqlite3 db1 test.db
40 db1 eval {
52 db1 eval {
59 db1 eval {
66 db1 close
79 db1 eval {
88 db1 eval {
91 db1 close
132 db1 eval {
151 db1 eval {
[all …]
H A Dshared3.test29 sqlite3 db1 test.db
30 db1 eval {
35 db1 close
36 sqlite3 db1 test.db
37 db1 eval {SELECT * FROM t1}
44 db1 close
48 sqlite3 db1 test.db
51 } db1
87 } db1
94 } db1
[all …]
H A Dbackup4.test43 sqlite3 db1 :memory:
44 db1 backup test.db
45 sqlite3 db1 test.db
46 db1 eval {
50 db1 close
74 sqlite3 db1 test.db2
75 db1 backup test.db
76 db1 close
100 sqlite3 db1 test.db2
101 db1 backup test.db
[all …]
H A Dshared8.test35 # 1.0: Open connection [db1] and populate the database.
42 # close db1 and check that db2 still works. This shows that closing
43 # db1 did not reset the in-memory schema.
51 sqlite3 db1 test.db
52 db1 func roman roman
61 } db1
65 sqlite3_db_config db1 DEFENSIVE 0
71 } db1
75 execsql { SELECT * FROM v1 } db1
85 db1 close
[all …]
H A Dtkt3793.test30 sqlite3 db1 "file:test.db?cache=private" -uri 1
54 db1 busy {busyhandler db1}
65 # Set the size of the cache shared by [db1] and [db2] to 10. Then update
76 } db1
81 # Run one SELECT query on the shared-cache using [db1], then from within
89 # associated with [db1].
95 set ::busyconnection db1
96 db1 eval {SELECT * FROM t2 ORDER BY a LIMIT 20} {
97 do_test tkt3793-2.[incr x] { set ::busyconnection } db1
102 set ::busyconnection db1
[all …]
H A Dincrvacuum_ioerr.test116 sqlite3 db1 test.db
128 } db1
130 execsql { INSERT INTO a VALUES($ii, randstr(800,1500)); } db1
132 execsql COMMIT db1
133 execsql {DELETE FROM a WHERE oid} db1
142 set nFree [execsql {pragma freelist_count} db1]
143 set nPage [execsql {pragma page_count} db1]
152 set ::rc [catch {execsql {pragma incremental_vacuum(5)} db1} msg]
161 set nFree2 [execsql {pragma freelist_count} db1]
162 set nPage2 [execsql {pragma page_count} db1]
[all …]
H A Dlock7.test25 sqlite3 db1 test.db
28 db1 eval {BEGIN}
33 execsql { PRAGMA lock_status } db1
40 catchsql { INSERT INTO t1 VALUES(1, 1) } db1
47 execsql { PRAGMA lock_status } db1
54 execsql { COMMIT } db1
57 db1 close
H A Dbusy2.test59 # [db] and [db1.2], process 2 has connection [db2] only.
65 sqlite3 db1.2 test.db
77 db1.2 timeout 1000
79 db1.2 eval {SELECT * FROM t1}
112 # Passive checkpoint with [db1.2] (process 1). No SQLITE_BUSY, returns
116 set res [code1 { db1.2 eval { PRAGMA wal_checkpoint } }]
121 # Full checkpoint with [db1.2] (process 1). SQLITE_BUSY returned in
125 set res [code1 { db1.2 eval { PRAGMA wal_checkpoint = FULL } }]
131 db1.2 close
H A Dmemdb1.test26 # Then extract the database into the $::db1 variable.
27 # Verify that the size of $::db1 is the same as the size of
30 unset -nocomplain db1
40 set ::db1 [db serialize]
41 expr {[string length $::db1]==$::sz1}
43 set fd [open db1.db wb]
44 puts -nonewline $fd $db1
52 db deserialize $db1
76 catch {db deserialize -unknown 1 $db1} msg
80 db deserialize -readonly 1 $db1
[all …]
H A Dnotify3.test120 catch { db1 close }
122 sqlite3 db1 test.db
125 sqlite3_extended_result_codes db1 $enable_extended_errors
128 if { $db1_loaded } { db1 eval "SELECT * FROM sqlite_master" }
132 catchsql "ATTACH 'test.db2' AS two" db1
136 list [sqlite3_errcode db1] [sqlite3_extended_errcode db1]
140 db1 unlock_notify {set invoked 1}
147 catch { db1 close }
H A Dtkt-f7b4edec.test27 sqlite3 db1 test.db
32 db1 update_hook update_hook
38 execsql { CREATE TABLE t1(x, y); } db1
39 execsql { INSERT INTO t1 VALUES(1, 2) } db1
63 execsql { INSERT INTO t1 VALUES(1, 2) } db1
70 db1 close
H A Dshared4.test36 sqlite3 db1 test1.db
40 db1 eval {
56 db1 eval {
76 db1 eval {
124 db1 eval {
156 db1 eval {
173 db1 eval {
197 db1 eval {
230 db1 close
H A Dshared.test436 } db1
447 } db1
453 } db1
462 } db1
493 } db1
509 } db1
1064 db1 eval {
1085 db1 close
1100 db1 close
1128 db1 close
[all …]
H A Dshared2.test29 sqlite3 db1 test.db
46 } db1
61 } db1
70 } db1
76 } db1
83 db1 close
H A Drecover.test24 proc compare_result {db1 db2 sql} {
25 set r1 [$db1 eval $sql]
35 proc compare_dbs {db1 db2} {
36 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
37 foreach tbl [$db1 eval {SELECT name FROM sqlite_master WHERE type='table'}] {
38 compare_result $db1 $db2 "SELECT * FROM $tbl"
H A Dswarmvtabfault.test34 forcedelete test.db1
38 ATTACH 'test.db1' AS aux;
54 ("test.db1", "t1", 1, 10),
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest7.c169 lsm_db *db1 = 0; in do_test_api2() local
173 db1 = newLsmConnection("testdb.lsm", 0, 0, pRc); in do_test_api2()
174 testPagesize(db1, 4096, 1024, pRc); in do_test_api2()
177 lsm_close(db1); in do_test_api2()
181 db1 = newLsmConnection("testdb.lsm", 1024, 64*1024, pRc); in do_test_api2()
182 testPagesize(db1, 1024, 64*1024, pRc); in do_test_api2()
185 lsm_close(db1); in do_test_api2()
189 db1 = newLsmConnection("testdb.lsm", 8192, 2*1024, pRc); in do_test_api2()
190 testPagesize(db1, 8192, 2*1024, pRc); in do_test_api2()
193 lsm_close(db1); in do_test_api2()
/sqlite-3.40.0/ext/recover/
H A Drecover1.test16 proc compare_result {db1 db2 sql} {
17 set r1 [$db1 eval $sql]
27 proc compare_dbs {db1 db2} {
28 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
29 foreach tbl [$db1 eval {SELECT name FROM sqlite_master WHERE type='table'}] {
30 compare_result $db1 $db2 "SELECT * FROM $tbl"
33 compare_result $db1 $db2 "PRAGMA page_size"
34 compare_result $db1 $db2 "PRAGMA auto_vacuum"
35 compare_result $db1 $db2 "PRAGMA encoding"
36 compare_result $db1 $db2 "PRAGMA user_version"
[all …]
H A Drecoverfault.test18 proc compare_result {db1 db2 sql} {
19 set r1 [$db1 eval $sql]
29 proc compare_dbs {db1 db2} {
30 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
31 foreach tbl [$db1 eval {SELECT name FROM sqlite_master WHERE type='table'}] {
32 compare_result $db1 $db2 "SELECT * FROM $tbl"
H A Drecoverfault2.test18 proc compare_result {db1 db2 sql} {
19 set r1 [$db1 eval $sql]
29 proc compare_dbs {db1 db2} {
30 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
31 foreach tbl [$db1 eval {SELECT name FROM sqlite_master WHERE type='table'}] {
32 compare_result $db1 $db2 "SELECT * FROM $tbl"
H A Drecoverold.test17 proc compare_result {db1 db2 sql} {
18 set r1 [$db1 eval $sql]
29 proc compare_dbs {db1 db2} {
30 compare_result $db1 $db2 "SELECT sql FROM sqlite_master ORDER BY 1"
31 foreach tbl [$db1 eval {SELECT name FROM sqlite_master WHERE type='table'}] {
32 compare_result $db1 $db2 "SELECT * FROM $tbl"
/sqlite-3.40.0/ext/session/
H A Dsession_common.tcl151 proc compare_db {db1 db2} {
154 set lot1 [$db1 eval $sql]
167 $db1 eval "PRAGMA table_info = $tbl" { lappend col1 $name }
172 set data1 [$db1 eval $sql]
175 puts "$db1: $data1"
H A Dsessiondiff.test30 proc database_cksum {db1} {
33 sqlite3 dbtmp $db1
56 proc get_changeset {db1 db2} {
57 exec $::PROG --changeset changeset.bin $db1 $db2

12