如何查找房间数据库中是否已存在记录

Question

我从sql db移到了Room。我不知道如何检查数据库中是否存在项目。如何使用Room编写这段代码？

fun existsCheck(place: Places): Boolean {
    val db= this.readableDatabase
    val query = "SELECT * FROM $TABLE_PLACES WHERE $COLUMN_LAT = ${place.lat} AND $COLUMN_LNG = ${place.lng}"
    val cursor = db.rawQuery(query, null)
    if(cursor.count > 0){
        cursor.close()
        db.close()
        return true
    }
    cursor.close()
    db.close()
    return false
}

我试图用这段代码来实现这一点，但总是得到FALSE返回

@Query("SELECT name FROM place WHERE lat = :lat AND lng = :lng")
fun exist(lat: Double?, lng: Double?): Flowable<String>

override fun save() {
    Observable.just(dao)
            .subscribeOn(Schedulers.io())
            .subscribe {  dao.insert(place) }
}

override fun itemExists(lat: Double?, lng: Double?): Single<Boolean> =
        dao.exist(lat, lng)
                .flatMapSingle { Single.just(it.isNotEmpty()) }
                .onErrorReturn { false }
                .first(false)



override fun delete() {
    dao.deleteByLat(place.lat)
}

override fun saveClicked() {
    var boolean = false
     itemExists(place.lat, place.lng)
             .subscribeOn(Schedulers.io())
             .map { it -> boolean = it }
    if (boolean){
        delete()
        v.setImageNotSaved()
    } else {
        save()
        v.setImageSaved()
    }

}

Answer 1

这个很好用

 override fun itemExists() {
         Observable.just(dao)
                .subscribeOn(Schedulers.io())
                .subscribeOn(AndroidSchedulers.mainThread())
                 .map { it -> it.exist(place.lat, place.lng) }
                .subscribe( { it -> saveClicked(true) },
                        {error -> saveClicked(false)})
    }