libdoltlite-sys 0.38.21

Native bindings to the DoltLite SQLite-compatible library
Documentation
#
# 13-January-2022
#
#-------------------------------------------------------------------------
#

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

#-------------------------------------------------------------------------
#
bcv_mkdir testdir
bcv_create_container cont1

bcv_upload_new_db cont1 x1.db {
  CREATE TABLE tX(a, b);
}
bcv_upload_new_db cont1 x2.db {
  CREATE TABLE t1(a, b);
}
bcv_upload_new_db cont1 x3.db {
  CREATE TABLE tY(a, b);
}

set cmd [bcvfs_create testdir "bcvfs"]
bcvfs_attach $cmd cont1

sqlite3 db /cont1/x2.db -vfs bcvfs
sqlite3_bcvfs_register_vtab db

do_execsql_test 1.0 {
  INSERT INTO t1 VALUES(1, 2);
  INSERT INTO t1 VALUES(3, 4);
} {}

#  container TEXT
#  database  TEXT
#  nblock INTEGER
#  ncache INTEGER
#  ndirty INTEGER
#  walfile BOOLEAN
do_execsql_test 1.1 {
  SELECT * FROM bcv_database
} {
  cont1 x1.db 1 0 0 0 {} 0 0 0
  cont1 x2.db 1 1 0 1 {} 1 0 1
  cont1 x3.db 1 0 0 0 {} 0 0 0
}

do_test 1.2 {
  $cmd upload cont1
} {}

do_execsql_test 1.3 {
  SELECT * FROM bcv_database
} {
  cont1 x1.db 1 0 0 0 {} 0 0 0
  cont1 x2.db 1 1 0 0 {} 1 0 1
  cont1 x3.db 1 0 0 0 {} 0 0 0
}

do_execsql_test 1.4 {
  INSERT INTO t1 VALUES(5, 6);
  INSERT INTO t1 VALUES(7, 8);
  PRAGMA wal_checkpoint;
} {
  0 2 2
}

do_execsql_test 1.4 {
  SELECT * FROM bcv_database
} {
  cont1 x1.db 1 0 0 0 {} 0 0 0
  cont1 x2.db 1 1 1 1 {} 1 0 1
  cont1 x3.db 1 0 0 0 {} 0 0 0
}

do_test 1.5 {
  set fd [open testdir/cont1/x3.db-wal w]
  puts $fd hello_world
  close $fd
} {}

do_execsql_test 1.6 {
  SELECT * FROM bcv_database
} {
  cont1 x1.db 1 0 0 0 {} 0 0 0
  cont1 x2.db 1 1 1 1 {} 1 0 1
  cont1 x3.db 1 0 0 1 {} 0 0 0
}

do_test 1.7 {
  $cmd upload cont1
} {}

do_execsql_test 1.8 {
  SELECT * FROM bcv_database
} {
  cont1 x1.db 1 0 0 0 {} 0 0 0
  cont1 x2.db 1 1 0 0 {} 1 0 1
  cont1 x3.db 1 1 0 0 {} 0 0 0
}

do_execsql_test 1.9 {
  INSERT INTO t1 VALUES(9, 10);
} {
}

sqlite3 db2 /cont1/x2.db -vfs bcvfs
do_execsql2_test 1.10 {
  BEGIN;
    SELECT * FROM t1;
} {1 2 3 4 5 6 7 8 9 10}

do_test 1.11 {
  list [catch { $cmd upload cont1 } msg] $msg
} {1 {5 database is locked}}

do_execsql2_test 1.12 {
  COMMIT;
  BEGIN;
    SELECT * FROM t1;
} {1 2 3 4 5 6 7 8 9 10}

do_execsql_test 1.13 {
  SELECT * FROM bcv_database
} {
  cont1 x1.db 1 0 0 0 {} 0 0 0
  cont1 x2.db 1 1 1 1 {} 2 0 2
  cont1 x3.db 1 1 0 0 {} 0 0 0
}

do_test 1.14 {
  list [catch { $cmd upload cont1 } msg] $msg
} {0 {}}

db2 close
db close
$cmd destroy

finish_test