Proyectos de Subversion Android Microlearning - Inconcert

package com.cesams.twogetskills.inconcert.dao;

import androidx.room.Dao;

import androidx.room.Insert;

import androidx.room.OnConflictStrategy;

import androidx.room.Query;

import androidx.room.Update;

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

import com.cesams.twogetskills.inconcert.room.ResultCount;

import java.util.List;

@Dao

public interface SlideDao {

    @Query("SELECT COUNT(*) AS count FROM tb_slides WHERE capsule_uuid = :capsuleUuid")

    ResultCount getCountByCapsuleUuid(String capsuleUuid);

    @Query("SELECT COUNT(*) AS count FROM tb_slides WHERE topic_uuid = :topicUuid")

    ResultCount getCountByTopicUuid(String topicUuid);

    @Query("SELECT * FROM tb_slides WHERE capsule_uuid = :capsuleUuid ORDER BY position, name")

    List<Slide> selectAllByCapsuleUuid(String capsuleUuid);

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

    Slide selectByUuid(String uuid);

    @Insert(onConflict = OnConflictStrategy.REPLACE)

    void insert(Slide slide);

    @Update

    void update(Slide slide);

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

    void removeByUuid(String uuid);

    @Query("DELETE FROM tb_slides")

    void removeAll();

}