Re: [darktable-user] Image list

[Tobias Ellinghaus]

Am Samstag, 14. April 2018, 19:41:41 CEST schrieb darkta...@911networks.com:
> DT 2.4.2 on manjaro
> 
> I need to create a spreadsheet.
> 
> Is there a way of exporting an image list/file list for:
> 
> * tags
> * labels
> * ratings
> 
> These settings don't have to be in the same list, I can merge them
> later.
> 
> Is there a data diagram with the relationships? If there is one, I
> could do it with sqlitebrowser.

The SQL would be something like this for tags:

select folder || "/" || filename, used_tags.name from images inner join 
film_rolls inner join tagged_images inner join used_tags where images.film_id 
= film_rolls.id and images.id = tagged_images.imgid and tagged_images.tagid = 
used_tags.id order by folder, filename;


For labels:

select folder || "/" || filename, color from images inner join film_rolls 
inner join color_labels where images.film_id = film_rolls.id and images.id = 
color_labels.imgid order by folder, filename, color;


Ratings are easier as they are in the same table as the filenames:

select folder || "/" || filename, flags & 7 from images inner join film_rolls 
where images.film_id = film_rolls.id order by folder, filename;


Tobias

signature.asc
Description: This is a digitally signed message part.