Digikam DB doc

[Matthieu Pupat]

   Hello,

Is there any documentation on the digikam DB shema?

I was looking at my digikam DB and was wondering why some pictures show
with an album=NULL and a status=3

Also I would like to be able to search for all the pictures without
geolocation information.

Thanks for your help

Matthieu
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Rinus]

Op 14-05-11 19:31, Matthieu schreef:
>     Hello,
>
> Is there any documentation on the digikam DB shema?
Once I got this answer to that question.

Look in digikam/project sub folder, there
is a ODF file to explain DB structure.

I am not clever enough to find it. If you can find it, please give me instruction so I can find it too.

Rinus

> I was looking at my digikam DB and was wondering why some pictures show
> with an album=NULL and a status=3
>
> Also I would like to be able to search for all the pictures without
> geolocation information.
>
> Thanks for your help
>
> Matthieu
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Matthieu Pupat]

On 05/14/2011 01:51 PM, sleepless wrote:

> Op 14-05-11 19:31, Matthieu schreef:
>>     Hello,
>>
>> Is there any documentation on the digikam DB shema?
> Once I got this answer to that question.
>
> Look in digikam/project sub folder, there
> is a ODF file to explain DB structure.
>
> I am not clever enough to find it. If you can find it, please give me instruction so I can find it too.
>
> Rinus
>

Thanks. You can get it from http://quickgit.kde.org/?p=digikam.git&a=tree
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Matthieu Pupat]

On 05/14/2011 01:31 PM, Matthieu wrote:
>    Hello,
>
>
> Also I would like to be able to search for all the pictures without
> geolocation information.
>

In case anyone is interested that would be:

SELECT a.relativePath, i.name FROM Images i INNER JOIN Albums a ON
i.album=a.id  LEFT JOIN ImagePositions ip ON i.id=ip.imageid WHERE
ip.latitude IS NULL
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Luke Campagnola]

On Sat, May 14, 2011 at 13:31, Matthieu <[hidden email]> wrote:
> I was looking at my digikam DB and was wondering why some pictures show
> with an album=NULL and a status=3

I have noticed the same thing--many of the entries in my images table
have album=null and status=3. These images are visible from within
digikam and hold meta-data with no trouble, but the null value is
causing a script I'm writing to choke. Does anyone know the cause or
have a solution for this?

Luke
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Anders Stedtlund]

Hi,

Are you sure that the images with album=null are the visible ones? In
my case I have a lot of images which have been moved to other albums
that have album=null and the images have new entries in the table with
correct album set. So one can say that the images have two rows each
in the table.

/Anders

2011/12/31 Luke Campagnola <[hidden email]>:

> On Sat, May 14, 2011 at 13:31, Matthieu <[hidden email]> wrote:
>> I was looking at my digikam DB and was wondering why some pictures show
>> with an album=NULL and a status=3
>
> I have noticed the same thing--many of the entries in my images table
> have album=null and status=3. These images are visible from within
> digikam and hold meta-data with no trouble, but the null value is
> causing a script I'm writing to choke. Does anyone know the cause or
> have a solution for this?
>
> Luke
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users