Lines Matching refs:sql
22 #include "sql.h"
31 char *sql;
33 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
36 sql = sqlite3_vmprintf(fmt, ap);
38 ret = sqlite3_exec(db, sql, 0, 0, &errMsg);
41 DPRINTF(E_ERROR, L_DB_SQL, "SQL ERROR %d [%s]\n%s\n", ret, errMsg, sql);
45 sqlite3_free(sql);
51 sql_get_table(sqlite3 *db, const char *sql, char ***pazResult, int *pnRow, int *pnColumn)
55 //DPRINTF(E_DEBUG, L_DB_SQL, "SQL: %s\n", sql);
57 ret = sqlite3_get_table(db, sql, pazResult, pnRow, pnColumn, &errMsg);
60 DPRINTF(E_ERROR, L_DB_SQL, "SQL ERROR %d [%s]\n%s\n", ret, errMsg, sql);
73 char *sql;
78 sql = sqlite3_vmprintf(fmt, ap);
81 //DPRINTF(E_DEBUG, L_DB_SQL, "sql: %s\n", sql);
83 switch (sqlite3_prepare_v2(db, sql, -1, &stmt, NULL))
88 DPRINTF(E_ERROR, L_DB_SQL, "prepare failed: %s\n%s\n", sqlite3_errmsg(db), sql);
89 sqlite3_free(sql);
117 DPRINTF(E_WARN, L_DB_SQL, "%s: step failed: %s\n%s\n", __func__, sqlite3_errmsg(db), sql);
121 sqlite3_free(sql);
132 char *sql;
137 sql = sqlite3_vmprintf(fmt, ap);
140 //DPRINTF(E_DEBUG, L_DB_SQL, "sql: %s\n", sql);
142 switch (sqlite3_prepare_v2(db, sql, -1, &stmt, NULL))
147 DPRINTF(E_ERROR, L_DB_SQL, "prepare failed: %s\n%s\n", sqlite3_errmsg(db), sql);
148 sqlite3_free(sql);
176 DPRINTF(E_WARN, L_DB_SQL, "%s: step failed: %s\n%s\n", __func__, sqlite3_errmsg(db), sql);
180 sqlite3_free(sql);
191 char *sql;
202 sql = sqlite3_vmprintf(fmt, ap);
205 //DPRINTF(E_DEBUG, L_DB_SQL, "sql: %s\n", sql);
207 switch (sqlite3_prepare_v2(db, sql, -1, &stmt, NULL))
212 DPRINTF(E_ERROR, L_DB_SQL, "prepare failed: %s\n%s\n", sqlite3_errmsg(db), sql);
213 sqlite3_free(sql);
216 sqlite3_free(sql);