src/core/data.c

   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  */
  27
  28 #if HAVE_CONFIG_H
  29 #       include "config.h"
  30 #endif /* HAVE_CONFIG_H */
  31
  32 #include "sysdb.h"
  33
  34 #include "core/data.h"
  35 #include "utils/error.h"
  36
  37 #include <errno.h>
  38
  39 #include <inttypes.h>
  40
  41 #include <stdio.h>
  42 #include <stdlib.h>
  43 #include <string.h>
  44
  45 #include <math.h>
  46
  47 /*
  48  * private helper functions
  49  */
  50
  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;
  57
  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 */
  69
  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;
 113
 114         res->type = d1->type;
 115         return 0;
 116 } /* data_mul */
 117
 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;
 169
 170         if (res)
 171                 res->type = d1->type;
 172         if (rem)
 173                 rem->type = d1->type;
 174         return 0;
 175 } /* data_div */
 176
 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;
 184
 185         if (d1->type != d2->type)
 186                 return -1;
 187
 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;
 202
 203         if (s1 || s2) {
 204                 new = malloc(len1 + len2 + 1);
 205                 if (! new)
 206                         return -1;
 207         }
 208         else
 209                 new = NULL;
 210
 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';
 217
 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 */
 228
 229 /*
 230  * public API
 231  */
 232
 233 int
 234 sdb_data_copy(sdb_data_t *dst, const sdb_data_t *src)
 235 {
 236         sdb_data_t tmp;
 237
 238         if ((! dst) || (! src))
 239                 return -1;
 240
 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         }
 256
 257         sdb_data_free_datum(dst);
 258         *dst = tmp;
 259         return 0;
 260 } /* sdb_data_copy */
 261
 262 void
 263 sdb_data_free_datum(sdb_data_t *datum)
 264 {
 265         if (! datum)
 266                 return;
 267
 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 */
 282
 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)
 292
 293         CMP_NULL(d1, d2);
 294
 295         if (d1->type != d2->type)
 296                 return SDB_CMP(d1->type, d2->type);
 297
 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;
 311
 312                         CMP_NULL(d1->data.binary.datum, d2->data.binary.datum);
 313
 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);
 328
 329                         return diff;
 330                 }
 331         }
 332         return -1;
 333 } /* sdb_data_cmp */
 334
 335 int
 336 sdb_data_strcmp(const sdb_data_t *d1, const sdb_data_t *d2)
 337 {
 338         char d1_str[sdb_data_strlen(d1) + 1];
 339         char d2_str[sdb_data_strlen(d2) + 1];
 340
 341         if (sdb_data_isnull(d1))
 342                 d1 = NULL;
 343         if (sdb_data_isnull(d2))
 344                 d2 = NULL;
 345
 346         CMP_NULL(d1, d2);
 347
 348         if (sdb_data_format(d1, d1_str, sizeof(d1_str), SDB_UNQUOTED) < 0)
 349                 return SDB_CMP(sizeof(d1_str), sizeof(d2_str));
 350         if (sdb_data_format(d2, d2_str, sizeof(d2_str), SDB_UNQUOTED) < 0)
 351                 return SDB_CMP(sizeof(d1_str), sizeof(d2_str));
 352
 353         return strcasecmp(d1_str, d2_str);
 354 #undef CMP_NULL
 355 } /* sdb_data_strcmp */
 356
 357 _Bool
 358 sdb_data_isnull(const sdb_data_t *datum)
 359 {
 360         if (! datum)
 361                 return 1;
 362         if ((datum->type == SDB_TYPE_STRING) && (! datum->data.string))
 363                 return 1;
 364         if ((datum->type == SDB_TYPE_BINARY) && (! datum->data.binary.datum))
 365                 return 1;
 366         return 0;
 367 } /* sdb_data_isnull */
 368
 369 int
 370 sdb_data_expr_eval(int op, const sdb_data_t *d1, const sdb_data_t *d2,
 371                 sdb_data_t *res)
 372 {
 373         if ((! d1) || (! d2) || (! res))
 374                 return -1;
 375         switch (op) {
 376                 case SDB_DATA_CONCAT:
 377                         return data_concat(d1, d2, res);
 378                 case SDB_DATA_ADD:
 379                         return data_lin(d1, 1, d2, res);
 380                 case SDB_DATA_SUB:
 381                         return data_lin(d1, -1, d2, res);
 382                 case SDB_DATA_MUL:
 383                         return data_mul(d1, d2, res);
 384                 case SDB_DATA_DIV:
 385                         return data_div(d1, d2, res, NULL);
 386                 case SDB_DATA_MOD:
 387                         return data_div(d1, d2, NULL, res);
 388         }
 389         return -1;
 390 } /* sdb_data_expr_eval */
 391
 392 size_t
 393 sdb_data_strlen(const sdb_data_t *datum)
 394 {
 395         if (! datum)
 396                 return 0;
 397
 398         switch (datum->type) {
 399                 case SDB_TYPE_INTEGER:
 400                         /* log(64) */
 401                         return 20;
 402                 case SDB_TYPE_DECIMAL:
 403                         /* XXX: -d.dddddde+dd or -ddddd.dddddd */
 404                         return 42;
 405                 case SDB_TYPE_STRING:
 406                         if (! datum->data.string)
 407                                 return 8; /* "<NULL>" */
 408                         /* in the worst case, each character needs to be escaped */
 409                         return 2 * strlen(datum->data.string) + 2;
 410                 case SDB_TYPE_DATETIME:
 411                         /* "YYYY-MM-DD HH:MM:SS +zzzz" */
 412                         return 27;
 413                 case SDB_TYPE_BINARY:
 414                         if (! datum->data.binary.datum)
 415                                 return 8; /* "<NULL>" */
 416                         /* "\xNN" */
 417                         return 4 * datum->data.binary.length + 2;
 418         }
 419         return 0;
 420 } /* sdb_data_strlen */
 421
 422 int
 423 sdb_data_format(const sdb_data_t *datum, char *buf, size_t buflen, int quoted)
 424 {
 425         char tmp[sdb_data_strlen(datum) + 1];
 426         char *data = NULL;
 427         int ret = -1;
 428
 429         size_t i, pos;
 430
 431         if ((! datum) || (! buf))
 432                 return -1;
 433
 434         switch (datum->type) {
 435                 case SDB_TYPE_INTEGER:
 436                         ret = snprintf(buf, buflen, "%"PRIi64, datum->data.integer);
 437                         break;
 438                 case SDB_TYPE_DECIMAL:
 439                         ret = snprintf(buf, buflen, "%g", datum->data.decimal);
 440                         break;
 441                 case SDB_TYPE_STRING:
 442                         if (! datum->data.string)
 443                                 data = "<NULL>";
 444                         else {
 445                                 pos = 0;
 446                                 for (i = 0; i < strlen(datum->data.string); ++i) {
 447                                         char byte = datum->data.string[i];
 448
 449                                         if ((byte == '\\') || (byte == '"')) {
 450                                                 tmp[pos] = '\\';
 451                                                 ++pos;
 452                                         }
 453                                         tmp[pos] = byte;
 454                                         ++pos;
 455                                 }
 456                                 tmp[pos] = '\0';
 457                                 data = tmp;
 458                         }
 459                         break;
 460                 case SDB_TYPE_DATETIME:
 461                         if (! sdb_strftime(tmp, sizeof(tmp), "%F %T %z",
 462                                                 datum->data.datetime))
 463                                 return -1;
 464                         tmp[sizeof(tmp) - 1] = '\0';
 465                         data = tmp;
 466                         break;
 467                 case SDB_TYPE_BINARY:
 468                         pos = 0;
 469                         for (i = 0; i < datum->data.binary.length; ++i) {
 470                                 int byte = (int)datum->data.binary.datum[i];
 471                                 char hex[] = {'0', '1', '2', '3', '4', '5', '6', '7',
 472                                         '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'};
 473
 474                                 tmp[pos] = '\\';
 475                                 tmp[pos + 1] = 'x';
 476                                 pos += 2;
 477
 478                                 if (byte > 0xf) {
 479                                         tmp[pos] = hex[byte >> 4];
 480                                         ++pos;
 481                                 }
 482                                 tmp[pos] = hex[byte & 0xf];
 483                                 ++pos;
 484                         }
 485                         if (datum->data.binary.datum) {
 486                                 tmp[pos] = '\0';
 487                                 data = tmp;
 488                         }
 489                         else
 490                                 data = "<NULL>";
 491                         break;
 492         }
 493
 494         if (data) {
 495                 if (quoted == SDB_UNQUOTED)
 496                         ret = snprintf(buf, buflen, "%s", data);
 497                 else if (quoted == SDB_SINGLE_QUOTED)
 498                         ret = snprintf(buf, buflen, "'%s'", data);
 499                 else
 500                         ret = snprintf(buf, buflen, "\"%s\"", data);
 501         }
 502         buf[buflen - 1] = '\0';
 503         return ret;
 504 } /* sdb_data_format */
 505
 506 int
 507 sdb_data_parse(char *str, int type, sdb_data_t *data)
 508 {
 509         sdb_data_t tmp;
 510
 511         char *endptr = NULL;
 512
 513         errno = 0;
 514         switch (type) {
 515                 case SDB_TYPE_INTEGER:
 516                         tmp.data.integer = strtoll(str, &endptr, 0);
 517                         break;
 518                 case SDB_TYPE_DECIMAL:
 519                         tmp.data.decimal = strtod(str, &endptr);
 520                         break;
 521                 case SDB_TYPE_STRING:
 522                         tmp.data.string = str;
 523                         break;
 524                 case SDB_TYPE_DATETIME:
 525                         {
 526                                 double datetime = strtod(str, &endptr);
 527                                 tmp.data.datetime = DOUBLE_TO_SDB_TIME(datetime);
 528                         }
 529                         break;
 530                 case SDB_TYPE_BINARY:
 531                         /* we don't support any binary information containing 0-bytes */
 532                         tmp.data.binary.length = strlen(str);
 533                         tmp.data.binary.datum = (unsigned char *)str;
 534                         break;
 535                 default:
 536                         errno = EINVAL;
 537                         return -1;
 538         }
 539
 540         if ((type == SDB_TYPE_INTEGER) || (type == SDB_TYPE_DECIMAL)
 541                         || (type == SDB_TYPE_DATETIME)) {
 542                 if (errno || (str == endptr)) {
 543                         char errbuf[1024];
 544                         sdb_log(SDB_LOG_ERR, "core: Failed to parse string "
 545                                         "'%s' as numeric value (type %i): %s", str, type,
 546                                         sdb_strerror(errno, errbuf, sizeof(errbuf)));
 547                         return -1;
 548                 }
 549                 else if (endptr && (*endptr != '\0'))
 550                         sdb_log(SDB_LOG_WARNING, "core: Ignoring garbage after "
 551                                         "number while parsing numeric value (type %i): %s.",
 552                                         type, endptr);
 553         }
 554
 555         if (data) {
 556                 *data = tmp;
 557                 data->type = type;
 558         }
 559         return 0;
 560 } /* sdb_data_parse */
 561
 562 /* vim: set tw=78 sw=4 ts=4 noexpandtab : */
 563