blob: 01f43b68901704e82dc15b56070a31957aade43d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
package it.niedermann.nextcloud.deck.persistence.sync.adapters.db.dao;
import android.arch.lifecycle.LiveData;
import android.arch.persistence.room.Dao;
import android.arch.persistence.room.Query;
import java.util.List;
import it.niedermann.nextcloud.deck.model.Label;
@Dao
public interface LabelDao extends GenericDao<Label> {
// @Query("SELECT * FROM label WHERE stackId = :localStackId")
// LiveData<List<Label>> getLabelsForStack(final long localStackId);
@Query("SELECT * FROM label WHERE accountId = :accountId and id = :remoteId")
LiveData<Label> getLabelByRemoteId(final long accountId, final long remoteId);
@Query("SELECT * FROM label WHERE accountId = :accountId and id = :remoteId")
Label getLabelByRemoteIdDirectly(final long accountId, final long remoteId);
@Query("SELECT * FROM label WHERE localId IN (:labelIDs)")
List<Label> getLabelsByIdDirectly(List<Long> labelIDs);
@Query("SELECT * FROM label WHERE accountId = :accountId and title = :searchTerm")
LiveData<List<Label>> searchLabelByTitle(final long accountId, String searchTerm);
}
|