[Digikam-users] sql queries digikam

[Arnd Baecker]

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

> Hi Arnd,
>
> Thanks for your response. But it's not quite what I am looking for.
>
> The queries (user searches) stored by digikam in the digikam3.db are in the format used by digikam.
> Eg 'digikamsearch:1%20AND%202?1.key=imagename&1.op=LIKE&1
> .val=20&2.key=imagedate&2.op=LT&2.val=2007-07-02&count=2&name=testsearch');
> These are not sql queries.
>
> I am looking for the sql queries that digikam generates to access the digikam3.db internally
> when a  user performs a search.

Alright, next try (need not be better ;-):

Can you compile from source?
If so you could just add in digikamsearch.cpp
  kdWarning() << "QUERY" << sqlQuery << endl;
in a line before the two calls
  m_db.execSql(sqlQuery, &values)

This should give you the full search string on the konsole
when running searches in digikam.

Best, Arnd