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

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[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: [hidden email]
          Reporter: [hidden email]

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.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Reply | Threaded
Open this post in threaded view
|

[digikam] [Bug 331457] Show some statistic for albums

Gilles Caulier-4
https://bugs.kde.org/show_bug.cgi?id=331457

Gilles Caulier <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |[hidden email]
         Resolution|---                         |DUPLICATE

--- Comment #1 from Gilles Caulier <[hidden email]> ---


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

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel