1 files changed, 7 insertions, 1 deletions
diff --git a/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java b/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
index 2b61a666..83bdf6fe 100644
--- a/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
+++ b/app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java
@@ -16,6 +16,12 @@ public interface SubscribedUserDao {
     @Query("DELETE FROM subscribed_users")
     void deleteAllSubscribedUsers();
 
-    @Query("SELECT * from subscribed_users ORDER BY name COLLATE NOCASE ASC")
+    @Query("SELECT * FROM subscribed_users ORDER BY name COLLATE NOCASE ASC")
     LiveData<List<SubscribedUserData>> getAllSubscribedUsers();
+
+    @Query("SELECT * FROM subscribed_users WHERE name = :userName LIMIT 1")
+    SubscribedUserData getSubscribedUser(String userName);
+
+    @Query("DELETE FROM subscribed_users WHERE name = :userName")
+    void deleteSubscribedUser(String userName);
 }