search

clementine-player / Clementine

:tangerine: Clementine Music Player
https://www.clementine-player.org/
GNU General Public License v3.0
3.73k stars 674 forks source link

(Where) are the file paths stored? #7224

Closed FrankwaP closed 1 year ago

FrankwaP commented 1 year ago

Hi!

I would like to use the 'artist - album - title - file_path' information from Clementine's database.

I've found the artist, album and title in the songs table of clementine.db. But I could not find anything better than the album_path (subdirectories table). I'm kind of lost as I even tried making a duplicate of an album to see how it would impact the database… but it does not seems to change size! Yet Clementine displays the duplicate files and knows where they are…

What kind of sorcery is going on? :-)

FrankwaP commented 1 year ago

Silly me… the file paths are located (drum roll) in the filename field of the songs table.

I had loaded the table into a pandas DataFrame and displayed it in my IDE, but since the file paths are encoded (b'/file/path/') I could not see them, also the text searches I tried did not work on them.