3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
10 #***********************************************************************
11 # This file implements regression tests for SQLite library. The
12 # focus of this script is btree database backend - specifically
13 # the B+tree tables. B+trees store all data on the leaves rather
14 # that storing data with keys on interior nodes.
16 # $Id: btree6.test,v 1.4 2004/05/20 22:16:31 drh Exp $
19 set testdir [file dirname $argv0]
20 source $testdir/tester.tcl
23 # Insert many entries into the table that cursor $cur points to.
24 # The table should be an INTKEY table.
26 # Stagger the inserts. After the inserts complete, go back and do
27 # deletes. Stagger the deletes too. Repeat this several times.
30 # Do N inserts into table $tab using random keys between 0 and 1000000
32 proc random_inserts {cur N} {
35 set k [expr {int(rand()*1000000)}]
36 if {[btree_move_to $cur $k]==0} {
37 continue; # entry already exists
40 btree_insert $cur $k data-for-$k
46 # Do N delete from the table that $cur points to.
48 proc random_deletes {cur N} {
50 set k [expr {int(rand()*1000000)}]
57 # Make sure the table that $cur points to has exactly N entries.
58 # Make sure the data for each entry agrees with its key.
60 proc check_table {cur N} {
63 while {![btree_eof $cur]} {
64 if {[set data [btree_data $cur]] ne "data-for-[btree_key $cur]"} {
65 return "wrong data for entry $cnt"
67 set n [string length $data]
68 set fdata1 [btree_fetch_data $cur $n]
69 set fdata2 [btree_fetch_data $cur -1]
70 if {$fdata1 ne "" && $fdata1 ne $data} {
71 return "DataFetch returned the wrong value with amt=$n"
73 if {$fdata1 ne $fdata2} {
74 return "DataFetch returned the wrong value when amt=-1"
77 set fdata3 [btree_fetch_data $cur 10]
78 if {$fdata3 ne [string range $data 0 9]} {
79 return "DataFetch returned the wrong value when amt=10"
86 return "wrong number of entries. Got $cnt. Looking for $N"
91 # Initialize the database
93 file delete -force test1.bt
94 file delete -force test1.bt-journal
95 set b1 [btree_open test1.bt 2000 0]
96 btree_begin_transaction $b1
97 set tab [btree_create_table $b1 5]
98 set cur [btree_cursor $b1 $tab 1]
105 for {set i 1} {$i<=40} {incr i} {
106 do_test btree6-1.$i.1 {
107 random_inserts $cur 200
109 check_table $cur $cnt
111 do_test btree6-1.$i.2 {
112 btree_integrity_check $b1 1 $tab
114 do_test btree6-1.$i.3 {
115 random_deletes $cur 90
117 check_table $cur $cnt
119 do_test btree6-1.$i.4 {
120 btree_integrity_check $b1 1 $tab
124 btree_close_cursor $cur