libdoltlite-sys 0.38.26

Native bindings to the DoltLite SQLite-compatible library
Documentation
#
# 06-August-2022
#
#-------------------------------------------------------------------------
#

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

# This test is designed to run with the proxy.tcl/azurite combination 
# only. Print an error message and exit if it cannot be found.
if {[catch bcv_proxy_test msg]} { puts $msg ; exit }


# Configure the proxy to pass everything straight through.
#
bcv_proxy_config {
  DELETE FROM new_client_message;
}

# Initialize a new system
start_new_daemon 0 
set cmd [bcvfs_create testdir.0 "bcvfs"]
# $cmd config httptimeout 3

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

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

do_execsql_test 1.0 {
  BEGIN;
    SELECT sql FROM sqlite_schema
} {
  {CREATE TABLE x1(x INTEGER PRIMARY KEY, y)}
}

bcv_proxy_config {
  INSERT INTO new_client_message(pattern, action) 
    VALUES ('GET%', 'error 1 {SSL connection error}');
}

do_catchsql_test 1.1 {
    SELECT * FROM x1
} {1 {SQL logic error}}

do_catchsql_test 1.2 {
  SELECT * FROM x1
} {1 {SQL logic error}}

wait_ms 10

#-------------------------------------------------------------------------

bcv_proxy_config {
  DELETE FROM new_client_message;
}

bcv_upload_new_db cont1 t2.db {
  CREATE TABLE x1(x INTEGER PRIMARY KEY, y);
  CREATE TABLE x2(x INTEGER PRIMARY KEY, y);
  CREATE TABLE x3(x INTEGER PRIMARY KEY, y);

  WITH s(i) AS (
    SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<1000
  )
  INSERT INTO x1 SELECT i, hex(randomblob(500)) FROM s;
  INSERT INTO x2 SELECT x, hex(randomblob(500)) FROM x1;
  INSERT INTO x3 SELECT x, hex(randomblob(500)) FROM x1;
}

$cmd poll cont1
sqlite3 db2 /cont1/t2.db -vfs bcvfs
db close
sqlite3 db /cont1/t2.db -vfs bcvfs
db2 close

do_execsql_test 2.0 {
  PRAGMA cache_size = 10;
  BEGIN;
    SELECT sql FROM sqlite_schema
} {
  {CREATE TABLE x1(x INTEGER PRIMARY KEY, y)}
  {CREATE TABLE x2(x INTEGER PRIMARY KEY, y)}
  {CREATE TABLE x3(x INTEGER PRIMARY KEY, y)}
}

do_execsql_test 2.1 {
  SELECT count(y) FROM x3
} {1000}

bcv_proxy_config {
  INSERT INTO new_client_message(pattern, action) 
    VALUES ('GET%', 'error 1 {SSL connection error}');
}

breakpoint
do_catchsql_test 2.2.1 {
  SELECT count(y) FROM x1
} {1 {SQL logic error}}
do_catchsql_test 2.2.2 {
  SELECT count(y) FROM x1
} {1 {SQL logic error}}

do_execsql_test 2.3 {
  SELECT count(y) FROM x3
} {1000}

bcv_proxy_config {
  DELETE FROM new_client_message;
}

do_execsql_test 2.4 {
  SELECT count(y) FROM x1
} {1000}

wait_ms 10

db close
$cmd destroy

finish_test