From 807ddf5a6e595d2368579008bb8132296be54ea2 Mon Sep 17 00:00:00 2001 From: Alex Ning Date: Thu, 27 Dec 2018 13:54:19 +0800 Subject: Move several classes to other packages. --- .../SubscribedUserDatabase/SubscribedUserDao.java | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 app/src/main/java/SubscribedUserDatabase/SubscribedUserDao.java (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 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> getAllSubscribedUsers(); +} -- cgit v1.2.3