Dao example

TodoDao.kt

@Dao
interface TodoDao : BaseDao<TodoEntity> {
    @Query("SELECT * from todo")
    suspend fun getAll(): Array<TodoEntity>

    @Query("SELECT * from todo WHERE :uuid = uuid")
    suspend fun getById(uuid: Long): TodoEntity?

    @Query("DELETE from todo")
    suspend fun deleteAll()
}

@Transaction
suspend fun TodoDao.replaceAll(vararg todos: TodoEntity) {
    deleteAll()
    insert(*todos)
}