Debian Codegraph @

mysql-test/suite/x/t/macros/validation_schema.macro

raw
1 #
2 # Macros specific for tests with schema validation.
3 #
4
5 -->macro Execute_admin_cmd_with_validation %CMD% %COLLECTION% %VALIDATION_SCHEMA% %LEVEL%
6 Mysqlx.Sql.StmtExecute {
7 stmt: "%CMD%"
8 args {
9 type: OBJECT obj {
10 fld {
11 key:'schema'
12 value{type:SCALAR scalar{type:V_STRING v_string{value:'xtest'}}}
13 }
14 fld {
15 key:'name'
16 value{type:SCALAR scalar{type:V_STRING v_string{value:'%COLLECTION%'}}}
17 }
18 fld {
19 key:'options'
20 value{
21 type:OBJECT
22 obj {
23 fld {
24 key:'validation'
25 value{
26 type:OBJECT
27 obj{
28 fld {
29 key:'schema'
30 value{%VALIDATION_SCHEMA%}
31 }
32 fld {
33 key:'level'
34 value{type:SCALAR scalar{type:V_STRING v_string{value:%LEVEL%}}}
35 }
36 }
37 }
38 }
39 }
40 }
41 }
42 }
43 }
44 namespace: "mysqlx"
45 }
46 -->endmacro
47
48 -->macro Assert_is_enforced %COLUMN_NAME% %RESULT%
49 stmtsql SELECT enforced FROM information_schema.table_constraints WHERE
50 constraint_schema = "xtest" AND table_name ='%COLUMN_NAME%' AND
51 constraint_name LIKE '$val_strict_%';
52 -->recvtovar %IS_ENFORCED%
53 -->assert_eq %IS_ENFORCED% %RESULT%
54 -->endmacro
55
56 -->macro Show_validation_schema
57 stmtsql SELECT generation_expression FROM information_schema.columns WHERE
58 table_schema = "xtest" AND column_name ='_json_schema';
59 -->recvresult
60 -->endmacro
61
62 -->macro Insert_value_to_collection %COLLECTION% %VALUE%
63 Mysqlx.Crud.Insert {
64 collection {
65 name: "%COLLECTION%"
66 schema: "xtest"
67 }
68 data_model: DOCUMENT
69 row {
70 field {
71 type: LITERAL
72 literal {
73 type: V_STRING
74 v_string {
75 value: %VALUE%
76 }
77 }
78 }
79 }
80 }
81 -->endmacro
82
83 -->macro Create_coll_with_validation %NAME% %VALIDATION% %LEVEL%
84 stmtadmin create_collection {"schema": "xtest", "name": "%NAME%", "options": {
85 "validation": {
86 "schema": %VALIDATION%, "level": "%LEVEL%"
87 }
88 }};
89 -->recvresult
90 -->endmacro
91
92 -->macro Modify_schema %NAME% %SCHEMA%
93 stmtadmin modify_collection_options {"schema": "xtest", "name": "%NAME%", "options": {
94 "validation": {
95 "schema": %SCHEMA%
96 }
97 }};
98 -->endmacro
99
100 -->macro Modify_level %NAME% %LEVEL%
101 stmtadmin modify_collection_options {"schema": "xtest", "name": "%NAME%", "options": {
102 "validation": {
103 "level": "%LEVEL%"
104 }
105 }};
106 -->endmacro
107
108 -->macro Update_item %COLLECTION_NAME% %ITEM_NAME% %OLD_VALUE% %NEW_VALUE%
109 Mysqlx.Crud.Update {
110 collection { name: "%COLLECTION_NAME%" schema: "xtest"}
111 data_model: DOCUMENT
112 criteria {
113 type: OPERATOR
114 operator {
115 name: "=="
116 param {
117 type: IDENT
118 identifier {
119 document_path {
120 type: MEMBER
121 value: "%ITEM_NAME%"
122 }
123 }
124 }
125 param {
126 type: LITERAL
127 literal %OLD_VALUE%
128 }
129 }
130 }
131 operation {
132 source {
133 document_path {type: MEMBER value: '%ITEM_NAME%'}
134 }
135 operation: ITEM_SET
136 value: {
137 type: LITERAL literal %NEW_VALUE%
138 }
139 }
140 }
141 -->endmacro
142
143 -->macro Drop_collection %COLL_NAME%
144 -->stmtsql DROP TABLE IF EXISTS xtest.%COLL_NAME%
145 -->recvresult
146 -->endmacro
147
148 -->macro Assert_not_empty %COLLECTION_NAME%
149 -->stmtsql SELECT COUNT(*) FROM xtest.%COLLECTION_NAME%
150 -->recvtovar %CNT%
151 -->assert_ne %CNT% 0
152 -->endmacro