60 GString *s = g_string_new(negate ?
"num NOT IN (" :
"num IN (");
61 for(GList *l = nums; l; l = g_list_next(l))
63 if(l != nums) g_string_append_c(s,
',');
64 g_string_append_printf(s,
"%d", GPOINTER_TO_INT(l->data));
66 g_string_append_c(s,
')');
67 return g_string_free(s,
FALSE);
81 "SELECT id FROM data.styles WHERE name=?1 ORDER BY id DESC LIMIT 1", -1, &stmt,
84 if(sqlite3_step(stmt) == SQLITE_ROW)
86 id = sqlite3_column_int(stmt, 0);
88 sqlite3_finalize(stmt);
94 if(styleid == 0)
return NULL;
102 description = (
char *)sqlite3_column_text(stmt, 0);
104 sqlite3_finalize(stmt);
112 char *iop_list_txt = NULL;
125 if(sqlite3_column_type(stmt, 0) != SQLITE_NULL)
126 iop_list_txt = g_strdup((
const char *)sqlite3_column_text(stmt, 0));
127 sqlite3_finalize(stmt);
132 const char *iop_list_txt)
140 "INSERT INTO data.styles (name, description, id, iop_list)"
141 " VALUES (?1, ?2, (SELECT COALESCE(MAX(id),0)+1 FROM data.styles), ?3)", -1, &stmt, NULL);
150 sqlite3_bind_null(stmt, 3);
152 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
153 sqlite3_finalize(stmt);
159 if(styleid == 0)
return FALSE;
165 "UPDATE data.styles SET iop_list=?1 WHERE id=?2", -1, &stmt, NULL);
172 "UPDATE data.styles SET iop_list=NULL WHERE id=?1", -1, &stmt, NULL);
176 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
177 sqlite3_finalize(stmt);
184 if(styleid == 0)
return FALSE;
188 "UPDATE data.styles SET name=?1, description=?2 WHERE id=?3", -1, &stmt, NULL);
192 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
193 sqlite3_finalize(stmt);
199 if(styleid == 0)
return FALSE;
208 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
209 sqlite3_finalize(stmt);
215 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
216 sqlite3_finalize(stmt);
226 char filterstring[512] = { 0 };
227 snprintf(filterstring,
sizeof(filterstring),
"%%%s%%", filter);
235 "SELECT name, description FROM data.styles WHERE name LIKE ?1 OR description LIKE ?1 ORDER BY name", -1,
240 sqlite3_clear_bindings(stmt);
243 while(sqlite3_step(stmt) == SQLITE_ROW)
244 cb(user_data, (
const char *)sqlite3_column_text(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1));
254 gboolean found =
FALSE;
257 "SELECT name, description FROM data.styles WHERE name = ?1", -1, &stmt, NULL);
259 if(sqlite3_step(stmt) == SQLITE_ROW)
261 cb(user_data, (
const char *)sqlite3_column_text(stmt, 0), (
const char *)sqlite3_column_text(stmt, 1));
264 sqlite3_finalize(stmt);
283 "SELECT num, module, operation, op_params, enabled,"
284 " blendop_params, blendop_version, multi_priority, multi_name"
285 " FROM data.style_items WHERE styleid=?1 "
286 " ORDER BY num, operation, multi_priority",
293 sqlite3_clear_bindings(stmt);
296 while(sqlite3_step(stmt) == SQLITE_ROW)
300 cb(user_data, sqlite3_column_int(stmt, 0), sqlite3_column_int(stmt, 7), sqlite3_column_int(stmt, 1),
301 (
const char *)sqlite3_column_text(stmt, 2), sqlite3_column_int(stmt, 4),
302 sqlite3_column_blob(stmt, 3), sqlite3_column_bytes(stmt, 3),
303 sqlite3_column_blob(stmt, 5), sqlite3_column_bytes(stmt, 5),
304 sqlite3_column_int(stmt, 6), (
const char *)sqlite3_column_text(stmt, 8), 0, 0.0);
319 "SELECT num, module, operation, op_params, enabled,"
320 " blendop_params, blendop_version, multi_priority, multi_name"
321 " FROM data.style_items"
322 " WHERE styleid =?1",
327 while(sqlite3_step(stmt) == SQLITE_ROW)
329 cb(user_data, sqlite3_column_int(stmt, 0), sqlite3_column_int(stmt, 7), sqlite3_column_int(stmt, 1),
330 (
const char *)sqlite3_column_text(stmt, 2), sqlite3_column_int(stmt, 4),
331 sqlite3_column_blob(stmt, 3), sqlite3_column_bytes(stmt, 3),
332 sqlite3_column_blob(stmt, 5), sqlite3_column_bytes(stmt, 5),
333 sqlite3_column_int(stmt, 6), (
const char *)sqlite3_column_text(stmt, 8), -1, 0.0);
335 sqlite3_finalize(stmt);
346 "SELECT num, multi_priority, module, operation, enabled, op_params, blendop_params, "
347 " multi_name, blendop_version"
348 " FROM data.style_items"
349 " WHERE styleid=?1 ORDER BY num DESC",
354 while(sqlite3_step(stmt) == SQLITE_ROW)
356 const int num = (sqlite3_column_type(stmt, 0) == SQLITE_NULL) ? -1 : sqlite3_column_int(stmt, 0);
358 cb(user_data, num, sqlite3_column_int(stmt, 1), sqlite3_column_int(stmt, 2),
359 (
const char *)sqlite3_column_text(stmt, 3), sqlite3_column_int(stmt, 4),
360 sqlite3_column_blob(stmt, 5), sqlite3_column_bytes(stmt, 5),
361 sqlite3_column_blob(stmt, 6), sqlite3_column_bytes(stmt, 6),
362 sqlite3_column_int(stmt, 8), (
const char *)sqlite3_column_text(stmt, 7), -1,
363 sqlite3_column_double(stmt, 8));
365 sqlite3_finalize(stmt);
376 "SELECT num, multi_priority, module, operation, enabled, 0, 0, multi_name"
377 " FROM data.style_items"
378 " WHERE styleid=?1 ORDER BY num DESC",
383 while(sqlite3_step(stmt) == SQLITE_ROW)
385 const int num = (sqlite3_column_type(stmt, 0) == SQLITE_NULL) ? -1 : sqlite3_column_int(stmt, 0);
388 cb(user_data, num, sqlite3_column_int(stmt, 1), sqlite3_column_int(stmt, 2),
389 (
const char *)sqlite3_column_text(stmt, 3), sqlite3_column_int(stmt, 4),
391 sqlite3_column_int(stmt, 8), (
const char *)sqlite3_column_text(stmt, 7), -1,
392 sqlite3_column_double(stmt, 8));
394 sqlite3_finalize(stmt);
410 "SELECT num, multi_priority, module, operation, enabled,"
414 " AND operation=data.style_items.operation"
415 " AND multi_priority=data.style_items.multi_priority),"
416 " 0, multi_name, blendop_version"
417 " FROM data.style_items"
420 " SELECT -1,main.history.multi_priority,main.history.module,main.history.operation,main.history.enabled, "
421 " main.history.num,0,multi_name, blendop_version"
423 " WHERE imgid=?2 AND main.history.enabled=1"
424 " AND (main.history.operation NOT IN (SELECT operation FROM data.style_items WHERE styleid=?1))"
425 " GROUP BY operation HAVING MAX(num) ORDER BY num DESC", -1, &stmt, NULL);
430 while(sqlite3_step(stmt) == SQLITE_ROW)
432 const int num = (sqlite3_column_type(stmt, 0) == SQLITE_NULL) ? -1 : sqlite3_column_int(stmt, 0);
433 const int selimg_num = (sqlite3_column_type(stmt, 5) == SQLITE_NULL) ? -1 : sqlite3_column_int(stmt, 5);
434 cb(user_data, num, sqlite3_column_int(stmt, 1), sqlite3_column_int(stmt, 2),
435 (
const char *)sqlite3_column_text(stmt, 3), sqlite3_column_int(stmt, 4),
437 sqlite3_column_int(stmt, 8), (
const char *)sqlite3_column_text(stmt, 7), selimg_num,
438 sqlite3_column_double(stmt, 8));
440 sqlite3_finalize(stmt);
446 if(styleid == 0)
return FALSE;
455 query = g_strdup_printf(
456 "INSERT INTO data.style_items"
457 " (styleid,num,module,operation,op_params,enabled,blendop_params,"
458 " blendop_version,multi_priority,multi_name)"
459 " SELECT ?1, num,module,operation,op_params,enabled,blendop_params,blendop_version,"
460 " multi_priority,multi_name"
462 " WHERE imgid=?2 AND %s",
470 "INSERT INTO data.style_items"
471 " (styleid,num,module,operation,op_params,enabled,blendop_params,"
472 " blendop_version,multi_priority,multi_name)"
473 " SELECT ?1, num,module,operation,op_params,enabled,blendop_params,blendop_version,"
474 " multi_priority,multi_name"
482 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
483 sqlite3_finalize(stmt);
491 const int32_t source_styleid, GList *nums)
493 if(dest_styleid == 0 || source_styleid == 0)
return FALSE;
502 query = g_strdup_printf(
503 "INSERT INTO data.style_items "
504 " (styleid,num,module,operation,op_params,enabled,blendop_params,blendop_version,"
505 " multi_priority,multi_name)"
506 " SELECT ?1, num,module,operation,op_params,enabled,blendop_params,blendop_version,"
507 " multi_priority,multi_name"
508 " FROM data.style_items"
509 " WHERE styleid=?2 AND %s",
517 "INSERT INTO data.style_items "
518 " (styleid,num,module,operation,op_params,enabled,blendop_params,"
519 " blendop_version,multi_priority,multi_name)"
520 " SELECT ?1, num,module,operation,op_params,enabled,blendop_params,"
521 " blendop_version,multi_priority,multi_name"
522 " FROM data.style_items"
529 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
530 sqlite3_finalize(stmt);
539 if(styleid == 0)
return FALSE;
544 char *query = g_strdup_printf(
"DELETE FROM data.style_items WHERE styleid=?1 AND %s", predicate);
548 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
549 sqlite3_finalize(stmt);
557 const int32_t imgid,
const int history_num)
559 if(styleid == 0)
return;
563 static const char *
const fields[] = {
"op_params",
"module",
"enabled",
"blendop_params",
564 "blendop_version",
"multi_priority",
"multi_name", NULL };
566 GString *q = g_string_new(
"UPDATE data.style_items SET ");
567 for(
int k = 0; fields[
k];
k++)
569 if(
k != 0) g_string_append_c(q,
',');
570 g_string_append_printf(q,
"%s=(SELECT %s FROM main.history WHERE imgid=%d AND num=%d)", fields[
k],
571 fields[
k], imgid, history_num);
573 g_string_append_printf(q,
" WHERE styleid=%d AND data.style_items.num=%d", styleid, item_num);
575 char *query = g_string_free(q,
FALSE);
581 const int history_num)
583 if(styleid == 0)
return;
586 char *query = g_strdup_printf(
587 "INSERT INTO data.style_items "
588 " (styleid, num, module, operation, op_params, enabled, blendop_params,"
589 " blendop_version, multi_priority, multi_name)"
592 " FROM data.style_items"
594 " ORDER BY num DESC LIMIT 1), "
595 " module, operation, op_params, enabled, blendop_params, blendop_version,"
596 " multi_priority, multi_name"
598 " WHERE imgid=%d AND num=%d",
599 styleid, styleid, imgid, history_num);
607 const int module_version,
const char *operation,
609 const int enabled,
const void *blendop_params,
610 const int32_t blendop_params_size,
611 const int blendop_version,
const int multi_priority,
612 const char *multi_name)
614 if(styleid == 0)
return FALSE;
619 "INSERT INTO data.style_items "
620 " (styleid, num, module, operation, op_params, enabled, blendop_params,"
621 " blendop_version, multi_priority, multi_name)"
622 " VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10)",
636 const gboolean ok = (sqlite3_step(stmt) == SQLITE_DONE);
637 sqlite3_finalize(stmt);
643 if(styleid == 0)
return FALSE;
652 char last_operation[128] = { 0 };
667 "SELECT rowid,operation FROM data.style_items WHERE styleid=?1 ORDER BY operation, multi_priority ASC", -1,
671 while(sqlite3_step(stmt) == SQLITE_ROW)
673 struct _data *
d = malloc(
sizeof(
struct _data));
674 const char *operation = (
const char *)sqlite3_column_text(stmt, 1);
676 if(strncmp(last_operation, operation, 128) != 0)
679 g_strlcpy(last_operation, operation,
sizeof(last_operation));
684 d->rowid = sqlite3_column_int(stmt, 0);
686 list = g_list_prepend(list,
d);
688 sqlite3_finalize(stmt);
689 list = g_list_reverse(list);
694 for(GList *list_iter = list; list_iter; list_iter = g_list_next(list_iter))
696 struct _data *
d = (
struct _data *)list_iter->data;
699 "UPDATE data.style_items SET multi_priority=?1 WHERE rowid=?2", -1, &stmt, NULL);
702 ok &= (sqlite3_step(stmt) == SQLITE_DONE);
703 sqlite3_finalize(stmt);
const char ** description(struct dt_iop_module_t *self)
size_t params_size(dt_imageio_module_format_t *self)
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
static const dt_iop_drawlayer_params_t * params
float *const restrict const size_t k
#define IS_NULL_PTR(p)
C is way too permissive with !=, == and if(var) checks, which can mean too many things depending on w...
static void dt_free_gpointer(gpointer ptr)
g_free() one pointer, with the signature GDestroyNotify wants.
#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_EXEC(a, b, c, d, e)
#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)
static dt_pthread_mutex_t _styles_stmt_mutex
gboolean dt_style_repository_delete_items_except(const int32_t styleid, GList *nums)
gboolean dt_style_repository_copy_items_from_history(const int32_t styleid, const int32_t imgid, GList *nums)
void dt_style_repository_foreach_style(const char *filter, dt_style_repository_style_cb cb, void *user_data)
gboolean dt_style_repository_get_style(const char *name, dt_style_repository_style_cb cb, void *user_data)
int32_t dt_style_repository_get_id_by_name(const char *name)
char * dt_style_repository_get_iop_list(const char *name)
void dt_style_repository_foreach_item_with_params(const int32_t styleid, dt_style_repository_item_cb cb, void *user_data)
gboolean dt_style_repository_normalize_multi_priority(const int32_t styleid)
static gsize _styles_stmt_mutex_inited
void dt_style_repository_foreach_item(const int32_t styleid, dt_style_repository_item_cb cb, void *user_data)
gboolean dt_style_repository_insert_item(const int32_t styleid, const int num, const int module_version, const char *operation, const void *params, const int32_t params_size, const int enabled, const void *blendop_params, const int32_t blendop_params_size, const int blendop_version, const int multi_priority, const char *multi_name)
gboolean dt_style_repository_set_iop_list(const int32_t styleid, const char *iop_list_txt)
void dt_style_repository_cleanup(void)
void dt_style_repository_foreach_item_against_image(const int32_t styleid, const int32_t imgid, dt_style_repository_item_cb cb, void *user_data)
static sqlite3_stmt * _styles_apply_items_stmt
void dt_style_repository_foreach_apply_item(const int32_t styleid, dt_style_repository_item_cb cb, void *user_data)
gboolean dt_style_repository_update_header(const int32_t styleid, const char *newname, const char *description)
static void _styles_stmt_mutex_ensure(void)
gboolean dt_style_repository_insert_header(const char *name, const char *description, const char *iop_list_txt)
void dt_style_repository_append_item_from_history(const int32_t styleid, const int32_t imgid, const int history_num)
static char * _num_set_predicate(GList *nums, const gboolean negate)
char * dt_style_repository_get_description(const int32_t styleid)
gboolean dt_style_repository_delete(const int32_t styleid)
void dt_style_repository_foreach_item_for_export(const int32_t styleid, dt_style_repository_item_cb cb, void *user_data)
static sqlite3_stmt * _styles_get_list_stmt
void dt_style_repository_update_item_from_history(const int32_t styleid, const int item_num, const int32_t imgid, const int history_num)
gboolean dt_style_repository_copy_items_from_style(const int32_t dest_styleid, const int32_t source_styleid, GList *nums)
void(* dt_style_repository_style_cb)(void *user_data, const char *name, const char *description)
void(* dt_style_repository_item_cb)(void *user_data, const int num, const int multi_priority, const int module_version, const char *operation, const int enabled, const void *params, const int32_t params_size, const void *blendop_params, const int32_t blendop_params_size, const int blendop_version, const char *multi_name, const int selimg_num, const double iop_order)