Proyectos de Subversion Android Microlearning - Nuevo Interface

Rev

Rev 24 | Mostrar el archivo completo | | | Autoría | Ultima modificación | Ver Log |

Rev 24 Rev 71
Línea 44... Línea 44...
44 
    Progress  selectByTopicUuidAndUserUuid(String topicUuid, String userUuid);
 44 
    Progress  selectByTopicUuidAndUserUuid(String topicUuid, String userUuid);
Línea 45... Línea 45...
45 
 
 45 
 
46 
    @Query("SELECT * FROM tb_progress WHERE capsule_uuid = :capsuleUuid AND type = 'c' LIMIT 1")
 46 
    @Query("SELECT * FROM tb_progress WHERE capsule_uuid = :capsuleUuid AND type = 'c' LIMIT 1")
Línea -... Línea 47...
- 
 
 47 
    Progress selectByCapsuleUuid(String capsuleUuid);
- 
 
 48 
 
- 
 
 49 
    @Query("SELECT * FROM tb_progress WHERE user_uuid = :userUuid AND type = 'c' AND completed = 0 AND progress <= 100 ORDER BY updated_on DESC LIMIT 1")
47 
    Progress selectByCapsuleUuid(String capsuleUuid);
 50 
    Progress selectLastCapsule(String userUuid);
48 
 
 51 
 
- 
 
 52 
    @Query("SELECT * FROM tb_progress WHERE type = 'c' AND completed = 0 AND progress <= 100 ORDER BY updated_on ")
- 
 
 53 
    List<Progress> selectAllCapsulesInProgress();
- 
 
 54 
 
Línea 49... Línea 55...
49 
    @Query("SELECT * FROM tb_progress WHERE type = 'c' ORDER BY updated_on DESC")
 55 
    @Query("SELECT * FROM tb_progress WHERE type = 'c' AND completed = 1 AND progress >= 100 ORDER BY updated_on ")
50 
    List<Progress> selectAllCapsulesProgress();
 56 
    List<Progress> selectAllCapsulesCompleted();
Línea 51... Línea 57...
51 
 
 57 
 
52 
    @Query("SELECT * FROM tb_progress WHERE capsule_uuid = :capsuleUuid AND user_uuid = :userUuid AND type = 'c' LIMIT 1")
 58 
    @Query("SELECT * FROM tb_progress WHERE capsule_uuid = :capsuleUuid AND user_uuid = :userUuid AND type = 'c' LIMIT 1")
Línea 53... Línea 59...
53 
    Progress selectByCapsuleUuidAndUserUuid(String capsuleUuid, String userUuid);
 59 
    Progress selectByCapsuleUuidAndUserUuid(String capsuleUuid, String userUuid);
54 
 
 60 
 
- 
 
 61 
    @Query("SELECT * FROM tb_progress WHERE slide_uuid = :slideUuid AND type = 's' LIMIT 1")
55 
    @Query("SELECT * FROM tb_progress WHERE slide_uuid = :slideUuid AND type = 's' LIMIT 1")
 62 
    Progress selectBySlideUuid(String slideUuid);
56 
    Progress selectBySlideUuid(String slideUuid);
 63 
 
Línea 57... Línea 64...
57 
 
 64 
    @Query("SELECT * FROM tb_progress WHERE slide_uuid = :slideUuid AND user_uuid = :userUuid AND type = 's' LIMIT 1")
58 
    @Query("SELECT * FROM tb_progress WHERE slide_uuid = :slideUuid AND user_uuid = :userUuid AND type = 's' LIMIT 1")
 65 
    Progress selectBySlideUuidAndUserUuid(String slideUuid, String userUuid);