54#define LIMIT_QUERY "LIMIT ?1, ?2"
58#define and_operator_initial() (0)
75#define or_operator_initial() (0)
111 const gboolean changed = (g_strcmp0(
_query, query) != 0);
125 const gboolean recursive)
127 char *escaped_text = sqlite3_mprintf(
"%q", text);
128 const unsigned int escaped_length = strlen(escaped_text);
138 query = g_strdup_printf(
"(%s)", text);
140 query = g_strdup(
"1=1");
144 if(!(escaped_text && *escaped_text))
146 query = g_strdup_printf(
"(film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '%s%%'))",
151 query = g_strdup_printf(
"(film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '%s'))",
162 const gboolean has_star = (escaped_length > 0) && (escaped_text[escaped_length-1] ==
'*');
163 if(recursive || has_star)
165 if(has_star) escaped_text[escaped_length-1] =
'\0';
167 query = g_strdup_printf(
"(film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '%s' OR folder LIKE '%s"
168 G_DIR_SEPARATOR_S
"%%'))",
169 escaped_text, escaped_text);
173 else if ((escaped_length > 1) && (strcmp(escaped_text+escaped_length-2,
"|%") == 0 ))
175 escaped_text[escaped_length-2] =
'\0';
177 query = g_strdup_printf(
"(film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '%s"
178 G_DIR_SEPARATOR_S
"%%'))",
185 query = g_strdup_printf(
"(film_id IN (SELECT id FROM main.film_rolls WHERE folder LIKE '%s'))",
194 if(!(escaped_text && *escaped_text) || strcmp(escaped_text,
"%") == 0)
196 query = g_strdup_printf(
"(id IN (SELECT imgid FROM main.color_labels WHERE color IS NOT NULL))");
201 if(strcmp(escaped_text, _(
"red")) == 0)
203 else if(strcmp(escaped_text, _(
"yellow")) == 0)
205 else if(strcmp(escaped_text, _(
"green")) == 0)
207 else if(strcmp(escaped_text, _(
"blue")) == 0)
209 else if(strcmp(escaped_text, _(
"purple")) == 0)
212 query = g_strdup_printf(
"(id IN (SELECT imgid FROM main.color_labels WHERE color=%d))",
color);
220 if(strcmp(escaped_text, _(
"altered")) == 0)
222 query = g_strdup(
"EXISTS (SELECT 1 FROM main.history h WHERE h.imgid = id)");
224 else if(strcmp(escaped_text, _(
"unaltered")) == 0)
226 query = g_strdup(
"NOT EXISTS (SELECT 1 FROM main.history h WHERE h.imgid = id)");
230 query = g_strdup(
"1");
237 const gboolean not_tagged = strcmp(escaped_text, _(
"not tagged")) == 0;
238 const gboolean no_location = strcmp(escaped_text, _(
"tagged")) == 0;
239 const gboolean all_tagged = strcmp(escaped_text, _(
"tagged*")) == 0;
240 char *escaped_text2 = g_strstr_len(escaped_text, -1,
"|");
241 char *name_clause = g_strdup_printf(
"t.name LIKE \'%s\' || \'%s\'",
244 if (escaped_text2 && (escaped_text2[strlen(escaped_text2)-1] ==
'*'))
246 escaped_text2[strlen(escaped_text2)-1] =
'\0';
247 name_clause = g_strdup_printf(
"(t.name LIKE \'%s\' || \'%s\' OR t.name LIKE \'%s\' || \'%s|%%\')",
251 if(not_tagged || all_tagged)
253 query = g_strdup_printf(
"(id %s IN (SELECT id AS imgid FROM main.images "
254 "WHERE (longitude IS NOT NULL AND latitude IS NOT NULL))) ",
255 all_tagged ?
"" :
"not");
259 query = g_strdup_printf(
"(id IN (SELECT id AS imgid FROM main.images "
260 "WHERE (longitude IS NOT NULL AND latitude IS NOT NULL))"
261 "AND id %s IN (SELECT imgid FROM main.tagged_images AS ti"
262 " JOIN data.tags AS t"
263 " ON t.id = ti.tagid"
265 no_location ?
"not" :
"",
273 query = g_strdup_printf(
"(id %s IN (SELECT id AS imgid FROM main.images WHERE (flags & %d))) ",
274 (strcmp(escaped_text, _(
"not copied locally")) == 0) ?
"not" :
"",
281 query = g_strdup_printf(
"((1=0)");
284 for(GList *element = lists; element; element = g_list_next(element))
286 GList *tuple = element->data;
287 char *clause = sqlite3_mprintf(
" OR (maker = '%q' AND model = '%q')", tuple->data, tuple->next->data);
289 sqlite3_free(clause);
302 if(!strcmp(escaped_text, _(
"not tagged")))
305 query = g_strdup_printf(
"(id NOT IN (SELECT DISTINCT imgid FROM main.tagged_images "
306 "WHERE tagid NOT IN memory.darktable_tags))");
311 if ((escaped_length > 0) && (escaped_text[escaped_length-1] ==
'*'))
315 escaped_text[escaped_length-1] =
'\0';
317 query = g_strdup_printf(
"(id IN (SELECT imgid FROM main.tagged_images WHERE tagid IN "
318 "(SELECT id FROM data.tags "
319 "WHERE LOWER(name) = LOWER('%s')"
320 " OR SUBSTR(LOWER(name), 1, LENGTH('%s') + 1) = LOWER('%s|'))))",
321 escaped_text, escaped_text, escaped_text);
324 else if ((escaped_length > 0) && (escaped_text[escaped_length-1] ==
'%'))
327 escaped_text[escaped_length-1] =
'\0';
329 query = g_strdup_printf(
"(id IN (SELECT imgid FROM main.tagged_images WHERE tagid IN "
330 "(SELECT id FROM data.tags WHERE SUBSTR(LOWER(name), 1, LENGTH('%s')) = LOWER('%s'))))",
331 escaped_text, escaped_text);
338 query = g_strdup_printf(
"(id IN (SELECT imgid FROM main.tagged_images WHERE tagid IN "
339 "(SELECT id FROM data.tags WHERE LOWER(name) = LOWER('%s'))))",
348 query = g_strdup_printf(
"(lens LIKE '%%%s%%')", escaped_text);
353 gchar *
operator, *number1, *number2;
356 if(
operator && strcmp(
operator,
"[]") == 0)
358 if(number1 && number2)
359 query = g_strdup_printf(
"((focal_length >= %s) AND (focal_length <= %s))", number1, number2);
361 else if(
operator && number1)
362 query = g_strdup_printf(
"(focal_length %s %s)",
operator, number1);
365 query = g_strdup_printf(
"(CAST(focal_length AS INTEGER) = CAST(%s AS INTEGER))", number1);
368 query = g_strdup_printf(
"(focal_length LIKE '%%%s%%')", escaped_text);
378 gchar *
operator, *number1, *number2;
381 if(
operator && strcmp(
operator,
"[]") == 0)
383 if(number1 && number2)
384 query = g_strdup_printf(
"((iso >= %s) AND (iso <= %s))", number1, number2);
386 else if(
operator && number1)
387 query = g_strdup_printf(
"(iso %s %s)",
operator, number1);
389 query = g_strdup_printf(
"(iso = %s)", number1);
391 query = g_strdup_printf(
"(iso LIKE '%%%s%%')", escaped_text);
401 gchar *
operator, *number1, *number2;
404 if(
operator && strcmp(
operator,
"[]") == 0)
406 if(number1 && number2)
408 query = g_strdup_printf(
"((ROUND(aperture,1) >= %s) AND (ROUND(aperture,1) <= %s))", number1,
412 else if(
operator && number1)
413 query = g_strdup_printf(
"(ROUND(aperture,1) %s %s)",
operator, number1);
415 query = g_strdup_printf(
"(ROUND(aperture,1) = %s)", number1);
417 query = g_strdup_printf(
"(ROUND(aperture,1) LIKE '%%%s%%')", escaped_text);
427 gchar *
operator, *number1, *number2;
430 if(
operator && strcmp(
operator,
"[]") == 0)
432 if(number1 && number2)
434 query = g_strdup_printf(
"((exposure >= %s - 1.0/100000) AND (exposure <= %s + 1.0/100000))", number1,
438 else if(
operator && number1)
439 query = g_strdup_printf(
"(exposure %s %s)",
operator, number1);
442 query = g_strdup_printf(
"(CASE WHEN exposure < 0.4 THEN ((exposure >= %s - 1.0/100000) AND (exposure <= %s + 1.0/100000)) "
443 "ELSE (ROUND(exposure,2) >= %s - 1.0/100000) AND (ROUND(exposure,2) <= %s + 1.0/100000) END)",
444 number1, number1, number1, number1);
447 query = g_strdup_printf(
"(exposure LIKE '%%%s%%')", escaped_text);
459 for (GList *l = list; l; l = g_list_next(l))
461 char *
name = (
char*)l->data;
462 l->data = g_strdup_printf(
"(filename LIKE '%%%s%%')",
name);
467 query = g_strdup_printf(
"(%s)", subquery);
481 const int local_property = property;
482 char *colname = NULL;
484 switch(local_property)
493 gchar *
operator, *number1, *number2;
495 if(number1 && number1[strlen(number1) - 1] ==
'%')
496 number1[strlen(number1) - 1] =
'\0';
500 if(strcmp(
operator,
"[]") == 0)
502 if(number1 && number2)
503 query = g_strdup_printf(
"((%s >= %" G_GINT64_FORMAT
") AND (%s <= %" G_GINT64_FORMAT
"))", colname, nb1, colname, nb2);
505 else if((strcmp(
operator,
"=") == 0 || strcmp(
operator,
"") == 0) && number1 && number2)
506 query = g_strdup_printf(
"((%s >= %" G_GINT64_FORMAT
") AND (%s <= %" G_GINT64_FORMAT
"))", colname, nb1, colname, nb2);
507 else if(strcmp(
operator,
"<>") == 0 && number1 && number2)
510 query = g_strdup_printf(
"((%s < %" G_GINT64_FORMAT
") OR (%s > %" G_GINT64_FORMAT
"))", colname, nb1, colname, nb2);
512 query = g_strdup_printf(
"(%s %s %" G_GINT64_FORMAT
")", colname,
operator, nb1);
514 query = g_strdup(
"1 = 1");
523 query = g_strdup_printf(
"(id %s group_id)", (strcmp(escaped_text, _(
"group leaders")) == 0) ?
"=" :
"!=");
529 query = g_strdup_printf(
"(id IN (SELECT imgid AS id FROM main.history AS h "
530 "JOIN memory.darktable_iop_names AS m ON m.operation = h.operation "
531 "WHERE h.enabled = 1 AND m.name LIKE '%s'))", escaped_text);
543 query = g_strdup_printf(
"(id IN (SELECT imgid FROM main.module_order WHERE version = %d))",
i);
547 query = g_strdup_printf(
"(id NOT IN (SELECT imgid FROM main.module_order))");
554 gchar *
operator, *number1, *number2;
557 if(
operator && strcmp(
operator,
"[]") == 0)
559 if(number1 && number2)
561 if(atoi(number1) == -1)
564 query = g_strdup_printf(
"(flags & 7 >= %s AND flags & 7 <= %s)", number1, number2);
570 query = g_strdup_printf(
"((flags & 8 == 0) AND (flags & 7 >= %s AND flags & 7 <= %s))", number1, number2);
575 else if(
operator && number1)
577 if(g_strcmp0(
operator,
"<=") == 0 || g_strcmp0(
operator,
"<") == 0)
580 query = g_strdup_printf(
"(flags & 8 == 8 OR flags & 7 %s %s)",
operator, number1);
583 else if(g_strcmp0(
operator,
">=") == 0 || g_strcmp0(
operator,
">") == 0)
585 if(atoi(number1) >= 0)
588 query = g_strdup_printf(
"(flags & 8 == 0 AND flags & 7 %s %s)",
operator, number1);
595 if(atoi(number1) == -1)
597 query = g_strdup_printf(
"(flags & 8 == 0)");
601 query = g_strdup_printf(
"(flags & 8 == 8 OR flags & 7 %s %s)",
operator, number1);
607 if(atoi(number1) == -1)
609 query = g_strdup_printf(
"(flags & 8 == 8)");
613 query = g_strdup_printf(
"(flags & 8 == 0 AND flags & 7 == %s)", number1);
629 if(strcmp(escaped_text, _(
"not defined")) != 0)
631 query = g_strdup_printf(
"(id IN (SELECT id FROM main.meta_data WHERE key = %d AND value "
632 "LIKE '%%%s%%'))", keyid, escaped_text);
636 query = g_strdup_printf(
"(id NOT IN (SELECT id FROM main.meta_data WHERE key = %d))",
643 sqlite3_free(escaped_text);
646 query = g_strdup_printf(
"(1=1)");
669 gchar *complete_string = g_strdup(
"");
674 if(
i == exclude)
continue;
678 gchar *where_ext = g_strdup_printf(
"(1=1%s)", complete_string);
685 gchar *complete_string = g_strjoinv(NULL,
_where_ext);
686 gchar *where_ext = g_strdup_printf(
"(1=1%s)", complete_string);
692 const uint32_t tagid =
_tagid;
693 char tag[16] = { 0 };
694 snprintf(tag,
sizeof(tag),
"%u", tagid);
698 "SELECT DISTINCT mi.id FROM (SELECT"
699 " id, group_id, film_id, filename, datetime_taken, "
700 " flags, version, aspect_ratio,"
701 " maker, model, lens, aperture, exposure, focal_length,"
702 " iso, import_timestamp, change_timestamp,"
703 " export_timestamp, print_timestamp"
704 " FROM main.images AS mi %s%s WHERE ",
705 tagid ?
" LEFT JOIN main.tagged_images AS ti"
706 " ON ti.imgid = mi.id AND ti.tagid = " :
"",
713 const gchar *order = (
_params.descending) ?
"DESC" :
"ASC";
723 const int local_order =
_params.sort;
733 default: colname =
"";
736 sq = g_strdup_printf(
"ORDER BY %s %s", colname, order);
743 sq = g_strdup_printf(
"ORDER BY CASE WHEN flags & 8 = 8 THEN -1 ELSE flags & 7 END %s", order);
749 sq = g_strdup_printf(
"ORDER BY filename %s", order);
755 sq = g_strdup_printf(
"ORDER BY mi.id %s", order);
761 sq = g_strdup_printf(
"ORDER BY color %s", order);
767 sq = g_strdup_printf(
"ORDER BY group_id %s, mi.id-group_id != 0", order);
773 sq = g_strdup_printf(
"ORDER BY folder %s", order);
779 sq = g_strdup_printf(
"ORDER BY m.value %s", order);
787 sq = g_strdup_printf(
"ORDER BY mi.id %s", order);
794 sq =
dt_util_dstrcat(sq,
", group_id ASC, mi.id-group_id != 0, filename ASC, version ASC, mi.id ASC");
801 gchar *wq, *sq, *selq_pre, *selq_post, *query;
802 wq = sq = selq_pre = selq_post = query = NULL;
808 wq = g_strdup(where_ext);
819 gboolean got_rating_filter
825 if(got_rating_filter)
864 if(got_rating_filter)
867 gboolean got_altered_filter
870 if(got_altered_filter)
882 wq =
dt_util_dstrcat(wq,
" %s id NOT IN (SELECT imgid FROM main.history) ",
886 if(got_altered_filter)
893 wq =
dt_util_dstrcat(wq,
" %s id IN (SELECT id FROM main.meta_data WHERE value LIKE '%s'"
894 " UNION SELECT imgid AS id FROM main.tagged_images AS ti, data.tags AS t"
895 " WHERE t.id=ti.tagid AND (t.name LIKE '%s' OR t.synonyms LIKE '%s')"
896 " UNION SELECT id FROM main.images"
897 " WHERE filename LIKE '%s'"
898 " UNION SELECT i.id FROM main.images AS i, main.film_rolls AS fr"
899 " WHERE fr.id=i.film_id AND fr.folder LIKE '%s')",
909 gboolean got_color_filter =
_params.filter_flags
935 " (SELECT imgid AS id, SUM(1 << color) AS mask FROM main.color_labels GROUP BY imgid)"
936 " WHERE ((mask & %i) > 0))",
941 " (SELECT imgid AS id, SUM(1 << color) AS mask FROM main.color_labels GROUP BY imgid)"
942 " WHERE ((mask & 31) > 0))",
959 wq = g_strdup(
" id=0");
971 selq_post =
dt_util_dstrcat(selq_post,
") AS mi LEFT OUTER JOIN main.color_labels AS b ON mi.id = b.imgid");
982 ") AS mi JOIN (SELECT id AS film_rolls_id, folder FROM main.film_rolls) ON film_id = film_rolls_id");
991 selq_post =
dt_util_dstrcat(selq_post,
") AS mi LEFT OUTER JOIN main.meta_data AS m ON mi.id = m.id AND m.key = %d ",
997 const uint32_t tagid =
_tagid;
998 char tag[16] = { 0 };
999 snprintf(tag,
sizeof(tag),
"%u", tagid);
1002 "SELECT DISTINCT mi.id FROM (SELECT"
1003 " id, group_id, film_id, filename, datetime_taken, "
1004 " flags, version, %s position, aspect_ratio,"
1005 " maker, model, lens, aperture, exposure, focal_length,"
1006 " iso, import_timestamp, change_timestamp,"
1007 " export_timestamp, print_timestamp"
1008 " FROM main.images AS mi %s%s ) AS mi ",
1009 tagid ?
"CASE WHEN ti.position IS NULL THEN 0 ELSE ti.position END AS" :
"",
1010 tagid ?
" LEFT JOIN main.tagged_images AS ti"
1011 " ON ti.imgid = mi.id AND ti.tagid = " :
"",
1017 const uint32_t tagid =
_tagid;
1018 char tag[16] = { 0 };
1019 snprintf(tag,
sizeof(tag),
"%u", tagid);
1022 "SELECT DISTINCT mi.id FROM (SELECT"
1023 " id, group_id, film_id, filename, datetime_taken, "
1024 " flags, version, %s position, aspect_ratio,"
1025 " maker, model, lens, aperture, exposure, focal_length,"
1026 " iso, import_timestamp, change_timestamp,"
1027 " export_timestamp, print_timestamp"
1028 " FROM main.images AS mi %s%s ) AS mi WHERE ",
1029 tagid ?
"CASE WHEN ti.position IS NULL THEN 0 ELSE ti.position END AS" :
"",
1030 tagid ?
" LEFT JOIN main.tagged_images AS ti"
1031 " ON ti.imgid = mi.id AND ti.tagid = " :
"",
1046 =
dt_util_dstrcat(query,
"%s%s%s %s%s", selq_pre, wq, selq_post ? selq_post :
"", sq ? sq :
"",
1063 sqlite3_stmt *stmt = NULL;
1065 "SELECT COUNT(DISTINCT imgid) from memory.collected_images",
1068 if(sqlite3_step(stmt) == SQLITE_ROW) count = sqlite3_column_int(stmt, 0);
1069 sqlite3_finalize(stmt);
1088 static const char *
const conj[] = {
"AND",
"OR",
"AND NOT" };
1090 gchar **parts = g_malloc0_n(n_rules + 1,
sizeof(gchar *));
1091 for(
int i = 0;
i < n_rules;
i++)
1094 const int mode = CLAMP(
r->mode, 0, 2);
1098 parts[
i] = g_strdup((mode == 1) ?
" OR 1=1" :
"");
1103 parts[
i] = g_strdup_printf(
" %s %s", conj[mode], where);
1112 const uint32_t tagid)
1143 sqlite3_stmt *stmt = NULL;
1145 "INSERT INTO memory.darktable_iop_names (operation, name) VALUES (?1, ?2)",
1150 for(
size_t i = 0;
i < count;
i++)
1152 sqlite3_reset(stmt);
1153 sqlite3_clear_bindings(stmt);
1159 sqlite3_finalize(stmt);
1174 sqlite3_stmt *stmt = NULL;
1176 gchar *query = g_strdup_printf(
"SELECT id"
1178 " WHERE group_id = %d AND id IN (%s)",
1179 group_id, collection_query);
1185 while(sqlite3_step(stmt) == SQLITE_ROW)
1187 const int32_t
id = sqlite3_column_int(stmt, 0);
1188 if(
id != exclude_imgid) ids = g_list_prepend(ids, GINT_TO_POINTER(
id));
1190 sqlite3_finalize(stmt);
1191 return g_list_reverse(ids);
1205 gchar *q = g_strdup_printf(
"SELECT maker, model, COUNT(*) AS count FROM main.images AS mi"
1206 " WHERE %s GROUP BY maker, model", where_ext);
1208 sqlite3_stmt *stmt = NULL;
1211 while(stmt && sqlite3_step(stmt) == SQLITE_ROW)
1213 const char *
maker = (
const char *)sqlite3_column_text(stmt, 0);
1214 const char *
model = (
const char *)sqlite3_column_text(stmt, 1);
1218 if(stmt) sqlite3_finalize(stmt);
1220 return g_list_reverse(
out);
1228 const gboolean has_status
1230 gchar *query = NULL;
1235 query = g_strdup_printf(
"SELECT folder, film_rolls_id, COUNT(*) AS count, status"
1236 " FROM main.images AS mi"
1237 " JOIN (SELECT fr.id AS film_rolls_id, folder, status"
1238 " FROM main.film_rolls AS fr"
1239 " JOIN memory.film_folder AS ff ON fr.id = ff.id)"
1240 " ON film_id = film_rolls_id"
1241 " WHERE %s GROUP BY folder, film_rolls_id", where_ext);
1245 query = g_strdup_printf(
"SELECT name, 1 AS tagid, SUM(count) AS count"
1246 " FROM (SELECT tagid, COUNT(*) as count"
1247 " FROM main.images AS mi JOIN main.tagged_images ON id = imgid"
1248 " WHERE %s GROUP BY tagid)"
1249 " JOIN (SELECT name, id AS tag_id FROM data.tags)"
1250 " ON tagid = tag_id GROUP BY name", where_ext);
1252 "SELECT '%s' AS name, 0 as id, COUNT(*) AS count "
1253 "FROM main.images AS mi WHERE mi.id NOT IN"
1254 " (SELECT DISTINCT imgid FROM main.tagged_images AS ti"
1255 " WHERE ti.tagid NOT IN memory.darktable_tags)",
1260 query = g_strdup_printf(
"SELECT CASE WHEN mi.longitude IS NULL OR mi.latitude IS null THEN '%s'"
1261 " ELSE CASE WHEN ta.imgid IS NULL THEN '%s' ELSE '%s' || ta.tagname END"
1262 " END AS name, ta.tagid AS tag_id, COUNT(*) AS count"
1263 " FROM main.images AS mi"
1264 " LEFT JOIN (SELECT imgid, t.id AS tagid, SUBSTR(t.name, %d) AS tagname"
1265 " FROM main.tagged_images AS ti JOIN data.tags AS t ON ti.tagid = t.id"
1266 " JOIN data.locations AS l ON l.tagid = t.id) AS ta ON ta.imgid = mi.id"
1267 " WHERE %s GROUP BY name, tag_id",
1268 _(
"not tagged"), _(
"tagged"), _(
"tagged"),
1273 query = g_strdup_printf(
"SELECT (datetime_taken / 86400000000) * 86400000000 AS date, 1, COUNT(*) AS count"
1274 " FROM main.images AS mi"
1275 " WHERE datetime_taken IS NOT NULL AND datetime_taken <> 0 AND %s"
1276 " GROUP BY date", where_ext);
1285 char *colname = NULL;
1295 query = g_strdup_printf(
"SELECT %s AS date, 1, COUNT(*) AS count FROM main.images AS mi"
1296 " WHERE %s IS NOT NULL AND %s <> 0 AND %s GROUP BY date",
1297 colname, colname, colname, where_ext);
1302 query = g_strdup_printf(
"SELECT CASE WHEN EXISTS (SELECT 1 FROM main.history h WHERE h.imgid = mi.id)"
1303 " THEN '%s' ELSE '%s' END as altered, 1, COUNT(*) AS count"
1304 " FROM main.images AS mi WHERE %s GROUP BY altered ORDER BY altered ASC",
1305 _(
"altered"), _(
"unaltered"), where_ext);
1309 query = g_strdup_printf(
"SELECT CASE WHEN (flags & %d) THEN '%s' ELSE '%s' END as lcp, 1, COUNT(*) AS count"
1310 " FROM main.images AS mi WHERE %s GROUP BY lcp ORDER BY lcp ASC",
1315 query = g_strdup_printf(
"SELECT CASE color WHEN 0 THEN '%s' WHEN 1 THEN '%s' WHEN 2 THEN '%s'"
1316 " WHEN 3 THEN '%s' WHEN 4 THEN '%s' ELSE '' END, color, COUNT(*) AS count"
1317 " FROM main.images AS mi"
1318 " JOIN (SELECT imgid AS color_labels_id, color FROM main.color_labels)"
1319 " ON id = color_labels_id WHERE %s GROUP BY color ORDER BY color DESC",
1320 _(
"red"), _(
"yellow"), _(
"green"), _(
"blue"), _(
"purple"), where_ext);
1324 query = g_strdup_printf(
"SELECT lens, 1, COUNT(*) AS count FROM main.images AS mi WHERE %s"
1325 " GROUP BY lens ORDER BY lens", where_ext);
1329 query = g_strdup_printf(
"SELECT CAST(focal_length AS INTEGER) AS focal_length, 1, COUNT(*) AS count"
1330 " FROM main.images AS mi WHERE %s GROUP BY CAST(focal_length AS INTEGER)"
1331 " ORDER BY CAST(focal_length AS INTEGER)", where_ext);
1335 query = g_strdup_printf(
"SELECT CAST(iso AS INTEGER) AS iso, 1, COUNT(*) AS count"
1336 " FROM main.images AS mi WHERE %s GROUP BY iso ORDER BY iso", where_ext);
1340 query = g_strdup_printf(
"SELECT ROUND(aperture,1) AS aperture, 1, COUNT(*) AS count"
1341 " FROM main.images AS mi WHERE %s GROUP BY aperture ORDER BY aperture", where_ext);
1345 query = g_strdup_printf(
"SELECT CASE WHEN (exposure < 0.4) THEN '1/' || CAST(1/exposure + 0.9 AS INTEGER)"
1346 " ELSE ROUND(exposure,2) || '\"' END as _exposure, 1, COUNT(*) AS count"
1347 " FROM main.images AS mi WHERE %s GROUP BY _exposure ORDER BY exposure", where_ext);
1351 query = g_strdup_printf(
"SELECT filename, 1, COUNT(*) AS count FROM main.images AS mi WHERE %s"
1352 " GROUP BY filename ORDER BY filename", where_ext);
1356 query = g_strdup_printf(
"SELECT CASE WHEN id = group_id THEN '%s' ELSE '%s' END as group_leader, 1,"
1357 " COUNT(*) AS count FROM main.images AS mi WHERE %s"
1358 " GROUP BY group_leader ORDER BY group_leader ASC",
1359 _(
"group leaders"), _(
"group followers"), where_ext);
1363 query = g_strdup_printf(
"SELECT m.name AS module_name, 1, COUNT(*) AS count FROM main.images AS mi"
1364 " JOIN (SELECT DISTINCT imgid, operation FROM main.history WHERE enabled = 1) AS h"
1365 " ON h.imgid = mi.id JOIN memory.darktable_iop_names AS m"
1366 " ON m.operation = h.operation WHERE %s GROUP BY module_name ORDER BY module_name",
1376 query = g_strdup_printf(
"SELECT CASE %s END as ver, 1, COUNT(*) AS count FROM main.images AS mi"
1377 " LEFT JOIN (SELECT imgid, version FROM main.module_order) mo ON mo.imgid = mi.id"
1378 " WHERE %s GROUP BY ver ORDER BY ver",
orders, where_ext);
1384 query = g_strdup_printf(
"SELECT CASE WHEN (flags & 8) == 8 THEN -1 ELSE (flags & 7) END AS rating, 1,"
1385 " COUNT(*) AS count FROM main.images AS mi WHERE %s GROUP BY rating ORDER BY rating",
1395 query = g_strdup_printf(
"SELECT CASE WHEN value IS NULL THEN '%s' ELSE value END AS value, 1,"
1396 " COUNT(*) AS count, CASE WHEN value IS NULL THEN 0 ELSE 1 END AS force_order"
1397 " FROM main.images AS mi"
1398 " LEFT JOIN (SELECT id AS meta_data_id, value FROM main.meta_data WHERE key = %d)"
1399 " ON id = meta_data_id WHERE %s GROUP BY value ORDER BY force_order, value",
1400 _(
"not defined"), keyid, where_ext);
1406 query = g_strdup_printf(
"SELECT folder, film_rolls_id, COUNT(*) AS count, status FROM main.images AS mi"
1407 " JOIN (SELECT fr.id AS film_rolls_id, folder, status FROM main.film_rolls AS fr"
1408 " JOIN memory.film_folder AS ff ON ff.id = fr.id) ON film_id = film_rolls_id"
1409 " WHERE %s GROUP BY folder ORDER BY %s", where_ext, order_by);
1414 if(!query)
return NULL;
1416 sqlite3_stmt *stmt = NULL;
1418 while(stmt && sqlite3_step(stmt) == SQLITE_ROW)
1426 name = g_strdup(sdt);
1430 const char *txt = (
const char *)sqlite3_column_text(stmt, 0);
1431 name = txt ? g_strdup(txt) : g_strdup(
"");
1433 const int id = sqlite3_column_int(stmt, 1);
1434 const int count = sqlite3_column_int(stmt, 2);
1435 const int status = has_status ? sqlite3_column_int(stmt, 3) : -1;
1438 if(stmt) sqlite3_finalize(stmt);
1440 return g_list_reverse(
out);
1445 gchar *needle = NULL;
1446 gboolean wildcard =
FALSE;
1448 GHashTable *
names = NULL;
1450 names = g_hash_table_new(g_str_hash, g_str_equal);
1452 if (filter && filter[0] !=
'\0')
1454 needle = g_utf8_strdown(filter, -1);
1455 wildcard = (needle && needle[strlen(needle) - 1] ==
'%') ?
TRUE :
FALSE;
1457 needle[strlen(needle) - 1] =
'\0';
1460 sqlite3_stmt *stmt = NULL;
1462 "SELECT maker, model FROM main.images GROUP BY maker, model",
1465 while(sqlite3_step(stmt) == SQLITE_ROW)
1467 const char *exif_maker = (
char *)sqlite3_column_text(stmt, 0);
1468 const char *exif_model = (
char *)sqlite3_column_text(stmt, 1);
1472 gchar *haystack = g_utf8_strdown(makermodel, -1);
1473 if (
IS_NULL_PTR(needle) || (wildcard && g_strrstr(haystack, needle) != NULL)
1474 || (!wildcard && !g_strcmp0(haystack, needle)))
1479 GList *inner_list = NULL;
1480 inner_list = g_list_append(inner_list, g_strdup(exif_maker));
1481 inner_list = g_list_append(inner_list, g_strdup(exif_model));
1482 *exif = g_list_append(*exif, inner_list);
1487 gchar *
key = g_strdup(makermodel);
1494 sqlite3_finalize(stmt);
1499 *sanitized = g_list_sort(g_hash_table_get_keys(
names), (GCompareFunc) strcmp);
1500 g_hash_table_destroy(
names);
1510 GList *result = NULL;
1514 gchar *query = g_strdup_printf(
"SELECT id FROM main.images WHERE %s", where);
1517 sqlite3_stmt *stmt = NULL;
1521 while(sqlite3_step(stmt) == SQLITE_ROW)
1522 result = g_list_prepend(result, GINT_TO_POINTER(sqlite3_column_int(stmt, 0)));
1523 sqlite3_finalize(stmt);
1527 return g_list_reverse(result);
1538 for(GList *l = imgids; l; l = g_list_next(l))
1540 const int id = GPOINTER_TO_INT(l->data);
1552 gchar *query = g_strdup_printf(
"SELECT imgid"
1553 " FROM memory.collected_images"
1554 " WHERE imgid NOT IN (%s)"
1555 " AND rowid > (SELECT rowid"
1556 " FROM memory.collected_images"
1557 " WHERE imgid IN (%s)"
1558 " ORDER BY rowid LIMIT 1)"
1559 " ORDER BY rowid LIMIT 1",
1562 sqlite3_stmt *stmt2;
1564 if(sqlite3_step(stmt2) == SQLITE_ROW)
1566 next = sqlite3_column_int(stmt2, 0);
1568 sqlite3_finalize(stmt2);
1574 query = g_strdup_printf(
"SELECT imgid"
1575 " FROM memory.collected_images"
1576 " WHERE imgid NOT IN (%s)"
1577 " AND rowid < (SELECT rowid"
1578 " FROM memory.collected_images"
1579 " WHERE imgid IN (%s)"
1580 " ORDER BY rowid LIMIT 1)"
1581 " ORDER BY rowid DESC LIMIT 1",
1585 if(sqlite3_step(stmt2) == SQLITE_ROW)
1587 next = sqlite3_column_int(stmt2, 0);
1589 sqlite3_finalize(stmt2);
1623 "DELETE FROM memory.collected_images",
1627 "DELETE FROM memory.sqlite_sequence"
1628 " WHERE name='collected_images'",
1633 gchar *ins_query = g_strdup_printf(
"INSERT INTO memory.collected_images (imgid) %s", query);
1639 sqlite3_finalize(stmt);
1655 sqlite3_stmt *stmt = NULL;
1657 use_limit ?
"SELECT imgid FROM memory.collected_images LIMIT -1, ?1"
1658 :
"SELECT imgid FROM memory.collected_images",
1663 while(sqlite3_step(stmt) == SQLITE_ROW)
1665 const int32_t imgid = sqlite3_column_int(stmt, 0);
1666 list = g_list_prepend(list, GINT_TO_POINTER(imgid));
1668 sqlite3_finalize(stmt);
1671 return g_list_reverse(list);
1678 sqlite3_stmt *stmt = NULL;
1684 if(sqlite3_step(stmt) == SQLITE_ROW)
1686 result = sqlite3_column_int(stmt, 0);
1689 sqlite3_finalize(stmt);
1698 sqlite3_stmt *stmt = NULL;
1700 "SELECT imgid FROM memory.collected_images",
1704 gboolean found =
FALSE;
1706 while(sqlite3_step(stmt) == SQLITE_ROW)
1708 const int id = sqlite3_column_int(stmt, 0);
1717 sqlite3_finalize(stmt);
1719 if(!found) offset = 0;
1728 "INSERT INTO memory.collected_images"
1729 " SELECT * FROM memory.collected_backup",
1737 "INSERT INTO memory.collected_backup"
1738 " SELECT * FROM memory.collected_images",
1748 "DELETE FROM memory.collected_images"
1749 " WHERE imgid NOT IN "
1750 " (SELECT imgid FROM main.selected_images)",
void dt_collection_split_operator_exposure(const gchar *input, char **number1, char **number2, char **operator)
dt_collection_t * dt_collection_get_global(void)
static const char * _order_names[DT_IOP_ORDER_LAST]
void dt_collection_split_operator_number(const gchar *input, char **number1, char **number2, char **operator)
void dt_collection_get_makermodels(const gchar *filter, GList **sanitized, GList **exif)
gchar * dt_collection_get_makermodel(const char *exif_maker, const char *exif_model)
void dt_collection_split_operator_datetime(const gchar *input, char **number1, char **number2, char **operator)
dt_collection_properties_t
@ DT_COLLECTION_PROP_EXPOSURE
@ DT_COLLECTION_PROP_MODULE
@ DT_COLLECTION_PROP_RATING
@ DT_COLLECTION_PROP_QUERY
@ DT_COLLECTION_PROP_TIME
@ DT_COLLECTION_PROP_METADATA
@ DT_COLLECTION_PROP_GROUPING
@ DT_COLLECTION_PROP_FILMROLL
@ DT_COLLECTION_PROP_LENS
@ DT_COLLECTION_PROP_CAMERA
@ DT_COLLECTION_PROP_LOCAL_COPY
@ DT_COLLECTION_PROP_GEOTAGGING
@ DT_COLLECTION_PROP_FILENAME
@ DT_COLLECTION_PROP_COLORLABEL
@ DT_COLLECTION_PROP_ORDER
@ DT_COLLECTION_PROP_FOLDERS
@ DT_COLLECTION_PROP_APERTURE
@ DT_COLLECTION_PROP_IMPORT_TIMESTAMP
@ DT_COLLECTION_PROP_FOCAL_LENGTH
@ DT_COLLECTION_PROP_EXPORT_TIMESTAMP
@ DT_COLLECTION_PROP_CHANGE_TIMESTAMP
@ DT_COLLECTION_PROP_HISTORY
@ DT_COLLECTION_PROP_PRINT_TIMESTAMP
@ COLLECTION_QUERY_USE_ONLY_WHERE_EXT
@ COLLECTION_QUERY_USE_WHERE_EXT
@ COLLECTION_QUERY_USE_SORT
@ COLLECTION_QUERY_USE_LIMIT
@ COLLECTION_FILTER_ALTERED
@ COLLECTION_FILTER_UNALTERED
@ COLLECTION_FILTER_GREEN
@ COLLECTION_FILTER_2_STAR
@ COLLECTION_FILTER_MAGENTA
@ COLLECTION_FILTER_0_STAR
@ COLLECTION_FILTER_1_STAR
@ COLLECTION_FILTER_5_STAR
@ COLLECTION_FILTER_YELLOW
@ COLLECTION_FILTER_REJECTED
@ COLLECTION_FILTER_4_STAR
@ COLLECTION_FILTER_3_STAR
@ COLLECTION_FILTER_WHITE
@ DT_COLLECTION_SORT_EXPORT_TIMESTAMP
@ DT_COLLECTION_SORT_IMPORT_TIMESTAMP
@ DT_COLLECTION_SORT_DATETIME
@ DT_COLLECTION_SORT_GROUP
@ DT_COLLECTION_SORT_FILENAME
@ DT_COLLECTION_SORT_RATING
@ DT_COLLECTION_SORT_PATH
@ DT_COLLECTION_SORT_TITLE
@ DT_COLLECTION_SORT_CHANGE_TIMESTAMP
@ DT_COLLECTION_SORT_NONE
@ DT_COLLECTION_SORT_PRINT_TIMESTAMP
@ DT_COLLECTION_SORT_COLOR
static int _order_names_count
static int _recompose(void)
static uint64_t _generation
uint64_t dt_collection_query_get_generation(void)
void dt_collection_query_set_order_names(const char *const *names, const int count)
static gchar ** _where_ext
void dt_collection_query_pop(void)
static gchar * _sort_query(void)
static const gchar * _ensure_query(void)
int dt_collection_query_set_rules(const dt_collection_params_t *params, const dt_collection_rule_t *rules, const int n_rules, const uint32_t tagid)
GList * dt_collection_query_get_group_members(const int32_t group_id, const int32_t exclude_imgid)
void dt_collection_query_set_order_resolver(dt_collection_query_order_resolver_t fn)
GList * dt_collection_query_get_property_values(const dt_collection_values_request_t *req)
void dt_collection_query_cleanup(void)
static dt_collection_name_value_t * _name_value_new(char *name, int id, int count, int status)
void dt_collection_query_set_iop_names(const dt_iop_name_row_t *rows, const size_t count)
Fill memory.darktable_iop_names, the table the module-name rules join against.
static gchar * _extended_where(void)
static char * or_operator(int *term)
void dt_collection_query_push(void)
static gchar * _extended_where_excluding(const int exclude, const gboolean apply_exclude)
void dt_collection_query_get_makermodels(const gchar *filter, GList **sanitized, GList **exif)
static uint32_t _compute_count(void)
static dt_collection_params_t _params
int dt_collection_query_recompose(void)
void dt_collection_query_refresh_memory_table(void)
GList * dt_collection_query_get_images_for_rule(const dt_collection_properties_t property, const char *text, gboolean recursive)
static void _set_selq_pre_sort(char **selq_pre)
#define or_operator_initial()
uint32_t dt_collection_query_count(void)
static char * and_operator(int *term)
int32_t dt_collection_query_find_neighbour(GList *imgids)
static int _store(gchar *query)
static dt_collection_query_order_resolver_t _order_resolver
static gchar * get_query_string(const dt_collection_properties_t property, const gchar *text, const gboolean recursive)
int32_t dt_collection_query_get_nth(const int nth)
GList * dt_collection_query_get_images(const uint32_t limit)
static gchar ** _compose_where_ext(const dt_collection_rule_t *rules, const int n_rules)
int dt_collection_query_image_offset(const int32_t imgid)
void dt_collection_query_restrict_to_selection(void)
int(* dt_collection_query_order_resolver_t)(const char *text)
const dt_colormatrix_t dt_aligned_pixel_t out
sqlite3 * dt_database_get_sqlite3_global(void)
gboolean dt_database_is_open(void)
#define dt_database_start_transaction()
#define dt_database_release_transaction()
GTimeSpan dt_datetime_exif_to_gtimespan(const char *sdt)
gboolean dt_datetime_gtimespan_to_exif(char *sdt, const size_t sdt_size, const GTimeSpan gts)
#define DT_DATETIME_EXIF_LENGTH
static const dt_iop_order_entry_t * orders[5]
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...
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.
dt_imageio_retval_t status
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_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)
unsigned __int64 uint64_t
dt_collection_properties_t property
const char * filmroll_order_by
One module's identity, for the rule that searches by module name.
GList * dt_util_str_to_glist(const gchar *separator, const gchar *text)
gchar * dt_util_glist_to_str(const gchar *separator, GList *items)
gchar * dt_util_dstrcat(gchar *str, const gchar *format,...)