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. |
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. |
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 |
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. |
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 |
Free forum by Nabble | Edit this page |