Debian Codegraph @

ext/session/sessionsize.test

raw
1 # 2021 April 22
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
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.
9 #
10 #***********************************************************************
11 # This file implements regression tests for SQLite library.
12 #
13
14 if {![info exists testdir]} {
15 set testdir [file join [file dirname [info script]] .. .. test]
16 }
17 source [file join [file dirname [info script]] session_common.tcl]
18 source $testdir/tester.tcl
19 ifcapable !session {finish_test; return}
20
21 set testprefix sessionsize
22
23 proc do_changeset_size_test {tn sql} {
24 sqlite3session S db main
25 S attach *
26 db eval $sql
27
28 set sz [S changeset_size]
29 set C [S changeset]
30 set szC [string length $C]
31 S delete
32
33 do_test $tn "expr $sz" $szC
34 }
35
36 do_execsql_test 1.0 {
37 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
38 INSERT INTO t1 VALUES(1, 'abc', 'def');
39 INSERT INTO t1 VALUES(2, 'ghi', 'jkl');
40 }
41
42 do_changeset_size_test 1.1 {
43 INSERT INTO t1 VALUES(3, 'hello', 'world');
44 }
45
46 do_changeset_size_test 1.2 {
47 DELETE FROM t1 WHERE a=2;
48 }
49
50 do_changeset_size_test 1.3 {
51 DELETE FROM t1 WHERE a=3;
52 INSERT INTO t1 VALUES(3, 1, 2);
53 }
54
55 do_changeset_size_test 1.4 {
56 UPDATE t1 SET c='hello world' WHERE a=3;
57 }
58
59 #-------------------------------------------------------------------------
60
61 do_execsql_test 2.0 {
62 CREATE TABlE t2(a, b, c, d, PRIMARY KEY(a, b)) WITHOUT ROWID;
63 CREATE TABlE t3(a, b, c, d PRIMARY KEY);
64 }
65
66 do_changeset_size_test 2.1 {
67 WITH s(i) AS (
68 SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<50
69 )
70 INSERT INTO t2 SELECT i, i+1, i+2, i+3 FROM s;
71
72 UPDATE t2 SET c=randomblob(a) WHERE a>10
73 }
74
75 do_changeset_size_test 2.2 {
76 DELETE FROM t2 WHERE a=1;
77 INSERT INTO t2 VALUES(1, 4, 3, 4);
78 }
79
80 do_changeset_size_test 2.2 {
81 UPDATE t2 SET b=4 WHERE a=2
82 }
83
84 do_changeset_size_test 2.3 {
85 INSERT INTO t2 VALUES('a', 'b', 'c', 'd');
86 UPDATE t2 SET c='qwertyuiop' WHERE a='a';
87 }
88
89 do_changeset_size_test 2.4 {
90 DELETE FROM t2 WHERE a='a';
91 INSERT INTO t2 VALUES('a', 'b', 'c', 'd');
92 }
93
94 do_changeset_size_test 2.5 {
95 UPDATE t2 SET a='aa', b='bb' WHERE (a, b) = ('a', 'b');
96 }
97
98 do_changeset_size_test 2.6 {
99 UPDATE t2 SET a='a', b='b' WHERE (a, b) = ('aa', 'bb');
100 }
101
102 do_changeset_size_test 2.7 {
103 INSERT INTO t3 DEFAULT VALUES;
104 INSERT INTO t3 VALUES(1,2,3,4);
105 }
106
107 #-------------------------------------------------------------------------
108 reset_db
109
110 do_execsql_test 3.0 {
111 CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
112 }
113
114 do_test 3.1 {
115 sqlite3session S db main
116 S object_config size -1
117 } 1
118
119 do_test 3.2.1 { S object_config size 0 } 0
120 do_test 3.2.2 { S object_config size -1 } 0
121 do_test 3.2.3 { S object_config size 1 } 1
122 do_test 3.2.4 { S object_config size -1 } 1
123
124 do_test 3.3 { S attach t1 } {}
125 do_test 3.4 { S object_config size 1 } {SQLITE_MISUSE}
126 do_test 3.4 { S object_config size -1 } {1}
127
128 S delete
129
130 finish_test
131