2 This file is part of GNUnet
3 Copyright (C) 2016 GNUnet e.V.
5 GNUnet is free software: you can redistribute it and/or modify it
6 under the terms of the GNU Affero General Public License as published
7 by the Free Software Foundation, either version 3 of the License,
8 or (at your 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 Affero General Public License for more details.
16 * @author Christian Grothoff
17 * @author Christophe Genevey
20 * Helper library to access a MySQL database
22 * @defgroup mysql MySQL library
23 * Helper library to access a MySQL database.
26 #ifndef GNUNET_MY_LIB_H
27 #define GNUNET_MY_LIB_H
29 #include "gnunet_util_lib.h"
30 #include "gnunet_mysql_lib.h"
31 #include <mysql/mysql.h>
36 #if 0 /* keep Emacsens' auto-indent happy */
44 * Information we pass to #GNUNET_MY_exec_prepared() to
45 * initialize the arguments of the prepared statement.
47 struct GNUNET_MY_QueryParam;
51 * Function called to convert input argument into SQL parameters.
54 * @param pq data about the query
55 * @param qbind array of parameters to initialize
59 (*GNUNET_MY_QueryConverter)(void *cls,
60 const struct GNUNET_MY_QueryParam *qp,
65 * Function called to cleanup result data.
68 * @param rs spec to clean up
71 (*GNUNET_MY_QueryCleanup)(void *cls,
74 * Information we pass to #GNUNET_MY_exec_prepared() to
75 * initialize the arguments of the prepared statement.
79 struct GNUNET_MY_QueryParam
83 * Function to call for the type conversion.
85 GNUNET_MY_QueryConverter conv;
88 * Function to call for cleaning up the query. Can be NULL.
90 GNUNET_MY_QueryCleanup cleaner;
93 * Closure for @e conv.
98 * Number of arguments the @a conv converter expects to initialize.
100 unsigned int num_params;
103 * Information to pass to @e conv.
108 * Information to pass to @e conv. Size of @a data.
110 unsigned long data_len;
115 * End of query parameter specification.
117 * @return array last entry for the result specification to use
119 #define GNUNET_MY_query_param_end { NULL, NULL, NULL, 0, NULL, 0 }
123 * Generate query parameter for a buffer @a ptr of
124 * @a ptr_size bytes.FG
126 * @param ptr pointer to the query parameter to pass
127 * @oaran ptr_size number of bytes in @a ptr
129 struct GNUNET_MY_QueryParam
130 GNUNET_MY_query_param_fixed_size (const void *ptr,
135 * Run a prepared SELECT statement.
137 * @param mc mysql context
138 * @param sh handle to SELECT statment
139 * @param params parameters to the statement
143 GNUNET_MY_exec_prepared (struct GNUNET_MYSQL_Context *mc,
144 struct GNUNET_MYSQL_StatementHandle *sh,
145 struct GNUNET_MY_QueryParam *params);
149 * Information we pass to #GNUNET_MY_extract_result() to
150 * initialize the arguments of the prepared statement.
152 struct GNUNET_MY_ResultParam;
155 * Information we pass to #GNUNET_MY_extract_result() to
156 * initialize the arguments of the prepared statement.
158 struct GNUNET_MY_ResultSpec;
161 * Function called to convert input argument into SQL parameters.
165 * @param stmt the mysql statement that is being run
166 * @param column the column that is being processed
167 * @param[out] results
168 * @return -1 on error
171 (*GNUNET_MY_ResultConverter)(void *cls,
172 struct GNUNET_MY_ResultSpec *rs,
175 MYSQL_BIND *results);
178 * Function called to cleanup result data.
181 * @param rs spec to clean up
184 (*GNUNET_MY_ResultCleanup)(void *cls,
185 struct GNUNET_MY_ResultSpec *rs);
189 * Information we pass to #GNUNET_MY_extract_result() to
190 * initialize the arguments of the prepared statement.
192 struct GNUNET_MY_ResultSpec
196 * Function to call to initialize the MYSQL_BIND array.
198 GNUNET_MY_ResultConverter pre_conv;
201 * Function to call for converting the result. Can be NULL.
203 GNUNET_MY_ResultConverter post_conv;
206 * Function to call for cleaning up the result. Can be NULL.
208 GNUNET_MY_ResultCleanup cleaner;
211 * Closure for @e conv.
216 * Destination for the data.
221 * Allowed size for the data, 0 for variable-size
222 * (in this case, the type of @e dst is a `void **`
223 * and we need to allocate a buffer of the right size).
228 * Where to store actual size of the result.
233 * How many fields does this result specification occupy
234 * in the result returned by MySQL.
236 unsigned int num_fields;
239 * Location where we temporarily store the output buffer
240 * length from MySQL. Internal to libgnunetmy.
242 unsigned long mysql_bind_output_length;
245 * Memory for MySQL to notify us about NULL values.
253 * End of result speceter specification.
255 * @return array last entry for the result specification to use
257 #define GNUNET_MY_result_spec_end { NULL, NULL, NULL, 0, NULL, 0, 0 }
262 * Obtain fixed size result of @a ptr_size bytes from
263 * MySQL, store in already allocated buffer at @a ptr.
265 * @spec ptr where to write the result
266 * @oaran ptr_size number of bytes available at @a ptr
268 struct GNUNET_MY_ResultSpec
269 GNUNET_MY_result_spec_fixed_size (void *ptr,
273 * Generate query parameter for a string
275 *@param ptr pointer to the string query parameter to pass
277 struct GNUNET_MY_QueryParam
278 GNUNET_MY_query_param_string (const char *ptr);
281 * Generate fixed-size query parameter with size determined
284 * @param x pointer to the query parameter to pass
286 #define GNUNET_MY_query_param_auto_from_type(x) GNUNET_MY_query_param_fixed_size ((x), sizeof (*(x)))
289 * Generate query parameter for an RSA public key. The
290 * database must contain a BLOB type in the respective position.
292 * @param x the query parameter to pass
293 * @return array entry for the query parameters to use
295 struct GNUNET_MY_QueryParam
296 GNUNET_MY_query_param_rsa_public_key (const struct GNUNET_CRYPTO_RsaPublicKey *x);
299 * Generate query parameter for an RSA signature. The
300 * database must contain a BLOB type in the respective position
302 *@param x the query parameter to pass
303 *@return array entry for the query parameters to use
305 struct GNUNET_MY_QueryParam
306 GNUNET_MY_query_param_rsa_signature (const struct GNUNET_CRYPTO_RsaSignature *x);
309 * Generate query parameter for an absolute time value.
310 * The database must store a 64-bit integer.
312 *@param x pointer to the query parameter to pass
313 *@return array entry for the query parameters to use
315 struct GNUNET_MY_QueryParam
316 GNUNET_MY_query_param_absolute_time (const struct GNUNET_TIME_Absolute *x);
320 * Generate query parameter for an absolute time value.
321 * The database must store a 64-bit integer.
323 *@param x pointer to the query parameter to pass
325 struct GNUNET_MY_QueryParam
326 GNUNET_MY_query_param_absolute_time_nbo (const struct GNUNET_TIME_AbsoluteNBO *x);
329 * Generate query parameter for an uint16_t in host byte order.
331 * @param x pointer to the query parameter to pass
333 struct GNUNET_MY_QueryParam
334 GNUNET_MY_query_param_uint16 (const uint16_t *x);
337 * Generate query parameter for an uint32_t in host byte order
339 *@param x pointer to the query parameter to pass
341 struct GNUNET_MY_QueryParam
342 GNUNET_MY_query_param_uint32 (const uint32_t *x);
345 * Generate query parameter for an uint64_t in host byte order
347 *@param x pointer to the query parameter to pass
349 struct GNUNET_MY_QueryParam
350 GNUNET_MY_query_param_uint64 (const uint64_t *x);
353 * We expect a fixed-size result, with size determined by the type of `* dst`
355 * @spec name name of the field in the table
356 * @spec dst point to where to store the result, type fits expected result size
357 * @return array entry for the result specification to use
359 #define GNUNET_MY_result_spec_auto_from_type(dst) GNUNET_MY_result_spec_fixed_size ((dst), sizeof (*(dst)))
363 * Variable-size result expected
365 * @param[out] dst where to store the result, allocated
366 * @param[out] sptr where to store the size of @a dst
367 * @return array entru for the result specification to use
369 struct GNUNET_MY_ResultSpec
370 GNUNET_MY_result_spec_variable_size (void **dst,
374 * RSA public key expected
376 * @param name name of the field in the table
377 * @param[out] rsa where to store the result
378 * @return array entry for the result specification to use
380 struct GNUNET_MY_ResultSpec
381 GNUNET_MY_result_spec_rsa_public_key (struct GNUNET_CRYPTO_RsaPublicKey **rsa);
385 * RSA signature expected.
387 * @param[out] sig where to store the result;
388 * @return array entry for the result specification to use
390 struct GNUNET_MY_ResultSpec
391 GNUNET_MY_result_spec_rsa_signature (struct GNUNET_CRYPTO_RsaSignature **sig);
394 * 0- terminated string exprected.
396 * @param[out] dst where to store the result, allocated
397 * @return array entry for the result specification to use
399 struct GNUNET_MY_ResultSpec
400 GNUNET_MY_result_spec_string (char **dst);
403 * Absolute time expected
405 * @param name name of the field in the table
406 * @param[out] at where to store the result
407 * @return array entry for the result specification to use
409 struct GNUNET_MY_ResultSpec
410 GNUNET_MY_result_spec_absolute_time (struct GNUNET_TIME_Absolute *at);
413 * Absolute time in network byte order expected
415 * @param[out] at where to store the result
416 * @return array entry for the result specification to use
418 struct GNUNET_MY_ResultSpec
419 GNUNET_MY_result_spec_absolute_time_nbo (struct GNUNET_TIME_AbsoluteNBO *at);
424 * @param[out] u16 where to store the result
425 * @return array entry for the result specification to use
427 struct GNUNET_MY_ResultSpec
428 GNUNET_MY_result_spec_uint16 (uint16_t *u16);
433 * @param[out] u32 where to store the result
434 * @return array entry for the result specification to use
436 struct GNUNET_MY_ResultSpec
437 GNUNET_MY_result_spec_uint32 (uint32_t *u32);
442 * @param[out] u64 where to store the result
443 * @return array entry for the result specification to use
445 struct GNUNET_MY_ResultSpec
446 GNUNET_MY_result_spec_uint64 (uint64_t *u64);
450 * Extract results from a query result according to the given
451 * specification. Always fetches the next row.
453 * @param sh statement that returned results
454 * @param rs specification to extract for
456 * #GNUNET_YES if all results could be extracted
457 * #GNUNET_NO if there is no more data in the result set
458 * #GNUNET_SYSERR if a result was invalid
461 GNUNET_MY_extract_result (struct GNUNET_MYSQL_StatementHandle *sh,
462 struct GNUNET_MY_ResultSpec *specs);
466 * Free all memory that was allocated in @a qp during
467 * #GNUNET_MY_exect_prepared().
469 * @param qp query specification to clean up
470 * @param qbind mysql query
473 GNUNET_MY_cleanup_query (struct GNUNET_MY_QueryParam *qp,
478 * Free all memory that was allocated in @a rs during
479 * #GNUNET_MY_extract_result().
481 * @param rs reult specification to clean up
484 GNUNET_MY_cleanup_result (struct GNUNET_MY_ResultSpec *rs);
487 #if 0 /* keep Emacsens' auto-indent happy */
496 /** @} */ /* end of group */