Proyectos de Subversion Android Microlearning - Inconcert

public interface CapsuleDao {

    @Query("SELECT * FROM tb_capsules WHERE uuid IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c' AND progress <= 100 AND completed = 0 ORDER BY updated_on DESC LIMIT 1) LIMIT 1")

    Capsule selectLastInProgress(String useruUuid);

    @Query("SELECT * FROM tb_capsules WHERE uuid NOT IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c')  ORDER BY name")

    List<Capsule> selectAllPending(String useruUuid);

    @Query("SELECT * FROM tb_capsules WHERE name LIKE :search AND uuid NOT IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c')  ORDER BY name")

    List<Capsule> selectAllPendingWithSearch(String useruUuid, String search);

    @Query("SELECT * FROM tb_capsules WHERE uuid IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c' AND progress <= 100 AND completed = 0 ORDER BY updated_on DESC)  ORDER BY name")

    List<Capsule> selectAllInProgress(String useruUuid);

    @Query("SELECT * FROM tb_capsules WHERE name LIKE :search AND uuid  IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c' AND progress <= 100 AND completed = 0 ORDER BY updated_on DESC)  ORDER BY name")

    List<Capsule> selectAllInProgressWithSearch(String useruUuid, String search);

    @Query("SELECT * FROM tb_capsules WHERE uuid  IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c' AND progress >= 100 AND completed = 1 ORDER BY updated_on DESC)  ORDER BY name")

    List<Capsule> selectAllCompleted(String useruUuid);

    @Query("SELECT * FROM tb_capsules WHERE name LIKE :search AND uuid IN (select capsule_uuid from tb_progress WHERE user_uuid = :useruUuid AND type = 'c' AND progress >= 100 AND completed = 1 ORDER BY updated_on DESC)  ORDER BY name")