kotlin 如何删除自动生成id的房间数据库中的项目?

xxb16uws  于 7个月前  发布在  Kotlin
关注(0)|答案(1)|浏览(63)

我有这个房间实体与自动生成的主键,我认为这导致了问题

@Entity(tableName = "savedlocations")
data class SavedLocationsEntity(

    @PrimaryKey(autoGenerate = true)
    val id: Int? = 0,

    @ColumnInfo("latitude")
    val latitude: Double,

    @ColumnInfo("longitude")
    val longitude: Double,

    @ColumnInfo("city")
    val city: String,

    @ColumnInfo("province")
    val province: String

)

字符串
这样不行

@Delete
    suspend fun removeFromSavedLocations(savedLocation: SavedLocationsEntity)


这些都在起作用

@Query("SELECT * FROM savedlocations")
    suspend fun getSavedLocations(): List<SavedLocationsEntity>

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    suspend fun addToSavedLocations(savedLocation: SavedLocationsEntity)

wbrvyc0a

wbrvyc0a1#

您可以尝试添加@Query而不是@Delete

@Query("DELETE FROM YourTableName WHERE id = :your_id")
suspend fun removeFromSavedLocations(your_id: Int)

字符串

相关问题