80 if(imgid <= 0)
return 0;
88 "SELECT history_end FROM main.images WHERE id=?1", -1,
93 sqlite3_clear_bindings(stmt);
95 if(sqlite3_step(stmt) == SQLITE_ROW && sqlite3_column_type(stmt, 0) != SQLITE_NULL)
96 end = sqlite3_column_int(stmt, 0);
104 if(imgid <= 0)
return FALSE;
111 "UPDATE main.images SET history_end = ?1 WHERE id = ?2", -1,
116 sqlite3_clear_bindings(stmt);
119 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
126 if(imgid <= 0)
return 0;
128 int32_t next_num = 0;
135 "SELECT IFNULL(MAX(num)+1, 0) FROM main.history"
142 sqlite3_clear_bindings(stmt);
144 if(sqlite3_step(stmt) == SQLITE_ROW)
145 next_num = sqlite3_column_int(stmt, 0);
152 if(imgid <= 0 ||
delta == 0)
return TRUE;
159 "UPDATE main.history SET num = num + ?2 WHERE imgid = ?1", -1,
164 sqlite3_clear_bindings(stmt);
167 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
173 const int op_params_size,
const int module_version,
const gboolean
enabled,
174 const void *blendop_params,
const int blendop_params_size,
175 const int blendop_version,
const int multi_priority,
const char *multi_name)
186 "SELECT num FROM main.history WHERE imgid = ?1 AND num = ?2", -1,
190 sqlite3_clear_bindings(stmt);
193 if(sqlite3_step(stmt) != SQLITE_ROW)
197 "INSERT INTO main.history (imgid, num) VALUES (?1, ?2)", -1,
201 sqlite3_clear_bindings(stmt);
204 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
210 "UPDATE main.history"
211 " SET operation = ?1, op_params = ?2, module = ?3, enabled = ?4, "
212 " blendop_params = ?7, blendop_version = ?8, multi_priority = ?9, multi_name = ?10"
213 " WHERE imgid = ?5 AND num = ?6",
218 sqlite3_clear_bindings(stmt);
229 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
237 if(imgid <= 0)
return FALSE;
243 "DELETE FROM main.history WHERE imgid = ?1", -1,
247 sqlite3_clear_bindings(stmt);
249 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
256 if(imgid <= 0)
return FALSE;
262 "DELETE FROM main.masks_history WHERE imgid = ?1", -1,
266 sqlite3_clear_bindings(stmt);
268 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
275 if(imgid <= 0)
return FALSE;
292 "SELECT imgid, num, module, operation,"
293 " op_params, enabled, blendop_params,"
294 " blendop_version, multi_priority, multi_name"
304 sqlite3_clear_bindings(stmt);
307 while(sqlite3_step(stmt) == SQLITE_ROW)
309 const int32_t
id = sqlite3_column_int(stmt, 0);
310 const int num = sqlite3_column_int(stmt, 1);
311 const int modversion = sqlite3_column_int(stmt, 2);
312 const char *operation = (
const char *)sqlite3_column_text(stmt, 3);
313 const void *module_params = sqlite3_column_blob(stmt, 4);
314 const gboolean
enabled = sqlite3_column_int(stmt, 5) != 0;
315 const void *blendop_params = sqlite3_column_blob(stmt, 6);
316 const int blendop_version = sqlite3_column_int(stmt, 7);
317 const int multi_priority = sqlite3_column_int(stmt, 8);
318 const char *multi_name = (
const char *)sqlite3_column_text(stmt, 9);
319 const int param_length = sqlite3_column_bytes(stmt, 4);
320 const int bl_length = sqlite3_column_bytes(stmt, 6);
322 cb(user_data,
id, num, modversion, operation, module_params, param_length,
enabled,
323 blendop_params, bl_length, blendop_version, multi_priority, multi_name,
"");
341 const char *table = use_modern_presets ?
"data.presets" :
"main.legacy_presets";
344 char *query = g_strdup_printf(
345 " SELECT ?1, 0, op_version, operation, op_params,"
346 " enabled, blendop_params, blendop_version, multi_priority, multi_name, name"
348 " WHERE ( (autoapply=1"
349 " AND ((?2 LIKE model AND ?3 LIKE maker) OR (?4 LIKE model AND ?5 LIKE maker))"
350 " AND ?6 LIKE lens AND ?7 BETWEEN iso_min AND iso_max"
351 " AND ?8 BETWEEN exposure_min AND exposure_max"
352 " AND ?9 BETWEEN aperture_min AND aperture_max"
353 " AND ?10 BETWEEN focal_length_min AND focal_length_max"
354 " AND (format = 0 OR (format & ?11 != 0 AND ~format & ?12 != 0)))"
356 " AND operation NOT IN"
357 " ('ioporder', 'metadata', 'modulegroups', 'export', 'tagging', 'collect', 'basecurve')"
358 " ORDER BY writeprotect DESC, LENGTH(model), LENGTH(maker), LENGTH(lens)",
366 sqlite3_stmt *stmt = *stmt_ptr;
368 sqlite3_clear_bindings(stmt);
383 while(sqlite3_step(stmt) == SQLITE_ROW)
385 const int32_t
id = sqlite3_column_int(stmt, 0);
386 const int num = sqlite3_column_int(stmt, 1);
387 const int modversion = sqlite3_column_int(stmt, 2);
388 const char *operation = (
const char *)sqlite3_column_text(stmt, 3);
389 const void *module_params = sqlite3_column_blob(stmt, 4);
390 const int enabled = sqlite3_column_int(stmt, 5);
391 const void *blendop_params = sqlite3_column_blob(stmt, 6);
392 const int blendop_version = sqlite3_column_int(stmt, 7);
393 const int multi_priority = sqlite3_column_int(stmt, 8);
394 const char *multi_name = (
const char *)sqlite3_column_text(stmt, 9);
395 const char *preset_name = (
const char *)sqlite3_column_text(stmt, 10);
396 const int param_length = sqlite3_column_bytes(stmt, 4);
397 const int bl_length = sqlite3_column_bytes(stmt, 6);
399 cb(user_data,
id, num, modversion, operation, module_params, param_length,
enabled,
400 blendop_params, bl_length, blendop_version, multi_priority, multi_name, preset_name);
407 const int iformat,
const int excluded,
void **
params,
424 " AND ((?2 LIKE model AND ?3 LIKE maker) OR (?4 LIKE model AND ?5 LIKE maker))"
425 " AND ?6 LIKE lens AND ?7 BETWEEN iso_min AND iso_max"
426 " AND ?8 BETWEEN exposure_min AND exposure_max"
427 " AND ?9 BETWEEN aperture_min AND aperture_max"
428 " AND ?10 BETWEEN focal_length_min AND focal_length_max"
429 " AND (format = 0 OR (format & ?11 != 0 AND ~format & ?12 != 0))"
430 " AND operation = 'ioporder'"
431 " ORDER BY writeprotect DESC, LENGTH(model), LENGTH(maker), LENGTH(lens)",
438 sqlite3_clear_bindings(stmt);
453 if(sqlite3_step(stmt) == SQLITE_ROW)
455 const void *blob = sqlite3_column_blob(stmt, 0);
456 const int32_t blob_len = sqlite3_column_bytes(stmt, 0);
457 if(blob && blob_len > 0)
459 *
params = g_malloc(blob_len);
461 *params_len = blob_len;
479 "SELECT COUNT(imgid) FROM main.history WHERE imgid = ?1", -1,
484 sqlite3_clear_bindings(stmt);
486 if(sqlite3_step(stmt) == SQLITE_ROW)
487 found_it = sqlite3_column_int(stmt, 0);
495 void **
params, int32_t *params_len)
508 "SELECT op_params, enabled"
510 " WHERE imgid=?1 AND operation=?2"
511 " ORDER BY num DESC LIMIT 1", -1,
516 if(sqlite3_step(stmt) == SQLITE_ROW && sqlite3_column_int(stmt, 1) != 0)
520 const void *blob = sqlite3_column_blob(stmt, 0);
521 const int32_t len = sqlite3_column_bytes(stmt, 0);
530 sqlite3_finalize(stmt);
536 gboolean result =
FALSE;
546 " WHERE imgid= ?1 AND operation = ?2",
552 sqlite3_clear_bindings(stmt);
555 if (sqlite3_step(stmt) == SQLITE_ROW) result =
TRUE;
564 if(imgid <= 0)
return FALSE;
572 "DELETE FROM main.history WHERE imgid = ?1",
575 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
576 sqlite3_finalize(stmt);
579 "DELETE FROM main.module_order WHERE imgid = ?1",
582 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
583 sqlite3_finalize(stmt);
588 " SET history_end = 0, aspect_ratio = 0.0"
593 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
594 sqlite3_finalize(stmt);
597 "DELETE FROM main.masks_history WHERE imgid = ?1",
600 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
601 sqlite3_finalize(stmt);
604 "DELETE FROM main.history_hash WHERE imgid = ?1",
607 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
608 sqlite3_finalize(stmt);
623 "SELECT num, operation, enabled, multi_name"
626 " AND num IN (SELECT MAX(num)"
627 " FROM main.history hst2"
628 " WHERE hst2.imgid=?1"
629 " AND hst2.operation=main.history.operation"
630 " GROUP BY multi_priority)"
631 " AND enabled in (1, ?2)"
632 " ORDER BY num DESC",
638 while(sqlite3_step(stmt) == SQLITE_ROW)
639 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1),
640 sqlite3_column_int(stmt, 2), (
const char *)sqlite3_column_text(stmt, 3));
642 sqlite3_finalize(stmt);
654 "SELECT operation, enabled, multi_name"
656 " WHERE imgid=?1 ORDER BY num DESC", -1, &stmt, NULL);
660 while(sqlite3_step(stmt) == SQLITE_ROW)
661 cb(user_data, 0, (
const char *)sqlite3_column_text(stmt, 0), sqlite3_column_int(stmt, 1),
662 (
const char *)sqlite3_column_text(stmt, 2));
664 sqlite3_finalize(stmt);
668 const int form,
const char *
name,
const int version,
669 const void *points,
const int points_len,
670 const int points_count,
const void *source,
671 const int source_len)
677 "INSERT INTO main.masks_history (imgid, num, formid, form, name, version, points, points_count, source) "
678 "VALUES (?1, ?9, ?2, ?3, ?4, ?5, ?6, ?7, ?8)",
691 const int rc = sqlite3_step(stmt);
692 sqlite3_finalize(stmt);
693 return (rc == SQLITE_DONE);
701 "SELECT COUNT(*) FROM main.masks_history WHERE imgid = ?1", -1,
704 if(sqlite3_step(stmt) == SQLITE_ROW)
705 num_masks = sqlite3_column_int(stmt, 0);
706 sqlite3_finalize(stmt);
719 "SELECT imgid, formid, form, name, version, points, points_count, source, num"
720 " FROM main.masks_history"
726 while(sqlite3_step(stmt) == SQLITE_ROW)
728 cb(user_data, sqlite3_column_int(stmt, 8), sqlite3_column_int(stmt, 1),
729 sqlite3_column_int(stmt, 2), (
const char *)sqlite3_column_text(stmt, 3),
730 sqlite3_column_int(stmt, 4), sqlite3_column_blob(stmt, 5), sqlite3_column_bytes(stmt, 5),
731 sqlite3_column_int(stmt, 6), sqlite3_column_blob(stmt, 7), sqlite3_column_bytes(stmt, 7));
733 sqlite3_finalize(stmt);
737 const int op_params_size)
739 sqlite3_stmt *stmt = NULL;
741 "SELECT module FROM main.history WHERE operation = ?1 AND op_params = ?2",
748 const int version = (sqlite3_step(stmt) == SQLITE_ROW) ? sqlite3_column_int(stmt, 0) : 0;
749 sqlite3_finalize(stmt);
760 sqlite3_stmt *stmt = NULL;
763 "SELECT MIN(num) AS num, operation, multi_name "
765 "WHERE imgid = ?1 AND enabled = 1 "
766 "GROUP BY operation, multi_name "
767 "ORDER BY MIN(num) ASC", -1, &stmt, NULL);
772 while(sqlite3_step(stmt) == SQLITE_ROW)
773 cb(user_data, sqlite3_column_int(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1),
774 (
const char *)sqlite3_column_text(stmt, 2));
775 sqlite3_finalize(stmt);
789 "SELECT version FROM main.module_order WHERE imgid = ?1", -1,
794 sqlite3_clear_bindings(stmt);
796 const gboolean found = (sqlite3_step(stmt) == SQLITE_ROW);
797 if(found) *version = sqlite3_column_int(stmt, 0);
814 row->iop_list = NULL;
815 if(imgid <= 0)
return FALSE;
823 "SELECT version, iop_list"
824 " FROM main.module_order"
830 sqlite3_clear_bindings(stmt);
833 const gboolean found = (sqlite3_step(stmt) == SQLITE_ROW);
836 row->version = sqlite3_column_int(stmt, 0);
837 if(sqlite3_column_type(stmt, 1) != SQLITE_NULL)
839 const char *buf = (
const char *)sqlite3_column_text(stmt, 1);
841 if(buf)
row->iop_list = g_strdup(buf);
862 row->iop_list = NULL;
866 const char *iop_list)
868 if(imgid <= 0)
return FALSE;
876 "INSERT OR REPLACE INTO main.module_order VALUES (?1, 0, NULL)",
890 "UPDATE main.module_order SET version = ?2, iop_list = ?3"
897 sqlite3_clear_bindings(stmt);
901 ok = (sqlite3_step(stmt) == SQLITE_DONE);
909 "UPDATE main.module_order SET version = ?2, iop_list = NULL"
916 sqlite3_clear_bindings(stmt);
919 ok = (sqlite3_step(stmt) == SQLITE_DONE);
sqlite3 * dt_database_get_sqlite3_global(void)
static int dt_pthread_mutex_unlock(dt_pthread_mutex_t *mutex) RELEASE(mutex) NO_THREAD_SAFETY_ANALYSIS
static int dt_pthread_mutex_init(dt_pthread_mutex_t *mutex, const pthread_mutexattr_t *mutexattr)
Initialise a mutex. With mutexattr NULL – which is how 54 of the 56 call sites in this tree spell it ...
static int dt_pthread_mutex_lock(dt_pthread_mutex_t *mutex) ACQUIRE(mutex) NO_THREAD_SAFETY_ANALYSIS
memcpy(roundtrip, origin, sizeof(roundtrip))
void dt_history_repository_foreach_auto_preset_row(const int32_t imgid, const dt_image_t *image, const char *workflow_preset, const int iformat, const int excluded, dt_history_repository_row_cb cb, void *user_data)
static sqlite3_stmt * _module_order_select_stmt
static sqlite3_stmt * _history_check_module_exists_stmt
static sqlite3_stmt * _history_select_history_stmt
static sqlite3_stmt * _history_get_next_num_stmt
static sqlite3_stmt * _history_update_item_stmt
static void _history_stmt_mutex_ensure(void)
gboolean dt_history_repository_get_module_order(const int32_t imgid, dt_module_order_row_t *row)
Read imgid's row. FALSE when there is none, and row is then left zeroed.
static gsize _history_stmt_mutex_inited
void dt_history_repository_foreach_last_item(const int32_t imgid, const gboolean enabled, dt_history_repository_item_cb cb, void *user_data)
void dt_history_repository_foreach_mask_item(const int32_t imgid, dt_history_repository_mask_cb cb, void *user_data)
gboolean dt_history_repository_get_last_enabled_params(const int32_t imgid, const char *operation, void **params, int32_t *params_len)
gboolean dt_history_repository_delete_dev_history(const int32_t imgid)
gboolean dt_history_repository_shift_nums(const int32_t imgid, const int delta)
gboolean dt_history_repository_write_item(const int32_t imgid, const int num, const char *operation, const void *op_params, const int op_params_size, const int module_version, const gboolean enabled, const void *blendop_params, const int blendop_params_size, const int blendop_version, const int multi_priority, const char *multi_name)
static sqlite3_stmt * _history_shift_history_nums_stmt
static sqlite3_stmt * _module_order_update_list_stmt
static sqlite3_stmt * _history_count_items_stmt
gboolean dt_history_repository_write_mask_item(const int32_t imgid, const int num, const int formid, const int form, const char *name, const int version, const void *points, const int points_len, const int points_count, const void *source, const int source_len)
static sqlite3_stmt * _history_delete_history_stmt
int dt_history_repository_count_mask_items(const int32_t imgid)
static sqlite3_stmt * _history_insert_num_stmt
static sqlite3_stmt * _history_auto_presets_legacy_stmt
void dt_history_repository_cleanup(void)
gboolean dt_history_repository_module_exists(const int32_t imgid, const char *operation)
static sqlite3_stmt * _module_order_select_version_stmt
static sqlite3_stmt * _history_delete_masks_stmt
gboolean dt_history_repository_delete_masks_history(const int32_t imgid)
static sqlite3_stmt * _module_order_insert_stmt
gboolean dt_history_repository_delete_all_for_image(const int32_t imgid)
void dt_module_order_row_cleanup(dt_module_order_row_t *row)
Release what dt_history_repository_get_module_order() allocated.
gboolean dt_history_repository_get_autoapply_ioporder_params(const int32_t imgid, const dt_image_t *image, const int iformat, const int excluded, void **params, int32_t *params_len)
static sqlite3_stmt * _history_set_end_stmt
gboolean dt_history_repository_set_module_order(const int32_t imgid, const int version, const char *iop_list)
Store imgid's order: version, and iop_list serialized or NULL.
static sqlite3_stmt * _history_auto_ioporder_stmt
void dt_history_repository_foreach_item(const int32_t imgid, dt_history_repository_item_cb cb, void *user_data)
int dt_history_repository_find_version_for_params(const char *operation, const void *op_params, const int op_params_size)
The module version some image's history recorded for this exact parameter blob.
gboolean dt_history_repository_delete_history(const int32_t imgid)
static sqlite3_stmt * _history_get_end_stmt
static dt_pthread_mutex_t _history_stmt_mutex
int dt_history_repository_count_items(const int32_t imgid)
static sqlite3_stmt * _module_order_update_null_stmt
gboolean dt_history_repository_set_end(const int32_t imgid, const int32_t history_end)
gboolean dt_history_repository_has_custom_module_order(const int32_t imgid)
Whether imgid's row stores a serialized list, i.e. iop_list IS NOT NULL.
gboolean dt_history_repository_get_module_order_version(const int32_t imgid, int *version)
imgid's stored order version.
static sqlite3_stmt * _history_select_num_stmt
gboolean dt_history_repository_has_module_order(const int32_t imgid)
Whether imgid has a main.module_order row at all, whatever it says.
static sqlite3_stmt * _history_auto_presets_stmt
int32_t dt_history_repository_get_end(const int32_t imgid)
int32_t dt_history_repository_get_next_num(const int32_t imgid)
void dt_history_repository_foreach_active_module(const int32_t imgid, dt_history_repository_active_module_cb cb, void *user_data)
Every module an image has enabled, once each, in the order they run.
void dt_history_repository_foreach_row(const int32_t imgid, dt_history_repository_row_cb cb, void *user_data)
void(* dt_history_repository_active_module_cb)(void *user_data, const int num, const char *operation, const char *multi_name)
void(* dt_history_repository_item_cb)(void *user_data, const int num, const char *operation, const gboolean enabled, const char *multi_name)
void(* dt_history_repository_mask_cb)(void *user_data, const int num, const int formid, const int form, const char *name, const int version, const void *points, const int points_len, const int points_count, const void *source, const int source_len)
void(* dt_history_repository_row_cb)(void *user_data, const int32_t imgid, const int num, const int module_version, const char *operation, const void *op_params, const int op_params_len, const gboolean enabled, const void *blendop_params, const int blendop_params_len, const int blendop_version, const int multi_priority, const char *multi_name, const char *preset_name)
@ DT_IMAGE_NO_LEGACY_PRESETS
static const dt_iop_drawlayer_params_t * params
#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_BIND_BLOB(a, b, c, d, e)
#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)
#define DT_DEBUG_SQLITE3_BIND_DOUBLE(a, b, c)
One main.module_order row.