Debian Codegraph @

mysql-test/suite/x/t/crud_update_doc.test

raw
1 ## Test document updates
2
3 --source include/xplugin_preamble.inc
4 --source include/xplugin_create_user.inc
5
6 ## Test starts here
7 --let $xtest_file= $MYSQL_TMP_DIR/update_doc.xpl
8 --write_file $xtest_file
9 -->quiet
10
11 -->varlet %LITERAL% type: LITERAL literal
12 -->varlet %V_OCTETS% type: V_OCTETS v_octets
13
14 -->macro Insert %SCHEMA% %NAME% %ROW%
15 Mysqlx.Crud.Insert {
16 data_model: DOCUMENT
17 collection { name: '%NAME%' schema: '%SCHEMA%'}
18 row { field { %LITERAL% { %V_OCTETS% { value:'%ROW%' } } } }
19 }
20 -->recvresult be-quiet
21 -->endmacro
22
23 -->macro Setup %SCHEMA% %NAME% %ROW%
24 -->stmtadmin ensure_collection {"schema":"%SCHEMA%", "name":"%NAME%"}
25 -->recvresult be-quiet
26 -->stmtsql TRUNCATE `%SCHEMA%`.`%NAME%`
27 -->recvresult be-quiet
28 -->callmacro Insert %SCHEMA% %NAME% %ROW%
29 -->endmacro
30
31
32 -->macro Show %SCHEMA% %NAME%
33 Mysqlx.Crud.Find {
34 collection { name: "%NAME%" schema: "%SCHEMA%" }
35 data_model: DOCUMENT
36 }
37 -->recvresult
38 -->endmacro
39
40 -->macro Assert %SCHEMA% %NAME% %EXPECT%
41 Mysqlx.Crud.Find {
42 collection { name: "%NAME%" schema: "%SCHEMA%" }
43 data_model: DOCUMENT
44 }
45 -->recvtovar %RESULT% doc
46 -->varlet %QUOTED% %EXPECT%
47 -->assert_eq %QUOTED% %RESULT%
48 -->endmacro
49
50
51 -->macro Update_base %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% %OPERATIONS% %ERROR%
52 Mysqlx.Crud.Update {
53 collection { schema: '%SCHEMA%' name: '%NAME%' }
54 data_model: DOCUMENT
55 criteria {
56 type: OPERATOR operator {
57 name: '%CRITERIA%'
58 param { type: IDENT identifier { name: '_id' } }
59 param { %LITERAL% { %V_OCTETS% { value: '%CRITERIA_VALUE%' } } }
60 }
61 }
62 %OPERATIONS%
63 }
64 -->expecterror %ERROR%
65 -->recvresult
66 -->endmacro
67
68
69 -->macro Update %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% %OPERATION% %TARGET% %VALUE% %ERROR%
70 -->callmacro Update_base %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% operation{operation:%OPERATION% source{%TARGET%} value{%VALUE%}} %ERROR%
71 -->endmacro
72
73 -->macro Update_two %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% %OPERATION1% %TARGET1% %VALUE1% %OPERATION2% %TARGET2% %VALUE2% %ERROR%
74 -->callmacro Update_base %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% operation{operation:%OPERATION1% source{%TARGET1%} value{%VALUE1%}} operation{operation:%OPERATION2% source{%TARGET2%} value{%VALUE2%}} %ERROR%
75 -->endmacro
76
77 -->macro Update_no_value %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% %OPERATION% %TARGET% %ERROR%
78 -->callmacro Update_base %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% operation{operation:%OPERATION% source{%TARGET%}} %ERROR%
79 -->endmacro
80
81 -->macro Update_two_no_value %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% %OPERATION1% %TARGET1% %VALUE1% %OPERATION2% %TARGET2% %ERROR%
82 -->callmacro Update_base %SCHEMA% %NAME% %CRITERIA% %CRITERIA_VALUE% operation{operation:%OPERATION1% source{%TARGET1%} value{%VALUE1%}} operation{operation:%OPERATION2% source{%TARGET2%}} %ERROR%
83 -->endmacro
84
85 -->varlet %MEMBER_NAME% document_path { type: MEMBER value: 'name' }
86 -->varlet %LEMON% %LITERAL% { %V_OCTETS% { value: 'lemon' } }
87
88 -->title =Update by ARRAY_APPEND
89 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
90 -->callmacro Update xtest coll == 1 ARRAY_APPEND %MEMBER_NAME% %LEMON% ER_SUCCESS
91 -->callmacro Assert xtest coll {"_id": "1", "name": ["banana", "lemon"], "price": 1.2}
92
93
94 -->varlet %MEMBER_ORIGIN% document_path { type: MEMBER value: 'origin' }
95 -->varlet %MEMBER_ORIGIN_1% %MEMBER_ORIGIN% document_path { type: ARRAY_INDEX index: 1 }
96 -->varlet %BRAZIL% %LITERAL% { %V_OCTETS% { value: 'brazil' } }
97
98 -->title =Update by ARRAY_INSERT
99 -->callmacro Setup xtest coll {"_id": "5", "name": "mango", "price": 0.90, "origin":["mexico", "philippines"]}
100 -->callmacro Update xtest coll == 5 ARRAY_INSERT %MEMBER_ORIGIN_1% %BRAZIL% ER_SUCCESS
101 -->callmacro Assert xtest coll {"_id": "5", "name": "mango", "price": 0.9, "origin": ["mexico", "brazil", "philippines"]}
102
103
104 -->title =Update by ARRAY_INSERT (invalid path)
105 -->callmacro Setup xtest coll {"_id": "5", "name": "mango", "price": 0.90, "origin":["mexico", "philippines"]}
106 -->callmacro Update xtest coll == 5 ARRAY_INSERT %MEMBER_ORIGIN% %BRAZIL% ER_INVALID_JSON_PATH_ARRAY_CELL
107 -->callmacro Assert xtest coll {"_id": "5", "name": "mango", "price": 0.9, "origin": ["mexico", "philippines"]}
108
109
110 -->title =Update by ITEM_REPLACE
111 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
112 -->callmacro Update xtest coll == 1 ITEM_REPLACE %MEMBER_NAME% %LEMON% ER_SUCCESS
113 -->callmacro Assert xtest coll {"_id": "1", "name": "lemon", "price": 1.2}
114
115
116 -->varlet %MEMBER_LOCATION% document_path { type: MEMBER value: 'location' }
117 -->varlet %PINEAPPLE% %LITERAL% { %V_OCTETS% { value: 'pineapple' } }
118
119 -->title =Update by ITEM_REPLACE non-existing member
120 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
121 -->callmacro Update xtest coll == 1 ITEM_REPLACE %MEMBER_LOCATION% %PINEAPPLE% ER_SUCCESS
122 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
123
124
125 -->varlet %NULL% %LITERAL% { type: V_NULL }
126
127 -->title =ITEM_SET to NULL
128 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
129 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_NAME% %NULL% ER_SUCCESS
130 -->callmacro Assert xtest coll {"_id": "1", "name": null, "price": 1.2}
131
132
133 -->varlet %MEMBER_PRICE% document_path { type: MEMBER value: 'price' }
134 -->varlet %LEMON_FOR_FREE% %LITERAL% { %V_OCTETS% { value: 'lemon for free!' } }
135
136 -->title =Update by ITEM_SET twice
137 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
138 -->callmacro Update_two xtest coll == 1 ITEM_SET %MEMBER_NAME% %LEMON% ITEM_SET %MEMBER_PRICE% %LEMON_FOR_FREE% ER_SUCCESS
139 -->callmacro Assert xtest coll {"_id": "1", "name": "lemon", "price": "lemon for free!"}
140
141
142 -->title =Update by ITEM_SET non-existing member
143 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
144 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_LOCATION% %LEMON% ER_SUCCESS
145 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2, "location": "lemon"}
146
147
148 -->title =Update a valid document by _id (from field)
149 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
150 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_NAME% %LEMON% ER_SUCCESS
151 -->callmacro Assert xtest coll {"_id": "1", "name": "lemon", "price": 1.2}
152
153
154 -->varlet %MEMBER_ID% document_path { type: MEMBER value: '_id' }
155
156 -->title =Update document with illegal _id change
157 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
158 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_ID% %LEMON% ER_X_BAD_MEMBER_TO_UPDATE
159 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
160
161
162 -->title =Update non-existing document
163 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
164 -->callmacro Update xtest coll == 666 ITEM_SET %MEMBER_NAME% %LEMON% ER_SUCCESS
165 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
166
167
168 -->title =Update multiple documents
169 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
170 -->callmacro Insert xtest coll {"_id": "2", "name": "apple", "price": 0.25}
171 -->callmacro Insert xtest coll {"_id": "3", "name": "tomato", "price": 1.80}
172 -->callmacro Insert xtest coll {"_id": "4", "name": "mango", "price": 3.14}
173 -->callmacro Insert xtest coll {"_id": "5", "name": "mango", "price": 0.90, "origin":["mexico","philippines"]}
174 -->callmacro Show xtest coll
175 -->callmacro Update xtest coll < 5 ITEM_SET %MEMBER_NAME% %LEMON% ER_SUCCESS
176 -->callmacro Show xtest coll
177
178
179 -->title =Update on an invalid schema (bad)
180 -->stmtsql CREATE SCHEMA ytest
181 -->recvresult
182 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
183 -->callmacro Update ytest coll == 1 ITEM_SET %MEMBER_NAME% %LEMON% ER_NO_SUCH_TABLE
184 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
185 -->stmtsql DROP SCHEMA IF EXISTS ytest
186 -->recvresult
187
188
189 -->title =Update on an invalid collection (bad)
190 -->callmacro Update xtest no_coll == 1 ITEM_SET %MEMBER_NAME% %LEMON% ER_NO_SUCH_TABLE
191
192
193 -->varlet %MEMBER_NAME_COLUMN% %MEMBER_NAME% name:'xfield'
194
195 -->title =Update member with column (bad)
196 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
197 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_NAME_COLUMN% %LEMON% ER_X_BAD_COLUMN_TO_UPDATE
198 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
199
200
201 -->varlet %MEMBER_NAME_TABLE% %MEMBER_NAME% table_name: 'xtable'
202
203 -->title =Update member with table name (bad)
204 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
205 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_NAME_TABLE% %LEMON% ER_X_BAD_COLUMN_TO_UPDATE
206 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
207
208
209 -->varlet %MEMBER_NAME_SCHEMA% %MEMBER_NAME% schema_name: 'xschema'
210
211 -->title =Update member with schema name (bad)
212 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
213 -->callmacro Update xtest coll == 1 ITEM_SET %MEMBER_NAME_SCHEMA% %LEMON% ER_X_BAD_COLUMN_TO_UPDATE
214 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
215
216
217 -->title =Update by SET (not allowed)
218 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
219 -->callmacro Update xtest coll == 1 SET %MEMBER_NAME% %LEMON% ER_X_BAD_TYPE_OF_UPDATE
220 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
221
222
223 -->title =Update by ITEM_REMOVE
224 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
225 -->callmacro Update_no_value xtest coll == 1 ITEM_REMOVE %MEMBER_NAME% ER_SUCCESS
226 -->callmacro Assert xtest coll {"_id": "1", "price": 1.2}
227
228
229 -->title =Multiple chained operations
230 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
231 -->callmacro Update_two_no_value xtest coll == 1 ITEM_SET %MEMBER_NAME% %LEMON% ITEM_REMOVE %MEMBER_PRICE% ER_SUCCESS
232 -->callmacro Assert xtest coll {"_id": "1", "name": "lemon"}
233
234
235 -->varlet %ROOT_EMPTY%
236 -->varlet %DOC_WITHOUT_ID% %LITERAL% { %V_OCTETS% { value: '{"one":1, "two":"foo"}' content_type: 2 } }
237
238 -->title =Merge with another document
239 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
240 -->callmacro Update xtest coll == 1 ITEM_MERGE %ROOT_EMPTY% %DOC_WITHOUT_ID% ER_SUCCESS
241 -->callmacro Assert xtest coll {"_id": "1", "one": 1, "two": "foo", "name": "banana", "price": 1.2}
242
243
244 -->varlet %DOC_WITH_ID% %LITERAL% { %V_OCTETS% { value: '{"three":3, "four":"bar", "_id":"666"}' content_type: 2 } }
245
246 -->title =Merge with another document containing _id
247 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
248 -->callmacro Update xtest coll == 1 ITEM_MERGE %ROOT_EMPTY% %DOC_WITH_ID% ER_SUCCESS
249 -->callmacro Assert xtest coll {"_id": "1", "four": "bar", "name": "banana", "price": 1.2, "three": 3}
250
251
252 -->varlet %ROOT_MEMBER% document_path { type: MEMBER }
253
254 -->title =Merge with another document containing _id (differ root)
255 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
256 -->callmacro Update xtest coll == 1 ITEM_MERGE %ROOT_MEMBER% %DOC_WITH_ID% ER_SUCCESS
257 -->callmacro Assert xtest coll {"_id": "1", "four": "bar", "name": "banana", "price": 1.2, "three": 3}
258
259
260 -->title =Set item and merge with another document
261 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
262 -->callmacro Update_two xtest coll == 1 ITEM_SET %MEMBER_NAME% %LEMON% ITEM_MERGE %ROOT_MEMBER% %DOC_WITHOUT_ID% ER_SUCCESS
263 -->callmacro Assert xtest coll {"_id": "1", "one": 1, "two": "foo", "name": "lemon", "price": 1.2}
264
265
266 -->title =Merge with another document and set item
267 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
268 -->callmacro Update_two xtest coll == 1 ITEM_MERGE %ROOT_MEMBER% %DOC_WITHOUT_ID% ITEM_SET %MEMBER_NAME% %LEMON% ER_SUCCESS
269 -->callmacro Assert xtest coll {"_id": "1", "one": 1, "two": "foo", "name": "lemon", "price": 1.2}
270
271
272 -->title =Merge with NULL
273 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
274 -->callmacro Update xtest coll == 1 ITEM_MERGE %ROOT_MEMBER% %NULL% ER_X_DOC_ID_MISSING
275 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
276
277
278 -->varlet %ARRAY% %LITERAL% { %V_OCTETS% { value: '[1,2,3]' } }
279
280 -->title =Merge with non-document
281 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
282 -->callmacro Update xtest coll == 1 ITEM_MERGE %ROOT_MEMBER% %ARRAY% ER_X_DOC_ID_MISSING
283 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
284
285
286 -->title =Merge with two documents
287 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
288 -->callmacro Show xtest coll
289 -->callmacro Update_two xtest coll == 1 ITEM_MERGE %ROOT_EMPTY% %DOC_WITH_ID% ITEM_MERGE %ROOT_EMPTY% %DOC_WITHOUT_ID% ER_SUCCESS
290 -->callmacro Assert xtest coll {"_id": "1", "one": 1, "two": "foo", "four": "bar", "name": "banana", "price": 1.2, "three": 3}
291
292
293 -->title =Merge with numeric literal
294 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
295 -->callmacro Update xtest coll == 1 ITEM_MERGE %ROOT_EMPTY% %LEMON% ER_X_BAD_UPDATE_DATA
296 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
297
298
299 -->title =Replace entire document (by empty source)
300 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
301 -->callmacro Update xtest coll == 1 ITEM_REPLACE %ROOT_EMPTY% %DOC_WITH_ID% ER_SUCCESS
302 -->callmacro Assert xtest coll {"_id": "1", "four": "bar", "three": 3}
303
304
305 -->title =Replace entire document (by member)
306 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
307 -->callmacro Update xtest coll == 1 ITEM_REPLACE %ROOT_MEMBER% %DOC_WITH_ID% ER_SUCCESS
308 -->callmacro Assert xtest coll {"_id": "1", "four": "bar", "three": 3}
309
310
311 -->title =Replace entire document, no _id (by member)
312 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
313 -->callmacro Update xtest coll == 1 ITEM_REPLACE %ROOT_MEMBER% %DOC_WITHOUT_ID% ER_SUCCESS
314 -->callmacro Assert xtest coll {"_id": "1", "one": 1, "two": "foo"}
315
316
317 -->title =Replace entire document by NULL
318 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
319 -->callmacro Update xtest coll == 1 ITEM_REPLACE %ROOT_MEMBER% %NULL% ER_X_DOC_ID_MISSING
320 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
321
322
323 -->title =Set entire document (by empty source)
324 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
325 -->callmacro Update xtest coll == 1 ITEM_SET %ROOT_EMPTY% %DOC_WITH_ID% ER_SUCCESS
326 -->callmacro Assert xtest coll {"_id": "1", "four": "bar", "three": 3}
327
328
329 -->title =Set entire document (by member)
330 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
331 -->callmacro Update xtest coll == 1 ITEM_SET %ROOT_MEMBER% %DOC_WITH_ID% ER_SUCCESS
332 -->callmacro Assert xtest coll {"_id": "1", "four": "bar", "three": 3}
333
334
335 -->title =Set entire document, no _id (by member)
336 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
337 -->callmacro Show xtest coll
338 -->callmacro Update xtest coll == 1 ITEM_SET %ROOT_MEMBER% %DOC_WITHOUT_ID% ER_SUCCESS
339 -->callmacro Assert xtest coll {"_id": "1", "one": 1, "two": "foo"}
340
341
342 -->title =Set entire document to NULL
343 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
344 -->callmacro Update xtest coll == 1 ITEM_SET %ROOT_MEMBER% %NULL% ER_X_DOC_ID_MISSING
345 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
346
347
348 -->title =Merge literal to member
349 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
350 -->callmacro Update xtest coll == 1 ITEM_MERGE %MEMBER_NAME% %LEMON% ER_X_BAD_UPDATE_DATA
351 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
352
353
354 -->title =Merge document to sub-document
355 -->callmacro Setup xtest coll {"_id": "1", "name": {"one": 3.4}, "price": 1.20}
356 -->callmacro Update xtest coll == 1 ITEM_MERGE %MEMBER_NAME% %DOC_WITHOUT_ID% ER_X_BAD_UPDATE_DATA
357 -->callmacro Assert xtest coll {"_id": "1", "name": {"one": 3.4}, "price": 1.2}
358
359
360 -->title =Merge document to member
361 -->callmacro Setup xtest coll {"_id": "1", "name": "banana", "price": 1.20}
362 -->callmacro Update xtest coll == 1 ITEM_MERGE %MEMBER_NAME% %DOC_WITHOUT_ID% ER_X_BAD_UPDATE_DATA
363 -->callmacro Assert xtest coll {"_id": "1", "name": "banana", "price": 1.2}
364
365
366 -->title =Merge document to member of array
367 -->callmacro Setup xtest coll {"_id": "2", "origin": ["mexico", {"philippines": true}]}
368 -->callmacro Update xtest coll == 2 ITEM_MERGE %MEMBER_ORIGIN_1% %DOC_WITHOUT_ID% ER_X_BAD_UPDATE_DATA
369 -->callmacro Assert xtest coll {"_id": "2", "origin": ["mexico", {"philippines": true}]}
370
371
372 EOF
373
374 CREATE SCHEMA xtest;
375
376 --exec $MYSQLXTEST -ux_root --password='' --file=$xtest_file 2>&1
377
378 ## Cleanup
379 --source ../include/xplugin_cleanup.inc