Digikam database query tool
Project description
digikuery is a script to perform queries in digikam (photo manager) database.
It can
- Query albums which contains tags matching a given regex
- Query most used tags and corresponding albums
- Print other tags present in matching albums
- List digikam database structure
- Provide an interactive python shell for manual queries
Usage
usage: digikuery.py [-h] [-d DBPATH] [-F] [-R ROOT] [-T [FILTER_TAGS]] {shell,schema,album,tag,stats} ...
digikuery - Digikam database query tool - v20230529
positional arguments:
{shell,schema,album,tag,stats}
shell spawn ipython shell to explor digikam database
schema dump digikam database schema
album [album] list tags for one or all albums
tag [tag] list all tags or query single tag
-C sort by result count
-I show image details
stats show digikam database statistics (default)
options:
-h, --help show this help message and exit
-d DBPATH, --dbpath DBPATH
database path
-F, --full-tagname display full tag name
-R ROOT, --root ROOT restrict query to this root album
-T [FILTER_TAGS], --filter-tags [FILTER_TAGS]
show and filter tags for displayed albums
examples:
List albums when tag 'Paquerette' is present, together with other tags of this album
$ digikuery tag Paquerette
Install
$ pip install digikuery
Example: Query which albums contain given tag expression
Bellow we look for the "semaphore" name in all tags.
The query returns 2 tags "TagCommunication/Semaphore/Bleu" and "TagAlphabet/Semaphore", listing for each tag the albums containing tagged pictures.
$ digikuery tag semaphore
3 TagCommunication/Semaphore/Bleu
album_albanie
album_france
album_grece
1 TagAlphabet/Semaphore
album_photos_19e_siecle
Providing -I option would list the picture names.
Let's just sort them by picture count:
$ digikuery tag -C semaphore
3 TagCommunication/Semaphore/Bleu
3 album_france
2 album_grece
2 album_albanie
1 TagAlphabet/Semaphore
19 album_photos_19e_siecle
For each matching album we can show if it contains other tags, for example tags maching "access"
$ digikuery -T access tag semaphore
3 TagCommunication/Semaphore/Bleu
album_france
TagAccess/Walking (9), TagAccess/Train(1)
album_grece
TagAccess/Car(6), TagAccess/Walking (3)
album_albanie
TagAccess/Walking (5)
Internals
digikuery uses sqlalchemy to map digikam database to python objects.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
digikuery-20230529.tar.gz
(6.0 kB
view hashes)
Built Distribution
Close
Hashes for digikuery-20230529-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7dbdd8ecbf3026fa346e741891bc4fc64401f4d9b72aede227f3c990a27a73b4 |
|
MD5 | 2c44a395954dcc019dafd2ceb334eafa |
|
BLAKE2b-256 | b6f35ba2c7906317ac699bc7a8d32cab4727fa8805de712e8fe7d8d29df5b138 |