Allows to write SQL statements instead of using contentResolver.query(...).
The library add an extension function to ContentResolver named
querySql(query: String, selectionArgs: Array<String>? = null)
- When using
LIMITkeyword, you need to specify alsoORDER BY. - When using
GROUP BYkeyword, you need to specify alsoWHERE. - You can use
WHERE 1 GROUP BYif you haven’t aWHEREcondition JOINare not supported by android content provider itself.
Step 1. Add the JitPack repository to your build file Add it in your root build.gradle at the end of repositories:
allprojects {
repositories {
...
maven { url 'https://jitpack.io' }
}
}Step 2. Add the dependency
implementation 'com.github.ologe:android-content-resolver-SQL:1.2.2'Get all songs
val query = """
SELECT *
FROM ${Media.EXTERNAL_CONTENT_URI}
"""
contentResolver.querySql(query)instead of
contentResolver.query(Media.EXTERNAL_CONTENT_URI, null, null, null, null)Get first 10 artists offsetted by 2, that have at least 5 tracks and 2 albums, excluding the podcast, ordered by artist desc
val query = """
SELECT distinct $ARTIST_ID, $ARTIST, count(*) as songs, count(distinct $ALBUM_ID) as albums
FROM ${Media.EXTERNAL_CONTENT_URI}
WHERE $IS_PODCAST = 0
GROUP BY $ARTIST_ID
HAVING songs >= 5 AND albums >= 2
ORDER BY $ARTIST_KEY DESC
LIMIT 10
OFFSET 2
"""
contentResolver.querySql(query)instead of
contentResolver.query(
uri = Media.EXTERNAL_CONTENT_URI,
projection = arrayOf(
"distinct $ARTIST_ID",
ARTIST,
"count(*) as songs",
"count(distinct $ALBUM_ID) as albums"
),
selection = "$IS_PODCAST = 0 ) GROUP BY $ARTIST_ID HAVING (songs >= 5 AND albums >= 2",
selectionArgs = null,
sortOrder = "$ARTIST_KEY DESC LIMIT 20 OFFSET 2"
)
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent