1 /*
2 * SysDB - t/unit/frontend/parser_test.c
3 * Copyright (C) 2013-2015 Sebastian 'tokkee' Harl <sh@tokkee.org>
4 * All rights reserved.
5 *
6 * Redistribution and use in source and binary forms, with or without
7 * modification, are permitted provided that the following conditions
8 * are met:
9 * 1. Redistributions of source code must retain the above copyright
10 * notice, this list of conditions and the following disclaimer.
11 * 2. Redistributions in binary form must reproduce the above copyright
12 * notice, this list of conditions and the following disclaimer in the
13 * documentation and/or other materials provided with the distribution.
14 *
15 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
16 * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED
17 * TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
18 * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR
19 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
20 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
21 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
22 * OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
23 * WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
24 * OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
25 * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
26 */
28 #if HAVE_CONFIG_H
29 # include "config.h"
30 #endif
32 #include "frontend/connection.h"
33 #include "frontend/parser.h"
34 #include "core/store-private.h"
35 #include "core/object.h"
36 #include "testutils.h"
38 #include <check.h>
39 #include <limits.h>
41 /*
42 * tests
43 */
45 struct {
46 const char *query;
47 int len;
48 int expected;
49 sdb_conn_state_t expected_cmd;
50 } parse_data[] = {
51 /* empty commands */
52 { NULL, -1, -1, 0 },
53 { "", -1, 0, 0 },
54 { ";", -1, 0, 0 },
55 { ";;", -1, 0, 0 },
57 /* FETCH commands */
58 { "FETCH host 'host'", -1, 1, SDB_CONNECTION_FETCH },
59 { "FETCH host 'host' FILTER "
60 "age > 60s", -1, 1, SDB_CONNECTION_FETCH },
61 { "FETCH service "
62 "'host'.'service'", -1, 1, SDB_CONNECTION_FETCH },
63 { "FETCH metric "
64 "'host'.'metric'", -1, 1, SDB_CONNECTION_FETCH },
66 /* LIST commands */
67 { "LIST hosts", -1, 1, SDB_CONNECTION_LIST },
68 { "LIST hosts -- foo", -1, 1, SDB_CONNECTION_LIST },
69 { "LIST hosts;", -1, 1, SDB_CONNECTION_LIST },
70 { "LIST hosts; INVALID", 11, 1, SDB_CONNECTION_LIST },
71 { "LIST hosts FILTER "
72 "age > 60s", -1, 1, SDB_CONNECTION_LIST },
73 { "LIST services", -1, 1, SDB_CONNECTION_LIST },
74 { "LIST services FILTER "
75 "age > 60s", -1, 1, SDB_CONNECTION_LIST },
76 { "LIST metrics", -1, 1, SDB_CONNECTION_LIST },
77 { "LIST metrics FILTER "
78 "age > 60s", -1, 1, SDB_CONNECTION_LIST },
80 /* LOOKUP commands */
81 { "LOOKUP hosts", -1, 1, SDB_CONNECTION_LOOKUP },
82 { "LOOKUP hosts MATCHING "
83 "name = 'host'", -1, 1, SDB_CONNECTION_LOOKUP },
84 { "LOOKUP hosts MATCHING NOT "
85 "name = 'host'", -1, 1, SDB_CONNECTION_LOOKUP },
86 { "LOOKUP hosts MATCHING "
87 "name =~ 'p' AND "
88 "ANY service =~ 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
89 { "LOOKUP hosts MATCHING NOT "
90 "name =~ 'p' AND "
91 "ANY service =~ 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
92 { "LOOKUP hosts MATCHING "
93 "name =~ 'p' AND "
94 "ANY service =~ 'p' OR "
95 "ANY service =~ 'r'", -1, 1, SDB_CONNECTION_LOOKUP },
96 { "LOOKUP hosts MATCHING NOT "
97 "name =~ 'p' AND "
98 "ANY service =~ 'p' OR "
99 "ANY service =~ 'r'", -1, 1, SDB_CONNECTION_LOOKUP },
100 { "LOOKUP hosts MATCHING "
101 "name =~ 'p' "
102 "FILTER age > 1D", -1, 1, SDB_CONNECTION_LOOKUP },
103 { "LOOKUP hosts MATCHING "
104 "name =~ 'p' "
105 "FILTER age > 1D AND "
106 "interval < 240s" , -1, 1, SDB_CONNECTION_LOOKUP },
107 { "LOOKUP hosts MATCHING "
108 "name =~ 'p' "
109 "FILTER NOT age>1D", -1, 1, SDB_CONNECTION_LOOKUP },
110 { "LOOKUP hosts MATCHING "
111 "name =~ 'p' "
112 "FILTER age>"
113 "interval", -1, 1, SDB_CONNECTION_LOOKUP },
114 { "LOOKUP hosts MATCHING "
115 "host.name =~ 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
116 { "LOOKUP services", -1, 1, SDB_CONNECTION_LOOKUP },
117 { "LOOKUP services MATCHING ANY "
118 "attribute =~ 'a'", -1, 1, SDB_CONNECTION_LOOKUP },
119 { "LOOKUP services MATCHING "
120 "host.name = 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
121 { "LOOKUP services MATCHING "
122 "service.name = 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
123 { "LOOKUP metrics", -1, 1, SDB_CONNECTION_LOOKUP },
124 { "LOOKUP metrics MATCHING ANY "
125 "attribute =~ 'a'", -1, 1, SDB_CONNECTION_LOOKUP },
126 { "LOOKUP metrics MATCHING "
127 "host.name = 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
128 { "LOOKUP metrics MATCHING "
129 "metric.name = 'p'", -1, 1, SDB_CONNECTION_LOOKUP },
131 /* TIMESERIES commands */
132 { "TIMESERIES 'host'.'metric' "
133 "START 2014-01-01 "
134 "END 2014-12-31 "
135 "23:59:59", -1, 1, SDB_CONNECTION_TIMESERIES },
136 { "TIMESERIES 'host'.'metric' "
137 "START 2014-02-02 "
138 "14:02", -1, 1, SDB_CONNECTION_TIMESERIES },
139 { "TIMESERIES 'host'.'metric' "
140 "END 2014-02-02", -1, 1, SDB_CONNECTION_TIMESERIES },
141 { "TIMESERIES "
142 "'host'.'metric'", -1, 1, SDB_CONNECTION_TIMESERIES },
144 /* STORE commands */
145 { "STORE host 'host'", -1, 1, SDB_CONNECTION_STORE_HOST },
146 { "STORE host 'host' "
147 "LAST UPDATE "
148 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_HOST },
149 { "STORE host attribute "
150 "'host'.'key' 123", -1, 1, SDB_CONNECTION_STORE_ATTRIBUTE },
151 { "STORE host attribute "
152 "'host'.'key' 123 "
153 "LAST UPDATE "
154 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_ATTRIBUTE },
155 { "STORE service "
156 "'host'.'svc'", -1, 1, SDB_CONNECTION_STORE_SERVICE },
157 { "STORE service "
158 "'host'.'svc' "
159 "LAST UPDATE "
160 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_SERVICE },
161 { "STORE service attribute "
162 "'host'.'svc'.'key' "
163 "123", -1, 1, SDB_CONNECTION_STORE_ATTRIBUTE },
164 { "STORE service attribute "
165 "'host'.'svc'.'key' "
166 "123 "
167 "LAST UPDATE "
168 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_ATTRIBUTE },
169 { "STORE metric "
170 "'host'.'metric'", -1, 1, SDB_CONNECTION_STORE_METRIC },
171 { "STORE metric "
172 "'host'.'metric' "
173 "LAST UPDATE "
174 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_METRIC },
175 { "STORE metric "
176 "'host'.'metric' "
177 "STORE 'typ' 'id' "
178 "LAST UPDATE "
179 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_METRIC },
180 { "STORE metric attribute "
181 "'host'.'metric'.'key' "
182 "123", -1, 1, SDB_CONNECTION_STORE_ATTRIBUTE },
183 { "STORE metric attribute "
184 "'host'.'metric'.'key' "
185 "123 "
186 "LAST UPDATE "
187 "2015-02-01", -1, 1, SDB_CONNECTION_STORE_ATTRIBUTE },
189 /* string constants */
190 { "LOOKUP hosts MATCHING "
191 "name = ''''", -1, 1, SDB_CONNECTION_LOOKUP },
192 { "LOOKUP hosts MATCHING "
193 "name = '''foo'", -1, 1, SDB_CONNECTION_LOOKUP },
194 { "LOOKUP hosts MATCHING "
195 "name = 'f''oo'", -1, 1, SDB_CONNECTION_LOOKUP },
196 { "LOOKUP hosts MATCHING "
197 "name = 'foo'''", -1, 1, SDB_CONNECTION_LOOKUP },
198 { "LOOKUP hosts MATCHING "
199 "name = '''", -1, -1, 0 },
201 /* numeric constants */
202 { "LOOKUP hosts MATCHING "
203 "attribute['foo'] = "
204 "1234", -1, 1, SDB_CONNECTION_LOOKUP },
205 { "LOOKUP hosts MATCHING "
206 "attribute['foo'] != "
207 "+234", -1, 1, SDB_CONNECTION_LOOKUP },
208 { "LOOKUP hosts MATCHING "
209 "attribute['foo'] < "
210 "-234", -1, 1, SDB_CONNECTION_LOOKUP },
211 { "LOOKUP hosts MATCHING "
212 "attribute['foo'] > "
213 "12.4", -1, 1, SDB_CONNECTION_LOOKUP },
214 { "LOOKUP hosts MATCHING "
215 "attribute['foo'] <= "
216 "12. + .3", -1, 1, SDB_CONNECTION_LOOKUP },
217 { "LOOKUP hosts MATCHING "
218 "attribute['foo'] <= "
219 "'f' || 'oo'", -1, 1, SDB_CONNECTION_LOOKUP },
220 { "LOOKUP hosts MATCHING "
221 "attribute['foo'] >= "
222 ".4", -1, 1, SDB_CONNECTION_LOOKUP },
223 { "LOOKUP hosts MATCHING "
224 "attribute['foo'] = "
225 "+12e3", -1, 1, SDB_CONNECTION_LOOKUP },
226 { "LOOKUP hosts MATCHING "
227 "attribute['foo'] = "
228 "+12e-3", -1, 1, SDB_CONNECTION_LOOKUP },
229 { "LOOKUP hosts MATCHING "
230 "attribute['foo'] = "
231 "-12e+3", -1, 1, SDB_CONNECTION_LOOKUP },
233 /* date, time, interval constants */
234 { "LOOKUP hosts MATCHING "
235 "attribute['foo'] = "
236 "1 Y 42D", -1, 1, SDB_CONNECTION_LOOKUP },
237 { "LOOKUP hosts MATCHING "
238 "attribute['foo'] = "
239 "1s 42D", -1, 1, SDB_CONNECTION_LOOKUP },
240 /*
241 * TODO: Something like 1Y42D should work as well but it doesn't since
242 * the scanner will tokenize it into {digit}{identifier} :-/
243 *
244 { "LOOKUP hosts MATCHING "
245 "attribute['foo'] = "
246 "1Y42D", -1, 1, SDB_CONNECTION_LOOKUP },
247 */
249 /* array constants */
250 { "LOOKUP hosts MATCHING "
251 "backend = ['foo']", -1, 1, SDB_CONNECTION_LOOKUP },
252 { "LOOKUP hosts MATCHING "
253 "backend = ['a','b']", -1, 1, SDB_CONNECTION_LOOKUP },
255 /* array iteration */
256 { "LOOKUP hosts MATCHING "
257 "'foo' IN backend", -1, 1, SDB_CONNECTION_LOOKUP },
258 { "LOOKUP hosts MATCHING "
259 "['foo','bar'] "
260 "IN backend ", -1, 1, SDB_CONNECTION_LOOKUP },
261 /* attribute type is unknown */
262 { "LOOKUP hosts MATCHING "
263 "attribute['backend'] "
264 "IN backend ", -1, 1, SDB_CONNECTION_LOOKUP },
265 /* type mismatch */
266 { "LOOKUP hosts MATCHING "
267 "1 IN backend ", -1, -1, 0 },
268 { "LOOKUP hosts MATCHING "
269 "ANY backend < 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
270 { "LOOKUP hosts MATCHING "
271 "ANY backend <= 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
272 { "LOOKUP hosts MATCHING "
273 "ANY backend = 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
274 { "LOOKUP hosts MATCHING "
275 "ANY backend != 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
276 { "LOOKUP hosts MATCHING "
277 "ANY backend >= 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
278 { "LOOKUP hosts MATCHING "
279 "ANY backend > 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
280 { "LOOKUP hosts MATCHING "
281 "ANY backend =~ 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
282 { "LOOKUP hosts MATCHING "
283 "ANY backend !~ 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
284 { "LOOKUP hosts MATCHING "
285 "ALL backend < 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
286 { "LOOKUP hosts MATCHING "
287 "ALL backend <= 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
288 { "LOOKUP hosts MATCHING "
289 "ALL backend = 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
290 { "LOOKUP hosts MATCHING "
291 "ALL backend != 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
292 { "LOOKUP hosts MATCHING "
293 "ALL backend >= 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
294 { "LOOKUP hosts MATCHING "
295 "ALL backend > 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
296 { "LOOKUP hosts MATCHING "
297 "ALL backend =~ 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
298 { "LOOKUP hosts MATCHING "
299 "ALL backend !~ 'b'", -1, 1, SDB_CONNECTION_LOOKUP },
300 /* attribute type is unknown */
301 { "LOOKUP hosts MATCHING "
302 "ANY backend = attribute['backend']",
303 -1, 1, SDB_CONNECTION_LOOKUP },
304 /* type mismatch */
305 { "LOOKUP hosts MATCHING "
306 "ANY backend = 1", -1, -1, 0 },
308 /* valid operand types */
309 { "LOOKUP hosts MATCHING "
310 "age * 1 > 0s", -1, 1, SDB_CONNECTION_LOOKUP },
311 { "LOOKUP hosts MATCHING "
312 "age / 1 > 0s", -1, 1, SDB_CONNECTION_LOOKUP },
313 { "LOOKUP hosts MATCHING "
314 "name > ''", -1, 1, SDB_CONNECTION_LOOKUP },
315 { "LOOKUP hosts MATCHING "
316 "name >= ''", -1, 1, SDB_CONNECTION_LOOKUP },
317 { "LOOKUP hosts MATCHING "
318 "name != ''", -1, 1, SDB_CONNECTION_LOOKUP },
319 { "LOOKUP hosts MATCHING "
320 "name = ''", -1, 1, SDB_CONNECTION_LOOKUP },
321 { "LOOKUP hosts MATCHING "
322 "name <= ''", -1, 1, SDB_CONNECTION_LOOKUP },
323 { "LOOKUP hosts MATCHING "
324 "name < ''", -1, 1, SDB_CONNECTION_LOOKUP },
326 /* NULL */
327 { "LOOKUP hosts MATCHING "
328 "attribute['foo'] "
329 "IS NULL", -1, 1, SDB_CONNECTION_LOOKUP },
330 { "LOOKUP hosts MATCHING "
331 "attribute['foo'] "
332 "IS NOT NULL", -1, 1, SDB_CONNECTION_LOOKUP },
333 { "LOOKUP hosts MATCHING "
334 "NOT attribute['foo'] "
335 "IS NULL", -1, 1, SDB_CONNECTION_LOOKUP },
336 { "LOOKUP hosts MATCHING "
337 "ANY service IS NULL", -1, -1, 0 },
339 /* invalid numeric constants */
340 { "LOOKUP hosts MATCHING "
341 "attribute['foo'] = "
342 "+-12e+3", -1, -1, 0 },
343 { "LOOKUP hosts MATCHING "
344 "attribute['foo'] = "
345 "-12e-+3", -1, -1, 0 },
346 { "LOOKUP hosts MATCHING "
347 "attribute['foo'] = "
348 "e+3", -1, -1, 0 },
349 { "LOOKUP hosts MATCHING "
350 "attribute['foo'] = "
351 "3e", -1, -1, 0 },
352 /* following SQL standard, we don't support hex numbers */
353 { "LOOKUP hosts MATCHING "
354 "attribute['foo'] = "
355 "0x12", -1, -1, 0 },
357 /* invalid expressions */
358 { "LOOKUP hosts MATCHING "
359 "attribute['foo'] = "
360 "1.23 + 'foo'", -1, -1, 0 },
361 { "LOOKUP hosts MATCHING "
362 "attr['foo'] = 1.23", -1, -1, 0 },
363 { "LOOKUP hosts MATCHING "
364 "attr['foo'] IS NULL", -1, -1, 0 },
366 /* type mismatches */
367 { "LOOKUP hosts MATCHING "
368 "age > 0", -1, -1, 0 },
369 { "LOOKUP hosts MATCHING "
370 "age >= 0", -1, -1, 0 },
371 { "LOOKUP hosts MATCHING "
372 "age = 0", -1, -1, 0 },
373 { "LOOKUP hosts MATCHING "
374 "age != 0", -1, -1, 0 },
375 { "LOOKUP hosts MATCHING "
376 "age <= 0", -1, -1, 0 },
377 { "LOOKUP hosts MATCHING "
378 "age < 0", -1, -1, 0 },
379 { "LOOKUP hosts MATCHING "
380 "age + 1 > 0s", -1, -1, 0 },
381 { "LOOKUP hosts MATCHING "
382 "age - 1 > 0s", -1, -1, 0 },
383 /* datetime <mul/div> integer is allowed */
384 { "LOOKUP hosts MATCHING "
385 "age || 1 > 0s", -1, -1, 0 },
386 { "LOOKUP hosts MATCHING "
387 "name + 1 = ''", -1, -1, 0 },
388 { "LOOKUP hosts MATCHING "
389 "name - 1 = ''", -1, -1, 0 },
390 { "LOOKUP hosts MATCHING "
391 "name * 1 = ''", -1, -1, 0 },
392 { "LOOKUP hosts MATCHING "
393 "name / 1 = ''", -1, -1, 0 },
394 { "LOOKUP hosts MATCHING "
395 "name % 1 = ''", -1, -1, 0 },
397 /* comments */
398 { "/* some comment */", -1, 0, 0 },
399 { "-- another comment", -1, 0, 0 },
401 /* syntax errors */
402 { "INVALID", -1, -1, 0 },
403 { "FETCH host", -1, -1, 0 },
404 { "FETCH 'host'", -1, -1, 0 },
405 { "LIST hosts; INVALID", -1, -1, 0 },
406 { "/* some incomplete", -1, -1, 0 },
408 /* invalid LIST commands */
409 { "LIST", -1, -1, 0 },
410 { "LIST foo", -1, -1, 0 },
411 { "LIST hosts MATCHING "
412 "name = 'host'", -1, -1, 0 },
413 { "LIST foo FILTER "
414 "age > 60s", -1, -1, 0 },
416 /* invalid FETCH commands */
417 { "FETCH host 'host' MATCHING "
418 "name = 'host'", -1, -1, 0 },
419 { "FETCH service 'host'",-1, -1, 0 },
420 { "FETCH metric 'host'", -1, -1, 0 },
421 { "FETCH host "
422 "'host'.'localhost'", -1, -1, 0 },
423 { "FETCH foo 'host'", -1, -1, 0 },
424 { "FETCH foo 'host' FILTER "
425 "age > 60s", -1, -1, 0 },
427 /* invalid LOOKUP commands */
428 { "LOOKUP foo", -1, -1, 0 },
429 { "LOOKUP foo MATCHING "
430 "name = 'host'", -1, -1, 0 },
431 { "LOOKUP foo FILTER "
432 "age > 60s", -1, -1, 0 },
433 { "LOOKUP foo MATCHING "
434 "name = 'host' FILTER "
435 "age > 60s", -1, -1, 0 },
436 { "LOOKUP hosts MATCHING "
437 "attribute['foo'] <= "
438 "f || 'oo'", -1, -1, 0 },
439 { "LOOKUP hosts MATCHING "
440 "attribute['foo'] <= "
441 "'f' || oo", -1, -1, 0 },
442 { "LOOKUP hosts MATCHING "
443 "ANY host = 'host'", -1, -1, 0 },
444 { "LOOKUP hosts MATCHING "
445 "service.name = 's'", -1, -1, 0 },
446 { "LOOKUP services MATCHING "
447 "ANY host = 'host'", -1, -1, 0 },
448 { "LOOKUP services MATCHING "
449 "ANY service = 'svc'", -1, -1, 0 },
450 { "LOOKUP services MATCHING "
451 "ANY metric = 'm'", -1, -1, 0 },
452 { "LOOKUP services MATCHING "
453 "metric.name = 'm'", -1, -1, 0 },
454 { "LOOKUP metrics MATCHING "
455 "ANY host = 'host'", -1, -1, 0 },
456 { "LOOKUP metrics MATCHING "
457 "ANY service = 'svc'", -1, -1, 0 },
458 { "LOOKUP metrics MATCHING "
459 "ANY metric = 'm'", -1, -1, 0 },
460 { "LOOKUP metrics MATCHING "
461 "service.name = 'm'", -1, -1, 0 },
463 /* invalid STORE commands */
464 { "STORE host "
465 "'obj'.'host'", -1, -1, 0 },
466 { "STORE host attribute "
467 ".'key' 123", -1, -1, 0 },
468 { "STORE host attribute "
469 "'o'.'h'.'key' 123", -1, -1, 0 },
470 { "STORE service 'svc'", -1, -1, 0 },
471 { "STORE service "
472 "'host'.'svc' "
473 "STORE 'typ' 'id' "
474 "LAST UPDATE "
475 "2015-02-01", -1, -1, 0 },
476 { "STORE service attribute "
477 "'svc'.'key' 123", -1, -1, 0 },
478 { "STORE metric 'm'", -1, -1, 0 },
479 { "STORE metric "
480 "'host'.'metric' "
481 "STORE 'typ'.'id' "
482 "LAST UPDATE "
483 "2015-02-01", -1, -1, 0 },
484 { "STORE metric attribute "
485 "'metric'.'key' 123", -1, -1, 0 },
486 };
488 START_TEST(test_parse)
489 {
490 sdb_strbuf_t *errbuf = sdb_strbuf_create(64);
491 sdb_llist_t *check;
492 sdb_object_t *obj;
493 _Bool ok;
495 check = sdb_fe_parse(parse_data[_i].query,
496 parse_data[_i].len, errbuf);
497 if (parse_data[_i].expected < 0)
498 ok = check == 0;
499 else
500 ok = sdb_llist_len(check) == (size_t)parse_data[_i].expected;
502 fail_unless(ok, "sdb_fe_parse(%s) = %p (len: %zu); expected: %d "
503 "(parser error: %s)", parse_data[_i].query, check,
504 sdb_llist_len(check), parse_data[_i].expected,
505 sdb_strbuf_string(errbuf));
507 if (! check) {
508 sdb_strbuf_destroy(errbuf);
509 return;
510 }
512 if ((! parse_data[_i].expected_cmd)
513 || (parse_data[_i].expected <= 0)) {
514 sdb_llist_destroy(check);
515 sdb_strbuf_destroy(errbuf);
516 return;
517 }
519 obj = sdb_llist_get(check, 0);
520 fail_unless(SDB_CONN_NODE(obj)->cmd == parse_data[_i].expected_cmd,
521 "sdb_fe_parse(%s)->cmd = %i; expected: %d",
522 parse_data[_i].query, SDB_CONN_NODE(obj)->cmd,
523 parse_data[_i].expected_cmd);
525 sdb_object_deref(obj);
526 sdb_llist_destroy(check);
527 sdb_strbuf_destroy(errbuf);
528 }
529 END_TEST
531 struct {
532 const char *expr;
533 int len;
534 int expected;
535 } parse_matcher_data[] = {
536 /* empty expressions */
537 { NULL, -1, -1 },
538 { "", -1, -1 },
540 /* match hosts by name */
541 { "name < 'localhost'", -1, MATCHER_LT },
542 { "name <= 'localhost'", -1, MATCHER_LE },
543 { "name = 'localhost'", -1, MATCHER_EQ },
544 { "name != 'localhost'", -1, MATCHER_NE },
545 { "name >= 'localhost'", -1, MATCHER_GE },
546 { "name > 'localhost'", -1, MATCHER_GT },
547 { "name =~ 'host'", -1, MATCHER_REGEX },
548 { "name !~ 'host'", -1, MATCHER_NREGEX },
549 { "name = 'localhost' -- foo", -1, MATCHER_EQ },
550 { "name = 'host' <garbage>", 13, MATCHER_EQ },
551 { "name &^ 'localhost'", -1, -1 },
552 /* match by backend */
553 { "ANY backend < 'be'", -1, MATCHER_ANY },
554 { "ANY backend <= 'be'", -1, MATCHER_ANY },
555 { "ANY backend = 'be'", -1, MATCHER_ANY },
556 { "ANY backend != 'be'", -1, MATCHER_ANY },
557 { "ANY backend >= 'be'", -1, MATCHER_ANY },
558 { "ANY backend > 'be'", -1, MATCHER_ANY },
559 { "ALL backend < 'be'", -1, MATCHER_ALL },
560 { "ALL backend <= 'be'", -1, MATCHER_ALL },
561 { "ALL backend = 'be'", -1, MATCHER_ALL },
562 { "ALL backend != 'be'", -1, MATCHER_ALL },
563 { "ALL backend >= 'be'", -1, MATCHER_ALL },
564 { "ALL backend > 'be'", -1, MATCHER_ALL },
565 { "ANY backend &^ 'be'", -1, -1 },
566 /* match hosts by service */
567 { "ANY service < 'name'", -1, MATCHER_ANY },
568 { "ANY service <= 'name'", -1, MATCHER_ANY },
569 { "ANY service = 'name'", -1, MATCHER_ANY },
570 { "ANY service != 'name'", -1, MATCHER_ANY },
571 { "ANY service >= 'name'", -1, MATCHER_ANY },
572 { "ANY service > 'name'", -1, MATCHER_ANY },
573 { "ANY service =~ 'pattern'", -1, MATCHER_ANY },
574 { "ANY service !~ 'pattern'", -1, MATCHER_ANY },
575 { "ANY service &^ 'name'", -1, -1 },
576 { "ALL service < 'name'", -1, MATCHER_ALL },
577 { "ALL service <= 'name'", -1, MATCHER_ALL },
578 { "ALL service = 'name'", -1, MATCHER_ALL },
579 { "ALL service != 'name'", -1, MATCHER_ALL },
580 { "ALL service >= 'name'", -1, MATCHER_ALL },
581 { "ALL service > 'name'", -1, MATCHER_ALL },
582 { "ALL service =~ 'pattern'", -1, MATCHER_ALL },
583 { "ALL service !~ 'pattern'", -1, MATCHER_ALL },
584 { "ALL service &^ 'name'", -1, -1 },
585 /* match hosts by metric */
586 { "ANY metric < 'name'", -1, MATCHER_ANY },
587 { "ANY metric <= 'name'", -1, MATCHER_ANY },
588 { "ANY metric = 'name'", -1, MATCHER_ANY },
589 { "ANY metric != 'name'", -1, MATCHER_ANY },
590 { "ANY metric >= 'name'", -1, MATCHER_ANY },
591 { "ANY metric > 'name'", -1, MATCHER_ANY },
592 { "ANY metric =~ 'pattern'", -1, MATCHER_ANY },
593 { "ANY metric !~ 'pattern'", -1, MATCHER_ANY },
594 { "ANY metric &^ 'pattern'", -1, -1 },
595 { "ALL metric < 'name'", -1, MATCHER_ALL },
596 { "ALL metric <= 'name'", -1, MATCHER_ALL },
597 { "ALL metric = 'name'", -1, MATCHER_ALL },
598 { "ALL metric != 'name'", -1, MATCHER_ALL },
599 { "ALL metric >= 'name'", -1, MATCHER_ALL },
600 { "ALL metric > 'name'", -1, MATCHER_ALL },
601 { "ALL metric =~ 'pattern'", -1, MATCHER_ALL },
602 { "ALL metric !~ 'pattern'", -1, MATCHER_ALL },
603 { "ALL metric &^ 'pattern'", -1, -1 },
604 /* match hosts by attribute */
605 { "ANY attribute < 'name'", -1, MATCHER_ANY },
606 { "ANY attribute <= 'name'", -1, MATCHER_ANY },
607 { "ANY attribute = 'name'", -1, MATCHER_ANY },
608 { "ANY attribute != 'name'", -1, MATCHER_ANY },
609 { "ANY attribute >= 'name'", -1, MATCHER_ANY },
610 { "ANY attribute > 'name'", -1, MATCHER_ANY },
611 { "ANY attribute =~ 'pattern'", -1, MATCHER_ANY },
612 { "ANY attribute !~ 'pattern'", -1, MATCHER_ANY },
613 { "ANY attribute &^ 'pattern'", -1, -1 },
614 { "ALL attribute < 'name'", -1, MATCHER_ALL },
615 { "ALL attribute <= 'name'", -1, MATCHER_ALL },
616 { "ALL attribute = 'name'", -1, MATCHER_ALL },
617 { "ALL attribute != 'name'", -1, MATCHER_ALL },
618 { "ALL attribute >= 'name'", -1, MATCHER_ALL },
619 { "ALL attribute > 'name'", -1, MATCHER_ALL },
620 { "ALL attribute =~ 'pattern'", -1, MATCHER_ALL },
621 { "ALL attribute !~ 'pattern'", -1, MATCHER_ALL },
622 { "ALL attribute &^ 'pattern'", -1, -1 },
623 /* composite expressions */
624 { "name =~ 'pattern' AND "
625 "ANY service =~ 'pattern'", -1, MATCHER_AND },
626 { "name =~ 'pattern' OR "
627 "ANY service =~ 'pattern'", -1, MATCHER_OR },
628 { "NOT name = 'host'", -1, MATCHER_NOT },
629 /* numeric expressions */
630 { "attribute['foo'] < 123", -1, MATCHER_LT },
631 { "attribute['foo'] <= 123", -1, MATCHER_LE },
632 { "attribute['foo'] = 123", -1, MATCHER_EQ },
633 { "attribute['foo'] >= 123", -1, MATCHER_GE },
634 { "attribute['foo'] > 123", -1, MATCHER_GT },
635 /* datetime expressions */
636 { "attribute['foo'] = "
637 "2014-08-16", -1, MATCHER_EQ },
638 { "attribute['foo'] = "
639 "17:23", -1, MATCHER_EQ },
640 { "attribute['foo'] = "
641 "17:23:53", -1, MATCHER_EQ },
642 { "attribute['foo'] = "
643 "17:23:53.123", -1, MATCHER_EQ },
644 { "attribute['foo'] = "
645 "17:23:53.123456789", -1, MATCHER_EQ },
646 { "attribute['foo'] = "
647 "2014-08-16 17:23", -1, MATCHER_EQ },
648 { "attribute['foo'] = "
649 "2014-08-16 17:23:53", -1, MATCHER_EQ },
650 /* NULL; while this is an implementation detail,
651 * IS NULL currently maps to an equality matcher */
652 { "attribute['foo'] IS NULL", -1, MATCHER_ISNULL },
653 { "attribute['foo'] IS NOT NULL", -1, MATCHER_ISNNULL },
654 /* array expressions */
655 { "backend < ['a']", -1, MATCHER_LT },
656 { "backend <= ['a']", -1, MATCHER_LE },
657 { "backend = ['a']", -1, MATCHER_EQ },
658 { "backend != ['a']", -1, MATCHER_NE },
659 { "backend >= ['a']", -1, MATCHER_GE },
660 { "backend > ['a']", -1, MATCHER_GT },
661 { "backend &^ ['a']", -1, -1 },
663 /* object field matchers */
664 { "name < 'a'", -1, MATCHER_LT },
665 { "name <= 'a'", -1, MATCHER_LE },
666 { "name = 'a'", -1, MATCHER_EQ },
667 { "name != 'a'", -1, MATCHER_NE },
668 { "name >= 'a'", -1, MATCHER_GE },
669 { "name > 'a'", -1, MATCHER_GT },
670 { "last_update < 2014-10-01", -1, MATCHER_LT },
671 { "last_update <= 2014-10-01", -1, MATCHER_LE },
672 { "last_update = 2014-10-01", -1, MATCHER_EQ },
673 { "last_update != 2014-10-01", -1, MATCHER_NE },
674 { "last_update >= 2014-10-01", -1, MATCHER_GE },
675 { "last_update > 2014-10-01", -1, MATCHER_GT },
676 { "Last_Update >= 24D", -1, MATCHER_GE },
677 { "age < 20s", -1, MATCHER_LT },
678 { "age <= 20s", -1, MATCHER_LE },
679 { "age = 20s", -1, MATCHER_EQ },
680 { "age != 20s", -1, MATCHER_NE },
681 { "age >= 20s", -1, MATCHER_GE },
682 { "age > 20s", -1, MATCHER_GT },
683 { "AGE <= 1m", -1, MATCHER_LE },
684 { "age > 1M", -1, MATCHER_GT },
685 { "age != 20Y", -1, MATCHER_NE },
686 { "age <= 2 * interval", -1, MATCHER_LE },
687 { "interval < 20s", -1, MATCHER_LT },
688 { "interval <= 20s", -1, MATCHER_LE },
689 { "interval = 20s", -1, MATCHER_EQ },
690 { "interval != 20s", -1, MATCHER_NE },
691 { "interval >= 20s", -1, MATCHER_GE },
692 { "interval > 20s", -1, MATCHER_GT },
693 { "'be' IN backend", -1, MATCHER_IN },
695 /* check operator precedence */
696 { "name = 'name' OR "
697 "ANY service = 'name' AND "
698 "ANY attribute = 'name' OR "
699 "attribute['foo'] = 'bar'", -1, MATCHER_OR },
700 { "name = 'name' AND "
701 "ANY service = 'name' AND "
702 "ANY attribute = 'name' OR "
703 "attribute['foo'] = 'bar'", -1, MATCHER_OR },
704 { "name = 'name' AND "
705 "ANY service = 'name' OR "
706 "ANY attribute = 'name' AND "
707 "attribute['foo'] = 'bar'", -1, MATCHER_OR },
708 { "(name = 'name' OR "
709 "ANY service = 'name') AND "
710 "(ANY attribute = 'name' OR "
711 "attribute['foo'] = 'bar')", -1, MATCHER_AND },
712 { "NOT name = 'name' OR "
713 "ANY service = 'name'", -1, MATCHER_OR },
714 { "NOT name = 'name' OR "
715 "NOT ANY service = 'name'", -1, MATCHER_OR },
716 { "NOT (name = 'name' OR "
717 "NOT ANY service = 'name')", -1, MATCHER_NOT },
719 /* syntax errors */
720 { "LIST", -1, -1 },
721 { "foo &^ bar", -1, -1 },
722 { "invalid", -1, -1 },
723 };
725 START_TEST(test_parse_matcher)
726 {
727 sdb_strbuf_t *errbuf = sdb_strbuf_create(64);
728 sdb_store_matcher_t *m;
730 m = sdb_fe_parse_matcher(parse_matcher_data[_i].expr,
731 parse_matcher_data[_i].len, errbuf);
733 if (parse_matcher_data[_i].expected < 0) {
734 fail_unless(m == NULL,
735 "sdb_fe_parse_matcher(%s) = %p; expected: NULL",
736 parse_matcher_data[_i].expr, m);
737 sdb_object_deref(SDB_OBJ(m));
738 sdb_strbuf_destroy(errbuf);
739 return;
740 }
742 fail_unless(m != NULL, "sdb_fe_parse_matcher(%s) = NULL; "
743 "expected: <matcher> (parser error: %s)",
744 parse_matcher_data[_i].expr, sdb_strbuf_string(errbuf));
745 fail_unless(M(m)->type == parse_matcher_data[_i].expected,
746 "sdb_fe_parse_matcher(%s) returned matcher of type %d; "
747 "expected: %d", parse_matcher_data[_i].expr, M(m)->type,
748 parse_matcher_data[_i].expected);
750 sdb_object_deref(SDB_OBJ(m));
751 sdb_strbuf_destroy(errbuf);
752 }
753 END_TEST
755 struct {
756 const char *expr;
757 int len;
758 int expected;
759 } parse_expr_data[] = {
760 /* empty expressions */
761 { NULL, -1, INT_MAX },
762 { "", -1, INT_MAX },
764 /* constant expressions */
765 { "'localhost'", -1, 0 },
766 { "123", -1, 0 },
767 { "2014-08-16", -1, 0 },
768 { "17:23", -1, 0 },
769 { "17:23:53", -1, 0 },
770 { "17:23:53.123", -1, 0 },
771 { "17:23:53.123456789", -1, 0 },
772 { "2014-08-16 17:23", -1, 0 },
773 { "2014-08-16 17:23:53", -1, 0 },
774 { "10s", -1, 0 },
775 { "60m", -1, 0 },
776 { "10Y 24D 1h", -1, 0 },
778 { "123 + 456", -1, 0 },
779 { "'foo' || 'bar'", -1, 0 },
780 { "456 - 123", -1, 0 },
781 { "1.2 * 3.4", -1, 0 },
782 { "1.2 / 3.4", -1, 0 },
783 { "5 % 2", -1, 0 },
785 /* queryable fields */
786 { "last_update", -1, FIELD_VALUE },
787 { "AGE", -1, FIELD_VALUE },
788 { "interval", -1, FIELD_VALUE },
789 { "Last_Update", -1, FIELD_VALUE },
790 { "backend", -1, FIELD_VALUE },
792 /* attributes */
793 { "attribute['foo']", -1, ATTR_VALUE },
795 /* arithmetic expressions */
796 { "age + age", -1, SDB_DATA_ADD },
797 { "age - age", -1, SDB_DATA_SUB },
798 { "age * age", -1, SDB_DATA_MUL },
799 { "age / age", -1, SDB_DATA_DIV },
800 { "age % age", -1, SDB_DATA_MOD },
801 { "age || age", -1, SDB_DATA_CONCAT },
803 /* operator precedence */
804 { "age + age * age", -1, SDB_DATA_ADD },
805 { "age * age + age", -1, SDB_DATA_ADD },
806 { "age + age - age", -1, SDB_DATA_SUB },
807 { "age - age + age", -1, SDB_DATA_ADD },
808 { "(age + age) * age", -1, SDB_DATA_MUL },
809 { "age + (age * age)", -1, SDB_DATA_ADD },
811 /* syntax errors */
812 { "LIST", -1, INT_MAX },
813 { "foo &^ bar", -1, INT_MAX },
814 { "invalid", -1, INT_MAX },
815 };
817 START_TEST(test_parse_expr)
818 {
819 sdb_strbuf_t *errbuf = sdb_strbuf_create(64);
820 sdb_store_expr_t *e;
822 e = sdb_fe_parse_expr(parse_expr_data[_i].expr,
823 parse_expr_data[_i].len, errbuf);
825 if (parse_expr_data[_i].expected == INT_MAX) {
826 fail_unless(e == NULL,
827 "sdb_fe_parse_expr(%s) = %p; expected: NULL",
828 parse_expr_data[_i].expr, e);
829 sdb_object_deref(SDB_OBJ(e));
830 sdb_strbuf_destroy(errbuf);
831 return;
832 }
834 fail_unless(e != NULL, "sdb_fe_parse_expr(%s) = NULL; "
835 "expected: <expr> (parser error: %s)",
836 parse_expr_data[_i].expr, sdb_strbuf_string(errbuf));
837 fail_unless(e->type == parse_expr_data[_i].expected,
838 "sdb_fe_parse_expr(%s) returned expression of type %d; "
839 "expected: %d", parse_expr_data[_i].expr, e->type,
840 parse_expr_data[_i].expected);
842 sdb_object_deref(SDB_OBJ(e));
843 sdb_strbuf_destroy(errbuf);
844 }
845 END_TEST
847 TEST_MAIN("frontend::parser")
848 {
849 TCase *tc = tcase_create("core");
850 TC_ADD_LOOP_TEST(tc, parse);
851 TC_ADD_LOOP_TEST(tc, parse_matcher);
852 TC_ADD_LOOP_TEST(tc, parse_expr);
853 ADD_TCASE(tc);
854 }
855 TEST_MAIN_END
857 /* vim: set tw=78 sw=4 ts=4 noexpandtab : */