Debian Codegraph @

ext/session/sessionnoact.test

raw
1 # 2023 October 20
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 sessionnoact
22
23 do_execsql_test 1.0 {
24 CREATE TABLE p1(a INTEGER PRIMARY KEY, b, c UNIQUE);
25 INSERT INTO p1 VALUES(1, 1, 'one');
26 INSERT INTO p1 VALUES(2, 2, 'two');
27 INSERT INTO p1 VALUES(3, 3, 'three');
28 INSERT INTO p1 VALUES(4, 4, 'four');
29 }
30
31 db_save
32
33 set C [changeset_from_sql {
34 DELETE FROM p1 WHERE a=2;
35 UPDATE p1 SET c='six' WHERE a=3;
36 INSERT INTO p1 VALUES(5, 5, 'two');
37 INSERT INTO p1 VALUES(6, 6, 'three');
38 }]
39
40 db_restore_and_reopen
41
42 do_execsql_test 1.1 {
43 CREATE TABLE c1(x INTEGER PRIMARY KEY, y,
44 FOREIGN KEY(y) REFERENCES p1(c) ON DELETE CASCADE ON UPDATE SET NULL
45 );
46
47 INSERT INTO c1 VALUES(10, 'one');
48 INSERT INTO c1 VALUES(20, 'two');
49 INSERT INTO c1 VALUES(30, 'three');
50 INSERT INTO c1 VALUES(40, 'four');
51 }
52
53 db_save
54
55 do_execsql_test 1.2 {
56 PRAGMA foreign_keys = 1;
57 }
58
59 set ::nConflict 0
60 proc conflict {args} {
61 incr ::nConflict
62 return "ABORT"
63 }
64
65 sqlite3changeset_apply_v2 db $C conflict
66
67 do_execsql_test 1.3 {
68 SELECT * FROM c1
69 } {
70 10 one
71 30 {}
72 40 four
73 }
74
75 db_restore_and_reopen
76
77 do_execsql_test 1.4 {
78 PRAGMA foreign_keys = 1;
79 }
80
81 do_execsql_test 1.5 {
82 UPDATE p1 SET c=12345 WHERE a = 45;
83 }
84
85 sqlite3changeset_apply_v2 -noaction db $C conflict
86 do_execsql_test 1.6 {
87 SELECT * FROM c1
88 } {
89 10 one
90 20 two
91 30 three
92 40 four
93 }
94
95 do_execsql_test 1.7 {
96 PRAGMA foreign_keys = 1;
97 UPDATE p1 SET c = 'ten' WHERE c='two';
98 SELECT * FROM c1;
99 } {
100 10 one
101 20 {}
102 30 three
103 40 four
104 }
105
106 do_execsql_test 1.8 {
107 PRAGMA foreign_key_check
108 }
109
110 #-------------------------------------------------------------------------
111 # Check that a changeset that causes an FK violation may not be applied,
112 # even if SQLITE_CHANGESETAPPLY_FKNOACTION is specified.
113 #
114 # UPDATE: Unless the conflict-handler returns OMIT. In that case it can
115 # be committed. See test cases 3.* in this file.
116 #
117 reset_db
118 do_execsql_test 2.0 {
119 CREATE TABLE p1(a INTEGER PRIMARY KEY, b, c UNIQUE);
120 INSERT INTO p1 VALUES(1, 1, 'one');
121 INSERT INTO p1 VALUES(2, 2, 'two');
122
123 CREATE TABLE c1(x REFERENCES p1(c) ON DELETE CASCADE);
124 INSERT INTO c1 VALUES('two');
125 }
126
127 db_save
128
129 set C [changeset_from_sql {
130 DELETE FROM p1 WHERE a=2;
131 }]
132
133 db_restore_and_reopen
134
135 do_test 2.1 {
136 sqlite3changeset_apply_v2 -noaction db $C conflict
137 } {}
138 do_execsql_test 2.2 {
139 SELECT * FROM p1
140 } {1 1 one}
141
142 db_restore_and_reopen
143 db eval { PRAGMA foreign_keys = 1 }
144
145 do_test 2.3 {
146 list [catch { sqlite3changeset_apply_v2 -noaction db $C conflict } msg] $msg
147 } {1 SQLITE_CONSTRAINT}
148 do_execsql_test 2.4 {
149 SELECT * FROM p1;
150 } {1 1 one 2 2 two}
151 do_execsql_test 2.5 {
152 SELECT * FROM c1;
153 } {two}
154
155 db_restore_and_reopen
156 db eval { PRAGMA foreign_keys = 1 }
157
158 do_test 2.6 {
159 list [catch {
160 sqlite3changeset_apply_v2 -ignorenoop -noaction db $C conflict
161 } msg] $msg
162 } {1 SQLITE_CONSTRAINT}
163 do_execsql_test 2.7 {
164 SELECT * FROM p1;
165 } {1 1 one 2 2 two}
166 do_execsql_test 2.8 {
167 SELECT * FROM c1;
168 } {two}
169
170 #-------------------------------------------------------------------------
171 #
172 reset_db
173 do_execsql_test 3.0 {
174 CREATE TABLE p1(a INTEGER PRIMARY KEY, b, c UNIQUE);
175 INSERT INTO p1 VALUES(1, 1, 'one');
176 INSERT INTO p1 VALUES(2, 2, 'two');
177
178 CREATE TABLE c1(x REFERENCES p1(c) ON DELETE CASCADE);
179 INSERT INTO c1 VALUES('two');
180 }
181
182 set ::nConflict 0
183 proc conflict {args} {
184 incr ::nConflict
185 return "OMIT"
186 }
187
188 db_save
189
190 set C [changeset_from_sql {
191 DELETE FROM p1 WHERE a=2;
192 }]
193
194 db_restore_and_reopen
195
196 do_test 3.1 {
197 sqlite3changeset_apply_v2 -noaction db $C conflict
198 } {}
199 do_execsql_test 3.2 {
200 SELECT * FROM p1
201 } {1 1 one}
202
203 db_restore_and_reopen
204 db eval { PRAGMA foreign_keys = 1 }
205
206 do_test 3.3 {
207 list [catch { sqlite3changeset_apply_v2 -noaction db $C conflict } msg] $msg
208 } {0 {}}
209 do_execsql_test 3.4 {
210 SELECT * FROM p1;
211 } {1 1 one}
212 do_execsql_test 3.5 {
213 SELECT * FROM c1;
214 } {two}
215
216 db_restore_and_reopen
217 db eval { PRAGMA foreign_keys = 1 }
218
219 do_test 3.6 {
220 list [catch {
221 sqlite3changeset_apply_v2 -ignorenoop -noaction db $C conflict
222 } msg] $msg
223 } {0 {}}
224 do_execsql_test 3.7 {
225 SELECT * FROM p1;
226 } {1 1 one}
227 do_execsql_test 3.8 {
228 SELECT * FROM c1;
229 } {two}
230
231 #-------------------------------------------------------------------------
232 reset_db
233
234 do_execsql_test 4.0 {
235 CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c INTEGER);
236 ATTACH ':memory:' AS aux;
237 CREATE TABLE aux.t1(a INTEGER PRIMARY KEY, b TEXT, c INTEGER);
238 }
239
240 do_test 4.1 {
241 sqlite3session S db main
242 S diff aux t1
243 } {}
244
245 do_test 4.2 {
246 sqlite3changeset_apply_v2 -ignorenoop -noaction db "" conflict
247 } {}
248
249 breakpoint
250 do_test 4.3 {
251 S diff aux t1
252 } {}
253
254 S delete
255
256 finish_test
257