aboutsummaryrefslogblamecommitdiff
path: root/app/src/main/java/SubscribedSubredditDatabase/SubscribedSubredditDao.java
blob: 6ddaf83597b33d4d89dd44ab7e37947239897ad4 (plain) (tree)
1
2
3
4
5
6
7
                                    
 




                                        










                                                                 

                                                                                                                
 

                                                                                                                                
 

                                                                                                       
 
package SubscribedSubredditDatabase;

import androidx.lifecycle.LiveData;
import androidx.room.Dao;
import androidx.room.Insert;
import androidx.room.OnConflictStrategy;
import androidx.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 WHERE username = :accountName ORDER BY name COLLATE NOCASE ASC")
    LiveData<List<SubscribedSubredditData>> getAllSubscribedSubreddits(String accountName);

    @Query("SELECT * from subscribed_subreddits WHERE name = :subredditName AND username = :accountName COLLATE NOCASE LIMIT 1")
    SubscribedSubredditData getSubscribedSubreddit(String subredditName, String accountName);

    @Query("DELETE FROM subscribed_subreddits WHERE name = :subredditName AND username = :accountName")
    void deleteSubscribedSubreddit(String subredditName, String accountName);
}
td>Alex Ning18-77/+187 2019-11-12Show low-resolution images in compact layout. Send notifications of messages ...Alex Ning7-48/+83 2019-11-11Set post layout for subreddit and user posts individually.Alex Ning10-22/+30 2019-11-11Changing post layout in other activities is available. Show username in card ...Alex Ning11-17/+151 2019-11-11Changing post layout in ViewSubredditDetailActivity is available. Tweak the c...Alex Ning7-15/+55 2019-11-09Update README.mdDocile-Alligator1-2/+3 2019-11-08Compact post layout is available. Fixed WebView cannot be inflated on Android...Alex Ning16-213/+1454 2019-11-05Fixed IllegalStateException in SubredditSelectionActivity. Downgrade material...Alex Ning3-67/+71 2019-10-29Minor UI issue fixed.Alex Ning1-1/+1 2019-10-29Fixed UI issues in posts and comments. Version 1.4.0.Alex Ning14-322/+171 2019-10-29Placing vote buttons on the right for comments is now available.Alex Ning7-24/+210 2019-10-29Make Placing vote buttons on the right an option.Alex Ning42-196/+334