Proyectos de Subversion Android Microlearning

package com.cesams.twogetskills.dao;

import androidx.room.Dao;

import androidx.room.Delete;

import androidx.room.Insert;

import androidx.room.OnConflictStrategy;

import androidx.room.Query;

import androidx.room.Update;

import com.cesams.twogetskills.entity.Quiz;

import java.util.List;

@Dao

public interface QuizDao {

    @Query("SELECT * FROM tb_quizzes ORDER BY name")

    List<Quiz> selectAll();

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

    Quiz selectByUuid(String uuid);

    @Insert(onConflict = OnConflictStrategy.IGNORE)

    void insert(Quiz quiz);

    @Update

    void update(Quiz quiz);

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

    void removeByUuid(String uuid);

    @Query("DELETE FROM tb_quizzes")

    void removeAll();

}