Android Open Source - RssReader Feed Data

From Project

Back to project page RssReader.
License

The source code is released under:
GNU General Public License
If you think the Android project RssReader listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

/**
 * RssReader/*from  w w  w  .  j ava  2 s.c o  m*/
 *
 * Copyright (c) 2013-2014 teejoe
 *
 *     This program is free software: you can redistribute it and/or modify
 *     it under the terms of the GNU General Public License as published by
 *     the Free Software Foundation, either version 3 of the License, or
 *     (at your option) any later version.
 *
 *     This program is distributed in the hope that it will be useful,
 *     but WITHOUT ANY WARRANTY; without even the implied warranty of
 *     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *     GNU General Public License for more details.
 *
 *     You should have received a copy of the GNU General Public License
 *     along with this program.  If not, see <http://www.gnu.org/licenses/>.
 *
 *
 * Some parts of this software are based on "Sparse rss" under the MIT license (see
 * below). Please refers to the original project to identify which parts are under the
 * MIT license.
 *
 * Copyright (c) 2010-2012 Stefan Handschuh
 *
 *     Permission is hereby granted, free of charge, to any person obtaining a copy
 *     of this software and associated documentation files (the "Software"), to deal
 *     in the Software without restriction, including without limitation the rights
 *     to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 *     copies of the Software, and to permit persons to whom the Software is
 *     furnished to do so, subject to the following conditions:
 *
 *     The above copyright notice and this permission notice shall be included in
 *     all copies or substantial portions of the Software.
 *
 *     THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 *     IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 *     FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 *     AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 *     LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *     OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
 *     THE SOFTWARE.
 */

package org.m2x.rssreader.provider;

import org.m2x.rssreader.Constants;

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 = "org.m2x.rssreader.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 final String ALL_UNREAD_NUMBER = new StringBuilder(
        "(SELECT COUNT(*) FROM ").append(FeedData.EntryColumns.TABLE_NAME).append(" WHERE ")
        .append(FeedData.EntryColumns.IS_READ).append(" IS NULL)").toString();
    
    public static final String FAVORITES_NUMBER = new StringBuilder(
        "(SELECT COUNT(*) FROM ").append(FeedData.EntryColumns.TABLE_NAME).append(" WHERE ")
        .append(FeedData.EntryColumns.IS_FAVORITE).append(Constants.DB_IS_TRUE).append(')')
        .toString();

  public static final String FEED_UNREAD_NUMBER = new StringBuilder("(SELECT COUNT(*) FROM ")
      .append(EntryColumns.TABLE_NAME).append(" WHERE ").append(EntryColumns.IS_READ)
        .append(" IS NULL AND ").append(EntryColumns.FEED_ID).append('=')
        .append(FeedColumns.TABLE_NAME).append('.').append(FeedColumns._ID).append(')')
        .toString();
  
  public static final String WHERE_UNREAD_ONLY = new StringBuilder("(SELECT COUNT(*) FROM ")
      .append(EntryColumns.TABLE_NAME).append(" WHERE ").append(EntryColumns.IS_READ)
        .append(" IS NULL AND ").append(EntryColumns.FEED_ID).append("=")
        .append(FeedColumns.TABLE_NAME).append('.').append(FeedColumns._ID).append(") > 0")
        .append(" OR (").append(FeedColumns.IS_GROUP).append("=1 AND (SELECT COUNT(*) FROM ")
        .append(FeedData.ENTRIES_TABLE_WITH_FEED_INFO).append(" WHERE ")
        .append(EntryColumns.IS_READ).append(" IS NULL AND ").append(FeedColumns.GROUP_ID)
        .append('=').append(FeedColumns.TABLE_NAME).append('.').append(FeedColumns._ID)
        .append(") > 0)").toString();
      
    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 COMMENTS = "comments";

        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},
                {COMMENTS, 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;
    }
}
Java Source Code List
