DAOHelper.java

/*
 * Copyright (c) 2014. Marshal Chen.
 */

package com.marshalchen.common.uimodule.standuptimer.dao;

import static android.provider.BaseColumns._ID;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.database.sqlite.SQLiteDatabase.CursorFactory;

public abstract class DAOHelper extends SQLiteOpenHelper implements DatabaseConstants {

    protected static final String TEAMS_TABLE_NAME = "teams";
    protected static final String TEAMS_NAME = "name";
    protected static final String[] TEAMS_ALL_COLUMS = { _ID, TEAMS_NAME };

    protected static final String MEETINGS_TABLE_NAME = "meetings";
    protected static final String MEETINGS_TEAM_NAME = "team_name";
    protected static final String MEETINGS_MEETING_TIME = "meeting_time";
    protected static final String MEETINGS_NUM_PARTICIPANTS = "num_participants";
    protected static final String MEETINGS_INDIVIDUAL_STATUS_LENGTH = "individual_status_length";
    protected static final String MEETINGS_MEETING_LENGTH = "meeting_length";
    protected static final String MEETINGS_QUICKEST_STATUS = "quickest_status";
    protected static final String MEETINGS_LONGEST_STATUS = "longest_status";
    protected static final String[] MEETINGS_ALL_COLUMS = { _ID, MEETINGS_TEAM_NAME, MEETINGS_MEETING_TIME, MEETINGS_NUM_PARTICIPANTS,
        MEETINGS_INDIVIDUAL_STATUS_LENGTH, MEETINGS_MEETING_LENGTH, MEETINGS_QUICKEST_STATUS, MEETINGS_LONGEST_STATUS};

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

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + TEAMS_TABLE_NAME + " (" +
                _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                TEAMS_NAME + " TEXT NOT NULL" +
                ");");

        db.execSQL("CREATE TABLE " + MEETINGS_TABLE_NAME + " (" +
                _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
                MEETINGS_TEAM_NAME + " TEXT NOT NULL, " +
                MEETINGS_MEETING_TIME + " INTEGER NOT NULL, " +
                MEETINGS_NUM_PARTICIPANTS + " INTEGER NOT NULL, " +
                MEETINGS_INDIVIDUAL_STATUS_LENGTH + " INTEGER NOT NULL, " +
                MEETINGS_MEETING_LENGTH + " INTEGER NOT NULL, " +
                MEETINGS_QUICKEST_STATUS + " INTEGER NOT NULL, " +
                MEETINGS_LONGEST_STATUS + " INTEGER NOT NULL" +
                ");");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + TEAMS_TABLE_NAME);
        db.execSQL("DROP TABLE IF EXISTS " + MEETINGS_TABLE_NAME);
        onCreate(db);
    }

    protected void closeCursor(Cursor cursor) {
        if (cursor != null) {
            cursor.close();
        }
    }
}