package com.dayu.general.dao
|
|
import androidx.room.Dao
|
import androidx.room.Insert
|
import androidx.room.OnConflictStrategy
|
import androidx.room.Query
|
import androidx.room.Update
|
import com.dayu.general.bean.db.RechargeRecordBean
|
|
@Dao
|
interface RechargeRecordDao {
|
@Insert(onConflict = OnConflictStrategy.REPLACE)
|
fun insert(rechargeRecord: RechargeRecordBean)
|
|
@Insert(onConflict = OnConflictStrategy.REPLACE)
|
fun insertAll(rechargeRecords: List<RechargeRecordBean>)
|
|
@Update
|
fun update(rechargeRecord: RechargeRecordBean)
|
|
@Query("SELECT * FROM recharge_record WHERE id = :id")
|
fun findById(id: Long): RechargeRecordBean?
|
|
@Query("SELECT * FROM recharge_record WHERE cardNumber = :cardNumber ORDER BY createTime DESC")
|
fun findByCardNumber(cardNumber: String): List<RechargeRecordBean>
|
|
@Query("SELECT * FROM recharge_record WHERE isReported = 0")
|
fun findUnreportedRecords(): List<RechargeRecordBean>
|
|
@Query("UPDATE recharge_record SET isReported = 1 WHERE id = :id")
|
fun markAsReported(id: Long)
|
|
@Query("SELECT * FROM recharge_record ORDER BY createTime DESC")
|
fun getAllRecords(): List<RechargeRecordBean>
|
}
|
