NdR23 Posted November 5, 2020 Share Posted November 5, 2020 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. Quote Link to comment Share on other sites More sharing options...
flyingdutchman Posted November 5, 2020 Share Posted November 5, 2020 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 Quote Link to comment Share on other sites More sharing options...
flyingdutchman Posted November 5, 2020 Share Posted November 5, 2020 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"); Quote Link to comment Share on other sites More sharing options...
NdR23 Posted November 5, 2020 Author Share Posted November 5, 2020 GREAT!! Thanks a lot. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.