static int collection_numindex(lua_State *L)
{
int index = luaL_checkinteger(L, -1);
if(index < 1)
{
return luaL_error(L, "incorrect index in database");
}
gchar *query = NULL;
gchar *sq = NULL;
/* get collection order */
if((darktable.collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
sq = dt_collection_get_sort_query(darktable.collection);
sqlite3_stmt *stmt = NULL;
/* build the query string */
query = dt_util_dstrcat(query, "select distinct id from images ");
if(darktable.collection->params.sort == DT_COLLECTION_SORT_COLOR
&& (darktable.collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
query = dt_util_dstrcat(query, "as a left outer join color_labels as b on a.id = b.imgid ");
query = dt_util_dstrcat(query, "%s limit -1 offset ?1", sq);
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), query, -1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, index -1);
if(sqlite3_step(stmt) == SQLITE_ROW)
{
int imgid = sqlite3_column_int(stmt, 0);
luaA_push(L, dt_lua_image_t, &imgid);
sqlite3_finalize(stmt);
}
else
{
g_free(sq);
g_free(query);
sqlite3_finalize(stmt);
return luaL_error(L, "incorrect index in database");
}
g_free(sq);
g_free(query);
return 1;
}
GList *dt_collection_get_selected(const dt_collection_t *collection, int limit)
{
GList *list = NULL;
gchar *query = NULL;
gchar *sq = NULL;
/* get collection order */
if((collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
sq = dt_collection_get_sort_query(collection);
sqlite3_stmt *stmt = NULL;
/* build the query string */
query = dt_util_dstrcat(query, "select distinct id from images ");
if(collection->params.sort == DT_COLLECTION_SORT_COLOR
&& (collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
query = dt_util_dstrcat(query, "as a left outer join color_labels as b on a.id = b.imgid ");
else if(collection->params.sort == DT_COLLECTION_SORT_PATH
&& (collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
query = dt_util_dstrcat(
query, "join (select id as film_rolls_id, folder from film_rolls) on film_id = film_rolls_id ");
query = dt_util_dstrcat(query, "where id in (select imgid from selected_images) %s limit ?1", sq);
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db), query, -1, &stmt, NULL);
DT_DEBUG_SQLITE3_BIND_INT(stmt, 1, limit);
while(sqlite3_step(stmt) == SQLITE_ROW)
{
int imgid = sqlite3_column_int(stmt, 0);
list = g_list_append(list, GINT_TO_POINTER(imgid));
}
sqlite3_finalize(stmt);
/* free allocated strings */
g_free(sq);
g_free(query);
return list;
}
GList *dt_collection_get_selected (const dt_collection_t *collection)
{
GList *list=NULL;
gchar *query = NULL;
gchar *sq = NULL;
/* get collection order */
if ((collection->params.query_flags&COLLECTION_QUERY_USE_SORT))
sq = dt_collection_get_sort_query(collection);
sqlite3_stmt *stmt = NULL;
/* build the query string */
query = dt_util_dstrcat(query, "select distinct id from images ");
if (collection->params.sort == DT_COLLECTION_SORT_COLOR && (collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
query = dt_util_dstrcat(query, "as a left outer join color_labels as b on a.id = b.imgid ");
query = dt_util_dstrcat(query, "where id in (select imgid from selected_images) %s", sq);
DT_DEBUG_SQLITE3_PREPARE_V2(dt_database_get(darktable.db),query, -1, &stmt, NULL);
while (sqlite3_step (stmt) == SQLITE_ROW)
{
long int imgid = sqlite3_column_int(stmt, 0);
list = g_list_append (list, (gpointer)imgid);
}
/* free allocated strings */
if (sq)
g_free(sq);
g_free(query);
return list;
}
int
dt_collection_update (const dt_collection_t *collection)
{
uint32_t result;
gchar *wq, *sq, *selq, *query;
wq = sq = selq = query = NULL;
/* build where part */
if (!(collection->params.query_flags&COLLECTION_QUERY_USE_ONLY_WHERE_EXT))
{
int need_operator = 0;
dt_collection_filter_t rating = collection->params.rating;
if(rating == DT_COLLECTION_FILTER_NOT_REJECT) rating = DT_COLLECTION_FILTER_STAR_NO;
/* add default filters */
if (collection->params.filter_flags & COLLECTION_FILTER_FILM_ID)
{
wq = dt_util_dstrcat(wq, "(film_id = %d)", collection->params.film_id);
need_operator = 1;
}
// DON'T SELECT IMAGES MARKED TO BE DELETED.
wq = dt_util_dstrcat(wq, " %s (flags & %d) != %d", (need_operator)?"and":((need_operator=1)?"":""), DT_IMAGE_REMOVE, DT_IMAGE_REMOVE);
if (collection->params.filter_flags & COLLECTION_FILTER_CUSTOM_COMPARE)
wq = dt_util_dstrcat(wq, " %s (flags & 7) %s %d and (flags & 7) != 6", (need_operator)?"and":((need_operator=1)?"":""), comparators[collection->params.comparator], rating - 1);
else if (collection->params.filter_flags & COLLECTION_FILTER_ATLEAST_RATING)
wq = dt_util_dstrcat(wq, " %s (flags & 7) >= %d and (flags & 7) != 6", (need_operator)?"and":((need_operator=1)?"":""), rating - 1);
else if (collection->params.filter_flags & COLLECTION_FILTER_EQUAL_RATING)
wq = dt_util_dstrcat(wq, " %s (flags & 7) == %d", (need_operator)?"and":((need_operator=1)?"":""), rating - 1);
if (collection->params.filter_flags & COLLECTION_FILTER_ALTERED)
wq = dt_util_dstrcat(wq, " %s id in (select imgid from history where imgid=id)", (need_operator)?"and":((need_operator=1)?"":"") );
else if (collection->params.filter_flags & COLLECTION_FILTER_UNALTERED)
wq = dt_util_dstrcat(wq, " %s id not in (select imgid from history where imgid=id)", (need_operator)?"and":((need_operator=1)?"":"") );
/* add where ext if wanted */
if ((collection->params.query_flags&COLLECTION_QUERY_USE_WHERE_EXT))
wq = dt_util_dstrcat(wq, " %s %s", (need_operator)?"and":"", collection->where_ext);
}
else
wq = dt_util_dstrcat(wq, "%s", collection->where_ext);
/* grouping */
if(darktable.gui && darktable.gui->grouping)
{
wq = dt_util_dstrcat(wq, " and (group_id = id or group_id = %d)", darktable.gui->expanded_group_id);
}
/* build select part includes where */
if (collection->params.sort == DT_COLLECTION_SORT_COLOR && (collection->params.query_flags & COLLECTION_QUERY_USE_SORT))
selq = dt_util_dstrcat(selq, "select distinct id from (select * from images where %s) as a left outer join color_labels as b on a.id = b.imgid", wq);
else if(collection->params.query_flags&COLLECTION_QUERY_USE_ONLY_WHERE_EXT)
selq = dt_util_dstrcat(selq, "select distinct images.id from images %s",wq);
else
selq = dt_util_dstrcat(selq, "select distinct id from images where %s",wq);
/* build sort order part */
if (!(collection->params.query_flags&COLLECTION_QUERY_USE_ONLY_WHERE_EXT) && (collection->params.query_flags&COLLECTION_QUERY_USE_SORT))
{
sq = dt_collection_get_sort_query(collection);
}
/* store the new query */
query = dt_util_dstrcat(query, "%s %s%s", selq, sq?sq:"", (collection->params.query_flags&COLLECTION_QUERY_USE_LIMIT)?" "LIMIT_QUERY:"");
result = _dt_collection_store(collection, query);
/* free memory used */
g_free(sq);
g_free(wq);
g_free(selq);
g_free (query);
/* update the cached count. collection isn't a real const anyway, we are writing to it in _dt_collection_store, too. */
((dt_collection_t*)collection)->count = _dt_collection_compute_count(collection);
dt_collection_hint_message(collection);
return result;
}
