libdoltlite-sys 0.38.21

Native bindings to the DoltLite SQLite-compatible library
Documentation
#
# 09-May-2022
#
#-------------------------------------------------------------------------
#

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

bcv_create_container cont1

bcv_upload_new_db cont1 t1.db {
  CREATE TABLE x1(x, y);
  WITH s(i) AS (
    SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<5000
  )
  INSERT INTO x1 SELECT randomblob(100), randomblob(100) FROM s;
}

bcv_mkdir testdir
set cmd [bcvfs_create testdir bcvfs]

bcvfs_attach $cmd cont1
sqlite3 db /cont1/t1.db -vfs bcvfs
sqlite3_bcvfs_register_vtab db

do_execsql_test 1.0 {
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  cont1 t1.db 9 1
}

do_test 1.1 {
  $cmd prefetch_new pf cont1 t1.db
  pf run 4 10000
} {0}

do_execsql_test 1.2 {
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  cont1 t1.db 9 2
}

do_test 1.3a { pf run 0 1000 } {0}
do_execsql_test 1.3b {
  SELECT container, database, nblock, 
    ncache BETWEEN 3 AND 5
  FROM bcv_database
} {
  cont1 t1.db 9 1
}

do_test 1.4a { pf run 0 1000 } {0}
do_execsql_test 1.4b {
  SELECT container, database, nblock,
    ncache BETWEEN 3 AND 5
  FROM bcv_database
} {
  cont1 t1.db 9 1
}

do_test 1.5a { pf run 0 1000 } {0}
do_execsql_test 1.5b {
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  cont1 t1.db 9 5
}

do_test 1.6a { pf run 0 1000 } {0}
do_execsql_test 1.6b {
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  cont1 t1.db 9 5
}

do_test 1.7a { pf run 10 1000 } {0}
do_execsql_test 1.7b {
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  cont1 t1.db 9 6
}
pf destroy

do_execsql_test 1.8 {
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  cont1 t1.db 9 6
}

do_execsql_test 1.9 {
  PRAGMA bcv_client = 'icheck';
  PRAGMA integrity_check;
  SELECT container, database, nblock, ncache FROM bcv_database
} {
  icheck
  ok cont1 t1.db 9 9
}

do_execsql_test 1.9b {
  SELECT id, uri LIKE '%manifest%', client, logmsg FROM bcv_http_log
  WHERE end_time IS NOT NULL;
} {
  1 1 "" ""
  2 0 "" "demand 0 of t1.db"
  3 0 prefetch "prefetch 1 of t1.db"
  4 0 prefetch "prefetch 2 of t1.db"
  5 0 prefetch "prefetch 3 of t1.db"
  6 0 prefetch "prefetch 4 of t1.db"
  8 0 prefetch "prefetch 6 of t1.db"
  11 0 icheck  "demand 8 of t1.db"
  12 0 icheck  "demand 7 of t1.db"
  13 0 icheck  "demand 5 of t1.db"
}

bcv_upload_new_db cont1 t2.db {
  CREATE TABLE x1(x, y);
  WITH s(i) AS (
    SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<5000
  )
  INSERT INTO x1 SELECT randomblob(100), randomblob(100) FROM s;
}
$cmd poll cont1

do_test 1.10 {
  $cmd prefetch_new pf cont1 t2.db
  while { 0==[pf run 1 1000] } { expr 0 }
  pf errcode
} 101
pf destroy

do_test 1.11 {
  $cmd prefetch_new pf cont1 t3.db
  list [pf errcode] [pf errmsg]
} {1 {no such database: t3.db}}
pf destroy

do_test 1.12 {
  $cmd prefetch_new pf cont4 t3.db
  list [pf errcode] [pf errmsg]
} {1 {no such container: cont4}}
pf destroy


db close
$cmd destroy
finish_test