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

Alexander Evseev aevseev at gmail.com
Mon Feb 24 13:13:50 GMT 2014


            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):



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

if [ $# -eq 1 ]
  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
  QUERY="select id, relativePath from Albums order by id"

sqlite3 ${DBName} "${QUERY}"

Reproducible: Always

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

More information about the Digikam-devel mailing list