2 * collectd - src/utils_db_query.c
3 * Copyright (C) 2008,2009 Florian octo Forster
5 * Permission is hereby granted, free of charge, to any person obtaining a
6 * copy of this software and associated documentation files (the "Software"),
7 * to deal in the Software without restriction, including without limitation
8 * the rights to use, copy, modify, merge, publish, distribute, sublicense,
9 * and/or sell copies of the Software, and to permit persons to whom the
10 * Software is furnished to do so, subject to the following conditions:
12 * The above copyright notice and this permission notice shall be included in
13 * all copies or substantial portions of the Software.
15 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
16 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
17 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
18 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
19 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING
20 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
21 * DEALINGS IN THE SOFTWARE.
24 * Florian octo Forster <octo at collectd.org>
31 #include "utils_db_query.h"
36 struct udb_result_s; /* {{{ */
37 typedef struct udb_result_s udb_result_t;
41 char *instance_prefix;
52 struct udb_query_s /* {{{ */
57 char *plugin_instance_from;
59 unsigned int min_version;
60 unsigned int max_version;
62 udb_result_t *results;
65 struct udb_result_preparation_area_s /* {{{ */
68 size_t *instances_pos;
71 char **instances_buffer;
73 char **metadata_buffer;
74 char *plugin_instance;
76 struct udb_result_preparation_area_s *next;
78 typedef struct udb_result_preparation_area_s udb_result_preparation_area_t;
80 struct udb_query_preparation_area_s /* {{{ */
83 size_t plugin_instance_pos;
90 udb_result_preparation_area_t *result_prep_areas;
94 * Config Private functions
96 static int udb_config_set_string (char **ret_string, /* {{{ */
101 if ((ci->values_num != 1)
102 || (ci->values[0].type != OCONFIG_TYPE_STRING))
104 WARNING ("db query utils: The `%s' config option "
105 "needs exactly one string argument.", ci->key);
109 string = strdup (ci->values[0].value.string);
112 ERROR ("db query utils: strdup failed.");
116 if (*ret_string != NULL)
118 *ret_string = string;
121 } /* }}} int udb_config_set_string */
123 static int udb_config_add_string (char ***ret_array, /* {{{ */
124 size_t *ret_array_len, oconfig_item_t *ci)
129 if (ci->values_num < 1)
131 WARNING ("db query utils: The `%s' config option "
132 "needs at least one argument.", ci->key);
136 for (int i = 0; i < ci->values_num; i++)
138 if (ci->values[i].type != OCONFIG_TYPE_STRING)
140 WARNING ("db query utils: Argument %i to the `%s' option "
141 "is not a string.", i + 1, ci->key);
146 array_len = *ret_array_len;
147 array = realloc (*ret_array,
148 sizeof (char *) * (array_len + ci->values_num));
151 ERROR ("db query utils: realloc failed.");
156 for (int i = 0; i < ci->values_num; i++)
158 array[array_len] = strdup (ci->values[i].value.string);
159 if (array[array_len] == NULL)
161 ERROR ("db query utils: strdup failed.");
162 *ret_array_len = array_len;
168 *ret_array_len = array_len;
170 } /* }}} int udb_config_add_string */
172 static int udb_config_set_uint (unsigned int *ret_value, /* {{{ */
177 if ((ci->values_num != 1)
178 || (ci->values[0].type != OCONFIG_TYPE_NUMBER))
180 WARNING ("db query utils: The `%s' config option "
181 "needs exactly one numeric argument.", ci->key);
185 tmp = ci->values[0].value.number;
186 if ((tmp < 0.0) || (tmp > ((double) UINT_MAX)))
189 *ret_value = (unsigned int) (tmp + .5);
191 } /* }}} int udb_config_set_uint */
194 * Result private functions
196 static int udb_result_submit (udb_result_t *r, /* {{{ */
197 udb_result_preparation_area_t *r_area,
198 udb_query_t const *q, udb_query_preparation_area_t *q_area)
200 value_list_t vl = VALUE_LIST_INIT;
203 assert (r_area->ds != NULL);
204 assert (((size_t) r_area->ds->ds_num) == r->values_num);
205 assert (r->values_num > 0);
207 vl.values = calloc (r->values_num, sizeof (*vl.values));
208 if (vl.values == NULL)
210 ERROR ("db query utils: calloc failed.");
213 vl.values_len = r_area->ds->ds_num;
215 for (size_t i = 0; i < r->values_num; i++)
217 char *value_str = r_area->values_buffer[i];
219 if (0 != parse_value (value_str, &vl.values[i], r_area->ds->ds[i].type))
221 ERROR ("db query utils: udb_result_submit: Parsing `%s' as %s failed.",
222 value_str, DS_TYPE_TO_STRING (r_area->ds->ds[i].type));
229 if (q_area->interval > 0)
230 vl.interval = q_area->interval;
232 sstrncpy (vl.host, q_area->host, sizeof (vl.host));
233 sstrncpy (vl.plugin, q_area->plugin, sizeof (vl.plugin));
234 sstrncpy (vl.type, r->type, sizeof (vl.type));
236 /* Set vl.plugin_instance */
237 if (q->plugin_instance_from != NULL) {
238 sstrncpy (vl.plugin_instance, r_area->plugin_instance, sizeof (vl.plugin_instance));
241 sstrncpy (vl.plugin_instance, q_area->db_name, sizeof (vl.plugin_instance));
244 /* Set vl.type_instance {{{ */
245 if (r->instances_num == 0)
247 if (r->instance_prefix == NULL)
248 vl.type_instance[0] = 0;
250 sstrncpy (vl.type_instance, r->instance_prefix,
251 sizeof (vl.type_instance));
253 else /* if ((r->instances_num > 0) */
255 if (r->instance_prefix == NULL)
257 int status = strjoin (vl.type_instance, sizeof (vl.type_instance),
258 r_area->instances_buffer, r->instances_num, "-");
261 ERROR ("udb_result_submit: creating type_instance failed with status %d.",
268 char tmp[DATA_MAX_NAME_LEN];
270 int status = strjoin (tmp, sizeof (tmp), r_area->instances_buffer,
271 r->instances_num, "-");
274 ERROR ("udb_result_submit: creating type_instance failed with status %d.",
278 tmp[sizeof (tmp) - 1] = 0;
280 snprintf (vl.type_instance, sizeof (vl.type_instance), "%s-%s",
281 r->instance_prefix, tmp);
284 vl.type_instance[sizeof (vl.type_instance) - 1] = 0;
287 /* Annotate meta data. {{{ */
288 if (r->metadata_num > 0)
290 vl.meta = meta_data_create ();
293 ERROR ("db query utils:: meta_data_create failed.");
297 for (size_t i = 0; i < r->metadata_num; i++)
299 int status = meta_data_add_string (vl.meta, r->metadata[i],
300 r_area->metadata_buffer[i]);
303 ERROR ("db query utils:: meta_data_add_string failed.");
304 meta_data_destroy (vl.meta);
312 plugin_dispatch_values (&vl);
314 if (r->metadata_num > 0)
316 meta_data_destroy (vl.meta);
321 } /* }}} void udb_result_submit */
323 static void udb_result_finish_result (udb_result_t const *r, /* {{{ */
324 udb_result_preparation_area_t *prep_area)
326 if ((r == NULL) || (prep_area == NULL))
329 prep_area->ds = NULL;
330 sfree (prep_area->instances_pos);
331 sfree (prep_area->values_pos);
332 sfree (prep_area->metadata_pos);
333 sfree (prep_area->instances_buffer);
334 sfree (prep_area->values_buffer);
335 sfree (prep_area->metadata_buffer);
336 } /* }}} void udb_result_finish_result */
338 static int udb_result_handle_result (udb_result_t *r, /* {{{ */
339 udb_query_preparation_area_t *q_area,
340 udb_result_preparation_area_t *r_area,
341 udb_query_t const *q, char **column_values)
343 assert (r && q_area && r_area);
345 for (size_t i = 0; i < r->instances_num; i++)
346 r_area->instances_buffer[i] = column_values[r_area->instances_pos[i]];
348 for (size_t i = 0; i < r->values_num; i++)
349 r_area->values_buffer[i] = column_values[r_area->values_pos[i]];
351 for (size_t i = 0; i < r->metadata_num; i++)
352 r_area->metadata_buffer[i] = column_values[r_area->metadata_pos[i]];
354 if (q->plugin_instance_from)
355 r_area->plugin_instance = column_values[q_area->plugin_instance_pos];
357 return udb_result_submit (r, r_area, q, q_area);
358 } /* }}} int udb_result_handle_result */
360 static int udb_result_prepare_result (udb_result_t const *r, /* {{{ */
361 udb_result_preparation_area_t *prep_area,
362 char **column_names, size_t column_num)
364 if ((r == NULL) || (prep_area == NULL))
367 #define BAIL_OUT(status) \
368 prep_area->ds = NULL; \
369 sfree (prep_area->instances_pos); \
370 sfree (prep_area->values_pos); \
371 sfree (prep_area->metadata_pos); \
372 sfree (prep_area->instances_buffer); \
373 sfree (prep_area->values_buffer); \
374 sfree (prep_area->metadata_buffer); \
377 /* Make sure previous preparations are cleaned up. */
378 udb_result_finish_result (r, prep_area);
379 prep_area->instances_pos = NULL;
380 prep_area->values_pos = NULL;
381 prep_area->metadata_pos = NULL;
383 /* Read `ds' and check number of values {{{ */
384 prep_area->ds = plugin_get_ds (r->type);
385 if (prep_area->ds == NULL)
387 ERROR ("db query utils: udb_result_prepare_result: Type `%s' is not "
388 "known by the daemon. See types.db(5) for details.",
393 if (prep_area->ds->ds_num != r->values_num)
395 ERROR ("db query utils: udb_result_prepare_result: The type `%s' "
396 "requires exactly %zu value%s, but the configuration specifies %zu.",
398 prep_area->ds->ds_num, (prep_area->ds->ds_num == 1) ? "" : "s",
404 /* Allocate r->instances_pos, r->values_pos, r->metadata_post,
405 * r->instances_buffer, r->values_buffer, and r->metadata_buffer {{{ */
406 if (r->instances_num > 0)
408 prep_area->instances_pos
409 = (size_t *) calloc (r->instances_num, sizeof (size_t));
410 if (prep_area->instances_pos == NULL)
412 ERROR ("db query utils: udb_result_prepare_result: calloc failed.");
416 prep_area->instances_buffer
417 = (char **) calloc (r->instances_num, sizeof (char *));
418 if (prep_area->instances_buffer == NULL)
420 ERROR ("db query utils: udb_result_prepare_result: calloc failed.");
423 } /* if (r->instances_num > 0) */
425 prep_area->values_pos
426 = (size_t *) calloc (r->values_num, sizeof (size_t));
427 if (prep_area->values_pos == NULL)
429 ERROR ("db query utils: udb_result_prepare_result: calloc failed.");
433 prep_area->values_buffer
434 = (char **) calloc (r->values_num, sizeof (char *));
435 if (prep_area->values_buffer == NULL)
437 ERROR ("db query utils: udb_result_prepare_result: calloc failed.");
441 prep_area->metadata_pos
442 = (size_t *) calloc (r->metadata_num, sizeof (size_t));
443 if (prep_area->metadata_pos == NULL)
445 ERROR ("db query utils: udb_result_prepare_result: calloc failed.");
449 prep_area->metadata_buffer
450 = (char **) calloc (r->metadata_num, sizeof (char *));
451 if (prep_area->metadata_buffer == NULL)
453 ERROR ("db query utils: udb_result_prepare_result: calloc failed.");
459 /* Determine the position of the plugin instance column {{{ */
460 for (size_t i = 0; i < r->instances_num; i++)
464 for (j = 0; j < column_num; j++)
466 if (strcasecmp (r->instances[i], column_names[j]) == 0)
468 prep_area->instances_pos[i] = j;
475 ERROR ("db query utils: udb_result_prepare_result: "
476 "Column `%s' could not be found.",
480 } /* }}} for (i = 0; i < r->instances_num; i++) */
483 /* Determine the position of the value columns {{{ */
484 for (size_t i = 0; i < r->values_num; i++)
488 for (j = 0; j < column_num; j++)
490 if (strcasecmp (r->values[i], column_names[j]) == 0)
492 prep_area->values_pos[i] = j;
499 ERROR ("db query utils: udb_result_prepare_result: "
500 "Column `%s' could not be found.",
504 } /* }}} for (i = 0; i < r->values_num; i++) */
506 /* Determine the position of the metadata columns {{{ */
507 for (size_t i = 0; i < r->metadata_num; i++)
511 for (j = 0; j < column_num; j++)
513 if (strcasecmp (r->metadata[i], column_names[j]) == 0)
515 prep_area->metadata_pos[i] = j;
522 ERROR ("db query utils: udb_result_prepare_result: "
523 "Metadata column `%s' could not be found.",
527 } /* }}} for (i = 0; i < r->metadata_num; i++) */
531 } /* }}} int udb_result_prepare_result */
533 static void udb_result_free (udb_result_t *r) /* {{{ */
539 sfree (r->instance_prefix);
541 for (size_t i = 0; i < r->instances_num; i++)
542 sfree (r->instances[i]);
543 sfree (r->instances);
545 for (size_t i = 0; i < r->values_num; i++)
546 sfree (r->values[i]);
549 for (size_t i = 0; i < r->metadata_num; i++)
550 sfree (r->metadata[i]);
553 udb_result_free (r->next);
556 } /* }}} void udb_result_free */
558 static int udb_result_create (const char *query_name, /* {{{ */
559 udb_result_t **r_head, oconfig_item_t *ci)
564 if (ci->values_num != 0)
566 WARNING ("db query utils: The `Result' block doesn't accept "
567 "any arguments. Ignoring %i argument%s.",
568 ci->values_num, (ci->values_num == 1) ? "" : "s");
571 r = calloc (1, sizeof (*r));
574 ERROR ("db query utils: calloc failed.");
578 r->instance_prefix = NULL;
584 /* Fill the `udb_result_t' structure.. */
586 for (int i = 0; i < ci->children_num; i++)
588 oconfig_item_t *child = ci->children + i;
590 if (strcasecmp ("Type", child->key) == 0)
591 status = udb_config_set_string (&r->type, child);
592 else if (strcasecmp ("InstancePrefix", child->key) == 0)
593 status = udb_config_set_string (&r->instance_prefix, child);
594 else if (strcasecmp ("InstancesFrom", child->key) == 0)
595 status = udb_config_add_string (&r->instances, &r->instances_num, child);
596 else if (strcasecmp ("ValuesFrom", child->key) == 0)
597 status = udb_config_add_string (&r->values, &r->values_num, child);
598 else if (strcasecmp ("MetadataFrom", child->key) == 0)
599 status = udb_config_add_string (&r->metadata, &r->metadata_num, child);
602 WARNING ("db query utils: Query `%s': Option `%s' not allowed here.",
603 query_name, child->key);
611 /* Check that all necessary options have been given. */
616 WARNING ("db query utils: `Type' not given for "
617 "result in query `%s'", query_name);
620 if (r->values == NULL)
622 WARNING ("db query utils: `ValuesFrom' not given for "
623 "result in query `%s'", query_name);
628 } /* while (status == 0) */
636 /* If all went well, add this result to the list of results. */
646 while (last->next != NULL)
653 } /* }}} int udb_result_create */
656 * Query private functions
658 static void udb_query_free_one (udb_query_t *q) /* {{{ */
664 sfree (q->statement);
665 sfree (q->plugin_instance_from);
667 udb_result_free (q->results);
670 } /* }}} void udb_query_free_one */
673 * Query public functions
675 int udb_query_create (udb_query_t ***ret_query_list, /* {{{ */
676 size_t *ret_query_list_len, oconfig_item_t *ci,
677 udb_query_create_callback_t cb)
679 udb_query_t **query_list;
680 size_t query_list_len;
685 if ((ret_query_list == NULL) || (ret_query_list_len == NULL))
687 query_list = *ret_query_list;
688 query_list_len = *ret_query_list_len;
690 if ((ci->values_num != 1)
691 || (ci->values[0].type != OCONFIG_TYPE_STRING))
693 WARNING ("db query utils: The `Query' block "
694 "needs exactly one string argument.");
698 q = calloc (1, sizeof (*q));
701 ERROR ("db query utils: calloc failed.");
705 q->max_version = UINT_MAX;
708 q->plugin_instance_from = NULL;
710 status = udb_config_set_string (&q->name, ci);
717 /* Fill the `udb_query_t' structure.. */
718 for (int i = 0; i < ci->children_num; i++)
720 oconfig_item_t *child = ci->children + i;
722 if (strcasecmp ("Statement", child->key) == 0)
723 status = udb_config_set_string (&q->statement, child);
724 else if (strcasecmp ("Result", child->key) == 0)
725 status = udb_result_create (q->name, &q->results, child);
726 else if (strcasecmp ("MinVersion", child->key) == 0)
727 status = udb_config_set_uint (&q->min_version, child);
728 else if (strcasecmp ("MaxVersion", child->key) == 0)
729 status = udb_config_set_uint (&q->max_version, child);
730 else if (strcasecmp ("PluginInstanceFrom", child->key) == 0)
731 status = udb_config_set_string (&q->plugin_instance_from, child);
733 /* Call custom callbacks */
736 status = (*cb) (q, child);
739 WARNING ("db query utils: The configuration callback failed "
740 "to handle `%s'.", child->key);
745 WARNING ("db query utils: Query `%s': Option `%s' not allowed here.",
746 q->name, child->key);
754 /* Check that all necessary options have been given. */
757 if (q->statement == NULL)
759 WARNING ("db query utils: Query `%s': No `Statement' given.", q->name);
762 if (q->results == NULL)
764 WARNING ("db query utils: Query `%s': No (valid) `Result' block given.",
768 } /* if (status == 0) */
770 /* If all went well, add this query to the list of queries within the
771 * database structure. */
776 temp = realloc (query_list,
777 sizeof (*query_list) * (query_list_len + 1));
780 ERROR ("db query utils: realloc failed");
786 query_list[query_list_len] = q;
793 udb_query_free_one (q);
797 *ret_query_list = query_list;
798 *ret_query_list_len = query_list_len;
801 } /* }}} int udb_query_create */
803 void udb_query_free (udb_query_t **query_list, size_t query_list_len) /* {{{ */
805 if (query_list == NULL)
808 for (size_t i = 0; i < query_list_len; i++)
809 udb_query_free_one (query_list[i]);
812 } /* }}} void udb_query_free */
814 int udb_query_pick_from_list_by_name (const char *name, /* {{{ */
815 udb_query_t **src_list, size_t src_list_len,
816 udb_query_t ***dst_list, size_t *dst_list_len)
820 if ((name == NULL) || (src_list == NULL) || (dst_list == NULL)
821 || (dst_list_len == NULL))
823 ERROR ("db query utils: udb_query_pick_from_list_by_name: "
824 "Invalid argument.");
829 for (size_t i = 0; i < src_list_len; i++)
831 udb_query_t **tmp_list;
834 if (strcasecmp (name, src_list[i]->name) != 0)
837 tmp_list_len = *dst_list_len;
838 tmp_list = realloc (*dst_list, (tmp_list_len + 1)
839 * sizeof (udb_query_t *));
840 if (tmp_list == NULL)
842 ERROR ("db query utils: realloc failed.");
846 tmp_list[tmp_list_len] = src_list[i];
849 *dst_list = tmp_list;
850 *dst_list_len = tmp_list_len;
853 } /* for (i = 0; i < src_list_len; i++) */
857 ERROR ("db query utils: Cannot find query `%s'. Make sure the <Query> "
858 "block is above the database definition!",
864 DEBUG ("db query utils: Added %i versions of query `%s'.",
869 } /* }}} int udb_query_pick_from_list_by_name */
871 int udb_query_pick_from_list (oconfig_item_t *ci, /* {{{ */
872 udb_query_t **src_list, size_t src_list_len,
873 udb_query_t ***dst_list, size_t *dst_list_len)
877 if ((ci == NULL) || (src_list == NULL) || (dst_list == NULL)
878 || (dst_list_len == NULL))
880 ERROR ("db query utils: udb_query_pick_from_list: "
881 "Invalid argument.");
885 if ((ci->values_num != 1)
886 || (ci->values[0].type != OCONFIG_TYPE_STRING))
888 ERROR ("db query utils: The `%s' config option "
889 "needs exactly one string argument.", ci->key);
892 name = ci->values[0].value.string;
894 return (udb_query_pick_from_list_by_name (name,
895 src_list, src_list_len,
896 dst_list, dst_list_len));
897 } /* }}} int udb_query_pick_from_list */
899 const char *udb_query_get_name (udb_query_t *q) /* {{{ */
905 } /* }}} const char *udb_query_get_name */
907 const char *udb_query_get_statement (udb_query_t *q) /* {{{ */
912 return (q->statement);
913 } /* }}} const char *udb_query_get_statement */
915 void udb_query_set_user_data (udb_query_t *q, void *user_data) /* {{{ */
920 q->user_data = user_data;
921 } /* }}} void udb_query_set_user_data */
923 void *udb_query_get_user_data (udb_query_t *q) /* {{{ */
928 return (q->user_data);
929 } /* }}} void *udb_query_get_user_data */
931 int udb_query_check_version (udb_query_t *q, unsigned int version) /* {{{ */
936 if ((version < q->min_version) || (version > q->max_version))
940 } /* }}} int udb_query_check_version */
942 void udb_query_finish_result (udb_query_t const *q, /* {{{ */
943 udb_query_preparation_area_t *prep_area)
945 udb_result_preparation_area_t *r_area;
948 if ((q == NULL) || (prep_area == NULL))
951 prep_area->column_num = 0;
952 sfree (prep_area->host);
953 sfree (prep_area->plugin);
954 sfree (prep_area->db_name);
956 prep_area->interval = 0;
958 for (r = q->results, r_area = prep_area->result_prep_areas;
959 r != NULL; r = r->next, r_area = r_area->next)
961 /* this may happen during error conditions of the caller */
964 udb_result_finish_result (r, r_area);
966 } /* }}} void udb_query_finish_result */
968 int udb_query_handle_result (udb_query_t const *q, /* {{{ */
969 udb_query_preparation_area_t *prep_area, char **column_values)
971 udb_result_preparation_area_t *r_area;
976 if ((q == NULL) || (prep_area == NULL))
979 if ((prep_area->column_num < 1) || (prep_area->host == NULL)
980 || (prep_area->plugin == NULL) || (prep_area->db_name == NULL))
982 ERROR ("db query utils: Query `%s': Query is not prepared; "
983 "can't handle result.", q->name);
987 #if defined(COLLECT_DEBUG) && COLLECT_DEBUG /* {{{ */
990 for (size_t i = 0; i < prep_area->column_num; i++)
992 DEBUG ("db query utils: udb_query_handle_result (%s, %s): "
994 prep_area->db_name, q->name, i, column_values[i]);
1000 for (r = q->results, r_area = prep_area->result_prep_areas;
1001 r != NULL; r = r->next, r_area = r_area->next)
1003 status = udb_result_handle_result (r, prep_area, r_area,
1011 ERROR ("db query utils: udb_query_handle_result (%s, %s): "
1012 "All results failed.", prep_area->db_name, q->name);
1017 } /* }}} int udb_query_handle_result */
1019 int udb_query_prepare_result (udb_query_t const *q, /* {{{ */
1020 udb_query_preparation_area_t *prep_area,
1021 const char *host, const char *plugin, const char *db_name,
1022 char **column_names, size_t column_num, cdtime_t interval)
1024 udb_result_preparation_area_t *r_area;
1028 if ((q == NULL) || (prep_area == NULL))
1031 udb_query_finish_result (q, prep_area);
1033 prep_area->column_num = column_num;
1034 prep_area->host = strdup (host);
1035 prep_area->plugin = strdup (plugin);
1036 prep_area->db_name = strdup (db_name);
1038 prep_area->interval = interval;
1040 if ((prep_area->host == NULL) || (prep_area->plugin == NULL)
1041 || (prep_area->db_name == NULL))
1043 ERROR ("db query utils: Query `%s': Prepare failed: Out of memory.", q->name);
1044 udb_query_finish_result (q, prep_area);
1048 #if defined(COLLECT_DEBUG) && COLLECT_DEBUG
1051 for (size_t i = 0; i < column_num; i++)
1053 DEBUG ("db query utils: udb_query_prepare_result: "
1054 "query = %s; column[%zu] = %s;",
1055 q->name, i, column_names[i]);
1060 /* Determine the position of the PluginInstance column {{{ */
1061 if (q->plugin_instance_from != NULL)
1065 for (i = 0; i < column_num; i++)
1067 if (strcasecmp (q->plugin_instance_from, column_names[i]) == 0)
1069 prep_area->plugin_instance_pos = i;
1074 if (i >= column_num)
1076 ERROR ("db query utils: udb_query_prepare_result: "
1077 "Column `%s' from `PluginInstanceFrom' could not be found.",
1078 q->plugin_instance_from);
1079 udb_query_finish_result (q, prep_area);
1085 for (r = q->results, r_area = prep_area->result_prep_areas;
1086 r != NULL; r = r->next, r_area = r_area->next)
1090 ERROR ("db query utils: Query `%s': Invalid number of result "
1091 "preparation areas.", q->name);
1092 udb_query_finish_result (q, prep_area);
1096 status = udb_result_prepare_result (r, r_area, column_names, column_num);
1099 udb_query_finish_result (q, prep_area);
1105 } /* }}} int udb_query_prepare_result */
1107 udb_query_preparation_area_t *
1108 udb_query_allocate_preparation_area (udb_query_t *q) /* {{{ */
1110 udb_query_preparation_area_t *q_area;
1111 udb_result_preparation_area_t **next_r_area;
1114 q_area = calloc (1, sizeof (*q_area));
1118 next_r_area = &q_area->result_prep_areas;
1119 for (r = q->results; r != NULL; r = r->next)
1121 udb_result_preparation_area_t *r_area;
1123 r_area = calloc (1, sizeof (*r_area));
1126 udb_result_preparation_area_t *a = q_area->result_prep_areas;
1130 udb_result_preparation_area_t *next = a->next;
1139 *next_r_area = r_area;
1140 next_r_area = &r_area->next;
1144 } /* }}} udb_query_preparation_area_t *udb_query_allocate_preparation_area */
1147 udb_query_delete_preparation_area (udb_query_preparation_area_t *q_area) /* {{{ */
1149 udb_result_preparation_area_t *r_area;
1154 r_area = q_area->result_prep_areas;
1155 while (r_area != NULL)
1157 udb_result_preparation_area_t *area = r_area;
1159 r_area = r_area->next;
1161 sfree (area->instances_pos);
1162 sfree (area->values_pos);
1163 sfree (area->instances_buffer);
1164 sfree (area->values_buffer);
1168 sfree (q_area->host);
1169 sfree (q_area->plugin);
1170 sfree (q_area->db_name);
1173 } /* }}} void udb_query_delete_preparation_area */
1175 /* vim: set sw=2 sts=2 et fdm=marker : */