From 9b04db61ed8a9273e3f1f01d5d76b19717bcff15 Mon Sep 17 00:00:00 2001 From: desperateCoder Date: Sun, 28 Nov 2021 19:27:50 +0100 Subject: #1165 optimized query --- .../nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java') 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 4fa7bf8f7..066b512e9 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 @@ -68,17 +68,15 @@ public interface BoardDao extends GenericDao { @Query("SELECT * FROM board WHERE accountId = :accountId and archived = 0 and permissionEdit = 1 and (deletedAt = 0 or deletedAt is null) and status <> 3 order by title asc") LiveData> getBoardsWithEditPermissionsForAccount(long accountId); - @Query("SELECT b.localId " + + @Query("SELECT s.boardId " + "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") LiveData getLocalBoardIdByCardRemoteIdAndAccountId(long cardRemoteId, long accountId); - @Query("SELECT b.localId " + + @Query("SELECT s.boardId " + "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") Long getBoardLocalIdByAccountAndCardRemoteIdDirectly(long accountId, long cardRemoteId); -- cgit v1.2.3