Android Open Source - SimpleReader Db Manager

• Back to Development/rss  ↑

From Project

Back to project page SimpleReader.

License

The source code is released under:

Apache License

Java Source Code

package com.dreamteam.app.db;
/*w w  w  .  ja v a 2s.  c  o m*/
import com.dreamteam.app.db.provider.RSSFeedCategoryProvider;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DbManager extends SQLiteOpenHelper {
  public static final String DB_NAME = "reader.db";
  public static final int DB_VERSION = 1;
  public static final String SECTION_TABLE_NAME = "section";
  public static final String FAVORITE_ITEM_TABLE_NAME = "favorite_item";
  public static final String RSS_CATEGORY_TABLE_NAME = "category";

  private static final String CREATE_SECTION_TABLE = "create table" + " "
      + SECTION_TABLE_NAME + "(title text, url text, table_name text)";
  
  private static final String CREATE_FAVORITE_TABLE = "create table" + " "
      + FAVORITE_ITEM_TABLE_NAME
      + "(title text, pubdate text, item_detail text, "
      + "link text, first_img_url text, table_name text)";

  private static final String CREATE_TABLE_CATEGORY = "create table "
      + RSS_CATEGORY_TABLE_NAME 
      + " ( " 
      + RSSFeedCategoryProvider.KEY_ID + " integer primary key autoincrement, " 
      + RSSFeedCategoryProvider.KEY_TITLE + " text, "
      + RSSFeedCategoryProvider.KEY_TABLE + " text, "
      + RSSFeedCategoryProvider.KEY_DESCRIPTION + " text, "
      + RSSFeedCategoryProvider.KEY_IMAGEURL + " text); ";

  public DbManager(Context context, String name, CursorFactory factory,
      int version) {
    super(context, name, factory, version);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
    db.execSQL(CREATE_SECTION_TABLE);
    db.execSQL(CREATE_FAVORITE_TABLE);
    db.execSQL(CREATE_TABLE_CATEGORY);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

  }

}

Java Source Code List

• Back to Development/rss  ↑