diff options
Diffstat (limited to 'src/lib/sq/sq_exec.c')
-rw-r--r-- | src/lib/sq/sq_exec.c | 113 |
1 files changed, 113 insertions, 0 deletions
diff --git a/src/lib/sq/sq_exec.c b/src/lib/sq/sq_exec.c new file mode 100644 index 000000000..d4690ee99 --- /dev/null +++ b/src/lib/sq/sq_exec.c | |||
@@ -0,0 +1,113 @@ | |||
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 | */ | ||
20 | /** | ||
21 | * @file sq/sq_exec.c | ||
22 | * @brief helper functions for executing SQL statements | ||
23 | * @author Christian Grothoff | ||
24 | */ | ||
25 | #include "platform.h" | ||
26 | #include "gnunet_sq_lib.h" | ||
27 | |||
28 | |||
29 | /** | ||
30 | * Create a `struct GNUNET_SQ_ExecuteStatement` where errors are fatal. | ||
31 | * | ||
32 | * @param sql actual SQL statement | ||
33 | * @return initialized struct | ||
34 | */ | ||
35 | struct GNUNET_SQ_ExecuteStatement | ||
36 | GNUNET_SQ_make_execute (const char *sql) | ||
37 | { | ||
38 | struct GNUNET_SQ_ExecuteStatement es = { | ||
39 | .sql = sql, | ||
40 | .ignore_errors = GNUNET_NO | ||
41 | }; | ||
42 | |||
43 | return es; | ||
44 | } | ||
45 | |||
46 | |||
47 | /** | ||
48 | * Create a `struct GNUNET_SQ_ExecuteStatement` where errors should | ||
49 | * be tolerated. | ||
50 | * | ||
51 | * @param sql actual SQL statement | ||
52 | * @return initialized struct | ||
53 | */ | ||
54 | struct GNUNET_SQ_ExecuteStatement | ||
55 | GNUNET_SQ_make_try_execute (const char *sql) | ||
56 | { | ||
57 | struct GNUNET_SQ_ExecuteStatement es = { | ||
58 | .sql = sql, | ||
59 | .ignore_errors = GNUNET_YES | ||
60 | }; | ||
61 | |||
62 | return es; | ||
63 | } | ||
64 | |||
65 | |||
66 | /** | ||
67 | * Request execution of an array of statements @a es from Postgres. | ||
68 | * | ||
69 | * @param dbh database to execute the statements over | ||
70 | * @param es #GNUNET_PQ_PREPARED_STATEMENT_END-terminated array of prepared | ||
71 | * statements. | ||
72 | * @return #GNUNET_OK on success (modulo statements where errors can be ignored) | ||
73 | * #GNUNET_SYSERR on error | ||
74 | */ | ||
75 | enum GNUNET_GenericReturnValue | ||
76 | GNUNET_SQ_exec_statements (sqlite3 *dbh, | ||
77 | const struct GNUNET_SQ_ExecuteStatement *es) | ||
78 | { | ||
79 | for (unsigned int i = 0; NULL != es[i].sql; i++) | ||
80 | { | ||
81 | char *emsg = NULL; | ||
82 | |||
83 | if (SQLITE_OK != | ||
84 | sqlite3_exec (dbh, | ||
85 | es[i].sql, | ||
86 | NULL, | ||
87 | NULL, | ||
88 | &emsg)) | ||
89 | { | ||
90 | if (es[i].ignore_errors) | ||
91 | { | ||
92 | GNUNET_log (GNUNET_ERROR_TYPE_DEBUG, | ||
93 | "Failed to run SQL `%s': %s\n", | ||
94 | es[i].sql, | ||
95 | emsg); | ||
96 | } | ||
97 | else | ||
98 | { | ||
99 | GNUNET_log (GNUNET_ERROR_TYPE_ERROR, | ||
100 | "Failed to run SQL `%s': %s\n", | ||
101 | es[i].sql, | ||
102 | emsg); | ||
103 | sqlite3_free (emsg); | ||
104 | return GNUNET_SYSERR; | ||
105 | } | ||
106 | sqlite3_free (emsg); | ||
107 | } | ||
108 | } | ||
109 | return GNUNET_OK; | ||
110 | } | ||
111 | |||
112 | |||
113 | /* end of sq_exec */ | ||