coding-blocks/CBOnlineApp

package com.codingblocks.cbonlineapp.database

import androidx.lifecycle.LiveData
import androidx.room.Dao
import androidx.room.Query
import androidx.room.Transaction
import com.codingblocks.cbonlineapp.database.models.NotesModel

@Dao
interface NotesDao : BaseDao<NotesModel> {

    @Query(
        """
        SElECT n.*,c.title as contentTitle FROM NotesModel n 
       INNER JOIN ContentModel c ON c.ccid = n.contentId
       where n.runAttemptId = :runAttemptId order by createdAt DESC
    """
    )
    fun getNotes(runAttemptId: String): LiveData<List<NotesModel>>

    @Query(
        """
        SElECT n.*,c.title as contentTitle FROM NotesModel n 
       INNER JOIN ContentModel c ON c.ccid = n.contentId
       where n.runAttemptId = :runAttemptId AND n.contentId = :contentId order by createdAt DESC
    """
    )
    fun getNotesForContent(runAttemptId: String, contentId: String): LiveData<List<NotesModel>>

    @Query("SElECT * FROM NotesModel")
    abstract fun getAllNotes(): LiveData<List<NotesModel>>

    @Query("UPDATE NotesModel SET text = :text where nttUid = :uid")
    abstract fun updateBody(uid: String, text: String)

    @Query("SElECT * FROM NotesModel where nttUid = :uid")
    abstract fun getNoteById(uid: String): LiveData<NotesModel>

    @Transaction
    @Query("DELETE FROM NotesModel where nttUid = :uid")
    abstract fun deleteNoteByID(uid: String)
}