| Summary: | Show some statistic for albums | ||
|---|---|---|---|
| Product: | [Applications] digikam | Reporter: | Alexander Evseev <aevseev> |
| Component: | Maintenance-Engine | Assignee: | Digikam Developers <digikam-bugs-null> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | wishlist | CC: | caulier.gilles |
| Priority: | NOR | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | unspecified | ||
| OS: | All | ||
| Latest Commit: | Version Fixed In: | ||
*** This bug has been marked as a duplicate of bug 151233 *** |
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