| Línea 11... |
Línea 11... |
| 11 |
import com.cesams.twogetskills.room.ResultTotalInt;
|
11 |
import com.cesams.twogetskills.room.ResultTotalInt;
|
| Línea 12... |
Línea 12... |
| 12 |
|
12 |
|
| 13 |
@Dao
|
13 |
@Dao
|
| Línea -... |
Línea 14... |
| - |
|
14 |
public interface ProgressDao {
|
| - |
|
15 |
|
| Línea -... |
Línea 16... |
| - |
|
16 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where topic_uuid = :topicUuid AND type = 's' AND completed = 1 AND user_uuid = :userUuid")
|
| - |
|
17 |
ResultCount getCountSlidesCompletedByTopicUuidAndUserUuid(String topicUuid, String userUuid);
|
| Línea 14... |
Línea 18... |
| 14 |
public interface ProgressDao {
|
18 |
|
| 15 |
|
19 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where topic_uuid = :topicUuid AND type = 'c' AND completed = 1 AND user_uuid = :userUuid")
|
| Línea 16... |
Línea 20... |
| 16 |
|
20 |
ResultCount getCountCapsulesCompletedByTopicUuidAndUserUuid(String topicUuid, String userUuid);
|
| 17 |
|
21 |
|
| Línea 18... |
Línea 22... |
| 18 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where topic_uuid = :topicUuid AND type = 's' AND completed = 1")
|
22 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where topic_uuid = :topicUuid AND type = 'c' AND completed = 1 AND user_uuid = :userUuid AND returning_after_completed = 0")
|
| 19 |
ResultCount getCountSlidesCompletedByTopicUuid(String topicUuid);
|
23 |
ResultCount getCountCapsulesCompletedWithoutReturningByTopicUuidAndUserUuid(String topicUuid, String userUuid);
|
| Línea 20... |
Línea -... |
| 20 |
|
- |
|
| 21 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where topic_uuid = :topicUuid AND type = 'c' AND completed = 1")
|
- |
|
| 22 |
ResultCount getCountCapsulesCompletedByTopicUuid(String topicUuid);
|
- |
|
| 23 |
|
- |
|
| 24 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where topic_uuid = :topicUuid AND type = 'c' AND completed = 1 AND returning_after_completed = 0")
|
- |
|
| 25 |
ResultCount getCountCapsulesCompletedWithoutReturningByTopicUuid(String topicUuid);
|
- |
|
| 26 |
|
- |
|
| 27 |
@Query("SELECT SUM(returning_after_completed) AS total FROM tb_progress where topic_uuid = :topicUuid AND type = 'c' AND completed = 1 AND returning_after_completed > 0")
|
- |
|
| 28 |
ResultTotalInt getCountCapsulesCompletedWithReturningByTopicUuid(String topicUuid);
|
- |
|
| Línea 29... |
Línea 24... |
| 29 |
|
24 |
|
| 30 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where capsule_uuid = :capsuleUuid AND type = 's' AND completed = 1")
|
25 |
@Query("SELECT SUM(returning_after_completed) AS total FROM tb_progress where topic_uuid = :topicUuid AND user_uuid = :userUuid AND type = 'c' AND completed = 1 AND returning_after_completed > 0")
|
| Línea 31... |
Línea -... |
| 31 |
ResultCount getCountSlidesCompletedByCapsuleUuid(String capsuleUuid);
|
- |
|
| 32 |
|
- |
|
| 33 |
|
- |
|
| 34 |
@Query("SELECT * FROM tb_progress WHERE topic_uuid = :topicUuid AND type = 't' LIMIT 1")
|
26 |
ResultTotalInt getCountCapsulesCompletedWithReturningByTopicUuidAndUserUuid(String topicUuid, String userUuid);
|
| 35 |
Progress selectByTopicUuid(String topicUuid);
|
27 |
|
| Línea 36... |
Línea -... |
| 36 |
|
- |
|
| 37 |
@Query("SELECT * FROM tb_progress WHERE topic_uuid = :topicUuid AND user_uuid = :userUuid AND type = 't' LIMIT 1")
|
- |
|
| 38 |
Progress selectByTopicUuidAndUserUuid(String topicUuid, String userUuid);
|
- |
|
| 39 |
|
28 |
@Query("SELECT COUNT(*) AS count FROM tb_progress where capsule_uuid = :capsuleUuid AND user_uuid = :userUuid AND type = 's' AND completed = 1")
|
| 40 |
@Query("SELECT * FROM tb_progress WHERE capsule_uuid = :capsuleUuid AND type = 'c' LIMIT 1")
|
29 |
ResultCount getCountSlidesCompletedByCapsuleUuidAndUserUuid(String capsuleUuid, String userUuid);
|
| 41 |
Progress selectByCapsuleUuid(String capsuleUuid);
|
30 |
|
| 42 |
|
31 |
|