我希望获取一个列表,其中
deletedAt
值为NULL
的MyModel
。这是我的表格:@Entity(tableName = "my_table")
data class MyModel(
@PrimaryKey
@ColumnInfo(name = "id")
var id: String,
@ColumnInfo(name = "deletedAt")
var deletedAt: Date? = null
)
道:
@Dao
abstract class MyDao : BaseDao<MyModel> {
@Query("SELECT * from my_table WHERE deletedAt IS NULL")
abstract fun getList(): LiveData<List<MyModel>>
}
我的类型转换器:
object DateTypeConverter {
@TypeConverter
@JvmStatic// It need to added else gives unwanted data binding error :D
fun fromTimestamp(value: Long?): Date? {
return if (value == null) null else Date(value)
}
@TypeConverter
@JvmStatic
fun dateToTimestamp(date: Date?): Long? {
return date?.time
}
但是,即使某些条目的“deletedAt”值为空,它也会返回所有MyModel数据。
@Query("SELECT * from my_table WHERE deletedAt IS NULL").
- Xuzan