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 " +
            "CASE WHEN :sortMethod='TitleASC'  THEN quoteTitle END ASC, quoteSection ASC," +
            "CASE WHEN :sortMethod='TitleDESC' THEN quoteTitle END DESC, quoteSection ASC," +
            "CASE WHEN :sortMethod='DateASC' THEN createdAt END ASC," +
            "CASE WHEN :sortMethod='DateDESC' THEN createdAt END DESC")
    fun getScoreList(sortMethod : String) : LiveData<List<Score>>
}