2 This file is part of GNUnet
3 Copyright (C) 2017 GNUnet e.V.
5 GNUnet is free software; you can redistribute it and/or modify it under the
6 terms of the GNU General Public License as published by the Free Software
7 Foundation; either version 3, or (at your option) any later version.
9 GNUnet is distributed in the hope that it will be useful, but WITHOUT ANY
10 WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
11 A PARTICULAR PURPOSE. See the GNU General Public License for more details.
13 You should have received a copy of the GNU General Public License along with
14 GNUnet; see the file COPYING. If not, If not, see <http://www.gnu.org/licenses/>
17 * @file include/gnunet_sq_lib.h
18 * @brief helper functions for Sqlite3 DB interactions
19 * @author Christian Grothoff
21 #ifndef GNUNET_SQ_LIB_H
22 #define GNUNET_SQ_LIB_H
25 #include "gnunet_util_lib.h"
29 * Function called to convert input argument into SQL parameters.
32 * @param data pointer to input argument
33 * @param data_len number of bytes in @a data (if applicable)
34 * @param stmt sqlite statement to bind parameters for
35 * @param off offset of the argument to bind in @a stmt, numbered from 1,
36 * so immediately suitable for passing to `sqlite3_bind`-functions.
37 * @return #GNUNET_SYSERR on error, #GNUNET_OK on success
40 (*GNUNET_SQ_QueryConverter)(void *cls,
48 * @brief Description of a DB query parameter.
50 struct GNUNET_SQ_QueryParam
54 * Function for how to handle this type of entry.
56 GNUNET_SQ_QueryConverter conv;
59 * Closure for @e conv.
74 * Number of parameters eaten by this operation.
76 unsigned int num_params;
81 * End of query parameter specification.
83 #define GNUNET_SQ_query_param_end { NULL, NULL, NULL, 0, 0 }
87 * Generate query parameter for a buffer @a ptr of
90 * @param ptr pointer to the query parameter to pass
91 * @oaran ptr_size number of bytes in @a ptr
93 struct GNUNET_SQ_QueryParam
94 GNUNET_SQ_query_param_fixed_size (const void *ptr,
100 * Generate query parameter for a string.
102 * @param ptr pointer to the string query parameter to pass
104 struct GNUNET_SQ_QueryParam
105 GNUNET_SQ_query_param_string (const char *ptr);
109 * Generate fixed-size query parameter with size determined
112 * @param x pointer to the query parameter to pass.
114 #define GNUNET_SQ_query_param_auto_from_type(x) GNUNET_SQ_query_param_fixed_size ((x), sizeof (*(x)))
118 * Generate query parameter for an RSA public key. The
119 * database must contain a BLOB type in the respective position.
121 * @param x the query parameter to pass.
123 struct GNUNET_SQ_QueryParam
124 GNUNET_SQ_query_param_rsa_public_key (const struct GNUNET_CRYPTO_RsaPublicKey *x);
128 * Generate query parameter for an RSA signature. The
129 * database must contain a BLOB type in the respective position.
131 * @param x the query parameter to pass
133 struct GNUNET_SQ_QueryParam
134 GNUNET_SQ_query_param_rsa_signature (const struct GNUNET_CRYPTO_RsaSignature *x);
138 * Generate query parameter for an absolute time value.
139 * The database must store a 64-bit integer.
141 * @param x pointer to the query parameter to pass
143 struct GNUNET_SQ_QueryParam
144 GNUNET_SQ_query_param_absolute_time (const struct GNUNET_TIME_Absolute *x);
148 * Generate query parameter for an absolute time value.
149 * The database must store a 64-bit integer.
151 * @param x pointer to the query parameter to pass
153 struct GNUNET_SQ_QueryParam
154 GNUNET_SQ_query_param_absolute_time_nbo (const struct GNUNET_TIME_AbsoluteNBO *x);
158 * Generate query parameter for an uint16_t in host byte order.
160 * @param x pointer to the query parameter to pass
162 struct GNUNET_SQ_QueryParam
163 GNUNET_SQ_query_param_uint16 (const uint16_t *x);
167 * Generate query parameter for an uint32_t in host byte order.
169 * @param x pointer to the query parameter to pass
171 struct GNUNET_SQ_QueryParam
172 GNUNET_SQ_query_param_uint32 (const uint32_t *x);
176 * Generate query parameter for an uint16_t in host byte order.
178 * @param x pointer to the query parameter to pass
180 struct GNUNET_SQ_QueryParam
181 GNUNET_SQ_query_param_uint64 (const uint64_t *x);
185 * Execute binding operations for a prepared statement.
187 * @param db_conn database connection
188 * @param params parameters to the statement
189 * @return #GNUNET_OK on success, #GNUNET_SYSERR on error
192 GNUNET_SQ_bind (sqlite3_stmt *stmt,
193 const struct GNUNET_SQ_QueryParam *params);
197 * Reset @a stmt and log error.
199 * @param dbh database handle
200 * @param stmt statement to reset
203 GNUNET_SQ_reset (sqlite3 *dbh,
208 * Extract data from a Postgres database @a result at row @a row.
211 * @param result where to extract data from
212 * @param column column to extract data from
213 * @param[in,out] dst_size where to store size of result, may be NULL
214 * @param[out] dst where to store the result
216 * #GNUNET_YES if all results could be extracted
217 * #GNUNET_SYSERR if a result was invalid (non-existing field or NULL)
220 (*GNUNET_SQ_ResultConverter)(void *cls,
221 sqlite3_stmt *result,
228 * @brief Description of a DB result cell.
230 struct GNUNET_SQ_ResultSpec;
234 * Function called to clean up memory allocated
235 * by a #GNUNET_SQ_ResultConverter.
240 (*GNUNET_SQ_ResultCleanup)(void *cls);
244 * @brief Description of a DB result cell.
246 struct GNUNET_SQ_ResultSpec
250 * What is the format of the result?
252 GNUNET_SQ_ResultConverter conv;
255 * Function to clean up result data, NULL if cleanup is
258 GNUNET_SQ_ResultCleanup cleaner;
261 * Closure for @e conv and @e cleaner.
266 * Destination for the data.
271 * Allowed size for the data, 0 for variable-size
272 * (in this case, the type of @e dst is a `void **`
273 * and we need to allocate a buffer of the right size).
278 * Where to store actual size of the result. If left at
279 * NULL, will be made to point to @e dst_size before
285 * Number of parameters (columns) eaten by this operation.
287 unsigned int num_params;
293 * End of result parameter specification.
295 * @return array last entry for the result specification to use
297 #define GNUNET_SQ_result_spec_end { NULL, NULL, NULL, NULL, 0, NULL }
301 * Variable-size result expected.
303 * @param[out] dst where to store the result, allocated
304 * @param[out] sptr where to store the size of @a dst
305 * @return array entry for the result specification to use
307 struct GNUNET_SQ_ResultSpec
308 GNUNET_SQ_result_spec_variable_size (void **dst,
313 * Fixed-size result expected.
315 * @param[out] dst where to store the result
316 * @param dst_size number of bytes in @a dst
317 * @return array entry for the result specification to use
319 struct GNUNET_SQ_ResultSpec
320 GNUNET_SQ_result_spec_fixed_size (void *dst,
325 * We expect a fixed-size result, with size determined by the type of `* dst`
327 * @param dst point to where to store the result, type fits expected result size
328 * @return array entry for the result specification to use
330 #define GNUNET_SQ_result_spec_auto_from_type(dst) GNUNET_SQ_result_spec_fixed_size ((dst), sizeof (*(dst)))
334 * Variable-size result expected.
336 * @param[out] dst where to store the result, allocated
337 * @param[out] sptr where to store the size of @a dst
338 * @return array entry for the result specification to use
340 struct GNUNET_SQ_ResultSpec
341 GNUNET_SQ_result_spec_variable_size (void **dst,
346 * 0-terminated string expected.
348 * @param[out] dst where to store the result, allocated
349 * @return array entry for the result specification to use
351 struct GNUNET_SQ_ResultSpec
352 GNUNET_SQ_result_spec_string (char **dst);
356 * RSA public key expected.
358 * @param[out] rsa where to store the result
359 * @return array entry for the result specification to use
361 struct GNUNET_SQ_ResultSpec
362 GNUNET_SQ_result_spec_rsa_public_key (struct GNUNET_CRYPTO_RsaPublicKey **rsa);
366 * RSA signature expected.
368 * @param[out] sig where to store the result;
369 * @return array entry for the result specification to use
371 struct GNUNET_SQ_ResultSpec
372 GNUNET_SQ_result_spec_rsa_signature (struct GNUNET_CRYPTO_RsaSignature **sig);
376 * Absolute time expected.
378 * @param[out] at where to store the result
379 * @return array entry for the result specification to use
381 struct GNUNET_SQ_ResultSpec
382 GNUNET_SQ_result_spec_absolute_time (struct GNUNET_TIME_Absolute *at);
386 * Absolute time expected.
388 * @param[out] at where to store the result
389 * @return array entry for the result specification to use
391 struct GNUNET_SQ_ResultSpec
392 GNUNET_SQ_result_spec_absolute_time_nbo (struct GNUNET_TIME_AbsoluteNBO *at);
398 * @param[out] u16 where to store the result
399 * @return array entry for the result specification to use
401 struct GNUNET_SQ_ResultSpec
402 GNUNET_SQ_result_spec_uint16 (uint16_t *u16);
408 * @param[out] u32 where to store the result
409 * @return array entry for the result specification to use
411 struct GNUNET_SQ_ResultSpec
412 GNUNET_SQ_result_spec_uint32 (uint32_t *u32);
418 * @param[out] u64 where to store the result
419 * @return array entry for the result specification to use
421 struct GNUNET_SQ_ResultSpec
422 GNUNET_SQ_result_spec_uint64 (uint64_t *u64);
426 * Extract results from a query result according to the given specification.
428 * @param result result to process
429 * @param[in,out] rs result specification to extract for
431 * #GNUNET_OK if all results could be extracted
432 * #GNUNET_SYSERR if a result was invalid (non-existing field)
435 GNUNET_SQ_extract_result (sqlite3_stmt *result,
436 struct GNUNET_SQ_ResultSpec *rs);
440 * Free all memory that was allocated in @a rs during
441 * #GNUNET_SQ_extract_result().
443 * @param rs reult specification to clean up
446 GNUNET_SQ_cleanup_result (struct GNUNET_SQ_ResultSpec *rs);
449 #endif /* GNUNET_SQ_LIB_H_ */
451 /* end of include/gnunet_sq_lib.h */