Lines Matching refs:db
46 proc multiplex_set {db name chunk_size max_chunks} {
51 set rc [catch {sqlite3_multiplex_control $db $name chunk_size $chunk_size} msg]
53 set rc [catch {sqlite3_multiplex_control $db $name max_chunks $max_chunks} msg]
70 db close
78 multiplex_delete test.db
79 multiplex_delete test2.db
96 do_test multiplex-1.9.2 { sqlite3 db test.db } {}
97 do_test multiplex-1.9.3 { multiplex_set db main 32768 16 } {SQLITE_OK}
98 do_test multiplex-1.9.4 { multiplex_set db main 32768 -1 } {SQLITE_OK}
99 do_test multiplex-1.9.6 { multiplex_set db main 31 16 } {SQLITE_OK}
100 do_test multiplex-1.9.7 { multiplex_set db main 32768 100 } {SQLITE_OK}
101 do_test multiplex-1.9.8 { multiplex_set db main 1073741824 1 } {SQLITE_OK}
102 do_test multiplex-1.9.9 { db close } {}
106 do_test multiplex-1.10.2 { sqlite3 db test.db } {}
112 do_test multiplex-1.10.9 { db close } {}
116 do_test multiplex-1.11.2 { sqlite3 db test.db } {}
117 do_test multiplex-1.11.3 { sqlite3_multiplex_control db main enable 0 } {SQLITE_OK}
118 do_test multiplex-1.11.4 { sqlite3_multiplex_control db main enable 1 } {SQLITE_OK}
119 do_test multiplex-1.11.5 { sqlite3_multiplex_control db main enable -1 } {SQLITE_OK}
120 do_test multiplex-1.11.6 { db close } {}
124 do_test multiplex-1.12.2 { sqlite3 db test.db } {}
128 do_test multiplex-1.12.6 { db close } {}
132 do_test multiplex-1.13.2 { sqlite3 db test.db } {}
135 do_test multiplex-1.13.6 { db close } {}
146 # multiplex-2.3.*: Open and close a second db.
148 # multiplex-2.4.*: Try to shutdown the multiplex system before closing the db
162 multiplex_set db main 32768 16
169 sqlite3 db test.x
215 db close
216 sqlite3 db test.x
217 db eval vacuum
218 db close
228 sqlite3 db test.x
229 multiplex_set db main 4096 16
254 db eval {SELECT * FROM t1 WHERE a=1}
258 db eval {SELECT * FROM t1 WHERE a=3}
262 db eval {SELECT * FROM t1 WHERE a=5}
266 db eval {SELECT a,length(b) FROM t1 WHERE a=2}
270 db eval {SELECT a,length(b) FROM t1 WHERE a=4}
280 sqlite3 db test.x
289 db close
299 multiplex_delete test.db
301 sqlite3 db test.db
302 multiplex_set db main $sz 32
306 db eval {
310 db eval "PRAGMA journal_mode = $jmode;"
322 db eval {SELECT b FROM t1 WHERE a=1}
326 db eval {SELECT length(b) FROM t1 WHERE a=2}
329 do_test multiplex-2.6.6.$sz.$jmode { file size [multiplex_name test.db 0] } [list $g_chunk_size]
332 db close
339 do_test multiplex-2.7.1 { multiplex_delete test.db } {}
341 do_test multiplex-2.7.3 { sqlite3 db test.db } {}
351 do_test multiplex-2.7.7 { expr ([file size [multiplex_name test.db 0]] < 65536) } {1}
352 do_test multiplex-2.7.8 { file exists [multiplex_name test.db 1] } {0}
359 do_test multiplex-2.7.10 { expr ([file size [multiplex_name test.db 0]] > 65536) } {1}
360 do_test multiplex-2.7.11 { file exists [multiplex_name test.db 1] } {0}
361 do_test multiplex-2.7.12 { db close } {}
374 multiplex_delete test.db
376 sqlite3 db test.db
377 multiplex_set db main 32768 16
387 file size [multiplex_name test.db 0]
390 sqlite3 db2 test.db
400 db close
406 multiplex_delete test.db
407 multiplex_delete test2.db
409 sqlite3 db1a test.db
410 sqlite3 db2a test2.db
412 foreach db {db1a db2a} {
418 } $db
421 list [file size [multiplex_name test.db 0]] [file size [multiplex_name test2.db 0]]
425 sqlite3 db1b test.db
426 sqlite3 db2b test2.db
455 foreach db {db1a db2a db2b db1b} { catch { $db close } }
462 multiplex_set db main 32768 16
466 glob -nocomplain test2.db*
470 multiplex_delete test2.db
471 sqlite3 db test2.db
472 db eval {CREATE TABLE t2(x); INSERT INTO t2 VALUES('tab-t2');}
474 list [regexp {test2.db} $res]
477 sqlite3 db2 test2.db
484 sqlite3 db2 test2.db
491 sqlite3 db2 test2.db
501 list [regexp {test2.db} $res]
506 list [regexp {test2.db} $res]
509 db close
511 } {test2.db}
520 multiplex_set db main 32768 16
523 catch {db close}
525 sqlite3 db test2.db
528 catch {db close}
530 sqlite3 db test.db
533 catch { db close }
534 multiplex_delete test.db
535 multiplex_delete test2.db
538 sqlite3 db test.db
554 catch { db close }
555 multiplex_delete test.db
556 file mkdir test.db
557 list [catch { sqlite3 db test.db } msg] $msg
559 catch { delete_file test.db }
565 multiplex_set db main 32768 16
575 multiplex_delete test.db
578 sqlite3 db test.x
579 multiplex_set db main 4096 16
602 db close
610 catch { db close }