[Digikam-devel] Newbie question

[Marcel Wiesweg]

> 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.