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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...