[Digikam-users] sql queries digikam

[depot @ xs4all. nl]

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.

Regards,

Jeroen

jeroen.leijen.net/photography





On Mon, Jul 02, 2007 at 01:39:23PM +0200, Arnd Baecker wrote:
> 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
> >
> >
>