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
    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();

}