Jump to content

Struggling with SQL queries


Recommended Posts


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.

Link to comment
Share on other sites

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");
Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...