package room

import android.arch.lifecycle.LiveData
import android.arch.persistence.room.Dao
import android.arch.persistence.room.Insert
import android.arch.persistence.room.OnConflictStrategy
import android.arch.persistence.room.Query
import room.support_chat.ApiUser
import room.support_chat.Appeal
import room.support_chat.Message

@Dao
interface ApiUserDao {

    @Query("SELECT * from support_chat_users ORDER BY date DESC LIMIT 1")
    fun getUser() : ApiUser?

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insertUser(user: ApiUser)
}

@Dao
interface AppealDao {

    @Query("SELECT * from support_chat_appeals ORDER BY id DESC")
    fun getAppeals() : List<Appeal>?

    @Query("SELECT * from support_chat_appeals WHERE is_closed = 0 ORDER BY id DESC")
    fun getOpenAppeals() : List<Appeal>?

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insert(appeals: List<Appeal>)
}

@Dao
interface MessageDao {

    @Query("SELECT * FROM support_chat_messages WHERE appeal_id = :appealId ORDER BY created ASC")
    fun getMessagesByAppeal(appealId : Int) : List<Message>

    @Query("DELETE FROM support_chat_messages WHERE appeal_id = :appealId")
    fun removeMessagesByAppeal(appealId : Int)

    @Insert(onConflict = OnConflictStrategy.REPLACE)
    fun insert(list: List<Message>)

}