1 package com.folioreader.model.sqlite;
3 import android.content.Context;
4 import android.database.sqlite.SQLiteDatabase;
5 import android.database.sqlite.SQLiteOpenHelper;
6 import android.util.Log;
8 public class FolioDatabaseHelper extends SQLiteOpenHelper {
9 @SuppressWarnings("unused")
10 private static final String TAG = "SQLiteOpenHelper";
12 private static FolioDatabaseHelper mInstance;
13 private static SQLiteDatabase myWritableDb;
15 public static final String DATABASE_NAME = "FolioReader.db";
16 private static final int DATABASE_VERSION = 2;
18 public static final String KEY_ID = "_id";
19 private final Context mContext;
21 public FolioDatabaseHelper(final Context context) {
22 super(context, DATABASE_NAME, null, DATABASE_VERSION);
26 public static FolioDatabaseHelper getInstance(Context context) {
27 if (mInstance == null) {
28 mInstance = new FolioDatabaseHelper(context);
33 public SQLiteDatabase getMyWritableDatabase() {
34 if ((myWritableDb == null) || (!myWritableDb.isOpen())) {
35 myWritableDb = this.getWritableDatabase();
44 if (myWritableDb != null) {
51 public final void onCreate(final SQLiteDatabase db) {
52 Log.d("create table highlight", "****" + HighLightTable.SQL_CREATE);
53 db.execSQL(HighLightTable.SQL_CREATE);
57 public final void onUpgrade(final SQLiteDatabase db, final int oldVersion,
58 final int newVersion) {
59 /* PROTECTED REGION ID(DatabaseUpdate) ENABLED START */
61 // TODO Implement your database update functionality here and remove the
62 // following method call!
63 //onUpgradeDropTables(db);
65 resetAllPreferences(mContext);
67 /* PROTECTED REGION END */
71 * This basic upgrade functionality will destroy all old data on upgrade
73 private final void onUpgradeDropTables(final SQLiteDatabase db) {
78 * Resets all shared preferences
82 private final void resetAllPreferences(Context context) {