2 * collectd - src/utils_db_query.c
3 * Copyright (C) 2008,2009 Florian octo Forster
5 * This program is free software; you can redistribute it and/or modify it
6 * under the terms of the GNU General Public License as published by the
7 * Free Software Foundation; only version 2 of the License is applicable.
9 * This program is distributed in the hope that it will be useful, but
10 * WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
12 * General Public License for more details.
14 * You should have received a copy of the GNU General Public License along
15 * with this program; if not, write to the Free Software Foundation, Inc.,
16 * 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
19 * Florian octo Forster <octo at verplant.org>
25 #include "configfile.h"
26 #include "utils_db_query.h"
31 struct udb_result_s; /* {{{ */
32 typedef struct udb_result_s udb_result_t;
36 char *instance_prefix;
42 /* Preparation area */
44 size_t *instances_pos;
46 char **instances_buffer;
51 size_t legacy_position;
52 /* When in legacy mode:
53 * - type/ds hold the format of the data
54 * - instance_prefix is used as type-instance if non-NULL
55 * - legacy_position holds the index of the column to use as value.
61 struct udb_query_s /* {{{ */
69 unsigned int min_version;
70 unsigned int max_version;
72 /* Preparation area */
78 udb_result_t *results;
82 * Config Private functions
84 static int udb_config_set_string (char **ret_string, /* {{{ */
89 if ((ci->values_num != 1)
90 || (ci->values[0].type != OCONFIG_TYPE_STRING))
92 WARNING ("db query utils: The `%s' config option "
93 "needs exactly one string argument.", ci->key);
97 string = strdup (ci->values[0].value.string);
100 ERROR ("db query utils: strdup failed.");
104 if (*ret_string != NULL)
106 *ret_string = string;
109 } /* }}} int udb_config_set_string */
111 static int udb_config_add_string (char ***ret_array, /* {{{ */
112 size_t *ret_array_len, oconfig_item_t *ci)
118 if (ci->values_num < 1)
120 WARNING ("db query utils: The `%s' config option "
121 "needs at least one argument.", ci->key);
125 for (i = 0; i < ci->values_num; i++)
127 if (ci->values[i].type != OCONFIG_TYPE_STRING)
129 WARNING ("db query utils: Argument %i to the `%s' option "
130 "is not a string.", i + 1, ci->key);
135 array_len = *ret_array_len;
136 array = (char **) realloc (*ret_array,
137 sizeof (char *) * (array_len + ci->values_num));
140 ERROR ("db query utils: realloc failed.");
145 for (i = 0; i < ci->values_num; i++)
147 array[array_len] = strdup (ci->values[i].value.string);
148 if (array[array_len] == NULL)
150 ERROR ("db query utils: strdup failed.");
151 *ret_array_len = array_len;
157 *ret_array_len = array_len;
159 } /* }}} int udb_config_add_string */
161 static int udb_config_set_uint (unsigned int *ret_value, /* {{{ */
166 if ((ci->values_num != 1)
167 || (ci->values[0].type != OCONFIG_TYPE_NUMBER))
169 WARNING ("db query utils: The `%s' config option "
170 "needs exactly one numeric argument.", ci->key);
174 tmp = ci->values[0].value.number;
175 if ((tmp < 0.0) || (tmp > ((double) UINT_MAX)))
178 *ret_value = (unsigned int) (tmp + .5);
180 } /* }}} int udb_config_set_uint */
183 * Legacy result private functions
185 static void udb_legacy_result_finish_result (udb_result_t *r) /* {{{ */
190 assert (r->legacy_mode == 1);
193 } /* }}} void udb_legacy_result_finish_result */
195 static int udb_legacy_result_handle_result (udb_result_t *r, /* {{{ */
196 udb_query_t *q, char **column_values)
198 value_list_t vl = VALUE_LIST_INIT;
202 assert (r->legacy_mode == 1);
203 assert (r->ds != NULL);
204 assert (r->ds->ds_num == 1);
211 if (r->ds->ds[0].type == DS_TYPE_COUNTER)
212 vl.values[0].counter = (counter_t) strtoll (column_values[r->legacy_position],
213 &endptr, /* base = */ 0);
214 else if (r->ds->ds[0].type == DS_TYPE_GAUGE)
215 vl.values[0].gauge = (gauge_t) strtod (column_values[r->legacy_position],
220 if ((endptr == column_values[r->legacy_position]) || (errno != 0))
222 WARNING ("db query utils: udb_result_submit: Parsing `%s' as %s failed.",
223 column_values[r->legacy_position],
224 (r->ds->ds[0].type == DS_TYPE_COUNTER) ? "counter" : "gauge");
225 vl.values[0].gauge = NAN;
228 sstrncpy (vl.host, q->host, sizeof (vl.host));
229 sstrncpy (vl.plugin, q->plugin, sizeof (vl.plugin));
230 sstrncpy (vl.plugin_instance, q->db_name, sizeof (vl.type_instance));
231 sstrncpy (vl.type, r->type, sizeof (vl.type));
233 if (r->instance_prefix != NULL)
234 sstrncpy (vl.type_instance, r->instance_prefix,
235 sizeof (vl.type_instance));
237 plugin_dispatch_values (&vl);
240 } /* }}} int udb_legacy_result_handle_result */
242 static int udb_legacy_result_prepare_result (udb_result_t *r, /* {{{ */
243 char **column_names, size_t column_num)
248 assert (r->legacy_mode == 1);
250 /* Make sure previous preparations are cleaned up. */
251 udb_legacy_result_finish_result (r);
253 if (r->legacy_position >= column_num)
255 ERROR ("db query utils: The legacy configuration specified (at least) "
256 "%zu `Column's, but the query returned only %zu columns!",
257 r->legacy_position + 1, column_num);
261 /* Read `ds' and check number of values {{{ */
262 r->ds = plugin_get_ds (r->type);
265 ERROR ("db query utils: udb_result_prepare_result: Type `%s' is not "
266 "known by the daemon. See types.db(5) for details.",
271 if (r->ds->ds_num != 1)
273 ERROR ("db query utils: udb_result_prepare_result: The type `%s' "
274 "requires exactly %i values, but the legacy configuration "
275 "requires exactly one!",
283 } /* }}} int udb_legacy_result_prepare_result */
285 static int udb_legacy_result_create (const char *query_name, /* {{{ */
286 udb_result_t **r_head, oconfig_item_t *ci, size_t position)
290 if ((ci->values_num < 1) || (ci->values_num > 2)
291 || (ci->values[0].type != OCONFIG_TYPE_STRING)
292 || ((ci->values_num == 2)
293 && (ci->values[1].type != OCONFIG_TYPE_STRING)))
295 WARNING ("db query utils: The `Column' block needs either one or two "
296 "string arguments.");
300 r = (udb_result_t *) malloc (sizeof (*r));
303 ERROR ("db query utils: malloc failed.");
306 memset (r, 0, sizeof (*r));
309 r->legacy_position = position;
311 r->type = strdup (ci->values[0].value.string);
314 ERROR ("db query utils: strdup failed.");
319 r->instance_prefix = NULL;
320 if (ci->values_num == 2)
322 r->instance_prefix = strdup (ci->values[1].value.string);
323 if (r->instance_prefix == NULL)
325 ERROR ("db query utils: strdup failed.");
332 /* If all went well, add this result to the list of results. */
342 while (last->next != NULL)
349 } /* }}} int udb_legacy_result_create */
352 * Result private functions
354 static void udb_result_submit (udb_result_t *r, udb_query_t *q) /* {{{ */
356 value_list_t vl = VALUE_LIST_INIT;
360 assert (r->legacy_mode == 0);
361 assert (r->ds != NULL);
362 assert (((size_t) r->ds->ds_num) == r->values_num);
364 vl.values = (value_t *) calloc (r->ds->ds_num, sizeof (value_t));
365 if (vl.values == NULL)
367 ERROR ("db query utils: malloc failed.");
370 vl.values_len = r->ds->ds_num;
372 for (i = 0; i < r->values_num; i++)
378 if (r->ds->ds[i].type == DS_TYPE_COUNTER)
379 vl.values[i].counter = (counter_t) strtoll (r->values_buffer[i],
380 &endptr, /* base = */ 0);
381 else if (r->ds->ds[i].type == DS_TYPE_GAUGE)
382 vl.values[i].gauge = (gauge_t) strtod (r->values_buffer[i], &endptr);
386 if ((endptr == r->values_buffer[i]) || (errno != 0))
388 WARNING ("db query utils: udb_result_submit: Parsing `%s' as %s failed.",
390 (r->ds->ds[i].type == DS_TYPE_COUNTER) ? "counter" : "gauge");
391 vl.values[i].gauge = NAN;
395 sstrncpy (vl.host, q->host, sizeof (vl.host));
396 sstrncpy (vl.plugin, q->plugin, sizeof (vl.plugin));
397 sstrncpy (vl.plugin_instance, q->db_name, sizeof (vl.type_instance));
398 sstrncpy (vl.type, r->type, sizeof (vl.type));
400 /* Set vl.type_instance {{{ */
401 if (r->instances_num <= 0)
403 if (r->instance_prefix == NULL)
404 vl.type_instance[0] = 0;
406 sstrncpy (vl.type_instance, r->instance_prefix,
407 sizeof (vl.type_instance));
409 else /* if ((r->instances_num > 0) */
411 if (r->instance_prefix == NULL)
413 strjoin (vl.type_instance, sizeof (vl.type_instance),
414 r->instances_buffer, r->instances_num, "-");
418 char tmp[DATA_MAX_NAME_LEN];
420 strjoin (tmp, sizeof (tmp), r->instances_buffer, r->instances_num, "-");
421 tmp[sizeof (tmp) - 1] = 0;
423 snprintf (vl.type_instance, sizeof (vl.type_instance), "%s-%s",
424 r->instance_prefix, tmp);
427 vl.type_instance[sizeof (vl.type_instance) - 1] = 0;
430 plugin_dispatch_values (&vl);
433 } /* }}} void udb_result_submit */
435 static void udb_result_finish_result (udb_result_t *r) /* {{{ */
440 if (r->legacy_mode == 1)
442 udb_legacy_result_finish_result (r);
446 assert (r->legacy_mode == 0);
449 sfree (r->instances_pos);
450 sfree (r->values_pos);
451 sfree (r->instances_buffer);
452 sfree (r->values_buffer);
453 } /* }}} void udb_result_finish_result */
455 static int udb_result_handle_result (udb_result_t *r, /* {{{ */
456 udb_query_t *q, char **column_values)
460 if (r->legacy_mode == 1)
461 return (udb_legacy_result_handle_result (r, q, column_values));
463 assert (r->legacy_mode == 0);
465 for (i = 0; i < r->instances_num; i++)
466 r->instances_buffer[i] = column_values[r->instances_pos[i]];
468 for (i = 0; i < r->values_num; i++)
469 r->values_buffer[i] = column_values[r->values_pos[i]];
471 udb_result_submit (r, q);
474 } /* }}} int udb_result_handle_result */
476 static int udb_result_prepare_result (udb_result_t *r, /* {{{ */
477 char **column_names, size_t column_num)
484 if (r->legacy_mode == 1)
485 return (udb_legacy_result_prepare_result (r, column_names, column_num));
487 assert (r->legacy_mode == 0);
489 #define BAIL_OUT(status) \
491 sfree (r->instances_pos); \
492 sfree (r->values_pos); \
493 sfree (r->instances_buffer); \
494 sfree (r->values_buffer); \
497 /* Make sure previous preparations are cleaned up. */
498 udb_result_finish_result (r);
499 r->instances_pos = NULL;
500 r->values_pos = NULL;
502 /* Read `ds' and check number of values {{{ */
503 r->ds = plugin_get_ds (r->type);
506 ERROR ("db query utils: udb_result_prepare_result: Type `%s' is not "
507 "known by the daemon. See types.db(5) for details.",
512 if (((size_t) r->ds->ds_num) != r->values_num)
514 ERROR ("db query utils: udb_result_prepare_result: The type `%s' "
515 "requires exactly %i value%s, but the configuration specifies %zu.",
517 r->ds->ds_num, (r->ds->ds_num == 1) ? "" : "s",
523 /* Allocate r->instances_pos, r->values_pos, r->instances_buffer, and
524 * r->values_buffer {{{ */
525 if (r->instances_num > 0)
527 r->instances_pos = (size_t *) calloc (r->instances_num, sizeof (size_t));
528 if (r->instances_pos == NULL)
530 ERROR ("db query utils: udb_result_prepare_result: malloc failed.");
534 r->instances_buffer = (char **) calloc (r->instances_num, sizeof (char *));
535 if (r->instances_buffer == NULL)
537 ERROR ("db query utils: udb_result_prepare_result: malloc failed.");
540 } /* if (r->instances_num > 0) */
542 r->values_pos = (size_t *) calloc (r->values_num, sizeof (size_t));
543 if (r->values_pos == NULL)
545 ERROR ("db query utils: udb_result_prepare_result: malloc failed.");
549 r->values_buffer = (char **) calloc (r->values_num, sizeof (char *));
550 if (r->values_buffer == NULL)
552 ERROR ("db query utils: udb_result_prepare_result: malloc failed.");
557 /* Determine the position of the instance columns {{{ */
558 for (i = 0; i < r->instances_num; i++)
562 for (j = 0; j < column_num; j++)
564 if (strcasecmp (r->instances[i], column_names[j]) == 0)
566 r->instances_pos[i] = j;
573 ERROR ("db query utils: udb_result_prepare_result: "
574 "Column `%s' could not be found.",
578 } /* }}} for (i = 0; i < r->instances_num; i++) */
580 /* Determine the position of the value columns {{{ */
581 for (i = 0; i < r->values_num; i++)
585 for (j = 0; j < column_num; j++)
587 if (strcasecmp (r->values[i], column_names[j]) == 0)
589 r->values_pos[i] = j;
596 ERROR ("db query utils: udb_result_prepare_result: "
597 "Column `%s' could not be found.",
601 } /* }}} for (i = 0; i < r->values_num; i++) */
605 } /* }}} int udb_result_prepare_result */
607 static void udb_result_free (udb_result_t *r) /* {{{ */
616 for (i = 0; i < r->instances_num; i++)
617 sfree (r->instances[i]);
618 sfree (r->instances);
620 for (i = 0; i < r->values_num; i++)
621 sfree (r->values[i]);
624 udb_result_free (r->next);
627 } /* }}} void udb_result_free */
629 static int udb_result_create (const char *query_name, /* {{{ */
630 udb_result_t **r_head, oconfig_item_t *ci)
636 if (ci->values_num != 0)
638 WARNING ("db query utils: The `Result' block doesn't accept "
639 "any arguments. Ignoring %i argument%s.",
640 ci->values_num, (ci->values_num == 1) ? "" : "s");
643 r = (udb_result_t *) malloc (sizeof (*r));
646 ERROR ("db query utils: malloc failed.");
649 memset (r, 0, sizeof (*r));
651 r->instance_prefix = NULL;
656 /* Fill the `udb_result_t' structure.. */
658 for (i = 0; i < ci->children_num; i++)
660 oconfig_item_t *child = ci->children + i;
662 if (strcasecmp ("Type", child->key) == 0)
663 status = udb_config_set_string (&r->type, child);
664 else if (strcasecmp ("InstancePrefix", child->key) == 0)
665 status = udb_config_set_string (&r->instance_prefix, child);
666 else if (strcasecmp ("InstancesFrom", child->key) == 0)
667 status = udb_config_add_string (&r->instances, &r->instances_num, child);
668 else if (strcasecmp ("ValuesFrom", child->key) == 0)
669 status = udb_config_add_string (&r->values, &r->values_num, child);
672 WARNING ("db query utils: Query `%s': Option `%s' not allowed here.",
673 query_name, child->key);
681 /* Check that all necessary options have been given. */
686 WARNING ("db query utils: `Type' not given for "
687 "result in query `%s'", query_name);
690 if (r->values == NULL)
692 WARNING ("db query utils: `ValuesFrom' not given for "
693 "result in query `%s'", query_name);
698 } /* while (status == 0) */
706 /* If all went well, add this result to the list of results. */
716 while (last->next != NULL)
723 } /* }}} int udb_result_create */
726 * Query private functions
728 void udb_query_free_one (udb_query_t *q) /* {{{ */
734 sfree (q->statement);
736 udb_result_free (q->results);
739 } /* }}} void udb_query_free_one */
742 * Query public functions
744 int udb_query_create (udb_query_t ***ret_query_list, /* {{{ */
745 size_t *ret_query_list_len, oconfig_item_t *ci,
746 udb_query_create_callback_t cb, int legacy_mode)
748 udb_query_t **query_list;
749 size_t query_list_len;
755 size_t legacy_position;
757 if ((ret_query_list == NULL) || (ret_query_list_len == NULL))
759 query_list = *ret_query_list;
760 query_list_len = *ret_query_list_len;
762 if ((ci->values_num != 1)
763 || (ci->values[0].type != OCONFIG_TYPE_STRING))
765 WARNING ("db query utils: The `Query' block "
766 "needs exactly one string argument.");
770 q = (udb_query_t *) malloc (sizeof (*q));
773 ERROR ("db query utils: malloc failed.");
776 memset (q, 0, sizeof (*q));
777 q->legacy_mode = legacy_mode;
779 q->max_version = UINT_MAX;
783 status = udb_config_set_string (&q->name, ci);
790 /* Fill the `udb_query_t' structure.. */
791 for (i = 0; i < ci->children_num; i++)
793 oconfig_item_t *child = ci->children + i;
795 if (strcasecmp ("Statement", child->key) == 0)
796 status = udb_config_set_string (&q->statement, child);
797 else if (strcasecmp ("Result", child->key) == 0)
798 status = udb_result_create (q->name, &q->results, child);
799 else if (strcasecmp ("MinVersion", child->key) == 0)
800 status = udb_config_set_uint (&q->min_version, child);
801 else if (strcasecmp ("MaxVersion", child->key) == 0)
802 status = udb_config_set_uint (&q->max_version, child);
804 /* PostgreSQL compatibility code */
805 else if ((strcasecmp ("Query", child->key) == 0)
806 && (q->legacy_mode == 1))
808 WARNING ("db query utils: Query `%s': The `Query' option is "
809 "deprecated. Please use `Statement' instead.",
811 status = udb_config_set_string (&q->statement, child);
813 else if ((strcasecmp ("Column", child->key) == 0)
814 && (q->legacy_mode == 1))
816 WARNING ("db query utils: Query `%s': The `Column' option is "
817 "deprecated. Please use the new syntax instead.",
819 status = udb_legacy_result_create (q->name, &q->results, child,
823 else if ((strcasecmp ("MinPGVersion", child->key) == 0)
824 && (q->legacy_mode == 1))
826 WARNING ("db query utils: Query `%s': The `MinPGVersion' option is "
827 "deprecated. Please use `MinVersion' instead.",
829 status = udb_config_set_uint (&q->min_version, child);
831 else if ((strcasecmp ("MaxPGVersion", child->key) == 0)
832 && (q->legacy_mode == 1))
834 WARNING ("db query utils: Query `%s': The `MaxPGVersion' option is "
835 "deprecated. Please use `MaxVersion' instead.",
837 status = udb_config_set_uint (&q->max_version, child);
840 /* Call custom callbacks */
843 status = (*cb) (q, child);
846 WARNING ("db query utils: The configuration callback failed "
847 "to handle `%s'.", child->key);
852 WARNING ("db query utils: Query `%s': Option `%s' not allowed here.",
853 q->name, child->key);
861 /* Check that all necessary options have been given. */
864 if (q->statement == NULL)
866 WARNING ("db query utils: Query `%s': No `Statement' given.", q->name);
869 if (q->results == NULL)
871 WARNING ("db query utils: Query `%s': No (valid) `Result' block given.",
875 } /* if (status == 0) */
877 /* If all went well, add this query to the list of queries within the
878 * database structure. */
883 temp = (udb_query_t **) realloc (query_list,
884 sizeof (*query_list) * (query_list_len + 1));
887 ERROR ("db query utils: realloc failed");
893 query_list[query_list_len] = q;
900 udb_query_free_one (q);
904 *ret_query_list = query_list;
905 *ret_query_list_len = query_list_len;
908 } /* }}} int udb_query_create */
910 void udb_query_free (udb_query_t **query_list, size_t query_list_len) /* {{{ */
914 if (query_list == NULL)
917 for (i = 0; i < query_list_len; i++)
918 udb_query_free_one (query_list[i]);
921 } /* }}} void udb_query_free */
923 int udb_query_pick_from_list_by_name (const char *name, /* {{{ */
924 udb_query_t **src_list, size_t src_list_len,
925 udb_query_t ***dst_list, size_t *dst_list_len)
930 if ((name == NULL) || (src_list == NULL) || (dst_list == NULL)
931 || (dst_list_len == NULL))
933 ERROR ("db query utils: udb_query_pick_from_list_by_name: "
934 "Invalid argument.");
939 for (i = 0; i < src_list_len; i++)
941 udb_query_t **tmp_list;
944 if (strcasecmp (name, src_list[i]->name) != 0)
947 tmp_list_len = *dst_list_len;
948 tmp_list = (udb_query_t **) realloc (*dst_list, (tmp_list_len + 1)
949 * sizeof (udb_query_t *));
950 if (tmp_list == NULL)
952 ERROR ("db query utils: realloc failed.");
956 tmp_list[tmp_list_len] = src_list[i];
959 *dst_list = tmp_list;
960 *dst_list_len = tmp_list_len;
963 } /* for (i = 0; i < src_list_len; i++) */
967 ERROR ("db query utils: Cannot find query `%s'. Make sure the <Query> "
968 "block is above the database definition!",
974 DEBUG ("db query utils: Added %i versions of query `%s'.",
979 } /* }}} int udb_query_pick_from_list_by_name */
981 int udb_query_pick_from_list (oconfig_item_t *ci, /* {{{ */
982 udb_query_t **src_list, size_t src_list_len,
983 udb_query_t ***dst_list, size_t *dst_list_len)
987 if ((ci == NULL) || (src_list == NULL) || (dst_list == NULL)
988 || (dst_list_len == NULL))
990 ERROR ("db query utils: udb_query_pick_from_list: "
991 "Invalid argument.");
995 if ((ci->values_num != 1)
996 || (ci->values[0].type != OCONFIG_TYPE_STRING))
998 ERROR ("db query utils: The `%s' config option "
999 "needs exactly one string argument.", ci->key);
1002 name = ci->values[0].value.string;
1004 return (udb_query_pick_from_list_by_name (name,
1005 src_list, src_list_len,
1006 dst_list, dst_list_len));
1007 } /* }}} int udb_query_pick_from_list */
1009 const char *udb_query_get_name (udb_query_t *q) /* {{{ */
1015 } /* }}} const char *udb_query_get_name */
1017 const char *udb_query_get_statement (udb_query_t *q) /* {{{ */
1022 return (q->statement);
1023 } /* }}} const char *udb_query_get_statement */
1025 void udb_query_set_user_data (udb_query_t *q, void *user_data) /* {{{ */
1030 q->user_data = user_data;
1031 } /* }}} void udb_query_set_user_data */
1033 void *udb_query_get_user_data (udb_query_t *q) /* {{{ */
1038 return (q->user_data);
1039 } /* }}} void *udb_query_get_user_data */
1041 int udb_query_check_version (udb_query_t *q, unsigned int version) /* {{{ */
1046 if ((version < q->min_version) || (version > q->max_version))
1050 } /* }}} int udb_query_check_version */
1052 void udb_query_finish_result (udb_query_t *q) /* {{{ */
1064 for (r = q->results; r != NULL; r = r->next)
1065 udb_result_finish_result (r);
1066 } /* }}} void udb_query_finish_result */
1068 int udb_query_handle_result (udb_query_t *q, char **column_values) /* {{{ */
1077 if ((q->column_num < 1) || (q->host == NULL) || (q->plugin == NULL)
1078 || (q->db_name == NULL))
1080 ERROR ("db query utils: Query `%s': Query is not prepared; "
1081 "can't handle result.", q->name);
1085 #if defined(COLLECT_DEBUG) && COLLECT_DEBUG /* {{{ */
1090 for (i = 0; i < q->column_num; i++)
1092 DEBUG ("db query utils: udb_query_handle_result (%s, %s): "
1093 "column[%zu] = %s;",
1094 q->db_name, q->name, i, column_values[i]);
1100 for (r = q->results; r != NULL; r = r->next)
1102 status = udb_result_handle_result (r, q, column_values);
1109 ERROR ("db query utils: udb_query_handle_result (%s, %s): "
1110 "All results failed.", q->db_name, q->name);
1115 } /* }}} int udb_query_handle_result */
1117 int udb_query_prepare_result (udb_query_t *q, /* {{{ */
1118 const char *host, const char *plugin, const char *db_name,
1119 char **column_names, size_t column_num)
1127 udb_query_finish_result (q);
1129 q->column_num = column_num;
1130 q->host = strdup (host);
1131 q->plugin = strdup (plugin);
1132 q->db_name = strdup (db_name);
1134 if ((q->host == NULL) || (q->plugin == NULL) || (q->db_name == NULL))
1136 ERROR ("db query utils: Query `%s': Prepare failed: Out of memory.", q->name);
1137 udb_query_finish_result (q);
1141 #if defined(COLLECT_DEBUG) && COLLECT_DEBUG
1146 for (i = 0; i < column_num; i++)
1148 DEBUG ("db query utils: udb_query_prepare_result: "
1149 "query = %s; column[%zu] = %s;",
1150 q->name, i, column_names[i]);
1155 for (r = q->results; r != NULL; r = r->next)
1157 status = udb_result_prepare_result (r, column_names, column_num);
1160 udb_query_finish_result (q);
1166 } /* }}} int udb_query_prepare_result */
1168 /* vim: set sw=2 sts=2 et fdm=marker : */