1 files changed, 21 insertions, 0 deletions
diff --git a/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java b/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
new file mode 100644
index 00000000..2b61a666
--- /dev/null
+++ b/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
@@ -0,0 +1,21 @@
+package SubscribedUserDatabase;
+
+import android.arch.lifecycle.LiveData;
+import android.arch.persistence.room.Dao;
+import android.arch.persistence.room.Insert;
+import android.arch.persistence.room.OnConflictStrategy;
+import android.arch.persistence.room.Query;
+
+import java.util.List;
+
+@Dao
+public interface SubscribedUserDao {
+    @Insert(onConflict = OnConflictStrategy.REPLACE)
+    void insert(SubscribedUserData subscribedUserData);
+
+    @Query("DELETE FROM subscribed_users")
+    void deleteAllSubscribedUsers();
+
+    @Query("SELECT * from subscribed_users ORDER BY name COLLATE NOCASE ASC")
+    LiveData<List<SubscribedUserData>> getAllSubscribedUsers();
+}