package com.dklaw.memorize.database

import androidx.lifecycle.LiveData
import androidx.room.Dao
import androidx.room.Delete
import androidx.room.Query
import androidx.room.Upsert

@Dao
interface ScoreDAO {

    @Upsert
    suspend fun upsertScore(score : Score)

    @Delete
    suspend fun deleteScore(score : Score)

    @Query("SELECT * FROM SCORE")
    fun getAllScores() : LiveData<List<Score>>

    @Query("SELECT * FROM SCORE ORDER BY quoteTitle ASC")
    fun getAllScoresByTitleASC() : LiveData<List<Score>>

    @Query("SELECT * FROM SCORE ORDER BY quoteTitle DESC")
    fun getAllScoresByTitleDESC() : LiveData<List<Score>>

    @Query("SELECT * FROM SCORE ORDER BY createdAt ASC")
    fun getAllScoresByDateASC() : LiveData<List<Score>>

    @Query("SELECT * FROM SCORE ORDER BY createdAt DESC")
    fun getAllScoresByDateDESC() : LiveData<List<Score>>
}