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
|
/* sqlite.h -- Generic functions to simplify SQLite3 queries - data structures defined here
*
* GPLv2 - Copyright (C) 2008 David Sommerseth <dazo@users.sourceforge.net>
*
* This program 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; version 2
* of the License.
*
* This program 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 this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*
*/
#ifndef SQLITE_H_
# define SQLITE_H_
#include <stdarg.h>
#include <eurephiadb_mapping.h>
typedef struct __sqlite_header {
unsigned int fieldid;
char *name;
// char *type;
size_t namelength;
size_t maxvaluelength;
struct __sqlite_header *next;
struct __sqlite_header *prev;
} _sqlite_header;
typedef struct __sqlite_tuples {
unsigned int tupleid;
unsigned int fieldid;
char *value;
size_t length;
_sqlite_header *header;
struct __sqlite_tuples *nextfield;
struct __sqlite_tuples *prevfield;
struct __sqlite_tuples *nexttuple;
struct __sqlite_tuples *prevtuple;
} _sqlite_tuples;
typedef struct __sqlite_dbresult {
// start of the chains
_sqlite_tuples *tuples;
_sqlite_header *headerrec;
size_t num_tuples;
size_t num_fields;
// Used for search functions
_sqlite_tuples *srch_tuples;
_sqlite_header *srch_headerrec;
} dbresult;
#ifndef SQLITE_C
#define sqlite_free_results(r) { _sqlite_free_results(r); r = NULL; }
void _sqlite_free_results(dbresult *);
dbresult *sqlite_query(eurephiaCTX *ctx, const char *, ...);
dbresult *sqlite_query_mapped(eurephiaCTX *, char *, eDBfieldMap *);
char *sqlite_get_value(dbresult *res, int, int);
void sqlite_dump_result(FILE *, dbresult *);
int sqlite_get_numtuples(dbresult *);
#endif
#endif /* !SQLITE_H_ */
|
