From e48bb565a5aa871be18cae4003cb781ef6e2e154 Mon Sep 17 00:00:00 2001 From: Alex Ning Date: Fri, 11 Jan 2019 11:33:32 +0800 Subject: View user details in ViewUserDetailActivity. Follow or unfollow user is not properly implemented right now. Change users and subscribed_users databases' schemes. Press Profile in navigation drawer to view my reddit info. Press the username in the post to view that account's info. --- app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java') 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> 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); } -- cgit v1.2.3