1/* Reusable SQLite3 wrapper functions
2 *
3 * Project : minidlna
4 * Website : http://sourceforge.net/projects/minidlna/
5 * Author  : Justin Maggard
6 *
7 * MiniDLNA media server
8 * Copyright (C) 2008-2009  Justin Maggard
9 *
10 * This file is part of MiniDLNA.
11 *
12 * MiniDLNA is free software; you can redistribute it and/or modify
13 * it under the terms of the GNU General Public License version 2 as
14 * published by the Free Software Foundation.
15 *
16 * MiniDLNA is distributed in the hope that it will be useful,
17 * but WITHOUT ANY WARRANTY; without even the implied warranty of
18 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
19 * GNU General Public License for more details.
20 *
21 * You should have received a copy of the GNU General Public License
22 * along with MiniDLNA. If not, see <http://www.gnu.org/licenses/>.
23 */
24#ifndef __SQL_H__
25#define __SQL_H__
26
27#include <stdint.h>
28#include <sqlite3.h>
29
30#ifndef HAVE_SQLITE3_MALLOC
31#define sqlite3_malloc(size) sqlite3_mprintf("%*s", size, "")
32#endif
33#ifndef HAVE_SQLITE3_PREPARE_V2
34#define sqlite3_prepare_v2 sqlite3_prepare
35#endif
36
37int sql_exec(sqlite3 *db, const char *fmt, ...);
38int sql_get_table(sqlite3 *db, const char *zSql, char ***pazResult, int *pnRow, int *pnColumn);
39int sql_get_int_field(sqlite3 *db, const char *fmt, ...);
40int64_t sql_get_int64_field(sqlite3 *db, const char *fmt, ...);
41char * sql_get_text_field(sqlite3 *db, const char *fmt, ...);
42int db_upgrade(sqlite3 *db);
43
44#endif
45