2 This file is part of GNUnet
3 Copyright (C) 2016 Inria & GNUnet e.V.
5 GNUnet is free software; you can redistribute it and/or modify
6 it under the terms of the GNU General Public License as published
7 by the Free Software Foundation; either version 3, or (at your
8 option) any later version.
10 GNUnet is distributed in the hope that it will be useful, but
11 WITHOUT ANY WARRANTY; without even the implied warranty of
12 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13 General Public License for more details.
15 You should have received a copy of the GNU General Public License
16 along with GNUnet; see the file COPYING. If not, write to the
17 Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
18 Boston, MA 02110-1301, USA.
22 * @brief library to help with access to a MySQL database
23 * @author Christophe Genevey
24 * @author Christian Grothoff
27 #include <mysql/mysql.h>
28 #include "gnunet_my_lib.h"
30 #define STRING_SIZE 50
33 * Run a prepared SELECT statement.
35 * @param mc mysql context
36 * @param sh handle to SELECT statment
37 * @param params parameters to the statement
39 #GNUNET_YES if we can prepare all statement
40 #GNUNET_SYSERR if we can't prepare all statement
43 GNUNET_MY_exec_prepared (struct GNUNET_MYSQL_Context *mc,
44 struct GNUNET_MYSQL_StatementHandle *sh,
45 const struct GNUNET_MY_QueryParam *params)
47 const struct GNUNET_MY_QueryParam *p;
53 for (i=0;NULL != params[i].conv;i++)
54 num += params[i].num_params;
56 MYSQL_BIND qbind[num];
59 memset(qbind, 0, sizeof(qbind));
61 for (i=0;NULL != (p = ¶ms[i])->conv;i++)
72 stmt = GNUNET_MYSQL_statement_get_stmt (mc, sh);
73 if (mysql_stmt_bind_param (stmt,
76 GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR, "mysql",
77 _("`%s' failed at %s:%d with error: %s\n"),
78 "mysql_stmt_bind_param", __FILE__, __LINE__,
79 mysql_stmt_error (stmt));
80 GNUNET_MYSQL_statements_invalidate (mc);
84 if (mysql_stmt_execute (stmt))
86 GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR, "mysql",
87 _("`%s' failed at %s:%d with error: %s\n"),
88 "mysql_stmt_execute", __FILE__, __LINE__,
89 mysql_stmt_error (stmt));
90 GNUNET_MYSQL_statements_invalidate (mc);
100 * Extract results from a query result according to the given
101 * specification. Always fetches the next row.
104 * @param sh statement that returned results
105 * @param rs specification to extract for
107 * #GNUNET_YES if all results could be extracted
108 * #GNUNET_NO if there is no more data in the result set
109 * #GNUNET_SYSERR if a result was invalid
112 GNUNET_MY_extract_result (struct GNUNET_MYSQL_StatementHandle *sh,
113 struct GNUNET_MY_ResultSpec *rs)
115 unsigned int num_fields;
120 stmt = GNUNET_MYSQL_statement_get_stmt (NULL /* FIXME */, sh);
123 GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR, "mysql",
124 ("`%s' failed at %s:%d with error: %s\n"),
125 "mysql_stmt_bind_result", __FILE__, __LINE__,
126 mysql_stmt_error (stmt));
127 return GNUNET_SYSERR;
131 for (i=0;NULL != rs[i].pre_conv;i++)
132 num_fields += rs[i].num_fields;
134 if (mysql_stmt_field_count (stmt) != num_fields)
136 GNUNET_log (GNUNET_ERROR_TYPE_ERROR,
137 "Number of fields missmatch between SQL result and result specification\n");
138 return GNUNET_SYSERR;
142 MYSQL_BIND result[num_fields];
143 unsigned int field_off;
145 memset (result, 0, sizeof (MYSQL_BIND) * num_fields);
147 for (i=0;NULL != rs[i].pre_conv;i++)
149 struct GNUNET_MY_ResultSpec *rp = &rs[i];
152 rp->pre_conv (rp->conv_cls,
158 GNUNET_log (GNUNET_ERROR_TYPE_ERROR,
159 "Pre-conversion for MySQL result failed at offset %u\n",
161 GNUNET_MY_cleanup_result (rs);
162 return GNUNET_SYSERR;
164 field_off += rp->num_fields;
166 if (mysql_stmt_bind_result (stmt, result))
168 GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR,
170 _("`%s' failed at %s:%d with error: %s\n"),
171 "mysql_stmt_bind_result", __FILE__, __LINE__,
172 mysql_stmt_error (stmt));
173 return GNUNET_SYSERR;
176 ret = mysql_stmt_fetch (stmt);
178 if (MYSQL_NO_DATA == ret)
180 if ((0 != ret ) & (MYSQL_DATA_TRUNCATED != ret))
182 GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR,
184 _("mysql_stmt_fetch failed at %s:%d with error: %s\n"),
186 mysql_stmt_error (stmt));
187 return GNUNET_SYSERR;
190 for (i=0;NULL != rs[i].post_conv;i++)
192 struct GNUNET_MY_ResultSpec *rp = &rs[i];
194 if (NULL != rp->post_conv)
196 rp->post_conv (rp->conv_cls,
202 GNUNET_log (GNUNET_ERROR_TYPE_ERROR,
203 "Post-conversion for MySQL result failed at offset %u\n",
205 GNUNET_MY_cleanup_result (rs);
206 return GNUNET_SYSERR;
208 field_off += rp->num_fields;
216 * Free all memory that was allocated in @a rs during
217 * #GNUNET_MY_extract_result().
219 * @param rs reult specification to clean up
222 GNUNET_MY_cleanup_result (struct GNUNET_MY_ResultSpec *rs)
226 for (i=0;NULL != rs[i].cleaner;i++)
227 rs[i].cleaner (rs[i].conv_cls,