#
# 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