aboutsummaryrefslogtreecommitdiff
path: root/app/src/main/java/SubscribedSubredditDatabase/SubscribedSubredditDao.java
blob: 6ddaf83597b33d4d89dd44ab7e37947239897ad4 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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);
}
ass='insertions'>+353 2023-10-06Version 6.3.1 (only for Patreon version).Docile-Alligator1-2/+2 2023-10-05Version 6.3.0Docile-Alligator1-2/+2 2023-10-04Set off screen page limit to ViewPager2.OFFSCREEN_PAGE_LIMIT_DEFAULT in some ...Docile-Alligator5-6/+5 2023-10-04Load more items in a single call.Docile-Alligator3-31/+33 2023-10-04Initialize LiveData data by using the constructor, not the postValue method.Docile-Alligator9-37/+21 2023-10-04Set filled card view background color in MaterialYouUtils.Docile-Alligator1-0/+3 2023-10-04Sync subscriptions once every 24 hours.Docile-Alligator2-1/+9 2023-10-01Version 6.3.0-beta2.Docile-Alligator1-2/+2 2023-10-01Fix changing playback speed not working in ViewImgurVideoFragment and ViewRed...Docile-Alligator3-22/+41 2023-10-01Fix video controller ui issues in ViewImgurVideoFragment, ViewRedditGalleryVi...Docile-Alligator3-16/+14 2023-10-01Fix video controller ui issues in ViewImgurVideoFragment, ViewRedditGalleryVi...Docile-Alligator3-22/+30 2023-09-25Version 6.3.0-beta1.Docile-Alligator1-2/+2 2023-09-25Version 6.3.0-beta1. Rename RedditAPIInfoBottomSheetFragment to ImportantInfo...Docile-Alligator3-9/+9 2023-09-23Changed video control UI.Docile-Alligator1-3/+3 2023-09-23Changed video control UI.Docile-Alligator5-48/+69 2023-09-22Start changing video control UI.Docile-Alligator16-108/+193