[Digikam-users] sql queries digikam

[Gilles Caulier]

2007/7/2, depot @ xs4all. nl <depot at xs4all.nl>:
>
> > 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
>
> Hi Arnd. Thanks a lot again!
> I did as you suggested. Even though I don't understand what your code
> does.


It just put as text the string used to query the database content...

This is a sample of the output on the console when I did some searches:
>
> digikam: Dirty: /
> digikam:
> digikamsearch:1?1.key=album&1.op=EQ&1.val=1&name=Last%20Search&count=1
> digikam:
> digikamsearch:1?1.key=tag&1.op=EQ&1.val=1&name=Last%20Search&count=1
> digikam:
> digikamsearch:1?1.key=tag&1.op=EQ&1.val=1&name=Last%20Search&count=1
> digikam:
> digikamsearch:1?1.key=tag&1.op=EQ&1.val=2&name=Last%20Search&count=1
> digikam: digikamsearch:1 AND
>
> 2?1.key=tag&1.op=EQ&1.val=2&2.key=album&2.op=EQ&2.val=1&name=Last%20Search&count=2
> digikam: digikamsearch:1 AND
>
> 2?1.key=tag&1.op=EQ&1.val=2&2.key=imagedate&2.op=GT&2.val=2007-07-02&name=Last%20Search&count=2
> digikam: digikamsearch:1 AND
>
> 2?1.key=tag&1.op=EQ&1.val=2&2.key=imagedate&2.op=LT&2.val=2007-07-02&name=Last%20Search&count=2
> digikam: digikamsearch:1 AND
>
> 2?1.key=tag&1.op=EQ&1.val=2&2.key=imagedate&2.op=LT&2.val=2007-07-02&name=Last%20Searchjkj&count=2
> digikam: Dirty: /
>
> Still it's not what I am looking for.


no, this is what you want, but you have a just a part of the DB query.

Gilles
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20070702/2a2d4e15/attachment.html>