Bug 331457 - Show some statistic for albums
Summary: Show some statistic for albums
Status: RESOLVED DUPLICATE of bug 151233
Alias: None
Product: digikam
Classification: Applications
Component: Maintenance-Engine (show other bugs)
Version: unspecified
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-24 13:13 UTC by Alexander Evseev
Modified: 2017-08-15 11:20 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Evseev 2014-02-24 13:13:50 UTC
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
Comment 1 caulier.gilles 2014-02-24 13:20:22 UTC

*** This bug has been marked as a duplicate of bug 151233 ***