1188b4030ba4215304c4f7a47ae25e68a5feb49f
1 /*
2 * SysDB - src/core/data.c
3 * Copyright (C) 2014 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 /* HAVE_CONFIG_H */
32 #include "sysdb.h"
34 #include "core/data.h"
35 #include "utils/error.h"
37 #include <errno.h>
39 #include <inttypes.h>
41 #include <stdio.h>
42 #include <stdlib.h>
43 #include <string.h>
45 #include <math.h>
47 /*
48 * private helper functions
49 */
51 /* Calculate the linear function 'd1 + n * d2'. */
52 static int
53 data_lin(const sdb_data_t *d1, int n, const sdb_data_t *d2, sdb_data_t *res)
54 {
55 if (d1->type != d2->type)
56 return -1;
58 if (d1->type == SDB_TYPE_INTEGER)
59 res->data.integer = d1->data.integer + (int64_t)n * d2->data.integer;
60 else if (d1->type == SDB_TYPE_DECIMAL)
61 res->data.decimal = d1->data.decimal + (double)n * d2->data.decimal;
62 else if (d1->type == SDB_TYPE_DATETIME)
63 res->data.datetime = d1->data.datetime + (sdb_time_t)n * d2->data.datetime;
64 else
65 return -1;
66 res->type = d1->type;
67 return 0;
68 } /* data_lin */
70 /* Multiply d1 with d2. */
71 static int
72 data_mul(const sdb_data_t *d1, const sdb_data_t *d2, sdb_data_t *res)
73 {
74 if (d1->type == SDB_TYPE_INTEGER) {
75 if (d2->type == SDB_TYPE_INTEGER)
76 res->data.integer = d1->data.integer * d2->data.integer;
77 else if (d2->type == SDB_TYPE_DATETIME) {
78 res->data.datetime = (sdb_time_t)d1->data.integer
79 * d2->data.datetime;
80 res->type = SDB_TYPE_DATETIME;
81 return 0;
82 }
83 else
84 return -1;
85 }
86 else if (d1->type == SDB_TYPE_DECIMAL) {
87 if (d2->type == SDB_TYPE_DECIMAL)
88 res->data.decimal = d1->data.decimal * d2->data.decimal;
89 else if (d2->type == SDB_TYPE_DATETIME) {
90 res->data.datetime = (sdb_time_t)(d1->data.decimal
91 * (double)d2->data.datetime);
92 res->type = SDB_TYPE_DATETIME;
93 return 0;
94 }
95 else
96 return -1;
97 }
98 else if (d1->type == SDB_TYPE_DATETIME) {
99 if (d2->type == SDB_TYPE_DATETIME)
100 res->data.datetime = d1->data.datetime
101 * d2->data.datetime;
102 else if (d2->type == SDB_TYPE_INTEGER)
103 res->data.datetime = d1->data.datetime
104 * (sdb_time_t)d2->data.integer;
105 else if (d2->type == SDB_TYPE_DECIMAL)
106 res->data.datetime = (sdb_time_t)((double)d1->data.datetime
107 * d2->data.decimal);
108 else
109 return -1;
110 }
111 else
112 return -1;
114 res->type = d1->type;
115 return 0;
116 } /* data_mul */
118 /* Device d1 by d2 and return the result and the remainder. */
119 static int
120 data_div(const sdb_data_t *d1, const sdb_data_t *d2,
121 sdb_data_t *res, sdb_data_t *rem)
122 {
123 if (d1->type == SDB_TYPE_INTEGER) {
124 if (d2->type != SDB_TYPE_INTEGER)
125 return -1;
126 if (res)
127 res->data.integer = d1->data.integer / d2->data.integer;
128 if (rem)
129 rem->data.integer = d1->data.integer % d2->data.integer;
130 }
131 else if (d1->type == SDB_TYPE_DECIMAL) {
132 if (d2->type != SDB_TYPE_DECIMAL)
133 return -1;
134 if (res)
135 res->data.decimal = d1->data.decimal / d2->data.decimal;
136 if (rem)
137 rem->data.decimal = fmod(d1->data.decimal, d2->data.decimal);
138 }
139 else if (d1->type == SDB_TYPE_DATETIME) {
140 if (d2->type == SDB_TYPE_DECIMAL) {
141 if (res)
142 res->data.datetime = (sdb_time_t)((double)d1->data.datetime
143 / d2->data.decimal);
144 if (rem) {
145 double tmp = fmod((double)d1->data.datetime, d2->data.decimal);
146 rem->data.datetime = (sdb_time_t)tmp;
147 }
148 }
149 else {
150 sdb_time_t a, b;
151 if (d2->type == SDB_TYPE_DATETIME) {
152 a = d1->data.datetime;
153 b = d2->data.datetime;
154 }
155 else if (d2->type == SDB_TYPE_INTEGER) {
156 a = d1->data.datetime;
157 b = (sdb_time_t)d2->data.integer;
158 }
159 else
160 return -1;
161 if (res)
162 res->data.datetime = a / b;
163 if (rem)
164 rem->data.datetime = a % b;
165 }
166 }
167 else
168 return -1;
170 if (res)
171 res->type = d1->type;
172 if (rem)
173 rem->type = d1->type;
174 return 0;
175 } /* data_div */
177 /* Concatenate d1 and d2. */
178 static int
179 data_concat(const sdb_data_t *d1, const sdb_data_t *d2, sdb_data_t *res)
180 {
181 unsigned char *new;
182 unsigned char *s1, *s2;
183 size_t len1, len2;
185 if (d1->type != d2->type)
186 return -1;
188 if (d1->type == SDB_TYPE_STRING) {
189 s1 = (unsigned char *)d1->data.string;
190 s2 = (unsigned char *)d2->data.string;
191 len1 = s1 ? strlen((char *)s1) : 0;
192 len2 = s2 ? strlen((char *)s2) : 0;
193 }
194 else if (d1->type == SDB_TYPE_BINARY) {
195 s1 = d1->data.binary.datum;
196 s2 = d2->data.binary.datum;
197 len1 = d1->data.binary.length;
198 len2 = d2->data.binary.length;
199 }
200 else
201 return -1;
203 if (s1 || s2) {
204 new = malloc(len1 + len2 + 1);
205 if (! new)
206 return -1;
207 }
208 else
209 new = NULL;
211 if (len1)
212 memcpy(new, s1, len1);
213 if (len2)
214 memcpy(new + len1, s2, len2);
215 if (new)
216 new[len1 + len2] = '\0';
218 res->type = d1->type;
219 if (res->type == SDB_TYPE_STRING) {
220 res->data.string = (char *)new;
221 }
222 else {
223 res->data.binary.datum = new;
224 res->data.binary.length = len1 + len2;
225 }
226 return 0;
227 } /* data_concat */
229 /*
230 * public API
231 */
233 int
234 sdb_data_copy(sdb_data_t *dst, const sdb_data_t *src)
235 {
236 sdb_data_t tmp;
238 if ((! dst) || (! src))
239 return -1;
241 tmp = *src;
242 switch (src->type) {
243 case SDB_TYPE_STRING:
244 tmp.data.string = strdup(src->data.string);
245 if (! tmp.data.string)
246 return -1;
247 break;
248 case SDB_TYPE_BINARY:
249 tmp.data.binary.datum = malloc(src->data.binary.length);
250 if (! tmp.data.binary.datum)
251 return -1;
252 memcpy(tmp.data.binary.datum, src->data.binary.datum,
253 src->data.binary.length);
254 break;
255 }
257 sdb_data_free_datum(dst);
258 *dst = tmp;
259 return 0;
260 } /* sdb_data_copy */
262 void
263 sdb_data_free_datum(sdb_data_t *datum)
264 {
265 if (! datum)
266 return;
268 switch (datum->type) {
269 case SDB_TYPE_STRING:
270 if (datum->data.string)
271 free(datum->data.string);
272 datum->data.string = NULL;
273 break;
274 case SDB_TYPE_BINARY:
275 if (datum->data.binary.datum)
276 free(datum->data.binary.datum);
277 datum->data.binary.datum = NULL;
278 datum->data.binary.length = 0;
279 break;
280 }
281 } /* sdb_data_free_datum */
283 int
284 sdb_data_cmp(const sdb_data_t *d1, const sdb_data_t *d2)
285 {
286 #define CMP_NULL(a, b) \
287 do { \
288 if (!(a) && !(b)) return 0; \
289 if (!(a)) return -1; \
290 if (!(b)) return 1; \
291 } while (0)
293 CMP_NULL(d1, d2);
295 if (d1->type != d2->type)
296 return SDB_CMP(d1->type, d2->type);
298 switch (d1->type) {
299 case SDB_TYPE_INTEGER:
300 return SDB_CMP(d1->data.integer, d2->data.integer);
301 case SDB_TYPE_DECIMAL:
302 return SDB_CMP(d1->data.decimal, d2->data.decimal);
303 case SDB_TYPE_STRING:
304 CMP_NULL(d1->data.string, d2->data.string);
305 return strcasecmp(d1->data.string, d2->data.string);
306 case SDB_TYPE_DATETIME:
307 return SDB_CMP(d1->data.datetime, d2->data.datetime);
308 case SDB_TYPE_BINARY:
309 {
310 int diff;
312 CMP_NULL(d1->data.binary.datum, d2->data.binary.datum);
314 /* on a common prefix, the shorter datum sorts less */
315 if (d1->data.binary.length < d2->data.binary.length) {
316 diff = memcmp(d1->data.binary.datum, d2->data.binary.datum,
317 d1->data.binary.length);
318 diff = diff ? diff : -1;
319 }
320 else if (d1->data.binary.length > d2->data.binary.length) {
321 diff = memcmp(d1->data.binary.datum, d2->data.binary.datum,
322 d2->data.binary.length);
323 diff = diff ? diff : 1;
324 }
325 else
326 diff = memcmp(d1->data.binary.datum, d2->data.binary.datum,
327 d1->data.binary.length);
329 return diff;
330 }
331 default:
332 return -1;
333 }
334 #undef CMP_NULL
335 } /* sdb_data_cmp */
337 int
338 sdb_data_expr_eval(int op, const sdb_data_t *d1, const sdb_data_t *d2,
339 sdb_data_t *res)
340 {
341 if ((! d1) || (! d2) || (! res))
342 return -1;
343 switch (op) {
344 case SDB_DATA_CONCAT:
345 return data_concat(d1, d2, res);
346 case SDB_DATA_ADD:
347 return data_lin(d1, 1, d2, res);
348 case SDB_DATA_SUB:
349 return data_lin(d1, -1, d2, res);
350 case SDB_DATA_MUL:
351 return data_mul(d1, d2, res);
352 case SDB_DATA_DIV:
353 return data_div(d1, d2, res, NULL);
354 case SDB_DATA_MOD:
355 return data_div(d1, d2, NULL, res);
356 }
357 return -1;
358 } /* sdb_data_expr_eval */
360 size_t
361 sdb_data_strlen(const sdb_data_t *datum)
362 {
363 if (! datum)
364 return 0;
366 switch (datum->type) {
367 case SDB_TYPE_INTEGER:
368 /* log(64) */
369 return 20;
370 case SDB_TYPE_DECIMAL:
371 /* XXX: -0xN.NNNNNNp+NNN */
372 return 42;
373 case SDB_TYPE_STRING:
374 if (! datum->data.string)
375 return 6; /* "NULL" */
376 /* in the worst case, each character needs to be escaped */
377 return 2 * strlen(datum->data.string) + 2;
378 case SDB_TYPE_DATETIME:
379 /* "YYYY-MM-DD HH:MM:SS +zzzz" */
380 return 27;
381 case SDB_TYPE_BINARY:
382 /* "\xNN" */
383 return 4 * datum->data.binary.length + 2;
384 }
385 return 0;
386 } /* sdb_data_strlen */
388 int
389 sdb_data_format(const sdb_data_t *datum, char *buf, size_t buflen, int quoted)
390 {
391 char tmp[sdb_data_strlen(datum) + 1];
392 char *data = NULL;
393 int ret = -1;
395 size_t i, pos;
397 if ((! datum) || (! buf))
398 return -1;
400 switch (datum->type) {
401 case SDB_TYPE_INTEGER:
402 ret = snprintf(buf, buflen, "%"PRIi64, datum->data.integer);
403 break;
404 case SDB_TYPE_DECIMAL:
405 ret = snprintf(buf, buflen, "%a", datum->data.decimal);
406 break;
407 case SDB_TYPE_STRING:
408 if (! datum->data.string)
409 data = "NULL";
410 else {
411 pos = 0;
412 for (i = 0; i < strlen(datum->data.string); ++i) {
413 char byte = datum->data.string[i];
415 if ((byte == '\\') || (byte == '"')) {
416 tmp[pos] = '\\';
417 ++pos;
418 }
419 tmp[pos] = byte;
420 ++pos;
421 }
422 tmp[pos] = '\0';
423 data = tmp;
424 }
425 break;
426 case SDB_TYPE_DATETIME:
427 if (! sdb_strftime(tmp, sizeof(tmp), "%F %T %z",
428 datum->data.datetime))
429 return -1;
430 tmp[sizeof(tmp) - 1] = '\0';
431 data = tmp;
432 break;
433 case SDB_TYPE_BINARY:
434 pos = 0;
435 for (i = 0; i < datum->data.binary.length; ++i) {
436 int byte = (int)datum->data.binary.datum[i];
437 char hex[] = {'0', '1', '2', '3', '4', '5', '6', '7',
438 '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'};
440 tmp[pos] = '\\';
441 tmp[pos + 1] = 'x';
442 pos += 2;
444 if (byte > 0xf) {
445 tmp[pos] = hex[byte >> 4];
446 ++pos;
447 }
448 tmp[pos] = hex[byte & 0xf];
449 ++pos;
450 }
451 tmp[pos] = '\0';
452 data = tmp;
453 break;
454 }
456 if (data) {
457 if (quoted == SDB_UNQUOTED)
458 ret = snprintf(buf, buflen, "%s", data);
459 else if (quoted == SDB_SINGLE_QUOTED)
460 ret = snprintf(buf, buflen, "'%s'", data);
461 else
462 ret = snprintf(buf, buflen, "\"%s\"", data);
463 }
464 buf[buflen - 1] = '\0';
465 return ret;
466 } /* sdb_data_format */
468 int
469 sdb_data_parse(char *str, int type, sdb_data_t *data)
470 {
471 sdb_data_t tmp;
473 char *endptr = NULL;
475 errno = 0;
476 switch (type) {
477 case SDB_TYPE_INTEGER:
478 tmp.data.integer = strtoll(str, &endptr, 0);
479 break;
480 case SDB_TYPE_DECIMAL:
481 tmp.data.decimal = strtod(str, &endptr);
482 break;
483 case SDB_TYPE_STRING:
484 tmp.data.string = str;
485 break;
486 case SDB_TYPE_DATETIME:
487 {
488 double datetime = strtod(str, &endptr);
489 tmp.data.datetime = DOUBLE_TO_SDB_TIME(datetime);
490 }
491 break;
492 case SDB_TYPE_BINARY:
493 /* we don't support any binary information containing 0-bytes */
494 tmp.data.binary.length = strlen(str);
495 tmp.data.binary.datum = (unsigned char *)str;
496 break;
497 default:
498 errno = EINVAL;
499 return -1;
500 }
502 if ((type == SDB_TYPE_INTEGER) || (type == SDB_TYPE_DECIMAL)
503 || (type == SDB_TYPE_DATETIME)) {
504 if (errno || (str == endptr)) {
505 char errbuf[1024];
506 sdb_log(SDB_LOG_ERR, "core: Failed to parse string "
507 "'%s' as numeric value (type %i): %s", str, type,
508 sdb_strerror(errno, errbuf, sizeof(errbuf)));
509 return -1;
510 }
511 else if (endptr && (*endptr != '\0'))
512 sdb_log(SDB_LOG_WARNING, "core: Ignoring garbage after "
513 "number while parsing numeric value (type %i): %s.",
514 type, endptr);
515 }
517 if (data) {
518 *data = tmp;
519 data->type = type;
520 }
521 return 0;
522 } /* sdb_data_parse */
524 /* vim: set tw=78 sw=4 ts=4 noexpandtab : */