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
|
/*
* Copyright (c) 2015, Vsevolod Stakhov
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
* * Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
* * Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in the
* documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY AUTHOR ''AS IS'' AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL AUTHOR BE LIABLE FOR ANY
* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
#ifndef SRC_LIBUTIL_SQLITE_UTILS_H_
#define SRC_LIBUTIL_SQLITE_UTILS_H_
#include "config.h"
#include "mem_pool.h"
#include "sqlite3.h"
#define RSPAMD_SQLITE3_STMT_MULTIPLE (1 << 0)
struct rspamd_sqlite3_prstmt {
gint idx;
const gchar *sql;
const gchar *args;
sqlite3_stmt *stmt;
gint result;
const gchar *ret;
gint flags;
};
/**
* Create prepared statements for specified database from init statements
* @param db
* @param max_idx
* @param err
* @return new prepared statements array or NULL
*/
GArray* rspamd_sqlite3_init_prstmt (sqlite3 *db,
struct rspamd_sqlite3_prstmt *init_stmt,
gint max_idx,
GError **err);
/**
* Run prepared statements by its index getting parameters and setting results from
* varargs structure
* @param db
* @param stmts
* @param idx
* @return
*/
gint rspamd_sqlite3_run_prstmt (rspamd_mempool_t *pool, sqlite3 *db, GArray *stmts,
gint idx, ...);
/**
* Close and free prepared statements
* @param db
* @param stmts
*/
void rspamd_sqlite3_close_prstmt (sqlite3 *db, GArray *stmts);
/**
* Creates or opens sqlite database trying to share it between processes
* @param path
* @param create_sql
* @return
*/
sqlite3 * rspamd_sqlite3_open_or_create (rspamd_mempool_t *pool, const gchar *path, const
gchar *create_sql, GError **err);
/**
* Sync sqlite3 db ensuring that all wal things are done
* @param db
*/
gboolean rspamd_sqlite3_sync (sqlite3 *db, gint *wal_frames, gint *wal_checkpoints);
#endif /* SRC_LIBUTIL_SQLITE_UTILS_H_ */
|
