Proyectos de Subversion Android Microlearning

package com.cesams.twogetskills.dao;

import androidx.room.Dao;

import androidx.room.Insert;

import androidx.room.Query;

import androidx.room.Update;

import com.cesams.twogetskills.entity.Question;

import java.util.List;

@Dao

public interface QuestionDao {

    @Query("SELECT * FROM tb_questions WHERE quiz_uuid = :quizUuid ORDER BY position")

    List<Question> selectAllByQuizUuid(String quizUuid);

    @Query("SELECT * FROM tb_questions WHERE uuid = :uuid LIMIT 1")

    Question selectByUuid(String uuid);

    @Insert

    void insert(Question question);

    @Update

    void update(Question question);

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

    void removeByUuid(String uuid);

    @Query("DELETE FROM tb_questions")

    void removeAll();

}