Android Open Source - DashNotifier Notif S Q Lite Helper

From Project

Back to project page DashNotifier.

License

The source code is released under:

MIT License

If you think the Android project DashNotifier listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package com.umang.dashnotifier.provider;
//  ww  w . j  a  va 2  s. co  m
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class NotifSQLiteHelper extends SQLiteOpenHelper {
  public static final String TABLE_NOTIF = "notifications";
  public static final String COL_ID = "_id";
    public static final String COL_PNAME = "package_name";
    public static final String COL_NOTIF_ID = "notif_id";
    public static final String COL_TITLE = "notif_title";
    public static final String COL_TEXT = "notif_text";
    public static final String COL_EXTRA = "notif_extra";
    public static final String COL_TIME = "notif_time";
    public static final String COL_TICKER = "notif_ticker";
    public static final String COL_CLEAR = "notif_clearable";
    public static final String COL_ONGOING = "notif_ongoing";
    public static final String COL_COUNT = "notif_count";
    public static final String COL_TAG = "notif_tag";
    
    private static final String DATABASE_NAME = "dashNotifications";
    private static final int DATABASE_VERSION = 3;
  
  public NotifSQLiteHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
  
  @Override
  public void onCreate(SQLiteDatabase db) {
     String CREATE_NOTIF_TABLE = "CREATE TABLE " + TABLE_NOTIF + 
         "(" + COL_ID   + " integer primary key autoincrement, "
         + COL_PNAME   + " text not null, "
         + COL_NOTIF_ID + " integer, " 
         + COL_TITLE   + " text not null, " 
         + COL_TEXT   + " text, " 
         + COL_EXTRA   + " text, " 
         + COL_TIME   + " text not null, " 
         + COL_TICKER   + " text, "
         + COL_CLEAR   + " integer, "
         + COL_ONGOING   + " integer, "
         + COL_COUNT  + " integer, "
         + COL_TAG    + " text );";
     db.execSQL(CREATE_NOTIF_TABLE);
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_NOTIF);
    onCreate(db);
  }
  
  public static class Columns{
    public static final int COL_ID = 0;
    public static final int COL_PNAME = 1;
    public static final int COL_NOTIF_ID = 2;
    public static final int COL_TITLE = 3;
    public static final int COL_TEXT = 4;
    public static final int COL_EXTRA = 5;
    public static final int COL_TIME = 6;
    public static final int COL_TICKER = 7;
    public static final int COL_CLEAR = 8;
    public static final int COL_ONGOING = 9;
    public static final int COL_COUNT = 10;
    public static final int COL_TAG = 11;
  }

}

Java Source Code List