Struggling with SQL queries

[NdR23]

Hello,

Is there any way to have "physical" acces to all databases without rooted device (cant have acces to one for several months)?

Im tired to guess column names with blind queries...

If not, anyone can tell me what the structures looks like?

For more in depth explaination, i need to query files by genre->artist->albums and albums->art uri, but cant find column's name for that.

[flyingdutchman]

Main table folder_files and I also attached the database itself. I use a windows based sql tool called RazorSql to build queries. I hope this helps

 

folders.db

[flyingdutchman]

For example to get all tracks

SELECT folder_files._id, folder_files.name AS name,
folder_files.artist_id AS artist_id,duration, rating, artists.artist,
 albums.album, folders.path FROM folder_files
 INNER JOIN folders ON folders._id=folder_id
 LEFT JOIN albums ON albums._id=folder_files.album_id
 LEFT JOIN artists ON artists._id=folder_files.artist_id
 WHERE (folder_files.cue_folder_id IS NULL)
 ORDER BY folder_files.title_tag COLLATE NOCASE

 

My app New Playlist Manager uses the uris below

public final Uri powerampuri = Uri.parse("content://com.maxmpz.audioplayer.data/files");
public final Uri powerampgenreuri = Uri.parse("content://com.maxmpz.audioplayer.data/genres/files");
public final Uri playlistfilesuri = Uri.parse("content://com.maxmpz.audioplayer.data/playlists/files");
public final Uri playlisturi = Uri.parse("content://com.maxmpz.audioplayer.data/playlists");
public final Uri preseturi = Uri.parse("content://com.maxmpz.audioplayer.data/eq_presets");

[NdR23]

GREAT!!

Thanks a lot.