Le 14/04/2010 22:15, Marcel Wiesweg a écrit :
>
>> Hi, I'd like to get images fullpath from digikam database with this
>> simple query :
>>
>> SELECT AlbumRoots.identifier || Albums.relativePath || '/' ||
>> images.name FROM images INNER JOIN Albums ON Images.album = Albums.id
>> INNER JOIN AlbumRoots ON Albums.albumRoot = AlbumRoots.id
>>
>> The result gives something like this :
>>
>> volumeid:?path=C%3A%2FUsers%2Flaurent%2FPictures/PictureProject/Sample
>> Images/Flower/Flower1.JPG
>>
>> Is there a method (QUrl ?) to make albumRoots human readable ? Or a
>> better way to get it ?
>>
> The AlbumRoots.identifier can take a number of different forms, most commonly
> it will be the UUID of the disk partition. Only the relative path is stored in
> the db directly. Take a look at CollectionManager how we access full paths.
> _______________________________________________
> Digikam-devel mailing list
>
[hidden email]
>
https://mail.kde.org/mailman/listinfo/digikam-devel>
>
Thanks Marcell, I'll take a look at it asap.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel
Locked
