[Digikam-devel] Newbie question

[Laurent Espitallier]

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
> Digikam-devel at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-devel
>
>    
Thanks Marcell, I'll take a look at it asap.