Back to project page CATaZine-Live.
The source code is released under:
GNU General Public License
If you think the Android project CATaZine-Live listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
package com.melegy.catazine.provider; /* w w w.j ava2s . c o m*/ import com.melegy.catazine.Constants; import com.melegy.catazine.utils.PrefUtils; import android.content.ContentValues; import android.net.Uri; import android.provider.BaseColumns; import android.text.TextUtils; public class FeedData { public static final String CONTENT = "content://"; public static final String AUTHORITY = "com.melegy.catazine.provider.FeedData"; public static final String CONTENT_AUTHORITY = CONTENT + AUTHORITY; static final String TYPE_PRIMARY_KEY = "INTEGER PRIMARY KEY AUTOINCREMENT"; static final String TYPE_EXTERNAL_ID = "INTEGER(7)"; static final String TYPE_TEXT = "TEXT"; static final String TYPE_TEXT_UNIQUE = "TEXT UNIQUE"; static final String TYPE_DATE_TIME = "DATETIME"; static final String TYPE_INT = "INT"; static final String TYPE_BOOLEAN = "INTEGER(1)"; public static final String FEEDS_TABLE_WITH_GROUP_PRIORITY = FeedColumns.TABLE_NAME + " LEFT JOIN (SELECT " + FeedColumns._ID + " AS joined_feed_id, " + FeedColumns.PRIORITY + " AS group_priority FROM " + FeedColumns.TABLE_NAME + ") AS f ON (" + FeedColumns.TABLE_NAME + '.' + FeedColumns.GROUP_ID + " = f.joined_feed_id)"; public static final String ENTRIES_TABLE_WITH_FEED_INFO = EntryColumns.TABLE_NAME + " JOIN (SELECT " + FeedColumns._ID + " AS joined_feed_id, " + FeedColumns.NAME + ", " + FeedColumns.URL + ", " + FeedColumns.ICON + ", " + FeedColumns.GROUP_ID + " FROM " + FeedColumns.TABLE_NAME + ") AS f ON (" + EntryColumns.TABLE_NAME + '.' + EntryColumns.FEED_ID + " = f.joined_feed_id)"; public static class FeedColumns implements BaseColumns { public static final String TABLE_NAME = "feeds"; public static final String URL = "url"; public static final String NAME = "name"; public static final String IS_GROUP = "isgroup"; public static final String GROUP_ID = "groupid"; public static final String LAST_UPDATE = "lastupdate"; public static final String REAL_LAST_UPDATE = "reallastupdate"; public static final String RETRIEVE_FULLTEXT = "retrievefulltext"; public static final String ICON = "icon"; public static final String ERROR = "error"; public static final String PRIORITY = "priority"; public static final String FETCH_MODE = "fetchmode"; public static final String[][] COLUMNS = new String[][]{{_ID, TYPE_PRIMARY_KEY}, {URL, TYPE_TEXT_UNIQUE}, {NAME, TYPE_TEXT}, {IS_GROUP, TYPE_BOOLEAN}, {GROUP_ID, TYPE_EXTERNAL_ID}, {LAST_UPDATE, TYPE_DATE_TIME}, {REAL_LAST_UPDATE, TYPE_DATE_TIME}, {RETRIEVE_FULLTEXT, TYPE_BOOLEAN}, {ICON, "BLOB"}, {ERROR, TYPE_TEXT}, {PRIORITY, TYPE_INT}, {FETCH_MODE, TYPE_INT}}; public static final Uri CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/feeds"); public static final Uri GROUPED_FEEDS_CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/grouped_feeds"); public static Uri CONTENT_URI(String feedId) { return Uri.parse(CONTENT_AUTHORITY + "/feeds/" + feedId); } public static Uri CONTENT_URI(long feedId) { return Uri.parse(CONTENT_AUTHORITY + "/feeds/" + feedId); } public static final Uri GROUPS_CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/groups"); public static Uri GROUPS_CONTENT_URI(String groupId) { return Uri.parse(CONTENT_AUTHORITY + "/groups/" + groupId); } public static Uri GROUPS_CONTENT_URI(long groupId) { return Uri.parse(CONTENT_AUTHORITY + "/groups/" + groupId); } public static Uri FEEDS_FOR_GROUPS_CONTENT_URI(String groupId) { return Uri.parse(CONTENT_AUTHORITY + "/groups/" + groupId + "/feeds"); } public static Uri FEEDS_FOR_GROUPS_CONTENT_URI(long groupId) { return Uri.parse(CONTENT_AUTHORITY + "/groups/" + groupId + "/feeds"); } public static final String[] PROJECTION_ID = new String[]{FeedColumns._ID}; public static final String[] PROJECTION_GROUP_ID = new String[]{FeedColumns.GROUP_ID}; public static final String[] PROJECTION_PRIORITY = new String[]{FeedColumns.PRIORITY}; } public static class FilterColumns implements BaseColumns { public static final String TABLE_NAME = "filters"; public static final String FEED_ID = "feedid"; public static final String FILTER_TEXT = "filtertext"; public static final String IS_REGEX = "isregex"; public static final String IS_APPLIED_TO_TITLE = "isappliedtotitle"; public static final String IS_ACCEPT_RULE = "isacceptrule"; public static final String[][] COLUMNS = new String[][]{{_ID, TYPE_PRIMARY_KEY}, {FEED_ID, TYPE_EXTERNAL_ID}, {FILTER_TEXT, TYPE_TEXT}, {IS_REGEX, TYPE_BOOLEAN}, {IS_APPLIED_TO_TITLE, TYPE_BOOLEAN}, {IS_ACCEPT_RULE, TYPE_BOOLEAN}}; public static final Uri CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/filters"); public static Uri FILTERS_FOR_FEED_CONTENT_URI(String feedId) { return Uri.parse(CONTENT_AUTHORITY + "/feeds/" + feedId + "/filters"); } public static Uri FILTERS_FOR_FEED_CONTENT_URI(long feedId) { return Uri.parse(CONTENT_AUTHORITY + "/feeds/" + feedId + "/filters"); } } public static class EntryColumns implements BaseColumns { public static final String TABLE_NAME = "entries"; public static final String FEED_ID = "feedid"; public static final String TITLE = "title"; public static final String ABSTRACT = "abstract"; public static final String MOBILIZED_HTML = "mobilized"; public static final String DATE = "date"; public static final String IS_READ = "isread"; public static final String LINK = "link"; public static final String IS_FAVORITE = "favorite"; public static final String ENCLOSURE = "enclosure"; public static final String GUID = "guid"; public static final String AUTHOR = "author"; public static final String[][] COLUMNS = new String[][]{{_ID, TYPE_PRIMARY_KEY}, {FEED_ID, TYPE_EXTERNAL_ID}, {TITLE, TYPE_TEXT}, {ABSTRACT, TYPE_TEXT}, {MOBILIZED_HTML, TYPE_TEXT}, {DATE, TYPE_DATE_TIME}, {IS_READ, TYPE_BOOLEAN}, {LINK, TYPE_TEXT}, {IS_FAVORITE, TYPE_BOOLEAN}, {ENCLOSURE, TYPE_TEXT}, {GUID, TYPE_TEXT}, {AUTHOR, TYPE_TEXT}}; public static final Uri CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/entries"); public static final Uri ALL_ENTRIES_CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/all_entries"); public static final Uri FAVORITES_CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/favorites"); public static Uri ENTRIES_FOR_FEED_CONTENT_URI(String feedId) { return Uri.parse(CONTENT_AUTHORITY + "/feeds/" + feedId + "/entries"); } public static Uri ENTRIES_FOR_FEED_CONTENT_URI(long feedId) { return Uri.parse(CONTENT_AUTHORITY + "/feeds/" + feedId + "/entries"); } public static Uri ENTRIES_FOR_GROUP_CONTENT_URI(String groupId) { return Uri.parse(CONTENT_AUTHORITY + "/groups/" + groupId + "/entries"); } public static Uri ENTRIES_FOR_GROUP_CONTENT_URI(long groupId) { return Uri.parse(CONTENT_AUTHORITY + "/groups/" + groupId + "/entries"); } public static Uri ALL_ENTRIES_CONTENT_URI(String entryId) { return Uri.parse(CONTENT_AUTHORITY + "/all_entries/" + entryId); } public static Uri CONTENT_URI(String entryId) { return Uri.parse(CONTENT_AUTHORITY + "/entries/" + entryId); } public static Uri CONTENT_URI(long entryId) { return Uri.parse(CONTENT_AUTHORITY + "/entries/" + entryId); } public static Uri PARENT_URI(String path) { return Uri.parse(CONTENT_AUTHORITY + path.substring(0, path.lastIndexOf('/'))); } public static Uri SEARCH_URI(String search) { return Uri.parse(CONTENT_AUTHORITY + "/entries/search/" + (TextUtils.isEmpty(search) ? " " : Uri.encode(search))); // The space is mandatory here with empty search } public static final String[] PROJECTION_ID = new String[]{EntryColumns._ID}; public static final String WHERE_READ = EntryColumns.IS_READ + Constants.DB_IS_TRUE; public static final String WHERE_UNREAD = "(" + EntryColumns.IS_READ + Constants.DB_IS_NULL + Constants.DB_OR + EntryColumns.IS_READ + Constants.DB_IS_FALSE + ')'; public static final String WHERE_NOT_FAVORITE = "(" + EntryColumns.IS_FAVORITE + Constants.DB_IS_NULL + Constants.DB_OR + EntryColumns.IS_FAVORITE + Constants.DB_IS_FALSE + ')'; } public static class TaskColumns implements BaseColumns { public static final String TABLE_NAME = "tasks"; public static final String ENTRY_ID = "entryid"; public static final String IMG_URL_TO_DL = "imgurl_to_dl"; public static final String NUMBER_ATTEMPT = "number_attempt"; public static final String[][] COLUMNS = new String[][]{{_ID, TYPE_PRIMARY_KEY}, {ENTRY_ID, TYPE_EXTERNAL_ID}, {IMG_URL_TO_DL, TYPE_TEXT}, {NUMBER_ATTEMPT, TYPE_INT}, {"UNIQUE", "(" + ENTRY_ID + ", " + IMG_URL_TO_DL + ") ON CONFLICT IGNORE"}}; public static final Uri CONTENT_URI = Uri.parse(CONTENT_AUTHORITY + "/tasks"); public static Uri CONTENT_URI(String taskId) { return Uri.parse(CONTENT_AUTHORITY + "/tasks/" + taskId); } public static Uri CONTENT_URI(long taskId) { return Uri.parse(CONTENT_AUTHORITY + "/tasks/" + taskId); } public static final String[] PROJECTION_ID = new String[]{EntryColumns._ID}; } public static ContentValues getReadContentValues() { ContentValues values = new ContentValues(); values.put(EntryColumns.IS_READ, true); return values; } public static ContentValues getUnreadContentValues() { ContentValues values = new ContentValues(); values.putNull(EntryColumns.IS_READ); return values; } public static boolean shouldShowReadEntries(Uri uri) { boolean alwaysShowRead = EntryColumns.FAVORITES_CONTENT_URI.equals(uri) || (FeedDataContentProvider.URI_MATCHER.match(uri) == FeedDataContentProvider.URI_SEARCH); return alwaysShowRead || PrefUtils.getBoolean(PrefUtils.SHOW_READ, true); } }