[Digikam-users] sql queries digikam

[Arnd Baecker]

Hi Jeroen,

as a quick reply:
- make a copy of your digkam3.db to a separate place
  (just to be sure ;-)
- sqlite3 digikam3.db
  sqlite> .output db.dump
  sqlite> .dump
  sqlite> .quit
- have a look at db.dump
  Near the end there are the searches.

I *think* that these are directly useable ...

Best, Arnd

On Mon, 2 Jul 2007, depot @ xs4all. nl wrote:

> Dear list,
>
> Sometimes I use sqlite3 from the cli to pull information directly out of the digikam sqlite
> database. For instance to generate simple statistics or for batch file renaming.
>
> My sql knowledge is very limited. I am looking for the sql queries as generated by digikam
> when a user performs a search using either the simple or the advanced search option.
> I found out that 'digikamsearch.cpp' (in the digikam source) is the code responsible for the
> sqlite queries. However you need to be a C++ debugger (and I am not) to reconstruct the queries
> from the code.
>
> Who can provide me with these sql queries? I assume at least the developpers have them.
>
> Thanks and happy digikam using,
>
> Jeroen
>
> jeroen.leijen.net/photography
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>