diff options
Diffstat (limited to '')
3 files changed, 89 insertions, 4 deletions
diff --git a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java index ea079722..e6163aa5 100644 --- a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java +++ b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterDao.java @@ -36,10 +36,10 @@ public interface CommentFilterDao { @Query("SELECT * FROM comment_filter") List<CommentFilter> getAllCommentFilters(); - /*@Query("SELECT * FROM comment_filter WHERE comment_filter.name IN " + + @Query("SELECT * FROM comment_filter WHERE comment_filter.name IN " + "(SELECT comment_filter_usage.name FROM comment_filter_usage WHERE (usage = :usage AND name_of_usage = :nameOfUsage) " + "OR (usage =:usage AND name_of_usage = '--'))") - List<CommentFilter> getValidCommentFilters(int usage, String nameOfUsage);*/ + List<CommentFilter> getValidCommentFilters(int usage, String nameOfUsage); @Transaction @Query("SELECT * FROM comment_filter ORDER BY name") diff --git a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsage.java b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsage.java index a250e7b0..368452ce 100644 --- a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsage.java +++ b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsage.java @@ -1,4 +1,62 @@ package ml.docilealligator.infinityforreddit.commentfilter; -public class CommentFilterUsage { +import android.os.Parcel; +import android.os.Parcelable; + +import androidx.annotation.NonNull; +import androidx.room.ColumnInfo; +import androidx.room.Entity; +import androidx.room.ForeignKey; + +@Entity(tableName = "comment_filter_usage", primaryKeys = {"name", "usage", "name_of_usage"}, + foreignKeys = @ForeignKey(entity = CommentFilter.class, parentColumns = "name", + childColumns = "name", onDelete = ForeignKey.CASCADE)) +public class CommentFilterUsage implements Parcelable { + public static final int SUBREDDIT_TYPE = 1; + public static final int USER_TYPE = 2; + + @NonNull + @ColumnInfo(name = "name") + public String name; + @ColumnInfo(name = "usage") + public int usage; + @NonNull + @ColumnInfo(name = "name_of_usage") + public String nameOfUsage; + + public CommentFilterUsage(@NonNull String name, int usage, @NonNull String nameOfUsage) { + this.name = name; + this.usage = usage; + this.nameOfUsage = nameOfUsage; + } + + protected CommentFilterUsage(Parcel in) { + name = in.readString(); + usage = in.readInt(); + nameOfUsage = in.readString(); + } + + public static final Creator<CommentFilterUsage> CREATOR = new Creator<CommentFilterUsage>() { + @Override + public CommentFilterUsage createFromParcel(Parcel in) { + return new CommentFilterUsage(in); + } + + @Override + public CommentFilterUsage[] newArray(int size) { + return new CommentFilterUsage[size]; + } + }; + + @Override + public int describeContents() { + return 0; + } + + @Override + public void writeToParcel(@NonNull Parcel dest, int flags) { + dest.writeString(name); + dest.writeInt(usage); + dest.writeString(nameOfUsage); + } } diff --git a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsageDao.java b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsageDao.java index ebd1e8dd..0ed0aec2 100644 --- a/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsageDao.java +++ b/app/src/main/java/ml/docilealligator/infinityforreddit/commentfilter/CommentFilterUsageDao.java @@ -1,4 +1,31 @@ package ml.docilealligator.infinityforreddit.commentfilter; -public class CommentFilterUsageDao { +import androidx.lifecycle.LiveData; +import androidx.room.Dao; +import androidx.room.Delete; +import androidx.room.Insert; +import androidx.room.OnConflictStrategy; +import androidx.room.Query; + +import java.util.List; + +@Dao +public interface CommentFilterUsageDao { + @Query("SELECT * FROM comment_filter_usage WHERE name = :name") + LiveData<List<CommentFilterUsage>> getAllCommentFilterUsageLiveData(String name); + + @Query("SELECT * FROM comment_filter_usage WHERE name = :name") + List<CommentFilterUsage> getAllCommentFilterUsage(String name); + + @Query("SELECT * FROM comment_filter_usage") + List<CommentFilterUsage> getAllCommentFilterUsageForBackup(); + + @Insert(onConflict = OnConflictStrategy.REPLACE) + void insert(CommentFilterUsage CommentFilterUsage); + + @Insert(onConflict = OnConflictStrategy.REPLACE) + void insertAll(List<CommentFilterUsage> CommentFilterUsageList); + + @Delete + void deleteCommentFilterUsage(CommentFilterUsage CommentFilterUsage); } |