[Digikam-devel] [digikam] [Bug 331457] New: Show some statistic for albums

[Alexander Evseev]

https://bugs.kde.org/show_bug.cgi?id=331457

            Bug ID: 331457
           Summary: Show some statistic for albums
    Classification: Unclassified
           Product: digikam
           Version: unspecified
          Platform: unspecified
                OS: All
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: Albums GUI
          Assignee: digikam-devel at kde.org
          Reporter: aevseev at gmail.com

digiKam database contains some metadata about photos...
It would be interesting to see summary information or statistics, such as focal
length or other data from table ImageMetadata

For example, I use following script to see most used focal ranges (for new
lenses selection):

#!/bin/sh

DK_CONF="${HOME}/.kde4/share/config/digikamrc"

eval `awk '/Database Name=/ {printf "DB%s/digikam4.db", $2}' ${DK_CONF}`

if [ $# -eq 1 ]
then
  QUERY="select count(m.imageid), m.focalLength from ImageMetadata m, Images i
where i.id=m.imageid and i.album=${1} group by m.focalLength order by
m.focalLength"
else
  QUERY="select id, relativePath from Albums order by id"
fi

sqlite3 ${DBName} "${QUERY}"

Reproducible: Always

-- 
You are receiving this mail because:
You are the assignee for the bug.