Android Open Source - HapiPodcastJ Subscription Columns

From Project

Back to project page HapiPodcastJ.
License

The source code is released under:
GNU General Public License
If you think the Android project HapiPodcastJ 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

package info.xuluan.podcast.provider;
//from  ww  w  .j  a v  a 2s .  com
import android.content.ContentValues;
import android.database.SQLException;
import android.net.Uri;
import android.provider.BaseColumns;

public class SubscriptionColumns implements BaseColumns {

  public static final Uri URI = Uri.parse("content://"
      + PodcastProvider.AUTHORITY + "/subscriptions");

  public static final String TABLE_NAME = "subs";

  public static final String URL = "url";

  public static final String LINK = "link";

  public static final String TITLE = "title";

  public static final String DESCRIPTION = "description";

  public static final String LAST_UPDATED = "last_updated";

  public static final String LAST_ITEM_UPDATED = "last_item_updated";

  public static final String FAIL_COUNT = "fail";

  public static final String STATUS = "status";

  public static final String COMMENT = "comment";
  public static final String RATING = "rating";
  public static final String USERNAME = "user";
  public static final String PASSWORD = "pwd";
  public static final String SERVER_ID = "server_id";
  public static final String SYNC = "sync";  
  public static final String AUTO_DOWNLOAD = "auto_download";  
  public static final String PLAYLIST_ID = "playlist_id";
  public static final String SUSPENDED = "suspended";
  

  public static final String[] ALL_COLUMNS = { _ID, URL, LINK, TITLE,
      DESCRIPTION, LAST_UPDATED, LAST_ITEM_UPDATED, FAIL_COUNT, STATUS,
      COMMENT, RATING, USERNAME, PASSWORD, SERVER_ID, SYNC, AUTO_DOWNLOAD,
      PLAYLIST_ID, SUSPENDED};

  public static final String DEFAULT_SORT_ORDER = _ID + " ASC";
  
  public static String sql_create_table(int version) {
    String sql = "CREATE TABLE "
            + TABLE_NAME + " (" 
            + _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " 
            + URL + " VARCHAR(1024), " 
            + LINK + " VARCHAR(256), " 
            + TITLE  + " VARCHAR(128), " 
            + DESCRIPTION + " TEXT, "
            + LAST_UPDATED + " INTEGER, " 
            + LAST_ITEM_UPDATED + " INTEGER, "
            + FAIL_COUNT + " INTEGER, " 
            + STATUS + " INTEGER, " 
            + COMMENT + " TEXT, " 
            + RATING + " INTEGER, " 
            + USERNAME  + " VARCHAR(32) , " 
            + PASSWORD + " VARCHAR(32) , " 
            + SERVER_ID + " INTEGER , " 
            + SYNC + " INTEGER , "     
            + AUTO_DOWNLOAD + " INTEGER , "
            + PLAYLIST_ID + " INTEGER "
            + (version>=14?(", "+SUSPENDED + " INTEGER NOT NULL DEFAULT 0 "):"")
            + ");";
    return sql;
  }

  //Upgrading database from 13 to 14
  public static final String sql_upgrade_subscriptions_add_suspended_column = "ALTER TABLE "
      + TABLE_NAME + " ADD COLUMN " + SUSPENDED + " INTEGER NOT NULL DEFAULT 0;";

  public static final String sql_index_subs_url = "CREATE UNIQUE INDEX IDX_"
      + TABLE_NAME + "_" + URL + " ON " + TABLE_NAME + " (" + URL + ");";

  public static final String sql_index_last_update = "CREATE INDEX IDX_"
      + TABLE_NAME + "_" + LAST_UPDATED + " ON " + TABLE_NAME + " ("
      + LAST_UPDATED + ");";

  public static final String sql_insert_default = "INSERT INTO "
      + TABLE_NAME
      + " ("
      + URL
      + ","
      + TITLE
      + ","
      + DESCRIPTION
      + ","
      + LINK
      + ","
      + LAST_UPDATED
      + ","
      + FAIL_COUNT
      + ","
      + LAST_ITEM_UPDATED
      + ") VALUES ('http://www.cbcradio3.com/podcast/', 'unknown', 'unknown', '', 0, 0, 0);";
  

  public static final String sql_insert_default1 = "INSERT INTO "
      + TABLE_NAME
      + " ("
      + URL
      + ","
      + TITLE
      + ","
      + DESCRIPTION
      + ","
      + LINK
      + ","
      + LAST_UPDATED
      + ","
      + FAIL_COUNT
      + ","
      + LAST_ITEM_UPDATED
      + ") VALUES ('http://www.blogtalkradio.com/rss/category/finance/mostviewed.rss', 'unknown', 'unknown', '', 0, 0, 0);";

  public static final String sql_insert_default2 = "INSERT INTO "
      + TABLE_NAME
      + " ("
      + URL
      + ","
      + TITLE
      + ","
      + DESCRIPTION
      + ","
      + LINK
      + ","
      + LAST_UPDATED
      + ","
      + FAIL_COUNT
      + ","
      + LAST_ITEM_UPDATED
      + ") VALUES ('http://www.npr.org/rss/podcast.php?id=13', 'unknown', 'unknown', '', 0, 0, 0);";
  public static final String sql_insert_default3 = "INSERT INTO "
      + TABLE_NAME
      + " ("
      + URL
      + ","
      + TITLE
      + ","
      + DESCRIPTION
      + ","
      + LINK
      + ","
      + LAST_UPDATED
      + ","
      + FAIL_COUNT
      + ","
      + LAST_ITEM_UPDATED
      + ") VALUES ('http://podcasts.engadget.com/rss.xml', 'unknown', 'unknown', '', 0, 0, 0);";

  public static final String sql_insert_default4 = "INSERT INTO "
    + TABLE_NAME
    + " ("
    + URL
    + ","
    + TITLE
    + ","
    + DESCRIPTION
    + ","
    + LINK
    + ","
    + LAST_UPDATED
    + ","
    + FAIL_COUNT
    + ","
    + LAST_ITEM_UPDATED
    + ") VALUES ('http://downloads.bbc.co.uk/podcasts/radio4/r4choice/rss.xml', 'unknown', 'unknown', '', 0, 0, 0);";
  
  public static ContentValues checkValues(ContentValues values, Uri uri) {
    if (values.containsKey(URL) == false) {
      throw new SQLException("Fail to insert row because URL is needed "
          + uri);
    }

    if (values.containsKey(LINK) == false) {
      values.put(LINK, "");
    }

    if (values.containsKey(TITLE) == false) {
      values.put(TITLE, "unknow");
    }

    if (values.containsKey(DESCRIPTION) == false) {
      values.put(DESCRIPTION, "");
    }

    if (values.containsKey(LAST_UPDATED) == false) {
      values.put(LAST_UPDATED, 0);
    }

    if (values.containsKey(LAST_ITEM_UPDATED) == false) {
      values.put(LAST_ITEM_UPDATED, 0);
    }

    if (values.containsKey(FAIL_COUNT) == false) {
      values.put(FAIL_COUNT, 0);
    }
    
    if (values.containsKey(AUTO_DOWNLOAD) == false) {
      values.put(AUTO_DOWNLOAD, 0);
    }    
    if (values.containsKey(PLAYLIST_ID) == false) {
      values.put(PLAYLIST_ID, -1);
    }
    if (values.containsKey(SUSPENDED) == false) {
      values.put(SUSPENDED, 0);
    }
    return values;
  }
}
Java Source Code List
