123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400 |
- /*
- This file is part of GNUnet
- Copyright (C) 2016 GNUnet e.V.
- GNUnet is free software: you can redistribute it and/or modify it
- under the terms of the GNU Affero General Public License as published
- by the Free Software Foundation, either version 3 of the License,
- or (at your option) any later version.
- GNUnet is distributed in the hope that it will be useful, but
- WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- Affero General Public License for more details.
- You should have received a copy of the GNU Affero General Public License
- along with this program. If not, see <http://www.gnu.org/licenses/>.
- SPDX-License-Identifier: AGPL3.0-or-later
- */
- /**
- * @file my/my_query_helper.c
- * @brief library to help with access to a MySQL database
- * @author Christian Grothoff
- * @author Christophe Genevey
- */
- #include "platform.h"
- #include <mysql/mysql.h>
- #include "gnunet_my_lib.h"
- /**
- * Function called to clean up memory allocated
- * by a #GNUNET_MY_QueryConverter.
- *
- * @param cls closure
- * @param qbind array of parameter to clean up
- */
- static void
- my_clean_query (void *cls,
- MYSQL_BIND *qbind)
- {
- (void) cls;
- GNUNET_free (qbind[0].buffer);
- }
- /**
- * Function called to convert input argument into SQL parameters.
- *
- * @param cls closure
- * @param pq data about the query
- * @param qbind array of parameters to initialize
- * @return -1 on error
- */
- static int
- my_conv_fixed_size (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- qbind->buffer = (void *) qp->data;
- qbind->buffer_length = qp->data_len;
- qbind->buffer_type = MYSQL_TYPE_BLOB;
- return 1;
- }
- /**
- * Generate query parameter for a buffer @a ptr of
- * @a ptr_size bytes.
- *
- * @param ptr pointer to the query parameter to pass
- * @param ptr_size number of bytes in @a ptr
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_fixed_size (const void *ptr,
- size_t ptr_size)
- {
- struct GNUNET_MY_QueryParam qp = {
- .conv = &my_conv_fixed_size,
- .cleaner = NULL,
- .conv_cls = NULL,
- .num_params = 1,
- .data = ptr,
- .data_len = (unsigned long) ptr_size
- };
- return qp;
- }
- /**
- * Function called to convert input argument into SQL parameters.
- *
- * @param cls closure
- * @param pq data about the query
- * @param qbind array of parameters to initialize
- * @return -1 on error
- */
- static int
- my_conv_string (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- qbind->buffer = (void *) qp->data;
- qbind->buffer_length = qp->data_len;
- qbind->buffer_type = MYSQL_TYPE_STRING;
- return 1;
- }
- /**
- * Generate query parameter for a string
- *
- * @param ptr pointer to the string query parameter to pass
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_string (const char *ptr)
- {
- struct GNUNET_MY_QueryParam qp = {
- .conv = &my_conv_string,
- .cleaner = NULL,
- .conv_cls = NULL,
- .num_params = 1,
- .data = ptr,
- .data_len = strlen (ptr)
- };
- return qp;
- }
- /**
- * Function called to convert input argument into SQL parameters
- *
- * @param cls closure
- * @param pq data about the query
- * @param qbind array of parameters to initialize
- * @return -1 on error
- */
- static int
- my_conv_uint16 (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- qbind->buffer = (void *) qp->data;
- qbind->buffer_length = sizeof(uint16_t);
- qbind->buffer_type = MYSQL_TYPE_SHORT;
- qbind->is_unsigned = 1;
- return 1;
- }
- /**
- * Generate query parameter for an uint16_t in host byte order.
- *
- * @param x pointer to the query parameter to pass
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_uint16 (const uint16_t *x)
- {
- struct GNUNET_MY_QueryParam res = {
- .conv = &my_conv_uint16,
- .cleaner = NULL,
- .conv_cls = NULL,
- .num_params = 1,
- .data = x,
- .data_len = sizeof(*x)
- };
- return res;
- }
- /**
- * Function called to convert input argument into SQL parameters
- *
- * @param cls closure
- * @param pq data about the query
- * @param qbind array of parameters to initialize
- * @return -1 on error
- */
- static int
- my_conv_uint32 (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- qbind->buffer = (void *) qp->data;
- qbind->buffer_length = sizeof(uint32_t);
- qbind->buffer_type = MYSQL_TYPE_LONG;
- qbind->is_unsigned = 1;
- return 1;
- }
- /**
- * Generate query parameter for an uint32_t in host byte order
- *
- * @param x pointer to the query parameter to pass
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_uint32 (const uint32_t *x)
- {
- struct GNUNET_MY_QueryParam res = {
- .conv = &my_conv_uint32,
- .cleaner = NULL,
- .conv_cls = NULL,
- .num_params = 1,
- .data = x,
- .data_len = sizeof(*x)
- };
- return res;
- }
- /**
- * Function called to convert input argument into SQL parameters
- *
- * @param cls closure
- * @param pq data about the query
- * @param qbind array of parameters to initialize
- * @return -1 on error
- */
- static int
- my_conv_uint64 (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- qbind->buffer = (void *) qp->data;
- qbind->buffer_length = sizeof(uint64_t);
- qbind->buffer_type = MYSQL_TYPE_LONGLONG;
- qbind->is_unsigned = 1;
- return 1;
- }
- /**
- * Generate query parameter for an uint64_t in host byte order
- *
- * @param x pointer to the query parameter to pass
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_uint64 (const uint64_t *x)
- {
- struct GNUNET_MY_QueryParam res = {
- .conv = &my_conv_uint64,
- .cleaner = NULL,
- .conv_cls = NULL,
- .num_params = 1,
- .data = x,
- .data_len = sizeof(*x)
- };
- return res;
- }
- /**
- * Function called to convert input argument into SQL parameters
- *
- * @param cls closure
- * @param pq data about the query
- * @param qbind array of parameters to initialize
- * @return -1 on error
- */
- static int
- my_conv_rsa_public_key (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- const struct GNUNET_CRYPTO_RsaPublicKey *rsa = qp->data;
- void *buf;
- size_t buf_size;
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- buf_size = GNUNET_CRYPTO_rsa_public_key_encode (rsa,
- &buf);
- qbind->buffer = buf;
- qbind->buffer_length = buf_size;
- qbind->buffer_type = MYSQL_TYPE_BLOB;
- return 1;
- }
- /**
- * Generate query parameter for an RSA public key. The
- * database must contain a BLOB type in the respective position.
- *
- * @param x the query parameter to pass
- * @return array entry for the query parameters to use
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_rsa_public_key (const struct
- GNUNET_CRYPTO_RsaPublicKey *x)
- {
- struct GNUNET_MY_QueryParam res = {
- .conv = &my_conv_rsa_public_key,
- .cleaner = &my_clean_query,
- .conv_cls = NULL,
- .num_params = 1,
- .data = x,
- .data_len = 0
- };
- return res;
- }
- /**
- * Function called to convert input argument into SQL parameters
- *
- *@param cls closure
- *@param pq data about the query
- *@param qbind array of parameters to initialize
- *@return -1 on error
- */
- static int
- my_conv_rsa_signature (void *cls,
- const struct GNUNET_MY_QueryParam *qp,
- MYSQL_BIND *qbind)
- {
- const struct GNUNET_CRYPTO_RsaSignature *sig = qp->data;
- void *buf;
- size_t buf_size;
- (void) cls;
- GNUNET_assert (1 == qp->num_params);
- buf_size = GNUNET_CRYPTO_rsa_signature_encode (sig,
- &buf);
- qbind->buffer = buf;
- qbind->buffer_length = buf_size;
- qbind->buffer_type = MYSQL_TYPE_BLOB;
- return 1;
- }
- /**
- * Generate query parameter for an RSA signature. The
- * database must contain a BLOB type in the respective position
- *
- * @param x the query parameter to pass
- * @return array entry for the query parameters to use
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_rsa_signature (const struct GNUNET_CRYPTO_RsaSignature *x)
- {
- struct GNUNET_MY_QueryParam res = {
- .conv = &my_conv_rsa_signature,
- .cleaner = &my_clean_query,
- .conv_cls = NULL,
- .num_params = 1,
- .data = (x),
- .data_len = 0
- };
- return res;
- }
- /**
- * Generate query parameter for an absolute time value.
- * The database must store a 64-bit integer.
- *
- * @param x pointer to the query parameter to pass
- * @return array entry for the query parameters to use
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_absolute_time (const struct GNUNET_TIME_Absolute *x)
- {
- return GNUNET_MY_query_param_uint64 (&x->abs_value_us);
- }
- /**
- * Generate query parameter for an absolute time value.
- * The database must store a 64-bit integer.
- *
- * @param x pointer to the query parameter to pass
- */
- struct GNUNET_MY_QueryParam
- GNUNET_MY_query_param_absolute_time_nbo (const struct
- GNUNET_TIME_AbsoluteNBO *x)
- {
- return GNUNET_MY_query_param_auto_from_type (&x->abs_value_us__);
- }
- /* end of my_query_helper.c */
|