libdoltlite-sys 0.38.21

Native bindings to the DoltLite SQLite-compatible library
Documentation
#
# 18-August-2023
#
#-------------------------------------------------------------------------
#

source [file join [file dirname [info script]] test_common.tcl]
set testprefix bcvfs_vtab3

bcv_mkdir testdir
bcv_create_container cont1
bcv_upload_new_db cont1 test.db {
  CREATE TABLE t1(x, y);
}

set cmd [bcvfs_create testdir "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 {
    db close
    sqlite3 db2 /cont1/test.db -vfs bcvfs
    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
finish_test