TodoTaskDao.kt

@Dao
interface TodoTaskDao {

    @Query("select * from todotasks order by id")
    fun getallTasks(): List<TodoTask>

    @Insert
    fun insertTodoTask(todoTask: TodoTask)

    @Update(onConflict = OnConflictStrategy.REPLACE)
    fun updateTodoTask(todoTask: TodoTask)

    @Delete
    fun deleteTodoTask()

    @Query("Select * from todotasks where id = :id")
    fun getTaskbyId(id: Int): List<TodoTask>
}