static void
get_query_string(const dt_collection_properties_t property, const gchar *escaped_text, char *query, size_t query_len)
{
switch(property)
{
case DT_COLLECTION_PROP_FILMROLL: // film roll
if (!(escaped_text && *escaped_text))
snprintf(query, query_len, "(film_id in (select id from film_rolls where folder like '%s%%'))", escaped_text);
else
snprintf(query, query_len, "(film_id in (select id from film_rolls where folder like '%s'))", escaped_text);
break;
case DT_COLLECTION_PROP_FOLDERS: // folders
snprintf(query, query_len, "(film_id in (select id from film_rolls where folder like '%s%%'))", escaped_text);
break;
case DT_COLLECTION_PROP_COLORLABEL: // colorlabel
{
int color = 0;
if(!(escaped_text && *escaped_text) || strcmp(escaped_text, "%")==0) snprintf(query, query_len, "(id in (select imgid from color_labels where color IS NOT NULL))");
else
{
if (strcmp(escaped_text,_("red") )==0) color=0;
else if(strcmp(escaped_text,_("yellow"))==0) color=1;
else if(strcmp(escaped_text,_("green") )==0) color=2;
else if(strcmp(escaped_text,_("blue") )==0) color=3;
else if(strcmp(escaped_text,_("purple"))==0) color=4;
snprintf(query, query_len, "(id in (select imgid from color_labels where color=%d))", color);
}
}
break;
case DT_COLLECTION_PROP_HISTORY: // history
snprintf(query, query_len, "(id %s in (select imgid from history where imgid=images.id)) ",(strcmp(escaped_text,_("altered"))==0)?"":"not");
break;
case DT_COLLECTION_PROP_GEOTAGGING: // geotagging
snprintf(query, query_len, "(id %s in (select id AS imgid from images where (longitude IS NOT NULL AND latitude IS NOT NULL))) ",(strcmp(escaped_text,_("tagged"))==0)?"":"not");
break;
case DT_COLLECTION_PROP_CAMERA: // camera
snprintf(query, query_len, "(maker || ' ' || model like '%%%s%%')", escaped_text);
break;
case DT_COLLECTION_PROP_TAG: // tag
snprintf(query, query_len, "(id in (select imgid from tagged_images as a join "
"tags as b on a.tagid = b.id where name like '%s'))", escaped_text);
break;
// TODO: How to handle images without metadata? In the moment they are not shown.
// TODO: Autogenerate this code?
case DT_COLLECTION_PROP_TITLE: // title
snprintf(query, query_len, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_TITLE, escaped_text);
break;
case DT_COLLECTION_PROP_DESCRIPTION: // description
snprintf(query, query_len, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_DESCRIPTION, escaped_text);
break;
case DT_COLLECTION_PROP_CREATOR: // creator
snprintf(query, query_len, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_CREATOR, escaped_text);
break;
case DT_COLLECTION_PROP_PUBLISHER: // publisher
snprintf(query, query_len, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_PUBLISHER, escaped_text);
break;
case DT_COLLECTION_PROP_RIGHTS: // rights
snprintf(query, query_len, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_RIGHTS, escaped_text);
break;
case DT_COLLECTION_PROP_LENS: // lens
snprintf(query, query_len, "(lens like '%%%s%%')", escaped_text);
break;
case DT_COLLECTION_PROP_ISO: // iso
{
gchar *operator, *number;
dt_collection_split_operator_number(escaped_text, &number, &operator);
if(operator && number)
snprintf(query, query_len, "(iso %s %s)", operator, number);
else if(number)
snprintf(query, query_len, "(iso = %s)", number);
else
snprintf(query, query_len, "(iso like '%%%s%%')", escaped_text);
g_free(operator);
g_free(number);
}
break;
case DT_COLLECTION_PROP_APERTURE: // aperture
{
gchar *operator, *number;
dt_collection_split_operator_number(escaped_text, &number, &operator);
if(operator && number)
snprintf(query, query_len, "(aperture %s %s)", operator, number);
else if(number)
snprintf(query, query_len, "(aperture = %s)", number);
else
snprintf(query, query_len, "(aperture like '%%%s%%')", escaped_text);
g_free(operator);
g_free(number);
}
break;
case DT_COLLECTION_PROP_FILENAME: // filename
snprintf(query, query_len, "(filename like '%%%s%%')", escaped_text);
break;
case DT_COLLECTION_PROP_BEFORE: // before a given date
snprintf(query, query_len, "(datetime_taken <= '%s%%')", escaped_text);
break;
case DT_COLLECTION_PROP_AFTER: // after a given date
snprintf(query, query_len, "(datetime_taken >= '%s%%')", escaped_text);
break;
default: // day or time
snprintf(query, query_len, "(datetime_taken like '%%%s%%')", escaped_text);
break;
}
}
static gchar *get_query_string(const dt_collection_properties_t property, const gchar *text)
{
char *escaped_text = sqlite3_mprintf("%q", text);
gchar *query = NULL;
switch(property)
{
case DT_COLLECTION_PROP_FILMROLL: // film roll
if(!(escaped_text && *escaped_text))
query = dt_util_dstrcat(query, "(film_id in (select id from film_rolls where folder like '%s%%'))",
escaped_text);
else
query = dt_util_dstrcat(query, "(film_id in (select id from film_rolls where folder like '%s'))",
escaped_text);
break;
case DT_COLLECTION_PROP_FOLDERS: // folders
query = dt_util_dstrcat(query, "(film_id in (select id from film_rolls where folder like '%s%%'))",
escaped_text);
break;
case DT_COLLECTION_PROP_COLORLABEL: // colorlabel
{
int color = 0;
if(!(escaped_text && *escaped_text) || strcmp(escaped_text, "%") == 0)
query = dt_util_dstrcat(query, "(id in (select imgid from color_labels where color IS NOT NULL))");
else
{
if(strcmp(escaped_text, _("red")) == 0)
color = 0;
else if(strcmp(escaped_text, _("yellow")) == 0)
color = 1;
else if(strcmp(escaped_text, _("green")) == 0)
color = 2;
else if(strcmp(escaped_text, _("blue")) == 0)
color = 3;
else if(strcmp(escaped_text, _("purple")) == 0)
color = 4;
query = dt_util_dstrcat(query, "(id in (select imgid from color_labels where color=%d))", color);
}
}
break;
case DT_COLLECTION_PROP_HISTORY: // history
query = dt_util_dstrcat(query, "(id %s in (select imgid from history where imgid=images.id)) ",
(strcmp(escaped_text, _("altered")) == 0) ? "" : "not");
break;
case DT_COLLECTION_PROP_GEOTAGGING: // geotagging
query = dt_util_dstrcat(query, "(id %s in (select id AS imgid from images where (longitude IS NOT NULL AND "
"latitude IS NOT NULL))) ",
(strcmp(escaped_text, _("tagged")) == 0) ? "" : "not");
break;
case DT_COLLECTION_PROP_CAMERA: // camera
if (!text || text[0] == '\0') // Optimize away the empty case
query = dt_util_dstrcat(query, "(1=1)");
else
{
// Start query with a false statement to avoid special casing the first condition
query = dt_util_dstrcat(query, "((1=0)");
GList *lists = NULL;
dt_collection_get_makermodel(text, NULL, &lists);
GList *element = lists;
while (element)
{
GList *tuple = element->data;
char *mk = sqlite3_mprintf("%q", tuple->data);
char *md = sqlite3_mprintf("%q", tuple->next->data);
query = dt_util_dstrcat(query, " or (maker = '%s' and model = '%s')", mk, md);
sqlite3_free(mk);
sqlite3_free(md);
g_free(tuple->data);
g_free(tuple->next->data);
g_list_free(tuple);
element = element->next;
}
g_list_free(lists);
query = dt_util_dstrcat(query, ")");
}
break;
case DT_COLLECTION_PROP_TAG: // tag
query = dt_util_dstrcat(query, "(id in (select imgid from tagged_images as a join "
"tags as b on a.tagid = b.id where name like '%s'))",
escaped_text);
break;
// TODO: How to handle images without metadata? In the moment they are not shown.
// TODO: Autogenerate this code?
case DT_COLLECTION_PROP_TITLE: // title
query = dt_util_dstrcat(query, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_TITLE, escaped_text);
break;
case DT_COLLECTION_PROP_DESCRIPTION: // description
query = dt_util_dstrcat(query, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_DESCRIPTION, escaped_text);
break;
case DT_COLLECTION_PROP_CREATOR: // creator
query = dt_util_dstrcat(query, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_CREATOR, escaped_text);
break;
case DT_COLLECTION_PROP_PUBLISHER: // publisher
query = dt_util_dstrcat(query, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_PUBLISHER, escaped_text);
break;
case DT_COLLECTION_PROP_RIGHTS: // rights
query = dt_util_dstrcat(query, "(id in (select id from meta_data where key = %d and value like '%%%s%%'))",
DT_METADATA_XMP_DC_RIGHTS, escaped_text);
break;
case DT_COLLECTION_PROP_LENS: // lens
query = dt_util_dstrcat(query, "(lens like '%%%s%%')", escaped_text);
break;
case DT_COLLECTION_PROP_FOCAL_LENGTH: // focal length
{
gchar *operator, *number1, *number2;
dt_collection_split_operator_number(escaped_text, &number1, &number2, &operator);
if(operator&& strcmp(operator, "[]") == 0)
{
if(number1 && number2)
query = dt_util_dstrcat(query, "((focal_length >= %s) AND (focal_length <= %s))", number1, number2);
}
else if(operator&& number1)
query = dt_util_dstrcat(query, "(focal_length %s %s)", operator, number1);
else if(number1)
query = dt_util_dstrcat(query, "(focal_length = %s)", number1);
else
query = dt_util_dstrcat(query, "(focal_length like '%%%s%%')", escaped_text);
g_free(operator);
g_free(number1);
g_free(number2);
}
break;
case DT_COLLECTION_PROP_ISO: // iso
{
gchar *operator, *number1, *number2;
dt_collection_split_operator_number(escaped_text, &number1, &number2, &operator);
if(operator&& strcmp(operator, "[]") == 0)
{
if(number1 && number2)
query = dt_util_dstrcat(query, "((iso >= %s) AND (iso <= %s))", number1, number2);
}
else if(operator&& number1)
query = dt_util_dstrcat(query, "(iso %s %s)", operator, number1);
else if(number1)
query = dt_util_dstrcat(query, "(iso = %s)", number1);
else
query = dt_util_dstrcat(query, "(iso like '%%%s%%')", escaped_text);
g_free(operator);
g_free(number1);
g_free(number2);
}
break;
case DT_COLLECTION_PROP_APERTURE: // aperture
{
gchar *operator, *number1, *number2;
dt_collection_split_operator_number(escaped_text, &number1, &number2, &operator);
if(operator&& strcmp(operator, "[]") == 0)
{
if(number1 && number2)
query = dt_util_dstrcat(query, "((round(aperture,1) >= %s) AND (round(aperture,1) <= %s))", number1,
number2);
}
else if(operator&& number1)
query = dt_util_dstrcat(query, "(round(aperture,1) %s %s)", operator, number1);
else if(number1)
query = dt_util_dstrcat(query, "(round(aperture,1) = %s)", number1);
else
query = dt_util_dstrcat(query, "(round(aperture,1) like '%%%s%%')", escaped_text);
g_free(operator);
g_free(number1);
g_free(number2);
}
break;
case DT_COLLECTION_PROP_FILENAME: // filename
query = dt_util_dstrcat(query, "(filename like '%%%s%%')", escaped_text);
break;
case DT_COLLECTION_PROP_DAY:
// query = dt_util_dstrcat(query, "(datetime_taken like '%%%s%%')", escaped_text);
// break;
case DT_COLLECTION_PROP_TIME:
{
gchar *operator, *number1, *number2;
dt_collection_split_operator_datetime(escaped_text, &number1, &number2, &operator);
if(operator&& strcmp(operator, "[]") == 0)
{
if(number1 && number2)
query = dt_util_dstrcat(query, "((datetime_taken >= '%s') AND (datetime_taken <= '%s'))", number1,
number2);
}
else if(operator&& strcmp(operator, "=") == 0 && number1)
query = dt_util_dstrcat(query, "(datetime_taken like '%s')", number1);
else if(operator&& strcmp(operator, "<>") == 0 && number1)
query = dt_util_dstrcat(query, "(datetime_taken not like '%s')", number1);
else if(operator&& number1)
query = dt_util_dstrcat(query, "(datetime_taken %s '%s')", operator, number1);
else if(number1)
query = dt_util_dstrcat(query, "(datetime_taken like '%s')", number1);
else
query = dt_util_dstrcat(query, "(datetime_taken like '%%%s%%')", escaped_text);
g_free(operator);
g_free(number1);
g_free(number2);
}
break;
default:
// we shouldn't be here
break;
}
sqlite3_free(escaped_text);
if(!query) // We've screwed up and not done a query string, send a placeholder
query = dt_util_dstrcat(query, "(1=1)");
return query;
}
