| 1 |
efrain |
1 |
package com.cesams.twogetskills.dao;
|
|
|
2 |
|
|
|
3 |
import androidx.room.Dao;
|
|
|
4 |
import androidx.room.Delete;
|
|
|
5 |
import androidx.room.Insert;
|
|
|
6 |
import androidx.room.Query;
|
|
|
7 |
import androidx.room.Update;
|
|
|
8 |
|
|
|
9 |
import com.cesams.twogetskills.entity.Answer;
|
|
|
10 |
|
|
|
11 |
import java.util.List;
|
|
|
12 |
|
|
|
13 |
@Dao
|
|
|
14 |
public interface AnswerDao {
|
|
|
15 |
|
|
|
16 |
@Query("SELECT * FROM tb_answers WHERE question_uuid = :questionUuid")
|
|
|
17 |
List<Answer> selectAllByQuestionUuid(String questionUuid);
|
|
|
18 |
|
|
|
19 |
@Query("SELECT * FROM tb_answers WHERE uuid = :uuid")
|
|
|
20 |
Answer selectByUuid(String uuid);
|
|
|
21 |
|
|
|
22 |
@Insert
|
|
|
23 |
void insert(Answer answer);
|
|
|
24 |
|
|
|
25 |
@Update
|
|
|
26 |
void update(Answer answer);
|
|
|
27 |
|
|
|
28 |
@Query("DELETE FROM tb_answers WHERE uuid = :uuid")
|
|
|
29 |
void removeByUuid(String uuid);
|
|
|
30 |
|
|
|
31 |
@Query("DELETE FROM tb_answers")
|
|
|
32 |
void removeAll();
|
|
|
33 |
|
|
|
34 |
|
|
|
35 |
}
|