Android Open Source - Tacere Event Database Open Helper

• Back to Development/calendar  ↑

From Project

Back to project page Tacere.

License

The source code is released under:

MIT License

Java Source Code

/*
 * Copyright (c) 2014 Jonathan Nelson/*from  w w  w  .  ja  va  2s .  com*/
 * Released under the BSD license.  For details see the COPYING file.
 */

package org.ciasaboark.tacere.database;

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

class EventDatabaseOpenHelper extends SQLiteOpenHelper {
    public static final String TABLE_EVENTS = "events";
    private static final String DB_NAME = "events.sqlite";
    private static final int VERSION = 10;

    public EventDatabaseOpenHelper(Context context) {
        super(context, DB_NAME, null, VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        createTable(db);
    }

    private void createTable(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE " + TABLE_EVENTS + " ( " +
                Columns._ID + " integer primary key," +
                Columns.EVENT_ID + " integer, " +
                Columns.TITLE + " varchar(100), " +
                Columns.DESCRIPTION + " varchar(100), " +
                Columns.BEGIN + " integer, " +
                Columns.EFFECTIVE_END + " integer, " +
                Columns.IS_ALLDAY + " integer, " +
                Columns.IS_FREETIME + " integer, " +
                Columns.RINGER_TYPE + " integer, " +
                Columns.DISPLAY_COLOR + " integer, " +
                Columns.CAL_ID + " integer, " +
                Columns.LOCATION + " varchar(100), " +
                Columns.EXTEND_BUFFER + " integer DEFAULT '0', " +
                Columns.ORGINAL_END + " integer " +
                ")");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int arg1, int arg2) {
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_EVENTS);
        createTable(db);
    }
}

Java Source Code List

• Back to Development/calendar  ↑