Android Open Source - L5RHelper D B Helper

• Back to Game/speed  ↑

From Project

Back to project page L5RHelper.

License

The source code is released under:

Copyright (c) 2010 Robert Uhl Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Sof...

Java Source Code

package com.uhl.db;
//from   w  w w. ja va  2  s .co  m
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;

import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;

import com.uhl.calc.Roll;

//adapted from writeup at: http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/
public class DBHelper extends SQLiteOpenHelper implements IDBHelper {

  private static final String DB_NAME = "data.db3";
  private static final String DB_PATH = "/data/data/com.uhl/databases/";
  private SQLiteDatabase myDataBase;
  private final Context myContext;

  public DBHelper(Context context) {
    super(context, DB_NAME, null, 1);
    myContext = context;
    try {
      this.createDataBase();
    } catch (IOException e) { 
      e.printStackTrace();
    }
  }  

  public void createDataBase() throws IOException {

    boolean dbExist = checkDataBase();

    if (dbExist) {
      // do nothing - database already exist
    } else {

      // By calling this method and empty database will be created into
      // the default system path
      // of your application so we are gonna be able to overwrite that
      // database with our database.
      
      File f = new File(DB_PATH);
      if (!f.exists()) {
        f.mkdir();
      }
      
      
      this.getReadableDatabase();
      this.close();
      try {

        copyDataBase();

      } catch (IOException e) {

        throw new Error("Error copying database");
      }
    }

  }

  private boolean checkDataBase() {

    SQLiteDatabase checkDB = null;

    try {
      String myPath = DB_PATH + DB_NAME;
      checkDB = SQLiteDatabase.openDatabase(myPath, null,
          SQLiteDatabase.OPEN_READONLY);

    } catch (SQLiteException e) {

      // database does't exist yet.

    }

    if (checkDB != null) {

      checkDB.close();

    }

    return checkDB != null;
  }

  /**
   * Copies your database from your local assets-folder to the just created
   * empty database in the system folder, from where it can be accessed and
   * handled. This is done by transfering bytestream.
   * */
  private void copyDataBase() throws IOException {

    // Open your local db as the input stream
    InputStream myInput = myContext.getAssets().open(DB_NAME);

    // Path to the just created empty db
    String outFileName = DB_PATH + DB_NAME;

    // Open the empty db as the output stream
    OutputStream myOutput = new FileOutputStream(outFileName);

    // transfer bytes from the inputfile to the outputfile
    byte[] buffer = new byte[1024];
    int length;
    while ((length = myInput.read(buffer)) > 0) {
      myOutput.write(buffer, 0, length);
    }

    // Close the streams
    myOutput.flush();
    myOutput.close();
    myInput.close();

  }

  public void openDataBase() throws SQLException {

    // Open the database
    String myPath = DB_PATH + DB_NAME;
    myDataBase = SQLiteDatabase.openDatabase(myPath, null,
        SQLiteDatabase.OPEN_READONLY);

  }

  @Override
  public synchronized void close() {

    if (myDataBase != null)
      myDataBase.close();

    super.close();

  }

  @Override
  public void onCreate(SQLiteDatabase db) {
  }

  @Override
  public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
    onCreate(arg0);
  }
  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#saveProfile(com.uhl.db.Profile)
   */
  public boolean saveProfile(Profile profile){
    
    String insertString = "";
    String[] values = new String[0];
    
    if(profile.getId() == -1){
      //create
      insertString = "insert into Profiles values (null,?,?,?,?,?,?,?,?,?,?,?)";
      values = new String[] {String.valueOf(profile.getName()),String.valueOf(profile.getDefaultViewId()),
          String.valueOf(profile.getEarthRing()),String.valueOf(profile.getWaterRing()),String.valueOf(profile.getFireRing()),
          String.valueOf(profile.getAirRing()),String.valueOf(profile.getVoidRing()),String.valueOf(profile.getReflexes()),
          String.valueOf(profile.getAgility()),String.valueOf(profile.getLuck()),String.valueOf(profile.getGp())};
    }else
    {
      //update
      insertString = "update Profiles set name = ?, defaultViewId = ?, earth = ?, water = ?, fire = ?, air = ?, void = ?, reflexes = ?, agility = ?, luck = ?, gp = ? where _id = ?";
      values = new String[] {
          String.valueOf(profile.getName()),String.valueOf(profile.getDefaultViewId()),
          String.valueOf(profile.getEarthRing()),String.valueOf(profile.getWaterRing()),String.valueOf(profile.getFireRing()),
          String.valueOf(profile.getAirRing()),String.valueOf(profile.getVoidRing()),String.valueOf(profile.getReflexes()),
          String.valueOf(profile.getAgility()),String.valueOf(profile.getLuck()),String.valueOf(profile.getGp()),String.valueOf(profile.getId())};
    }    
    this.openDataBase();
    SQLiteDatabase db2 = this.getWritableDatabase();
    try {
      db2.execSQL(insertString, values);            
      this.close();
      return true;
    } catch (SQLException e) {
      this.close();
      return false;
    }
  }
  
  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#loadProfile(int)
   */
  public Profile loadProfile(int id){
    
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery(
        "select _id, name, defaultViewId, earth, water, fire, air, void, reflexes, agility, luck, gp from Profiles where _id = ?",
        new String[] { String.valueOf(id)});
    cursor.moveToFirst();
    this.close();
    Profile result = new Profile(cursor);
    cursor.close();
    return result;
    
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#getHistogram(com.uhl.calc.Roll)
   */
  public Cursor getHistogram(Roll roll) {
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery(
        "select histogram from Rolls where rolled = ? and kept = ? and gp = ? and luck = ?",
        new String[] { String.valueOf(roll.getRolled()),
            String.valueOf(roll.getKept()),
            String.valueOf(roll.getGp()),
            String.valueOf(roll.getLuck())});
    cursor.moveToFirst();
    this.close();
    return cursor;
  }
  
  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#getProfiles()
   */
  public Profile[] getProfiles(){
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery("select _id, name from Profiles", new String[0]);
    cursor.moveToFirst();
    this.close();    
    Profile[] result = new Profile[cursor.getCount()];
    for(int i = 0; i < cursor.getCount(); i++){
      result[i] = new Profile(cursor.getString(1), 0);
      result[i].setId(cursor.getInt(0));
      cursor.moveToNext();
    }
    cursor.close();
    return result;
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#deleteProfile(int)
   */
  public boolean deleteProfile(int id) {        
  
    String deleteString = "delete from Profiles where _id = ?";
    String[] values = new String[] {String.valueOf(id)};        
    this.openDataBase();
    SQLiteDatabase db2 = this.getWritableDatabase();
    try {
      db2.execSQL(deleteString, values);            
      this.close();  
      return true;
    } catch (SQLException e) {
      this.close();
      return false;
    }
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#getTemplateNames(int)
   */
  public Cursor getTemplateNames(int profileId) {
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery("select _id, name from Templates where profileId = ?", new String[]{String.valueOf(profileId)});
    cursor.moveToFirst();
    this.close();    
    return cursor;
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#profileNameExists(java.lang.String, int)
   */
  public boolean profileNameExists(String name, int id) {
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery("select * from Profiles where upper(name) = upper(?) and _id != ?", new String[]{name, String.valueOf(id)});
    boolean result = cursor.getCount() >= 1;    
    this.close();
    cursor.close();    
    return result;
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#templateNameExists(java.lang.String, int, int)
   */
  public boolean templateNameExists(String name, int id, int profileId) {
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery("select * from Templates where upper(name) = upper(?) and profileId = ? and _id != ?", 
        new String[]{name, String.valueOf(profileId),String.valueOf(id)}
    );
    boolean result = cursor.getCount() >= 1;    
    this.close();
    cursor.close();    
    return result;
  }
  
  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#getTemplates(int)
   */
  public Cursor getTemplates(int profileId) {
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery(
        "select _id, profileId, name, reflexes, agility, useReflexes, skillRank, isGp, modifier, rolled, kept, castingRing from Templates where profileId = ?",
        new String[] { String.valueOf(profileId)});
    cursor.moveToFirst();
    this.close();
    return cursor;
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#loadTemplate(int)
   */
  public Template loadTemplate(int id) {
    
    this.openDataBase();
    SQLiteDatabase db2 = this.getReadableDatabase();
    Cursor cursor = db2.rawQuery(
        "select _id, profileId, name, reflexes, agility, useReflexes, skillRank, isGp, modifier, rolled, kept, castingRing from Templates where _id = ?",
        new String[] { String.valueOf(id)});
    cursor.moveToFirst();
    this.close();    
    Template result = new Template(cursor);
    cursor.close();
    return result;
  }
  
/* (non-Javadoc)
 * @see com.uhl.db.IDBHelper#saveTemplate(com.uhl.db.Template)
 */
public boolean saveTemplate(Template template){
    
    String insertString = "";
    String[] values = new String[0];
    
    if(template.getId() == -1){
      //create
      insertString = "insert into Templates values (null,?,?,?,?,?,?,?,?,?,?,?)";
      values = new String[] {String.valueOf(template.getProfileId()),String.valueOf(template.getName()),
          String.valueOf(template.getReflexes()),String.valueOf(template.getAgility()),String.valueOf(template.getUseReflexes()),
          String.valueOf(template.getSkillRank()),String.valueOf(template.getisGp()),String.valueOf(template.getModifier()),
          String.valueOf(template.getRolled()),String.valueOf(template.getKept()),String.valueOf(template.getCastingRing())};
    }else
    {
      //update
      insertString = "update Templates set name = ?, reflexes = ?, agility = ?, useReflexes = ?, skillRank = ?, isGp = ?, modifier = ?, rolled = ?, kept = ?, castingRing = ? where _id = ?";
      values = new String[] {String.valueOf(template.getName()),
          String.valueOf(template.getReflexes()),String.valueOf(template.getAgility()),String.valueOf(template.getUseReflexes()),
          String.valueOf(template.getSkillRank()),String.valueOf(template.getisGp()),String.valueOf(template.getModifier()),
          String.valueOf(template.getRolled()),String.valueOf(template.getKept()),String.valueOf(template.getCastingRing()), 
          String.valueOf(template.getId())};
    }    
    this.openDataBase();
    SQLiteDatabase db2 = this.getWritableDatabase();
    try{
      db2.execSQL(insertString, values);            
      this.close();
      return true;
    }catch(Exception e){
      this.close();
      return false;
    }
  }

  /* (non-Javadoc)
   * @see com.uhl.db.IDBHelper#deleteTemplate(java.lang.Integer, java.lang.Integer)
   */
  public boolean deleteTemplate(Integer id, Integer profileId) {        
    
    String deleteString = "delete from Templates where _id = ? and profileId = ?";
    String[] values = new String[] {id.toString(), profileId.toString()};        
    this.openDataBase();
    SQLiteDatabase db2 = this.getWritableDatabase();
    try {
      db2.execSQL(deleteString, values);            
      this.close();
      return true;
    } catch (SQLException e) {
      this.close();
      return false;
    }    
  }

}

Java Source Code List

• Back to Game/speed  ↑