1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
/*
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 General Public License as published
by the Free Software Foundation; either version 3, 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
General Public License for more details.
You should have received a copy of the GNU General Public License
along with GNUnet; see the file COPYING. If not, write to the
Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
Boston, MA 02110-1301, USA.
*/
/**
* @file my/my.c
* @brief library to help with access to a MySQL database
* @author Christian Grothoff
*/
#include "platform.h"
#include <mysql/mysql.h>
#include "gnunet_my_lib.h"
/**
* Run a prepared SELECT statement.
*
* @param mc mysql context
* @param sh handle to SELECT statment
* @param params parameters to the statement
* @return
*/
int
GNUNET_MY_exec_prepared (struct GNUNET_MYSQL_Context *mc,
struct GNUNET_MYSQL_StatementHandle *sh,
const struct GNUNET_MY_QueryParam *params)
{
const struct GNUNET_MY_QueryParam *p;
unsigned int num;
unsigned int i;
MYSQL_STMT *stmt;
num = 0;
for (i=0;NULL != params[i].conv;i++)
num += params[i].num_params;
{
MYSQL_BIND qbind[num];
unsigned int off;
memset(qbind, 0, sizeof(qbind));
off = 0;
for (i=0;NULL != (p = ¶ms[i])->conv;i++)
{
if (GNUNET_OK !=
p->conv (p->conv_cls,
p,
&qbind[off]))
{
return GNUNET_SYSERR;
}
off += p->num_params;
}
stmt = GNUNET_MYSQL_statement_get_stmt (mc, sh);
if (mysql_stmt_bind_param (stmt,
qbind))
{
GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR, "mysql",
_("`%s' failed at %s:%d with error: %s\n"),
"mysql_stmt_bind_param", __FILE__, __LINE__,
mysql_stmt_error (stmt));
GNUNET_MYSQL_statements_invalidate (mc);
return GNUNET_SYSERR;
}
}
if (mysql_stmt_execute (stmt))
{
GNUNET_log_from (GNUNET_ERROR_TYPE_ERROR, "mysql",
_("`%s' failed at %s:%d with error: %s\n"),
"mysql_stmt_execute", __FILE__, __LINE__,
mysql_stmt_error (stmt));
GNUNET_MYSQL_statements_invalidate (mc);
return GNUNET_SYSERR;
}
return GNUNET_OK;
}
/**
* Extract results from a query result according
* to the given specification. If colums are NULL,
* the destination is not modified, and #GNUNET_NO is returned
*
*
* @param result
* @param row, the row from the result to extract
* @param result specificatio to extract for
* @return
#GNUNET_YES if all results could be extracted
#GNUNET_NO if at least one result was NULL
#GNUNET_SYSERR if a result was invalid
*/
int
GNUNET_MY_extract_result (MYSQL_BIND * result,
int row,
struct GNUNET_MY_ResultSpec *specs)
{
unsigned int i;
int had_null = GNUNET_NO;
int ret;
for(i = 0 ; NULL != specs[i].conv ; i++)
{
struct GNUNET_MY_ResultSpec *spec;
spec = &specs[i];
ret = spec->conv(spec->conv_cls,
NULL, //wait GNUNET_MY_QueryParam
result);
if(ret == GNUNET_SYSERR)
return GNUNET_SYSERR;
if(spec->result_size != NULL)
*spec->result_size = spec->dst_size;
}
if(GNUNET_YES == had_null)
return GNUNET_NO;
return GNUNET_OK;
}
/* end of my.c */
|
