diff options
author | Stefan Niedermann <info@niedermann.it> | 2020-10-06 11:32:59 +0300 |
---|---|---|
committer | Stefan Niedermann <info@niedermann.it> | 2020-10-06 11:32:59 +0300 |
commit | cfc7c79ac52361d458f2913b1f36ec412a27dec6 (patch) | |
tree | a636f18683c14540e26f217073d83519ba193582 /app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java | |
parent | a3aa4a8b668d2519cd6c6e295b955669f4089fbb (diff) |
#831 Migrate from SQLiteOpenHelper to Room
Fix some build issues
Diffstat (limited to 'app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java')
-rw-r--r-- | app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java b/app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java index 36665725..9bfdd69e 100644 --- a/app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java +++ b/app/src/main/java/it/niedermann/owncloud/notes/persistence/dao/NoteDao.java @@ -64,8 +64,11 @@ public interface NoteDao { @Query("SELECT id FROM NoteEntity WHERE accountId = :accountId AND remoteId = :remoteId AND status != \"LOCAL_DELETED\"") Long getLocalIdByRemoteId(long accountId, long remoteId); - @Query("SELECT favorite, COUNT(*) FROM NoteEntity WHERE status != \"LOCAL_DELETED\" AND accountId = :accountId GROUP BY favorite ORDER BY favorite") - Map<String, Integer> getFavoritesCount(long accountId); + @Query("SELECT COUNT(*) FROM NoteEntity WHERE status != 'LOCAL_DELETED' AND accountId = :accountId AND favorite = 1") + Integer getFavoritesCount(long accountId); + + @Query("SELECT COUNT(*) FROM NoteEntity WHERE status != 'LOCAL_DELETED' AND accountId = :accountId AND favorite = 0") + Integer getNonFavoritesCount(long accountId); /** * Returns a list of all Notes in the Database which were modified locally |