how to store images from server(api) to room database

Question

I want to store images from and api into room db.I receive data and images from an api. When I'm in online mode, the images are loaded using the urls provided by the api but when offline, images should be stored and retrieved from the database in offline mode.

im loading the images like this (it loads images):----

 if (!data.data.images.isNullOrEmpty()) {

            val base = BuildConfig.SERVER_URL.replace("api/", "")

            data.data.images.forEachIndexed { pos, it ->

                Glide.with(this)
                    .asBitmap()
                    .load(base + it?.imagePath)
                    .into(object : CustomTarget<Bitmap>() {
                        override fun onResourceReady(
                                resource: Bitmap,
                                transition: Transition<in Bitmap>?
                        ) {
                            imageClick = pos + 1
                            val file = File(
                                    getExternalFilesDir(Environment.DIRECTORY_PICTURES),
                                    "${System.currentTimeMillis()}${Constants.PROFILE_PIC_FILE_EXTENSION}"
                            )
                            imagePath = file.absolutePath
                            Utils.saveBitmapToFile(resource, imagePath)
                            Utils.compressImage(imagePath)
                            onCropImageResult(resource)
                        }

                        override fun onLoadCleared(placeholder: Drawable?) {

                        }
                    })
                     }
                     }

my JSON is like this:--------

 "data" : {
  .
  .
  .
"images" : [ {
  "assetImageId" : 4113,
  "transactionTypeId" : 2,
  "transactionId" : 88341,
  "imageURL" : "",
  "imagePath" : "UserData/AssetImages/INS-0000017673_1616058387618.jpg",
  "createdBy" : 0,
  "createdOn" : "0001-01-01T00:00:00",
  "updatedBy" : null,
  "updatedOn" : null,
  "isActive" : 0,
  "isNew" : false,
  "isDeleted" : false,
  "isChanged" : false,
  "timestamp" : null
}, {
  "assetImageId" : 4114,
  "transactionTypeId" : 2,
  "transactionId" : 88341,
  "imageURL" : "",
  "imagePath" : "UserData/AssetImages/INS-0000017673_1616058402212.jpg",
  "createdBy" : 0,
  "createdOn" : "0001-01-01T00:00:00",
  "updatedBy" : null,
  "updatedOn" : null,
  "isActive" : 0,
  "isNew" : false,
  "isDeleted" : false,
  "isChanged" : false,
  "timestamp" : null
} ],
 }

my entity table :---

@Entity(tableName = DatabaseConstants.MYTABLE, indices = [Index(value = ["requestId"], unique = true)])
  data class AllocationDetailsByIdEntity(
    var requestId: String? = null,
    var subLocation: String? = null,
    var amsTagId: String? = null,
    var status: String? = null,
    var installedBy: String? = null,
    var installedDate: String? = null,
    val assetTree: String? = null,
    var images: List<ImagesssItem?>? =null,
    @PrimaryKey(autoGenerate = true) var id: Int? = null
   ): Serializable

   @Entity
 data class ImagesssItem (
var assetImageId :String?= null,
var transactionTypeId: Int? = null,
var transactionId: Int? = null,
var imageURL: String? = null,
var imagePath: String? = null
@PrimaryKey(autoGenerate = true) var id : Int? = null

 ):Serializable

tried solution 1:--this is not working

    .diskCacheStrategy(DiskCacheStrategy.DATA)

Any idea how do i store this images using Room db ???????? need help ... thanks in Advance

Read about GSON and use GSON to convert to your model and save it to your room database. — Khal, Mar 30 '21 at 10:26
But why? Glide already handles caching if you set the cache strategy accordingly, no reason to save image in db as blobs — EpicPandaForce, Mar 30 '21 at 10:45
i tried this .diskCacheStrategy(DiskCacheStrategy.DATA) but when offline it doesnt shows images @EpicPandaForce — android dev, Mar 30 '21 at 10:50
@EpicPandaForce SOURCE is not found...giving suggestion as RESOURCE — android dev, Mar 30 '21 at 11:26
@EpicPandaForce if i write preload()-->showing red/error on `.into()` — android dev, Mar 30 '21 at 11:27
@EpicPandaForce `no reason to save image in db as blobs` --> but i need to store those images in room db for further operations in offline mode — android dev, Mar 30 '21 at 11:33
Further operations other than loading the images from URL? This is essential to the question tbh. — EpicPandaForce, Mar 30 '21 at 12:12
@EpicPandaForce yes...i have further task like filling the offline form so need have a db for images — android dev, Mar 30 '21 at 12:13
I don't get what you mean. You already have the image URLs. You have them cached as files. You can load them. — EpicPandaForce, Mar 30 '21 at 12:14
@EpicPandaForce how do i make db for that images which is under data table ?? — android dev, Mar 31 '21 at 05:40
@EpicPandaForce how do i do it ???can you help??? have you seen my entity table in my question? — android dev, Mar 31 '21 at 10:28
@EpicPandaForce what query should fire in `Dao` for images(for images which is getting stored) for this `val file = File( getExternalFilesDir(Environment.DIRECTORY_PICTURES), "${System.currentTimeMillis()}${Constants.PROFILE_PIC_FILE_EXTENSION}"` — android dev, Mar 31 '21 at 10:30
It seems you already have a solution in mind that is completely oppositional to what I've been trying to say, so I can't help you. — EpicPandaForce, Mar 31 '21 at 11:51
@EpicPandaForce but this is also not working `.diskCacheStrategy(DiskCacheStrategy.RESOURCE)` images is not getting displayed in offline mode — android dev, Mar 31 '21 at 13:39

score 0 · Answer 1 · answered Mar 30 '21 at 11:36

0

Try to store it as URI. or create a type converter like this

class Converter {

    @TypeConverter
    fun fromBitmap(bmp: Bitmap): ByteArray {
        val outputStream = ByteArrayOutputStream()
        bmp.compress(Bitmap.CompressFormat.PNG, 100, outputStream)
        return outputStream.toByteArray()
    }

    @TypeConverter
    fun toBitmap(byteArray: ByteArray): Bitmap {
        return BitmapFactory.decodeByteArray(byteArray, 0, byteArray.size)
    }
}

and add this type converter in you roomdb class

@TypeConverters(Converter::class)
abstract class RunningDatabase : RoomDatabase() {

  ///


}

answered Mar 30 '21 at 11:36

Chirag Rayani

309
1
14

im having a image array under data...need help entity class...do i have to make a new table ??beacuse in my data table ->image array is there ...can you please guide or edit answer – android dev Mar 30 '21 at 11:47
@apj123 I think you don't need any new table just save the URL of the image with its data and use Glide to display the image it will take care of caching – EL TEGANI MOHAMED HAMAD GABIR Mar 30 '21 at 12:19
i dont get you @ELTEGANIMOHAMEDHAMADGABIR because `.diskCacheStrategy(DiskCacheStrategy.RESOURCE)` doesnt work and how do i get the stored images future for my further operations?? – android dev Mar 30 '21 at 12:31
@ELTEGANIMOHAMEDHAMADGABIR i have to fill a form offline where i need those images for that time – android dev Mar 30 '21 at 12:39
use `.diskCacheStrategy(DiskCacheStrategy.ALL)` for caching. to get ack your saved images you can select them from the table. – EL TEGANI MOHAMED HAMAD GABIR Mar 30 '21 at 12:42
for glide please [visit this](https://futurestud.io/tutorials/glide-caching-basics) – EL TEGANI MOHAMED HAMAD GABIR Mar 30 '21 at 12:44
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/230544/discussion-between-el-tegani-mohamed-hamad-gabir-and-apj123). – EL TEGANI MOHAMED HAMAD GABIR Mar 30 '21 at 12:50

how to store images from server(api) to room database

1 Answers1

Linked