diff options
| author | Stefan Niedermann <info@niedermann.it> | 2021-11-25 16:02:21 +0300 |
|---|---|---|
| committer | Niedermann IT-Dienstleistungen <stefan-niedermann@users.noreply.github.com> | 2021-11-29 17:28:10 +0300 |
| commit | be54e018c49a3899acc2baf182ac6dea4382dbf5 (patch) | |
| tree | f57a2a51a110481fef1d9ac3023d8cdd2dd0af94 /app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java | |
| parent | e23e826945923ab893dce1330c5e2f71cbb6e062 (diff) | |
#1165 Refactor PushNotifications
Signed-off-by: Stefan Niedermann <info@niedermann.it>
Diffstat (limited to 'app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java')
| -rw-r--r-- | app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java index 89846ac39..4fa7bf8f7 100644 --- a/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java +++ b/app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java @@ -75,12 +75,12 @@ public interface BoardDao extends GenericDao<Board> { "WHERE c.id = :cardRemoteId and c.accountId = :accountId") LiveData<Long> getLocalBoardIdByCardRemoteIdAndAccountId(long cardRemoteId, long accountId); - @Query("SELECT b.* " + + @Query("SELECT b.localId " + "FROM card c " + "inner join stack s on s.localId = c.stackId " + "inner join board b on s.boardId = b.localId " + "WHERE c.id = :cardRemoteId and c.accountId = :accountId") - Board getBoardByAccountAndCardRemoteIdDirectly(long accountId, long cardRemoteId); + Long getBoardLocalIdByAccountAndCardRemoteIdDirectly(long accountId, long cardRemoteId); @Query("SELECT count(*) FROM board WHERE accountId = :accountId and archived = 1 and (deletedAt = 0 or deletedAt is null) and status <> 3") LiveData<Integer> countArchivedBoards(long accountId); |