Android Open Source - Expenses Database Helper

• Back to App/simple  ↑

From Project

Back to project page Expenses.

License

The source code is released under:

GNU General Public License

Java Source Code

/*
 *   Copyright 2013, 2014 Daniel Pereira Coelho
 *   /*from ww  w  .j  a v  a  2  s.  co m*/
 *   This file is part of the Expenses Android Application.
 *
 *   Expenses is free software: you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation in version 3.
 *
 *   Expenses is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   You should have received a copy of the GNU General Public License
 *   along with Expenses.  If not, see <http://www.gnu.org/licenses/>.
 * 
 */

package com.dpcsoftware.mn;



import android.app.Activity;
import android.content.ContentValues;
import android.content.Context;
import android.content.res.Resources;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "dpcsoftware.mn";
    public static final int DATABASE_VERSION = 1;
    
    public static final int MODE_READ = 0;
    public static final int MODE_WRITE = 1;
  
  public static final String SQL_CREATE_T1 = "CREATE TABLE " + Db.Table1.TABLE_NAME + " ( "
      + Db.Table1._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
        + Db.Table1.COLUMN_VALORT + " REAL,"
        + Db.Table1.COLUMN_DATAT + " TEXT,"
        + Db.Table1.COLUMN_DESCRIC + " TEXT,"
        + Db.Table1.COLUMN_IDGRUPO + " INTEGER,"
        + Db.Table1.COLUMN_IDCAT + " INTEGER,"
        + "FOREIGN KEY(" + Db.Table1.COLUMN_IDGRUPO + ") REFERENCES " + Db.Table3.TABLE_NAME + "(" + Db.Table3._ID + "),"
        + "FOREIGN KEY(" + Db.Table1.COLUMN_IDCAT + ") REFERENCES " + Db.Table2.TABLE_NAME + "(" + Db.Table2._ID + "))";
    public static final String SQL_DELETE_T1 = "DROP TABLE IF EXISTS " + Db.Table1.TABLE_NAME;
    
    public static final String SQL_CREATE_T2 = "CREATE TABLE " + Db.Table2.TABLE_NAME + " ( "
        + Db.Table2._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
        + Db.Table2.COLUMN_NCAT + " TEXT,"
        + Db.Table2.COLUMN_CORCAT + " INTEGER)";
    public static final String SQL_DELETE_T2 = "DROP TABLE IF EXISTS " + Db.Table2.TABLE_NAME;
        
    public static final String SQL_CREATE_T3 = "CREATE TABLE " + Db.Table3.TABLE_NAME + " ( "
        + Db.Table3._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
        + Db.Table3.COLUMN_NGRUPO + " TEXT)";
    public static final String SQL_DELETE_T3 = "DROP TABLE IF EXISTS " + Db.Table3.TABLE_NAME;
      
    private Resources rs;
    
    public DatabaseHelper(Context context) {
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
      rs = context.getResources();
    }
    
  @Override
  public void onCreate(SQLiteDatabase database) {
    database.execSQL(SQL_CREATE_T2);
    insertCategory(database,R.string.dbHelper_c4,R.color.c14);
    insertCategory(database,R.string.dbHelper_c5,R.color.c1);
    insertCategory(database,R.string.dbHelper_c6,R.color.c4);
    insertCategory(database,R.string.dbHelper_c7,R.color.c7);
    insertCategory(database,R.string.dbHelper_c8,R.color.c5);
    
    database.execSQL(SQL_CREATE_T3);
    insertGroup(database,R.string.dbHelper_c1);
    insertGroup(database,R.string.dbHelper_c2);
    insertGroup(database,R.string.dbHelper_c3);
    
    database.execSQL(SQL_CREATE_T1);
  }
  
  @Override
  public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
    database.execSQL(SQL_DELETE_T1);
    database.execSQL(SQL_DELETE_T2);
    database.execSQL(SQL_DELETE_T3);
    onCreate(database);
  }
  
  private long insertCategory(SQLiteDatabase db, int catName, int catColor) {
    ContentValues cv = new ContentValues();
    cv.put(Db.Table2.COLUMN_NCAT, rs.getString(catName));
    cv.put(Db.Table2.COLUMN_CORCAT, rs.getColor(catColor));
    return db.insert(Db.Table2.TABLE_NAME, null, cv);
  }
  
  private long insertGroup(SQLiteDatabase db, int grName) {
    ContentValues cv = new ContentValues();
    cv.put(Db.Table3.COLUMN_NGRUPO, rs.getString(grName));
    return db.insert(Db.Table3.TABLE_NAME,null,cv);
  }
  
  public static SQLiteDatabase quickDb(Activity activity, int mode) {
    SQLiteDatabase db;
    DatabaseHelper dbHelper = ((App) activity.getApplication()).dbH;
    if(mode == MODE_READ)
      db = dbHelper.getReadableDatabase();
    else
      db = dbHelper.getWritableDatabase();
    return db;
  }
}

Java Source Code List

• Back to App/simple  ↑