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.Slide;
import com.cesams.twogetskills.room.ResultCount;

import java.util.List;

import javax.xml.transform.Result;

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

}