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 util_cleanup2

bcv_mkdir testdir

# Create new container. Ensure there are no old blob files within 
# cloud storage.
#
bcv_create_container cont1
set bcv [bcv_open cont1]
$bcv cleanup 0
$bcv close

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

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 name, ncleanup FROM bcv_container
} {cont1 0}

do_execsql_test 1.1 {
  SELECT container, database, nblock, ndirty FROM bcv_database
} {cont1 test.db 32 0}

do_execsql_test 1.2 {
  UPDATE t1 SET x = hex(randomblob(1000));
}

do_execsql_test 1.3 {
  SELECT container, database, nblock, ndirty FROM bcv_database
} {cont1 test.db 32 32}

$cmd upload cont1

do_execsql_test 1.4 {
  SELECT container, database, nblock, ndirty FROM bcv_database
} {cont1 test.db 32 0}

do_execsql_test 1.5 {
  SELECT name, ncleanup FROM bcv_container
} {cont1 32}

set ::progress_handler [list]
proc bcv_progress_handler {args} {
  lappend ::progress_handler $args
  return 0
}

do_test 1.6 {
  set bcv [bcv_open cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
  $bcv close
} {}

$cmd poll cont1
do_execsql_test 1.7 {
  SELECT name, ncleanup FROM bcv_container
} {cont1 0}

do_test 1.8 {
  set ::progress_handler
} [list {*}{
  {1 32} {2 32} {3 32} {4 32} {5 32} {6 32} {7 32} {8 32} 
  {9 32} {10 32} {11 32} {12 32} {13 32} {14 32} {15 32} {16 32} 
  {17 32} {18 32} {19 32} {20 32} {21 32} {22 32} {23 32} {24 32} 
  {25 32} {26 32} {27 32} {28 32} {29 32} {30 32} {31 32} {32 32}
}]

do_execsql_test 1.9 {
  UPDATE t1 SET x = hex(randomblob(1000));
}
$cmd upload cont1

set ::progress_handler [list]
proc bcv_progress_handler {nDone nTotal} {
  lappend ::progress_handler [list $nDone $nTotal]
  if {$nDone==16} { return 101 }
  return 0
}

do_test 1.10 {
  set bcv [bcv_open cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
  $bcv close
} {}

$cmd poll cont1
do_execsql_test 1.11 {
  SELECT name, ncleanup FROM bcv_container
} {cont1 16}

set ::progress_handler [list]
proc bcv_progress_handler {nDone nTotal} {
  lappend ::progress_handler [list $nDone $nTotal]
  if {$nDone==8} { return 1 }
  return 0
}

do_test 1.12 {
  set bcv [bcv_open cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {4}
$bcv close

$cmd poll cont1
do_execsql_test 1.13 {
  SELECT name, ncleanup FROM bcv_container
} {cont1 16}

set ::progress_handler [list]
proc bcv_progress_handler {nDone nTotal} {
  lappend ::progress_handler [list $nDone $nTotal]
  return 0
}
do_test 1.14 {
  set bcv [bcv_open cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {0}
$bcv close
do_test 1.15 {
  llength $::progress_handler 
} {16}

set ::progress_handler [list]
do_test 1.16 {
  set bcv [bcv_open cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {0}
$bcv close
do_test 1.17 {
  llength $::progress_handler 
} {0}

set ::progress_handler [list]
do_test 1.18 {
  set bcv [bcv_open -module $C(module)&maxresults=1 cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {0}
$bcv close
do_test 1.19 {
  expr [llength $::progress_handler]>=34
} {1}

proc bcv_progress_handler {nDone nTotal} {
  lappend ::progress_handler [list $nDone $nTotal]
  if {[llength $::progress_handler]==12} { return 1 }
  return 0
}
set ::progress_handler [list]
do_test 1.20 {
  set bcv [bcv_open -module $C(module)&maxresults=1 cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {4}
$bcv close

wait_ms 1000

proc bcv_progress_handler {nDone nTotal} {
  lappend ::progress_handler [list $nDone $nTotal]
  if {[llength $::progress_handler]==12} { return 101 }
  return 0
}
set ::progress_handler [list]
do_test 1.21 {
  set bcv [bcv_open -module $C(module)&maxresults=1 cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {0}
$bcv close

#-------------------------------------------------------------------------
# Run a full cleanup on the container.
#
do_test 2.0 {
  set bcv [bcv_open -module $C(module)&maxresults=1 cont1]
  $bcv cleanup 0
} {0}
$bcv close

proc bcv_progress_handler {nDone nTotal} {
  incr ::nProgressHandler 
  return 0
}
do_test 2.1.1 {
  set ::nProgressHandler 0
  set bcv [bcv_open -module $C(module)&maxresults=1 cont1]
  $bcv config progress bcv_progress_handler
  $bcv cleanup 0
} {0}
$bcv close
do_test 2.1.2 {
  expr {$::nProgressHandler > 0}
} 1
proc bcv_progress_handler {nDone nTotal} {
puts "PH: $nDone $nTotal"
  incr ::nProgressHandler 
  return 0
}
do_test 2.2.1 {
  set ::nProgressHandler 0
  set bcv [bcv_open -module $C(module)&maxresults=1 cont1]
  $bcv config progress bcv_progress_handler
  $bcv config find_orphans 0
  $bcv cleanup 0
} {0}
$bcv close
do_test 2.1.2 {
  expr {$::nProgressHandler > 0}
} 0



db close
$cmd destroy
finish_test