libdoltlite-sys 0.38.21

Native bindings to the DoltLite SQLite-compatible library
Documentation
#
# 20-November-2024
#
#-------------------------------------------------------------------------
#

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


bcv_create_container mycont
bcv_upload_new_db mycont xyz.db {
  CREATE TABLE t1(x);
  INSERT INTO t1 VALUES(1), (2), (3);
}

bcv_mkdir testdir1
bcv_mkdir testdir2
set cmd1 [bcvfs_create testdir1 bcvfs1]
bcvfs_attach $cmd1 mycont
set cmd2 [bcvfs_create testdir2 bcvfs2]
bcvfs_attach $cmd2 mycont


sqlite3 db  /mycont/xyz.db -vfs bcvfs1
sqlite3 db2 /mycont/xyz.db -vfs bcvfs2

do_execsql_test  1.0a { SELECT * FROM t1 } {1 2 3}
do_execsql2_test 1.0b { SELECT * FROM t1 } {1 2 3}

do_execsql_test 1.1 {
  INSERT INTO t1 VALUES(4);
}

do_execsql_test  1.2a { SELECT * FROM t1 } {1 2 3 4}
do_execsql2_test 1.2b { SELECT * FROM t1 } {1 2 3}

$cmd1 upload mycont

do_execsql_test  1.3a { SELECT * FROM t1 } {1 2 3 4}
do_execsql2_test 1.3b { SELECT * FROM t1 } {1 2 3}

$cmd2 poll mycont

do_execsql_test  1.4a { SELECT * FROM t1 } {1 2 3 4}
do_execsql2_test 1.4b { SELECT * FROM t1 } {1 2 3 4}

db close
db2 close
$cmd1 destroy
$cmd2 destroy

finish_test