1 #define _POSIX_C_SOURCE 200809L
9 #define SQLERROR(x) fprintf(stderr, "%s %d: %s\n", __func__, __LINE__, (x))
11 sqlite3_stmt *zpm_dbqueryv(struct zpm *zpm, char *query, va_list args) {
17 if (!zpm || zpm->error) {
28 sql = sqlite3_vmprintf(query, args);
35 rv = sqlite3_prepare_v2(db, sql, strlen(sql), &st, NULL);
36 if (rv != SQLITE_OK) {
37 SQLERROR(sqlite3_errmsg(db));
45 sqlite3_stmt *zpm_dbquery(struct zpm *zpm, char *query, ...) {
49 if (!zpm || zpm->error) {
58 va_start(args, query);
59 st = zpm_dbqueryv(zpm, query, args);
65 char *zpm_db_string(struct zpm *zpm, char *query, ...) {
71 va_start(args, query);
72 st = zpm_dbqueryv(zpm, query, args);
75 rv = sqlite3_step(st);
77 if (rv == SQLITE_ROW) {
78 result = (char *)sqlite3_column_text(st, 0);
80 result = strdup(result);