x/t/crud_update_doc.test

28 -->callmacro Insert	%SCHEMA%	%NAME%	%ROW%
70 -->callmacro Update_base	%SCHEMA%	%NAME%	%CRITERIA%	%CRITERIA_VALUE%	operation{operation:%OPERATION…
74 -->callmacro Update_base	%SCHEMA%	%NAME%	%CRITERIA%	%CRITERIA_VALUE%	operation{operation:%OPERATION…
78 -->callmacro Update_base	%SCHEMA%	%NAME%	%CRITERIA%	%CRITERIA_VALUE%	operation{operation:%OPERATION…
82 -->callmacro Update_base	%SCHEMA%	%NAME%	%CRITERIA%	%CRITERIA_VALUE%	operation{operation:%OPERATION…
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}
99 -->callmacro Setup	xtest	coll	{"_id": "5", "name": "mango", "price": 0.90, "origin":["mexico", "phi…
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", "br…
105 -->callmacro Setup	xtest	coll	{"_id": "5", "name": "mango", "price": 0.90, "origin":["mexico", "phi…
106 -->callmacro Update	xtest	coll	==	5	ARRAY_INSERT	%MEMBER_ORIGIN%	%BRAZIL%	ER_INVALID_JSON_PATH_ARRA…
107 -->callmacro Assert	xtest	coll	{"_id": "5", "name": "mango", "price": 0.9, "origin": ["mexico", "ph…
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}
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}
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}
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%	%LEM…
139 -->callmacro Assert	xtest	coll	{"_id": "1", "name": "lemon", "price": "lemon for free!"}
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"}
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}
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}
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}
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","phi…
174 -->callmacro Show	xtest	coll
175 -->callmacro Update	xtest	coll	<	5	ITEM_SET	%MEMBER_NAME%	%LEMON%	ER_SUCCESS
176 -->callmacro Show	xtest	coll
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}
190 -->callmacro Update	xtest	no_coll	==	1	ITEM_SET	%MEMBER_NAME%	%LEMON%	ER_NO_SUCH_TABLE
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}
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}
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}
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}
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}
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…
232 -->callmacro Assert	xtest	coll	{"_id": "1", "name": "lemon"}
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}
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":…
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":…
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%	%DO…
263 -->callmacro Assert	xtest	coll	{"_id": "1", "one": 1, "two": "foo", "name": "lemon", "price": 1.2}
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_…
269 -->callmacro Assert	xtest	coll	{"_id": "1", "one": 1, "two": "foo", "name": "lemon", "price": 1.2}
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}
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}
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_EMPT…
290 -->callmacro Assert	xtest	coll	{"_id": "1", "one": 1, "two": "foo", "four": "bar", "name": "banana"…
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}
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}
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}
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"}
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}
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}
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}
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"}
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}
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}
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}
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}
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_D…
369 -->callmacro Assert	xtest	coll	{"_id": "2", "origin": ["mexico", {"philippines": true}]}