diff options
| author | desperateCoder <echotodevnull@gmail.com> | 2020-04-13 20:11:36 +0300 |
|---|---|---|
| committer | desperateCoder <echotodevnull@gmail.com> | 2020-04-13 20:11:36 +0300 |
| commit | 67b4f8f406c13ee27a86befc26978353963579b4 (patch) | |
| tree | fa534451bc08b2cce253bd7e07b916d4c6e6261e /app/src/main/java/it/niedermann/nextcloud/deck/persistence/sync/adapters/db/dao/BoardDao.java | |
| parent | ff32b105b7163504dcc97107f979936dba0ae5f0 (diff) | |
dont fire livedata insanely
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 | 8 |
1 files changed, 8 insertions, 0 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 9e23ec524..9038151db 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 @@ -51,4 +51,12 @@ public interface BoardDao extends GenericDao<Board> { @Query("SELECT * FROM board WHERE accountId = :accountId 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 " + + "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); }
\ No newline at end of file |