app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/ActivityDao.java


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

package it.niedermann.nextcloud.deck.persistence.sync.adapters.db.dao;

import androidx.lifecycle.LiveData;
import androidx.room.Dao;
import androidx.room.Query;

import java.util.List;

import it.niedermann.nextcloud.deck.model.ocs.Activity;

@Dao
public interface ActivityDao extends GenericDao<Activity> {

    @Query("SELECT * FROM activity WHERE cardId = :localCardId order by lastModified desc")
    LiveData<List<Activity>> getActivitiesForCard(final long localCardId);

    @Query("SELECT * FROM activity WHERE accountId = :accountId and id = :remoteActivityId")
    Activity getActivityByRemoteIdDirectly(long accountId, long remoteActivityId);
}