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);
    }
}