GNUnet  0.10.x
sq_prepare.c
Go to the documentation of this file.
1 /*
2  This file is part of GNUnet
3  Copyright (C) 2018 GNUnet e.V.
4 
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.
9 
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.
14 
15  You should have received a copy of the GNU Affero General Public License
16  along with this program. If not, see <http://www.gnu.org/licenses/>.
17 
18  SPDX-License-Identifier: AGPL3.0-or-later
19  */
25 #include "platform.h"
26 #include "gnunet_sq_lib.h"
27 
28 
38  sqlite3_stmt **pstmt)
39 {
40  struct GNUNET_SQ_PrepareStatement ps = {
41  .sql = sql,
42  .pstmt = pstmt
43  };
44 
45  return ps;
46 }
47 
48 
49 
58 int
59 GNUNET_SQ_prepare(sqlite3 *dbh,
60  const struct GNUNET_SQ_PrepareStatement *ps)
61 {
62  for (unsigned int i = 0; NULL != ps[i].sql; i++)
63  {
64  const char *epos = NULL;
65  int ret;
66 
67  if (SQLITE_OK !=
68  (ret = sqlite3_prepare_v2(dbh,
69  ps[i].sql,
70  strlen(ps[i].sql),
71  ps[i].pstmt,
72  &epos)))
73  {
75  "Failed to prepare SQL `%s': error %d at %s\n",
76  ps[i].sql,
77  ret,
78  epos);
79  return GNUNET_SYSERR;
80  }
81  }
82  return GNUNET_OK;
83 }
84 
85 /* end of sq_prepare.c */
Information needed to run a list of SQL statements using GNUNET_SQ_exec_statements().
#define GNUNET_OK
Named constants for return values.
Definition: gnunet_common.h:75
static int ret
Final status code.
Definition: gnunet-arm.c:89
const char * sql
Actual SQL statement.
#define GNUNET_SYSERR
Definition: gnunet_common.h:76
helper functions for Sqlite3 DB interactions
#define GNUNET_log(kind,...)
sqlite3_stmt ** pstmt
Where to store handle?
struct GNUNET_SQ_PrepareStatement GNUNET_SQ_make_prepare(const char *sql, sqlite3_stmt **pstmt)
Create a struct GNUNET_SQ_PrepareStatement
Definition: sq_prepare.c:37
int GNUNET_SQ_prepare(sqlite3 *dbh, const struct GNUNET_SQ_PrepareStatement *ps)
Prepare all statements given in the (NULL,NULL)-terminated array at ps.
Definition: sq_prepare.c:59