diff options
| author | desperateCoder <echotodevnull@gmail.com> | 2021-11-28 21:27:50 +0300 |
|---|---|---|
| committer | Niedermann IT-Dienstleistungen <stefan-niedermann@users.noreply.github.com> | 2021-11-29 17:28:10 +0300 |
| commit | 9b04db61ed8a9273e3f1f01d5d76b19717bcff15 (patch) | |
| tree | 633a19bbaff74a8040a9cce0eff2bef7ea9e9fb3 /app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java | |
| parent | 67c3e11dfc719755d4af18d54ad9b3be3517285d (diff) | |
#1165 optimized query
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 | 6 |
1 files changed, 2 insertions, 4 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 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<Board> { @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<List<Board>> 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<Long> 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); |