#
# 18-August-2023
#
#-------------------------------------------------------------------------
#
source [file join [file dirname [info script]] test_common.tcl]
set testprefix dmn_vtab3.test
bcv_create_container cont1
bcv_upload_new_db cont1 test.db {
CREATE TABLE t1(x, y);
}
start_new_daemon 0
set cmd [bcvfs_create testdir.0 "bcvfs"]
bcvfs_attach $cmd cont1
sqlite3 db /cont1/test.db -vfs bcvfs
sqlite3_bcvfs_register_vtab db
do_execsql_test 1.0 {
SELECT container, database, nclient, nprefetch FROM bcv_database
} {cont1 test.db 1 0}
sqlite3 db2 /cont1/test.db -vfs bcvfs
do_execsql_test 1.1 {
SELECT container, database, nclient, nprefetch FROM bcv_database
} {cont1 test.db 2 0}
foreach {tn script nclient nprefetch} {
1 {
sqlite3 db2 /cont1/test.db -vfs bcvfs
$cmd prefetch_new pf1 cont1 test.db
} 2 1
2 {
pf1 destroy
sqlite3 db3 /cont1/test.db -vfs bcvfs
} 3 0
3 {
$cmd prefetch_new pf1 cont1 test.db
$cmd prefetch_new pf2 cont1 test.db
$cmd prefetch_new pf3 cont1 test.db
db2 close
} 2 3
4 {
pf1 destroy
pf3 destroy
db close
sqlite3 db /cont1/test.db -vfs bcvfs
sqlite3_bcvfs_register_vtab db
} 2 1
5 {
pf2 destroy
db3 close
} 1 0
6 {
sqlite3 db2 /cont1/test.db -vfs bcvfs
db close
sqlite3 db /cont1/test.db -vfs bcvfs
sqlite3_bcvfs_register_vtab db
} 2 0
7 {
db2 close
} 1 0
} {
eval $script
do_execsql_test 1.3.$tn {
SELECT container, database, nclient, nprefetch FROM bcv_database
} [list cont1 test.db $nclient $nprefetch]
}
bcv_upload_new_db cont1 test.db2 { CREATE TABLE t1(x, y); }
bcv_upload_new_db cont1 test.db3 { CREATE TABLE t1(x, y); }
bcv_upload_new_db cont1 test.db4 { CREATE TABLE t1(x, y); }
$cmd poll cont1
sqlite3 db2.1 /cont1/test.db2 -vfs bcvfs
sqlite3 db2.2 /cont1/test.db2 -vfs bcvfs
sqlite3 db3.1 /cont1/test.db3 -vfs bcvfs
sqlite3 db3.2 /cont1/test.db3 -vfs bcvfs
sqlite3 db3.3 /cont1/test.db3 -vfs bcvfs
sqlite3 db4.1 /cont1/test.db4 -vfs bcvfs
sqlite3 db4.2 /cont1/test.db4 -vfs bcvfs
sqlite3 db4.3 /cont1/test.db4 -vfs bcvfs
sqlite3 db4.4 /cont1/test.db4 -vfs bcvfs
do_execsql_test 1.4 {
SELECT container, database, nclient, nprefetch FROM bcv_database
} {
cont1 test.db 1 0
cont1 test.db2 2 0
cont1 test.db3 3 0
cont1 test.db4 4 0
}
db2.1 close
db2.2 close
db3.1 close
db3.2 close
db3.3 close
db4.1 close
db4.2 close
db4.3 close
db4.4 close
db close
$cmd destroy
wait_daemon 0
finish_test