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 <sqlite3.h> 28 29int 30sql_exec(sqlite3 *db, const char *fmt, ...); 31 32int 33sql_get_table(sqlite3 *db, const char *zSql, char ***pazResult, int *pnRow, int *pnColumn); 34 35int 36sql_get_int_field(sqlite3 *db, const char *fmt, ...); 37 38char * 39sql_get_text_field(sqlite3 *db, const char *fmt, ...); 40 41int 42db_upgrade(sqlite3 *db); 43 44#endif 45