libdoltlite-sys 0.38.21

Native bindings to the DoltLite SQLite-compatible library
Documentation
#
# 19-July-2020
#
#-------------------------------------------------------------------------
#

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


#-------------------------------------------------------------------------
# This test uses a single database in a single container. The container
# is attached to the main VFS twice - once as "c1" and once as "c2".
#
bcv_create_container container1
bcv_upload_empty_database container1 t1.db

bcv_mkdir testdir
set bcvfs [bcvfs_create testdir bcvfs]
$bcvfs log {all} log_callback
# proc log_callback {mask msg} { puts "111 $mask: $msg" }
proc log_callback {mask msg} { }
proc log_callback2 {mask msg} { puts "222 $mask: $msg" }

bcvfs_attach -alias c1 $bcvfs container1
sqlite3 db  /c1/t1.db -vfs bcvfs
sqlite3_bcvfs_register_vtab db

do_execsql_test 1.0 {
  CREATE TABLE t1(a, b);
  CREATE INDEX i1 ON t1(a);
  CREATE INDEX i2 ON t1(b);
  PRAGMA bcv_upload;
}

bcvfs_attach -alias c2 $bcvfs container1
sqlite3 db2 /c2/t1.db -vfs bcvfs
set bcv [bcv_open container1]

bcv_mkdir testdir3
set bcvfs3 [bcvfs_create testdir3 bcvfs3]
bcvfs_attach -alias c4 $bcvfs3 container1
$bcvfs3 destroy

set row_per_step 10
for {set ii 0} {$ii < 30} {incr ii} {
  do_test 2.$ii.1 {
    for {set jj 0} {$jj < $row_per_step} {incr jj} {
      db eval {
        INSERT INTO t1 SELECT randomblob(400), randomblob(400);
      }
    }
  } {}
  do_test 2.$ii.2 {
    db eval { PRAGMA bcv_upload }
  } {}

  do_test 2.$ii.3 {
    db2 eval { SELECT count(*) FROM t1 }
  } [expr $row_per_step * $ii]

  do_test 2.$ii.4a {
    db eval { 
      SELECT count(*) FROM t1;
      PRAGMA integrity_check;
    }
  } [list [expr $row_per_step * ($ii+1)] ok]

  do_test 2.$ii.4 {
    $bcvfs poll c2
    db2 eval { 
      SELECT count(*) FROM t1;
      PRAGMA integrity_check;
    }
  } [list [expr $row_per_step * ($ii+1)] ok]

  bcv_mkdir testdir2
  set bcvfs2 [bcvfs_create testdir2 bcvfs2]
  bcvfs_attach -alias c3 $bcvfs2 container1
  sqlite3 db3 /c3/t1.db -vfs bcvfs2
  do_test 2.$ii.5 {
    db3 eval { SELECT count(*) FROM t1; }
  } [expr $row_per_step * ($ii+1)]
  db3 close
  $bcvfs2 destroy

  set bcvfs4 [bcvfs_create testdir3 bcvfs4]
  sqlite3 db4 /c4/t1.db -vfs bcvfs4
  do_test 2.$ii.6 {
    db4 eval { SELECT count(*) FROM t1; }
  } [expr $row_per_step * $ii]
  do_test 2.$ii.7 {
    $bcvfs4 poll c4
    db4 eval {
      SELECT count(*) FROM t1;
      PRAGMA integrity_check;
    }
  } [list [expr $row_per_step * ($ii+1)] ok]

  db4 close
  $bcvfs4 destroy

  $bcv cleanup 0
  $bcvfs poll c1

  set len [expr $::C(namebytes)*2+4]
  do_execsql_test 2.$ii.8 {
    SELECT (
        SELECT nblock FROM bcv_database WHERE container='c1'
    )==(
      SELECT count(*) FROM bcv_tfs WHERE length(name)==$len
    )
  } 1

}

db  close
db2 close
$bcvfs destroy
$bcv close

finish_test