diff options
author | Tom Willemsen | 2013-01-27 15:55:33 +0100 |
---|---|---|
committer | Tom Willemsen | 2013-01-27 15:55:33 +0100 |
commit | 0be3e83d3b3bf8a7428c6a0108881e5aa8b47dd3 (patch) | |
tree | d7a368c8ee17054a42378854ae5f3ab8953baae8 /src/org/ryuslash/Dailies/SQLiteHelper.java | |
download | dailies-0be3e83d3b3bf8a7428c6a0108881e5aa8b47dd3.tar.gz dailies-0be3e83d3b3bf8a7428c6a0108881e5aa8b47dd3.zip |
Diffstat (limited to 'src/org/ryuslash/Dailies/SQLiteHelper.java')
-rw-r--r-- | src/org/ryuslash/Dailies/SQLiteHelper.java | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/src/org/ryuslash/Dailies/SQLiteHelper.java b/src/org/ryuslash/Dailies/SQLiteHelper.java new file mode 100644 index 0000000..0934f4e --- /dev/null +++ b/src/org/ryuslash/Dailies/SQLiteHelper.java @@ -0,0 +1,51 @@ +package org.ryuslash.Dailies; + +import android.content.Context; +import android.database.sqlite.SQLiteDatabase; +import android.database.sqlite.SQLiteOpenHelper; +import android.util.Log; + +public class SQLiteHelper extends SQLiteOpenHelper +{ + public static final String TABLE_DAILY = "daily"; + public static final String COLUMN_ID = "id"; + public static final String COLUMN_TITLE = "title"; + public static final String COLUMN_ALARM = "alarm"; + public static final String COLUMN_HOUR = "hour"; + public static final String COLUMN_MINUTE = "minute"; + public static final String COLUMN_LAST_COMPLETED = "last_completed"; + + private static final String DATABASE_NAME = "dailies.db"; + private static final int DATABASE_VERSION = 1; + + private static final String TABLE_DAILY_CREATE = + "CREATE TABLE " + TABLE_DAILY + " (" + + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + + COLUMN_TITLE + " TEXT NOT NULL, " + + COLUMN_ALARM + " INTEGER NOT NULL, " + + COLUMN_HOUR + " INTEGER NULL, " + + COLUMN_MINUTE + " INTEGER NULL, " + + COLUMN_LAST_COMPLETED + " TEXT NULL " + + ");"; + + public SQLiteHelper(Context context) + { + super(context, DATABASE_NAME, null, DATABASE_VERSION); + } + + @Override + public void onCreate(SQLiteDatabase database) + { + database.execSQL(TABLE_DAILY_CREATE); + } + + @Override + public void onUpgrade(SQLiteDatabase db, int oldV, int newV) + { + Log.w(SQLiteHelper.class.getName(), + "Upgrading database from version " + oldV + " to " + + newV + ", which will destroy all old data"); + db.execSQL("DROP TABLE IF EXISTS " + TABLE_DAILY); + onCreate(db); + } +} |