Proyectos de Subversion Android Microlearning - Inconcert

Rev

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

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