[digiKam-users] Where to find album thumbnails

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

[digiKam-users] Where to find album thumbnails

daniel bip
Hi there,

I'm coding a simple script in python which is supposed to send the thumbnail of each album by e-mail to a given address. But I'm getting crazy understanding where to look for that thumbnail.

I'm running digikam on sqlite files, and from what I've seen thumbnails might be stored in file "thumbnails-digikam.db", table "Thumbnails" field "Data" (blob field?), where they are listed by the same id which appears in "digikam4.db", table "albums" field "icon".

If so, I don't have anything in there... where should I look for that icon?

Thanks in advance :-)


BR,

d.

Reply | Threaded
Open this post in threaded view
|

Re: Where to find album thumbnails

Maik Qualmann
The "digikam4.db", table "albums" field "icon" has nothing to do with the
thumbnails. The thumbnails can / are found via the file path or the unique
file hash. Remember that the blob is a PGF file.

Maik

Am Samstag, 27. Juni 2020, 22:26:18 CEST schrieb daniel bip:

> Hi there,
>
> I'm coding a simple script in python which is supposed to send the
> thumbnail of each album by e-mail to a given address. But I'm getting crazy
> understanding where to look for that thumbnail.
>
> I'm running digikam on sqlite files, and from what I've seen thumbnails
> might be stored in file "thumbnails-digikam.db", table "Thumbnails" field
> "Data" (blob field?), where they are listed by the same id which appears in
> "digikam4.db", table "albums" field "icon".
>
> If so, I don't have anything in there... where should I look for that icon?
>
> Thanks in advance :-)
>
>
> BR,
>
> d.




Reply | Threaded
Open this post in threaded view
|

Re: Where to find album thumbnails

daniel bip
Maik,

Thank you for your prompt reply.

If "digikam4" > "albums" > "icon" has nothing to do with the Album Thumbnail where can I find that information then?

Thanks.


BR,

d.



On Sat, 27 Jun 2020 at 22:46, Maik Qualmann <[hidden email]> wrote:
The "digikam4.db", table "albums" field "icon" has nothing to do with the
thumbnails. The thumbnails can / are found via the file path or the unique
file hash. Remember that the blob is a PGF file.

Maik

Am Samstag, 27. Juni 2020, 22:26:18 CEST schrieb daniel bip:
> Hi there,
>
> I'm coding a simple script in python which is supposed to send the
> thumbnail of each album by e-mail to a given address. But I'm getting crazy
> understanding where to look for that thumbnail.
>
> I'm running digikam on sqlite files, and from what I've seen thumbnails
> might be stored in file "thumbnails-digikam.db", table "Thumbnails" field
> "Data" (blob field?), where they are listed by the same id which appears in
> "digikam4.db", table "albums" field "icon".
>
> If so, I don't have anything in there... where should I look for that icon?
>
> Thanks in advance :-)
>
>
> BR,
>
> d.




Reply | Threaded
Open this post in threaded view
|

Re: Where to find album thumbnails

Maik Qualmann
Oh, sorry, I missed the "Album" of thumbnails. Yes, the "Icon" column is
correct. You can find the Image.id from the Images table if an album thumbnail
is set.

Maik

Am Samstag, 27. Juni 2020, 23:02:52 CEST schrieb daniel bip:

> Maik,
>
> Thank you for your prompt reply.
>
> If "digikam4" > "albums" > "icon" has nothing to do with the Album
> Thumbnail where can I find that information then?
>
> Thanks.
>
>
> BR,
>
> d.
>
> On Sat, 27 Jun 2020 at 22:46, Maik Qualmann <[hidden email]> wrote:
> > The "digikam4.db", table "albums" field "icon" has nothing to do with the
> > thumbnails. The thumbnails can / are found via the file path or the unique
> > file hash. Remember that the blob is a PGF file.
> >
> > Maik
> >
> > Am Samstag, 27. Juni 2020, 22:26:18 CEST schrieb daniel bip:
> > > Hi there,
> > >
> > > I'm coding a simple script in python which is supposed to send the
> > > thumbnail of each album by e-mail to a given address. But I'm getting
> >
> > crazy
> >
> > > understanding where to look for that thumbnail.
> > >
> > > I'm running digikam on sqlite files, and from what I've seen thumbnails
> > > might be stored in file "thumbnails-digikam.db", table "Thumbnails"
> > > field
> > > "Data" (blob field?), where they are listed by the same id which appears
> >
> > in
> >
> > > "digikam4.db", table "albums" field "icon".
> > >
> > > If so, I don't have anything in there... where should I look for that
> >
> > icon?
> >
> > > Thanks in advance :-)
> > >
> > >
> > > BR,
> > >
> > > d.




Reply | Threaded
Open this post in threaded view
|

Re: Where to find album thumbnails

daniel bip
Hi Mark,

Ok, thanks, now I understand how are the tables and fields linked. Merci!


BR,

d.


On Sat, 27 Jun 2020 at 23:11, Maik Qualmann <[hidden email]> wrote:
Oh, sorry, I missed the "Album" of thumbnails. Yes, the "Icon" column is
correct. You can find the Image.id from the Images table if an album thumbnail
is set.

Maik

Am Samstag, 27. Juni 2020, 23:02:52 CEST schrieb daniel bip:
> Maik,
>
> Thank you for your prompt reply.
>
> If "digikam4" > "albums" > "icon" has nothing to do with the Album
> Thumbnail where can I find that information then?
>
> Thanks.
>
>
> BR,
>
> d.
>
> On Sat, 27 Jun 2020 at 22:46, Maik Qualmann <[hidden email]> wrote:
> > The "digikam4.db", table "albums" field "icon" has nothing to do with the
> > thumbnails. The thumbnails can / are found via the file path or the unique
> > file hash. Remember that the blob is a PGF file.
> >
> > Maik
> >
> > Am Samstag, 27. Juni 2020, 22:26:18 CEST schrieb daniel bip:
> > > Hi there,
> > >
> > > I'm coding a simple script in python which is supposed to send the
> > > thumbnail of each album by e-mail to a given address. But I'm getting
> >
> > crazy
> >
> > > understanding where to look for that thumbnail.
> > >
> > > I'm running digikam on sqlite files, and from what I've seen thumbnails
> > > might be stored in file "thumbnails-digikam.db", table "Thumbnails"
> > > field
> > > "Data" (blob field?), where they are listed by the same id which appears
> >
> > in
> >
> > > "digikam4.db", table "albums" field "icon".
> > >
> > > If so, I don't have anything in there... where should I look for that
> >
> > icon?
> >
> > > Thanks in advance :-)
> > >
> > >
> > > BR,
> > >
> > > d.