diff options
| author | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
|---|---|---|
| committer | bernard <[email protected]> | 2017-11-02 13:50:42 +0800 |
| commit | b2057f506a09e2adef81fc77efd697d16ae14bec (patch) | |
| tree | 3affefabfe376a0ec1b3ac4a5eef957c1dd58dc8 /components/external/SQLite-3.8.1/test/dbstatus2.test | |
| parent | 23582c8129228b4961ad35319cfd2d270039345f (diff) | |
[External] Remove external from RT-Thread
Diffstat (limited to 'components/external/SQLite-3.8.1/test/dbstatus2.test')
| -rw-r--r-- | components/external/SQLite-3.8.1/test/dbstatus2.test | 102 |
1 files changed, 0 insertions, 102 deletions
diff --git a/components/external/SQLite-3.8.1/test/dbstatus2.test b/components/external/SQLite-3.8.1/test/dbstatus2.test deleted file mode 100644 index 2541a1a823..0000000000 --- a/components/external/SQLite-3.8.1/test/dbstatus2.test +++ /dev/null @@ -1,102 +0,0 @@ -# 2011 September 20 -# -# The author disclaims copyright to this source code. In place of -# a legal notice, here is a blessing: -# -# May you do good and not evil. -# May you find forgiveness for yourself and forgive others. -# May you share freely, never taking more than you give. -# -#*********************************************************************** -# -# Tests for the sqlite3_db_status() function -# - -set testdir [file dirname $argv0] -source $testdir/tester.tcl - -set ::testprefix dbstatus2 - -do_execsql_test 1.0 { - PRAGMA page_size = 1024; - PRAGMA auto_vacuum = 0; - - CREATE TABLE t1(a PRIMARY KEY, b); - INSERT INTO t1 VALUES(1, randomblob(600)); - INSERT INTO t1 VALUES(2, randomblob(600)); - INSERT INTO t1 VALUES(3, randomblob(600)); -} - -proc db_hit_miss {db {reset 0}} { - set nHit [sqlite3_db_status $db CACHE_HIT $reset] - set nMiss [sqlite3_db_status $db CACHE_MISS $reset] - list $nHit $nMiss -} - -proc db_write {db {reset 0}} { - sqlite3_db_status $db CACHE_WRITE $reset -} - -do_test 1.1 { - db close - sqlite3 db test.db - execsql { PRAGMA mmap_size = 0 } - expr {[file size test.db] / 1024} -} 6 - -do_test 1.2 { - execsql { SELECT b FROM t1 WHERE a=2 } - db_hit_miss db -} {{0 2 0} {0 4 0}} - -do_test 1.3 { - execsql { SELECT b FROM t1 WHERE a=2 } - db_hit_miss db -} {{0 6 0} {0 4 0}} - -do_test 1.4 { - execsql { SELECT b FROM t1 WHERE a=2 } - db_hit_miss db -} {{0 10 0} {0 4 0}} - -do_test 1.5 { - db_hit_miss db 1 -} {{0 10 0} {0 4 0}} - -do_test 1.6 { - db_hit_miss db 0 -} {{0 0 0} {0 0 0}} - -do_test 1.7 { - set fd [db incrblob main t1 b 1] - fconfigure $fd -translation binary - set len [string length [read $fd]] - close $fd - set len -} 600 -do_test 1.8 { sqlite3_db_status db CACHE_HIT 0 } {0 2 0} -do_test 1.9 { sqlite3_db_status db CACHE_MISS 0 } {0 1 0} - -do_test 2.1 { db_write db } {0 0 0} -do_test 2.2 { - execsql { INSERT INTO t1 VALUES(4, randomblob(600)) } - db_write db -} {0 4 0} -do_test 2.3 { db_write db 1 } {0 4 0} -do_test 2.4 { db_write db 0 } {0 0 0} -do_test 2.5 { db_write db 1 } {0 0 0} - -ifcapable wal { - do_test 2.6 { - execsql { PRAGMA journal_mode = WAL } - db_write db 1 - } {0 1 0} -} -do_test 2.7 { - execsql { INSERT INTO t1 VALUES(5, randomblob(600)) } - db_write db -} {0 4 0} -do_test 2.8 { db_write db 1 } {0 4 0} -do_test 2.9 { db_write db 0 } {0 0 0} - -finish_test |
