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                 default:
 332                         return -1;
 333         }
 334 #undef CMP_NULL
 335 } /* sdb_data_cmp */
 336
 337 _Bool
 338 sdb_data_isnull(const sdb_data_t *datum)
 339 {
 340         if (! datum)
 341                 return 1;
 342         if ((datum->type == SDB_TYPE_STRING) && (! datum->data.string))
 343                 return 1;
 344         if ((datum->type == SDB_TYPE_BINARY) && (! datum->data.binary.datum))
 345                 return 1;
 346         return 0;
 347 } /* sdb_data_isnull */
 348
 349 int
 350 sdb_data_expr_eval(int op, const sdb_data_t *d1, const sdb_data_t *d2,
 351                 sdb_data_t *res)
 352 {
 353         if ((! d1) || (! d2) || (! res))
 354                 return -1;
 355         switch (op) {
 356                 case SDB_DATA_CONCAT:
 357                         return data_concat(d1, d2, res);
 358                 case SDB_DATA_ADD:
 359                         return data_lin(d1, 1, d2, res);
 360                 case SDB_DATA_SUB:
 361                         return data_lin(d1, -1, d2, res);
 362                 case SDB_DATA_MUL:
 363                         return data_mul(d1, d2, res);
 364                 case SDB_DATA_DIV:
 365                         return data_div(d1, d2, res, NULL);
 366                 case SDB_DATA_MOD:
 367                         return data_div(d1, d2, NULL, res);
 368         }
 369         return -1;
 370 } /* sdb_data_expr_eval */
 371
 372 size_t
 373 sdb_data_strlen(const sdb_data_t *datum)
 374 {
 375         if (! datum)
 376                 return 0;
 377
 378         switch (datum->type) {
 379                 case SDB_TYPE_INTEGER:
 380                         /* log(64) */
 381                         return 20;
 382                 case SDB_TYPE_DECIMAL:
 383                         /* XXX: -d.dddddde+dd or -ddddd.dddddd */
 384                         return 42;
 385                 case SDB_TYPE_STRING:
 386                         if (! datum->data.string)
 387                                 return 8; /* "<NULL>" */
 388                         /* in the worst case, each character needs to be escaped */
 389                         return 2 * strlen(datum->data.string) + 2;
 390                 case SDB_TYPE_DATETIME:
 391                         /* "YYYY-MM-DD HH:MM:SS +zzzz" */
 392                         return 27;
 393                 case SDB_TYPE_BINARY:
 394                         if (! datum->data.binary.datum)
 395                                 return 8; /* "<NULL>" */
 396                         /* "\xNN" */
 397                         return 4 * datum->data.binary.length + 2;
 398         }
 399         return 0;
 400 } /* sdb_data_strlen */
 401
 402 int
 403 sdb_data_format(const sdb_data_t *datum, char *buf, size_t buflen, int quoted)
 404 {
 405         char tmp[sdb_data_strlen(datum) + 1];
 406         char *data = NULL;
 407         int ret = -1;
 408
 409         size_t i, pos;
 410
 411         if ((! datum) || (! buf))
 412                 return -1;
 413
 414         switch (datum->type) {
 415                 case SDB_TYPE_INTEGER:
 416                         ret = snprintf(buf, buflen, "%"PRIi64, datum->data.integer);
 417                         break;
 418                 case SDB_TYPE_DECIMAL:
 419                         ret = snprintf(buf, buflen, "%g", datum->data.decimal);
 420                         break;
 421                 case SDB_TYPE_STRING:
 422                         if (! datum->data.string)
 423                                 data = "<NULL>";
 424                         else {
 425                                 pos = 0;
 426                                 for (i = 0; i < strlen(datum->data.string); ++i) {
 427                                         char byte = datum->data.string[i];
 428
 429                                         if ((byte == '\\') || (byte == '"')) {
 430                                                 tmp[pos] = '\\';
 431                                                 ++pos;
 432                                         }
 433                                         tmp[pos] = byte;
 434                                         ++pos;
 435                                 }
 436                                 tmp[pos] = '\0';
 437                                 data = tmp;
 438                         }
 439                         break;
 440                 case SDB_TYPE_DATETIME:
 441                         if (! sdb_strftime(tmp, sizeof(tmp), "%F %T %z",
 442                                                 datum->data.datetime))
 443                                 return -1;
 444                         tmp[sizeof(tmp) - 1] = '\0';
 445                         data = tmp;
 446                         break;
 447                 case SDB_TYPE_BINARY:
 448                         pos = 0;
 449                         for (i = 0; i < datum->data.binary.length; ++i) {
 450                                 int byte = (int)datum->data.binary.datum[i];
 451                                 char hex[] = {'0', '1', '2', '3', '4', '5', '6', '7',
 452                                         '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'};
 453
 454                                 tmp[pos] = '\\';
 455                                 tmp[pos + 1] = 'x';
 456                                 pos += 2;
 457
 458                                 if (byte > 0xf) {
 459                                         tmp[pos] = hex[byte >> 4];
 460                                         ++pos;
 461                                 }
 462                                 tmp[pos] = hex[byte & 0xf];
 463                                 ++pos;
 464                         }
 465                         if (datum->data.binary.datum) {
 466                                 tmp[pos] = '\0';
 467                                 data = tmp;
 468                         }
 469                         else
 470                                 data = "<NULL>";
 471                         break;
 472         }
 473
 474         if (data) {
 475                 if (quoted == SDB_UNQUOTED)
 476                         ret = snprintf(buf, buflen, "%s", data);
 477                 else if (quoted == SDB_SINGLE_QUOTED)
 478                         ret = snprintf(buf, buflen, "'%s'", data);
 479                 else
 480                         ret = snprintf(buf, buflen, "\"%s\"", data);
 481         }
 482         buf[buflen - 1] = '\0';
 483         return ret;
 484 } /* sdb_data_format */
 485
 486 int
 487 sdb_data_parse(char *str, int type, sdb_data_t *data)
 488 {
 489         sdb_data_t tmp;
 490
 491         char *endptr = NULL;
 492
 493         errno = 0;
 494         switch (type) {
 495                 case SDB_TYPE_INTEGER:
 496                         tmp.data.integer = strtoll(str, &endptr, 0);
 497                         break;
 498                 case SDB_TYPE_DECIMAL:
 499                         tmp.data.decimal = strtod(str, &endptr);
 500                         break;
 501                 case SDB_TYPE_STRING:
 502                         tmp.data.string = str;
 503                         break;
 504                 case SDB_TYPE_DATETIME:
 505                         {
 506                                 double datetime = strtod(str, &endptr);
 507                                 tmp.data.datetime = DOUBLE_TO_SDB_TIME(datetime);
 508                         }
 509                         break;
 510                 case SDB_TYPE_BINARY:
 511                         /* we don't support any binary information containing 0-bytes */
 512                         tmp.data.binary.length = strlen(str);
 513                         tmp.data.binary.datum = (unsigned char *)str;
 514                         break;
 515                 default:
 516                         errno = EINVAL;
 517                         return -1;
 518         }
 519
 520         if ((type == SDB_TYPE_INTEGER) || (type == SDB_TYPE_DECIMAL)
 521                         || (type == SDB_TYPE_DATETIME)) {
 522                 if (errno || (str == endptr)) {
 523                         char errbuf[1024];
 524                         sdb_log(SDB_LOG_ERR, "core: Failed to parse string "
 525                                         "'%s' as numeric value (type %i): %s", str, type,
 526                                         sdb_strerror(errno, errbuf, sizeof(errbuf)));
 527                         return -1;
 528                 }
 529                 else if (endptr && (*endptr != '\0'))
 530                         sdb_log(SDB_LOG_WARNING, "core: Ignoring garbage after "
 531                                         "number while parsing numeric value (type %i): %s.",
 532                                         type, endptr);
 533         }
 534
 535         if (data) {
 536                 *data = tmp;
 537                 data->type = type;
 538         }
 539         return 0;
 540 } /* sdb_data_parse */
 541
 542 /* vim: set tw=78 sw=4 ts=4 noexpandtab : */
 543