33 int32_t filmroll_id = -1;
40 const char *query =
"SELECT id FROM main.film_rolls WHERE folder LIKE ?1";
42 const char *query =
"SELECT id FROM main.film_rolls WHERE folder = ?1";
46 if(sqlite3_step(stmt) == SQLITE_ROW) filmroll_id = sqlite3_column_int(stmt, 0);
47 sqlite3_finalize(stmt);
58 " FROM main.film_rolls"
59 " WHERE id = ?1", -1, &stmt, NULL);
62 if(sqlite3_step(stmt) == SQLITE_ROW)
63 folder = g_strdup((
const char *)sqlite3_column_text(stmt, 1));
64 sqlite3_finalize(stmt);
75 "INSERT INTO main.film_rolls (id, access_timestamp, folder)"
76 " VALUES (NULL, strftime('%s', 'now'), ?1)",
80 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
81 sqlite3_finalize(stmt);
90 "UPDATE main.film_rolls"
91 " SET access_timestamp = strftime('%s', 'now')"
92 " WHERE id = ?1", -1, &stmt,
96 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
97 sqlite3_finalize(stmt);
107 "UPDATE main.film_rolls SET folder=?1 WHERE id=?2", -1, &stmt, NULL);
110 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
111 sqlite3_finalize(stmt);
121 "DELETE FROM main.film_rolls WHERE id = ?1", -1,
124 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
125 sqlite3_finalize(stmt);
131 gboolean has =
FALSE;
134 "SELECT id FROM main.images WHERE film_id = ?1", -1,
137 if(sqlite3_step(stmt) == SQLITE_ROW) has =
TRUE;
138 sqlite3_finalize(stmt);
144 GList *result = NULL;
147 "SELECT id FROM main.images WHERE film_id = ?1",
150 while(sqlite3_step(stmt) == SQLITE_ROW)
152 const int id = sqlite3_column_int(stmt, 0);
153 result = g_list_prepend(result, GINT_TO_POINTER(
id));
155 sqlite3_finalize(stmt);
156 return g_list_reverse(result);
165 "SELECT id, folder FROM main.film_rolls",
167 while(sqlite3_step(stmt) == SQLITE_ROW)
168 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1));
169 sqlite3_finalize(stmt);
179 " FROM main.film_rolls AS B"
180 " WHERE (SELECT COUNT(*)"
181 " FROM main.images AS A"
182 " WHERE A.film_id=B.id) = 0",
184 while(sqlite3_step(stmt) == SQLITE_ROW)
185 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1));
186 sqlite3_finalize(stmt);
195 gchar *like = g_strdup_printf(
"%s%%", path);
197 "SELECT id, folder FROM main.film_rolls WHERE folder LIKE ?1", -1, &stmt, NULL);
201 while(sqlite3_step(stmt) == SQLITE_ROW)
202 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1));
203 sqlite3_finalize(stmt);
210 "DELETE FROM memory.film_folder",
213 sqlite3_finalize(stmt);
221 "INSERT INTO memory.film_folder (id, status) "
228 sqlite3_finalize(stmt);
sqlite3 * dt_database_get_sqlite3_global(void)
GtkWidget * folder
destination folder chooser
char * dt_film_repository_get_folder(const int32_t id)
gboolean dt_film_repository_insert(const char *folder)
void dt_film_repository_foreach_empty(dt_film_repository_row_cb cb, void *user_data)
gboolean dt_film_repository_has_images(const int32_t id)
void dt_film_repository_foreach_under(const char *path, dt_film_repository_row_cb cb, void *user_data)
int32_t dt_film_repository_find_by_folder(const char *folder)
gboolean dt_film_repository_touch_access(const int32_t id)
void dt_film_repository_foreach(dt_film_repository_row_cb cb, void *user_data)
gboolean dt_film_repository_set_folder(const int32_t id, const char *folder)
gboolean dt_film_repository_delete(const int32_t id)
void dt_film_repository_folder_status_set(const int32_t id, const gboolean present)
GList * dt_film_repository_get_image_ids(const int32_t filmid)
void dt_film_repository_folder_status_clear(void)
void(* dt_film_repository_row_cb)(void *user_data, const int32_t id, const char *folder)
#define IS_NULL_PTR(p)
C is way too permissive with !=, == and if(var) checks, which can mean too many things depending on w...
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)