diff options
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 | 5 |
1 files changed, 3 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 fcb662b1d..89ada6e18 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,7 +51,6 @@ public interface BoardDao extends GenericDao<Board> { @Query("SELECT * FROM board WHERE accountId = :accountId and localId = :localId") LiveData<FullBoard> getFullBoardById(final long accountId, final long localId); - @Query("SELECT b.* FROM board b JOIN stack s ON s.boardId = b.localId JOIN card c ON s.localId = c.stackId where c.localId = :localCardId") Board getBoardByLocalCardIdDirectly(long localCardId); @@ -69,7 +68,6 @@ 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 " + "FROM card c " + "inner join stack s on s.localId = c.stackId " + @@ -82,4 +80,7 @@ public interface BoardDao extends GenericDao<Board> { @Query("SELECT * FROM board WHERE accountId = :accountId and title = :title") Board getBoardForAccountByNameDirectly(long accountId, String title); + + @Query("SELECT b.color FROM board b where b.localId = :localBoardId and b.accountId = :accountId") + Integer getBoardColorByLocalIdDirectly(long accountId, long localBoardId); }
\ No newline at end of file |