Android ContentResolver.query From Date to Date
December 17, 2021MediaStore.Images.ImageColumns.DATE_TAKEN is stored as Cursor#FIELD_TYPE_INTEGER
(number of milliseconds since 1970-01-01T00:00:00Z)
class Gallert(context: Context) {
private val contentResolver by lazy {
context.contentResolver
}
private val imageCollection: Uri by lazy {
if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.Q) {
MediaStore.Images.Media.getContentUri(
MediaStore.VOLUME_EXTERNAL
)
} else {
MediaStore.Images.Media.EXTERNAL_CONTENT_URI
}
}
private val imageProjections by lazy {
arrayOf(
MediaStore.Images.ImageColumns._ID,
// MediaStore.Images.ImageColumns.DATA,
MediaStore.Images.ImageColumns.BUCKET_DISPLAY_NAME,
MediaStore.Images.ImageColumns.DATE_TAKEN,
MediaStore.Images.ImageColumns.DISPLAY_NAME,
MediaStore.Images.ImageColumns.ORIENTATION,
MediaStore.Images.ImageColumns.WIDTH,
MediaStore.Images.ImageColumns.HEIGHT,
MediaStore.Images.ImageColumns.SIZE,
@Suppress("DEPRECATION")
MediaStore.Images.ImageColumns.LATITUDE,
@Suppress("DEPRECATION")
MediaStore.Images.ImageColumns.LONGITUDE
)
}
fun findLocalImagesByDate(date: LocalDate, page: Int, pageSize: Int): Cursor? {
val selection = "${MediaStore.Images.ImageColumns.DATE_TAKEN} >= ? AND ${MediaStore.Images.ImageColumns.DATE_TAKEN} <= ?"
val selectionArgs = arrayOf<String>(
date.atStartOfDay().toMillis().toString(),
date.atEndOfDay().toMillis().toString()
)
val limit = pageSize
val offset = (page - 1) * pageSize
val sort = MediaStore.Images.ImageColumns.DATE_TAKEN
val query = if (Build.VERSION.SDK_INT > Build.VERSION_CODES.Q) {
val bundle = Bundle().apply {
// selection
putString(ContentResolver.QUERY_ARG_SQL_SELECTION, selection)
putStringArray(
ContentResolver.QUERY_ARG_SQL_SELECTION_ARGS,
selectionArgs
)
// sort
putString(
ContentResolver.QUERY_ARG_SORT_COLUMNS,
sort
)
putInt(
ContentResolver.QUERY_ARG_SORT_DIRECTION,
ContentResolver.QUERY_SORT_DIRECTION_DESCENDING
)
// limit, offset
putInt(ContentResolver.QUERY_ARG_LIMIT, limit)
putInt(ContentResolver.QUERY_ARG_OFFSET, offset)
}
contentResolver.query(imageCollection, imageProjections, bundle, null)
}
else {
contentResolver.query(imageCollection, imageProjections, selection, selectionArgs, "$sort ASC LIMIT $limit OFFSET $offset")
}
return query
}
}
NOTE: Refer LocalDateTime.toMillis
- algo-trading
- algolia
- analytics
- android
- android-ktx
- android-permission
- android-studio
- apps-script
- bash
- binance
- bootstrap
- bootstrapvue
- chartjs
- chrome
- cloud-functions
- coding-interview
- contentresolver
- coroutines
- crashlytics
- crypto
- css
- dagger2
- datastore
- datetime
- docker
- eslint
- firebase
- firebase-auth
- firebase-hosting
- firestore
- firestore-security-rules
- flask
- fontawesome
- fresco
- git
- github
- glide
- godot
- google-app-engine
- google-cloud-storage
- google-colab
- google-drive
- google-maps
- google-places
- google-play
- google-sheets
- gradle
- html
- hugo
- inkscape
- java
- java-time
- javascript
- jetpack-compose
- jetson-nano
- kotlin
- kotlin-serialization
- layout
- lets-encrypt
- lifecycle
- linux
- logging
- lubuntu
- markdown
- mate
- material-design
- matplotlib
- md5
- mongodb
- moshi
- mplfinance
- mysql
- navigation
- nginx
- nodejs
- npm
- nuxtjs
- nvm
- pandas
- payment
- pip
- pwa
- pyenv
- python
- recylerview
- regex
- room
- rxjava
- scoped-storage
- selenium
- social-media
- ssh
- ssl
- static-site-generator
- static-website-hosting
- sublime-text
- ubuntu
- unit-test
- uwsgi
- viewmodel
- viewpager2
- virtualbox
- vue-chartjs
- vue-cli
- vue-router
- vuejs
- vuelidate
- vuepress
- web-development
- web-hosting
- webpack
- windows
- workmanager
- wsl
- yarn