1 files changed, 21 insertions, 0 deletions
diff --git a/app/src/main/java/SubscribedSubredditDatabase/SubscribedSubredditDao.java b/app/src/main/java/SubscribedSubredditDatabase/SubscribedSubredditDao.java
new file mode 100644
index 00000000..7837aa42
--- /dev/null
+++ b/app/src/main/java/SubscribedSubredditDatabase/SubscribedSubredditDao.java
@@ -0,0 +1,21 @@
+package SubscribedSubredditDatabase;
+
+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 SubscribedSubredditDao {
+    @Insert(onConflict = OnConflictStrategy.REPLACE)
+    void insert(SubscribedSubredditData subscribedSubredditData);
+
+    @Query("DELETE FROM subscribed_subreddits")
+    void deleteAllSubscribedSubreddits();
+
+    @Query("SELECT * from subscribed_subreddits ORDER BY name COLLATE NOCASE ASC")
+    LiveData<List<SubscribedSubredditData>> getAllSubscribedSubreddits();
+}