Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

Commit 60b47c6

Browse filesBrowse files
PhilippSalvisbergPhilippSalvisberg
committed
updated snippets according utPLSQL 3.1.12 docs
1 parent bc740dd commit 60b47c6
Copy full SHA for 60b47c6

File tree

1 file changed

+43
-29
lines changed
Filter options

1 file changed

+43
-29
lines changed

‎sqldev/src/main/resources/org/utplsql/sqldev/resources/UtplsqlSnippets.xml

Copy file name to clipboardExpand all lines: sqldev/src/main/resources/org/utplsql/sqldev/resources/UtplsqlSnippets.xml
+43-29Lines changed: 43 additions & 29 deletions
Original file line numberDiff line numberDiff line change
@@ -93,155 +93,169 @@
9393
</snippet>
9494
<snippet name="name" description="Package level. Denotes name for a context. Must be placed after the context annotation and before start of nested context.">
9595
<code>
96+
<![CDATA[--%name(<name>)]]>
97+
</code>
98+
</snippet>
9699
<snippet name="endcontext" description="Package level. Denotes end of a nested context (sub-suite) in a suite package.">
100+
<code>
97101
<![CDATA[--%endcontext]]>
98102
</code>
99103
</snippet>
100104
<snippet name="tags" description="Package/procedure level. Used to label a test or a suite for purpose of identification.">
101105
<code>
102-
<![CDATA[--%tags]]>
106+
<![CDATA[--%tags(<tag>[,...])]]>
103107
</code>
104108
</snippet>
105109
</group>
106110
<group category="utPLSQL Expectations" language="PLSQL">
107111
<snippet name="be_between" description="Validates that the actual value is between the lower and upper bound.">
108112
<code>
109-
<![CDATA[ut.expect(n1).to_be_between(n2);]]>
113+
<![CDATA[ut.expect(l_actual).to_be_between(l_expected_lower_bound, l_expected_upper_bound);]]>
110114
</code>
111115
</snippet>
112116
<snippet name="be_empty" description="Unary matcher that validates if the provided dataset is empty.">
113117
<code>
114-
<![CDATA[ut.expect(n).to_be_empty();]]>
118+
<![CDATA[ut.expect(l_actual).to_be_empty();]]>
115119
</code>
116120
</snippet>
117121
<snippet name="be_false" description="Unary matcher that validates if the provided value is false.">
118122
<code>
119-
<![CDATA[ut.expect(n).to_be_false();]]>
123+
<![CDATA[ut.expect(l_actual).to_be_false();]]>
120124
</code>
121125
</snippet>
122126
<snippet name="be_greater_or_equal" description="Checks if the actual value is greater or equal than the expected.">
123127
<code>
124-
<![CDATA[ut.expect(n1).to_be_greater_or_equal(n2);]]>
128+
<![CDATA[ut.expect(l_actual).to_be_greater_or_equal(l_expected);]]>
125129
</code>
126130
</snippet>
127131
<snippet name="be_greater_than" description="Checks if the actual value is greater than the expected.">
128132
<code>
129-
<![CDATA[ut.expect(n1).to_be_greater_than(n2);]]>
133+
<![CDATA[ut.expect(l_actual).to_be_greater_than(l_expected);]]>
130134
</code>
131135
</snippet>
132136
<snippet name="be_less_or_equal" description="Checks if the actual value is less or equal than the expected.">
133137
<code>
134-
<![CDATA[ut.expect(n1).to_be_less_or_equal(n2);]]>
138+
<![CDATA[ut.expect(l_actual).to_be_less_or_equal(l_expected);]]>
135139
</code>
136140
</snippet>
137141
<snippet name="be_less_than" description="Checks if the actual value is less than the expected.">
138142
<code>
139-
<![CDATA[ut.expect(n1).to_be_less_than(n2);]]>
143+
<![CDATA[ut.expect(l_actual).to_be_less_than(l_expected);]]>
140144
</code>
141145
</snippet>
142146
<snippet name="be_like" description="Validates that the actual value is like the expected expression.">
143147
<code>
144-
<![CDATA[ut.expect(n1).to_be_like(n2);]]>
148+
<![CDATA[ut.expect(l_actual).to_be_like('abc%\_t', '\');]]>
145149
</code>
146150
</snippet>
147151
<snippet name="be_not_null" description="Unary matcher that validates if the actual value is not null.">
148152
<code>
149-
<![CDATA[ut.expect(n).to_be_not_null();]]>
153+
<![CDATA[ut.expect(l_actual).to_be_not_null();]]>
150154
</code>
151155
</snippet>
152156
<snippet name="be_null" description="Unary matcher that validates if the actual value is null.">
153157
<code>
154-
<![CDATA[ut.expect(n).to_be_null();]]>
158+
<![CDATA[ut.expect(l_actual).to_be_null();]]>
155159
</code>
156160
</snippet>
157161
<snippet name="be_true" description="Unary matcher that validates if the provided value is true.">
158162
<code>
159-
<![CDATA[ut.expect(n).to_be_true();]]>
163+
<![CDATA[ut.expect(l_actual).to_be_true();]]>
160164
</code>
161165
</snippet>
162166
<snippet name="have_count" description="Unary matcher that validates if the provided dataset count is equal to expected value.">
163167
<code>
164-
<![CDATA[ut.expect(n1).to_have_count(n2);]]>
168+
<![CDATA[ut.expect(l_actual).to_have_count(1);]]>
165169
</code>
166170
</snippet>
167171
<snippet name="match" description="Validates that the actual value is matching the expected regular expression.">
168172
<code>
169-
<![CDATA[ut.expect(n1).to_match(n2);]]>
173+
<![CDATA[ut.expect(l_actual).to_match('^[a-z]\d{3}$', 'i');]]>
170174
</code>
171175
</snippet>
172176
<snippet name="equal" description="Validate that actual value is equal to expected">
173177
<code>
174-
<![CDATA[ut.expect(n1).to_equal(n2);]]>
178+
<![CDATA[ut.expect(l_actual).to_equal(l_expected);]]>
175179
</code>
176180
</snippet>
177181
<snippet name="contain" description="This matcher supports only compound data comparison. It check if the give set contain all values from given subset.">
178182
<code>
179-
<![CDATA[ut.expect(n1).to_contain(n2);]]>
183+
<![CDATA[ut.expect(c_actual).to_contain(c_expected);]]>
184+
</code>
185+
</snippet>
186+
<snippet name="to_be_within_pct" description="Determines whether actual value is within percentage range of expected value. The matcher only works with number data-type.">
187+
<code>
188+
<![CDATA[ut.expect(l_actual).to_be_within_pct(l_percent).of_(l_expected);]]>
180189
</code>
181190
</snippet>
182191
<snippet name="not_to_be_empty" description="Unary matcher that validates if the provided dataset is not empty">
183192
<code>
184-
<![CDATA[ut.expect(n).not_to_be_empty();]]>
193+
<![CDATA[ut.expect(l_actual).not_to_be_empty();]]>
185194
</code>
186195
</snippet>
187196
<snippet name="not_to_be_false" description="Unary matcher that validates if the provided value is not false.">
188197
<code>
189-
<![CDATA[ut.expect(n).not_to_be_false();]]>
198+
<![CDATA[ut.expect(l_actual).not_to_be_false();]]>
190199
</code>
191200
</snippet>
192201
<snippet name="not_to_be_greater_or_equal" description="Checks if the actual value is not greater or equal than the expected.">
193202
<code>
194-
<![CDATA[ut.expect(n1).not_to_be_greater_or_equal(n2);]]>
203+
<![CDATA[ut.expect(l_actual).not_to_be_greater_or_equal(l_expected);]]>
195204
</code>
196205
</snippet>
197206
<snippet name="not_to_be_greater_than" description="Checks if the actual value is not greater than the expected.">
198207
<code>
199-
<![CDATA[ut.expect(n1).not_to_be_greater_than(n2);]]>
208+
<![CDATA[ut.expect(l_actual).not_to_be_greater_than(l_expected);]]>
200209
</code>
201210
</snippet>
202211
<snippet name="not_to_be_less_or_equal" description="Checks if the actual value is not less or equal than the expected.">
203212
<code>
204-
<![CDATA[ut.expect(n1).not_to_be_less_or_equal(n2);]]>
213+
<![CDATA[ut.expect(l_actual).not_to_be_less_or_equal(l_expected);]]>
205214
</code>
206215
</snippet>
207216
<snippet name="not_to_be_less_than" description="Checks if the actual value is not less than the expected.">
208217
<code>
209-
<![CDATA[ut.expect(n1).not_to_be_less_than(n2);]]>
218+
<![CDATA[ut.expect(l_actual).not_to_be_less_than(l_expected);]]>
210219
</code>
211220
</snippet>
212221
<snippet name="not_to_be_like" description="Validates that the actual value is not like the expected expression.">
213222
<code>
214-
<![CDATA[ut.expect(n1).not_to_be_like(n2);]]>
223+
<![CDATA[ut.expect(l_actual).not_to_be_like('abc%\_t', '\');]]>
215224
</code>
216225
</snippet>
217226
<snippet name="not_to_have_count" description="Unary matcher that validates if the provided dataset count is not equal to expected value.">
218227
<code>
219-
<![CDATA[ut.expect(n1).not_to_have_count(n2);]]>
228+
<![CDATA[ut.expect(l_actual).not_to_have_count(1);]]>
220229
</code>
221230
</snippet>
222231
<snippet name="not_to_match" description="Validates that the actual value is not matching the expected regular expression.">
223232
<code>
224-
<![CDATA[ut.expect(n1).not_to_match(n2);]]>
233+
<![CDATA[ut.expect(l_actual).not_to_match('^[a-z]\d{3}$', 'i');]]>
225234
</code>
226235
</snippet>
227236
<snippet name="not_to_equal" description="Validate that actual value is not equal to expected">
228237
<code>
229-
<![CDATA[ut.expect(n1).not_to_equal(n2);]]>
238+
<![CDATA[ut.expect(l_actual).not_to_equal(l_expected);]]>
230239
</code>
231240
</snippet>
232241
<snippet name="not_to_contain" description="This matcher supports only compound data comparison. It check if the give set not contain all values from given subset.">
233242
<code>
243+
<![CDATA[ut.expect(c_actual).not_to_contain(c_expected);]]>
244+
</code>
245+
</snippet>
234246
<snippet name="not_to_be_within_pct" description="Determines whether actual value is not within percentage range of expected value. The matcher only works with number data-type.">
247+
<code>
248+
<![CDATA[ut.expect(l_actual).not_to_be_within_pct(l_percent).of_(l_expected);]]>
235249
</code>
236250
</snippet>
237251
<snippet name=".include" description="Valid only for compound data types. Item, comma separated list of items or table of items to include">
238252
<code>
239-
<![CDATA[.include(n)]]>
253+
<![CDATA[.include('COLUMN1').include(ut_varchar2_list('COLUMN2', 'COLUMN3'))]]>
240254
</code>
241255
</snippet>
242256
<snippet name=".exclude" description="Valid only for compound data types. Item, comma separated list of items or table of items to exclude">
243257
<code>
244-
<![CDATA[.exclude(n)]]>
258+
<![CDATA[.exclude('COLUMN1').exclude(ut_varchar2_list('COLUMN2', 'COLUMN3'))]]>
245259
</code>
246260
</snippet>
247261
<snippet name=".unordered" description="Valid only for compound data types.ignore order of data sets when comparing data. Default when comparing data-sets with to_contain">
@@ -251,7 +265,7 @@
251265
</snippet>
252266
<snippet name=".join_by" description="Valid only for compound data types. Item, comma separated list of items or table of items to join by two cursors">
253267
<code>
254-
<![CDATA[.join_by(n)]]>
268+
<![CDATA[.join_by('COLUMN1, COLUMN2')]]>
255269
</code>
256270
</snippet>
257271
<snippet name=".unordered_columns" description="Valid only for compound data types. Ignore the ordering of columns / attributes in compared data-sets. Column/attribute names will be used to identify data to be compared and the position will be ignored.">

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.