Proyectos de Subversion Android Microlearning - Inconcert

package com.cesams.twogetskills.inconcert.dao;

import androidx.room.Dao;

import androidx.room.Insert;

import androidx.room.Query;

import androidx.room.Update;

import com.cesams.twogetskills.inconcert.entity.Answer;

import java.util.List;

@Dao

public interface AnswerDao {

    @Query("SELECT * FROM tb_answers WHERE question_uuid = :questionUuid")

    List<Answer> selectAllByQuestionUuid(String questionUuid);

    @Query("SELECT * FROM tb_answers WHERE uuid = :uuid")

    Answer selectByUuid(String uuid);

    @Insert

    void insert(Answer answer);

    @Update

    void update(Answer answer);

    @Query("DELETE FROM tb_answers WHERE uuid  = :uuid")

    void removeByUuid(String uuid);

    @Query("DELETE FROM tb_answers")

    void removeAll();

}