33 sqlite3_stmt *stmt = NULL;
39 "SELECT value FROM main.meta_data WHERE id IN "
40 "(SELECT imgid FROM main.selected_images) AND key = ?1 ORDER BY value",
50 "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value",
59 while(sqlite3_step(stmt) == SQLITE_ROW)
61 const char *
value = (
const char *)sqlite3_column_text(stmt, 0);
62 result = g_list_prepend(result, g_strdup(
value ?
value :
""));
64 sqlite3_finalize(stmt);
66 return g_list_reverse(result);
71 sqlite3_stmt *stmt = NULL;
74 "SELECT key, value FROM main.meta_data WHERE id=?1", -1, &stmt, NULL);
78 GList *metadata = NULL;
79 while(sqlite3_step(stmt) == SQLITE_ROW)
81 const gchar *
value = (
const char *)sqlite3_column_text(stmt, 1);
82 gchar *ckey = g_strdup_printf(
"%d", sqlite3_column_int(stmt, 0));
84 metadata = g_list_append(metadata, (gpointer)ckey);
85 metadata = g_list_append(metadata, (gpointer)cvalue);
87 sqlite3_finalize(stmt);
95 sqlite3_stmt *stmt = NULL;
97 gchar *query = g_strdup_printf(
"DELETE FROM main.meta_data WHERE id = %d AND key IN (%s)",
102 sqlite3_finalize(stmt);
113 GString *values = g_string_new(NULL);
114 for(
size_t i = 0;
i < count;
i++)
116 char *escaped = sqlite3_mprintf(
"%q", rows[
i].
value ? rows[
i].
value :
"");
117 g_string_append_printf(values,
"%s(%d,%d,'%s')", (
i > 0) ?
"," :
"",
118 rows[
i].imgid, rows[
i].keyid, escaped);
119 sqlite3_free(escaped);
122 sqlite3_stmt *stmt = NULL;
124 gchar *query = g_strdup_printf(
"INSERT INTO main.meta_data (id, key, value) VALUES %s", values->str);
128 sqlite3_finalize(stmt);
130 g_string_free(values,
TRUE);
135 sqlite3_stmt *stmt = NULL;
138 "SELECT id FROM main.meta_data WHERE value=?1", -1, &stmt, NULL);
143 if(sqlite3_step(stmt) == SQLITE_ROW && sqlite3_column_int(stmt, 0) > -1)
144 imgid = sqlite3_column_int(stmt, 0);
145 sqlite3_finalize(stmt);
158 while(sqlite3_step(stmt) == SQLITE_ROW)
159 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1));
160 sqlite3_finalize(stmt);
167 sqlite3_stmt *stmt = NULL;
170 "SELECT m.key, m.value, COUNT(m.id) AS ct"
171 " FROM main.meta_data AS m"
172 " JOIN main.selected_images AS s ON s.imgid = m.id"
173 " GROUP BY m.key, m.value ORDER BY m.value",
178 while(sqlite3_step(stmt) == SQLITE_ROW)
179 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1),
180 (uint32_t)sqlite3_column_int(stmt, 2));
181 sqlite3_finalize(stmt);
sqlite3 * dt_database_get_sqlite3_global(void)
#define IS_NULL_PTR(p)
C is way too permissive with !=, == and if(var) checks, which can mean too many things depending on w...
#define dt_free(ptr)
g_free() ptr and set it to NULL, skipping both if it is already NULL.
Checked wrappers around the sqlite3_* calls: trace the statement, assert the return code,...
#define DT_DEBUG_SQLITE3_PREPARE_V2(a, b, c, d, e)
#define DT_DEBUG_SQLITE3_BIND_TEXT(a, b, c, d, e)
#define DT_DEBUG_SQLITE3_BIND_INT(a, b, c)