Android Open Source - DemiGod Hero D B

From Project

Back to project page DemiGod.
License

The source code is released under:
GNU General Public License
If you think the Android project DemiGod 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

/*
 Copyright (C) 2013  //  www. j av  a  2 s. co m

 @author High Caliber Productions

 This program 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, either version 3 of the License, or
 (at your option) any later version.

 This program 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 this program.  If not, see <http://www.gnu.org/licenses/>.
 */

package high.caliber.productions.demigod.database;

import high.caliber.productions.demigod.Item;

import java.util.ArrayList;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteException;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class HeroDB extends SQLiteOpenHelper {

  private static final String DB_PATH = "data/data/high.caliber.productions.demigod/databases/Hero.db";
  private static final String DB_NAME = "Hero.db";

  private static final String TABLE_STATS = "Stats";
  private static final String TABLE_INVENTORY = "Inventory";
  private static final int DB_VERSION = 1;

  public static final String COL_ID = "_id";
  public static final String COL_CLASS = "Class";
  public static final String COL_NAME = "Name";
  public static final String COL_LVL = "Level";
  public static final String COL_EXP = "Exp";
  public static final String COL_MAX_EXP = "MaxExp";
  public static final String COL_HEALTH = "Health";
  public static final String COL_MAX_HEALTH = "MaxHealth";
  public static final String COL_ENERGY = "Energy";
  public static final String COL_MAX_ENERGY = "MaxEnergy";
  public static final String COL_MANA = "Mana";
  public static final String COL_MAX_MANA = "MaxMana";
  public static final String COL_ATTACK = "Attack";
  public static final String COL_MAGIC = "Magic";
  public static final String COL_PH_DEFENSE = "PhDefense";
  public static final String COL_MG_DEFENSE = "MgDefense";
  public static final String COL_AGILITY = "Agility";
  public static final String COL_DEXTERITY = "Dexterity";

  public static final String COL_ITEM_ID = "ItemId";
  public static final String COL_TABLE_ID = "TableId";
  public static final String COL_QTY = "Quantity";

  private static final String STATS_CREATE = ("CREATE TABLE " + TABLE_STATS
      + " (" + COL_ID + "  INTEGER PRIMARY KEY AUTOINCREMENT, "
      + COL_CLASS + " TEXT, " + COL_NAME + " TEXT, " + COL_LVL
      + " TEXT, " + COL_EXP + " TEXT, " + COL_MAX_EXP + " TEXT, "
      + COL_HEALTH + " TEXT, " + COL_MAX_HEALTH + " TEXT, " + COL_ENERGY
      + " TEXT, " + COL_MAX_ENERGY + " TEXT, " + COL_MANA + " TEXT, "
      + COL_MAX_MANA + " TEXT, " + COL_ATTACK + " TEXT, " + COL_MAGIC
      + " TEXT, " + COL_PH_DEFENSE + " TEXT, " + COL_MG_DEFENSE
      + " TEXT," + COL_AGILITY + " TEXT, " + COL_DEXTERITY + " TEXT)");

  private static final String INVENTORY_CREATE = ("CREATE TABLE "
      + TABLE_INVENTORY + " (" + COL_ID
      + "  INTEGER PRIMARY KEY AUTOINCREMENT, " + COL_ITEM_ID + " TEXT,"
      + COL_TABLE_ID + " TEXT," + COL_QTY + " TEXT)");

  private static SQLiteDatabase db;
  Context context;

  public HeroDB(Context context) {
    super(context, DB_NAME, null, DB_VERSION);
    this.context = context;
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
    db.execSQL(STATS_CREATE);
    db.execSQL(INVENTORY_CREATE);
  }

  /**
   * Inserts hero's initial inventory
   */
  public void PopulateInventoryFields() {

    try {

      db = SQLiteDatabase.openDatabase(DB_PATH, null,
          SQLiteDatabase.OPEN_READWRITE);

      Log.d("Inventory Table",
          "Inserting Initial Inventory Items into Table");

      ContentValues cv = new ContentValues();

      // 150 Gold
      cv.put(COL_ID, "1");
      cv.put(COL_ITEM_ID, "1");
      cv.put(COL_TABLE_ID, ItemDB.TABLE_CONSUMABLES_ID);
      cv.put(COL_QTY, "150");

      db.insert(TABLE_INVENTORY, COL_ID, cv);

      // 3 apples
      cv.put(COL_ID, "2");
      cv.put(COL_ITEM_ID, "5");
      cv.put(COL_TABLE_ID, ItemDB.TABLE_CONSUMABLES_ID);
      cv.put(COL_QTY, "3");

      db.insert(TABLE_INVENTORY, COL_ID, cv);

      // 1 wooden sword
      cv.put(COL_ID, "3");
      cv.put(COL_ITEM_ID, "1");
      cv.put(COL_TABLE_ID, ItemDB.TABLE_WEAPONS_ID);
      cv.put(COL_QTY, "1");

      db.insert(TABLE_INVENTORY, COL_ID, cv);

      // 1 leather armor
      cv.put(COL_ID, "4");
      cv.put(COL_ITEM_ID, "2");
      cv.put(COL_TABLE_ID, ItemDB.TABLE_ARMOR_ID);
      cv.put(COL_QTY, "1");

      db.insert(TABLE_INVENTORY, COL_ID, cv);

      // 1 mana potion
      cv.put(COL_ID, "5");
      cv.put(COL_ITEM_ID, "4");
      cv.put(COL_TABLE_ID, ItemDB.TABLE_CONSUMABLES_ID);
      cv.put(COL_QTY, "1");

      db.insert(TABLE_INVENTORY, COL_ID, cv);

      db.close();
    } catch (SQLiteException e) {
      Log.d("Inventory Table", "Error Inserting Values");

    }

    db.close();
    Log.d("Inventory Table", "Values Successfully Inserted Into Table");

  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    Log.w(HeroDB.class.getName(), "Upgrading database from version "
        + oldVersion + " to " + newVersion
        + ", which will destroy all old data");
    db.execSQL("DROP TABLE IF EXISTS " + TABLE_STATS);

    this.onCreate(db);
  }

  @Override
  public synchronized void close() {

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

    super.close();

  }

  public boolean isCreated() {

    SQLiteDatabase db = null;
    boolean isCreated = false;

    try {
      db = SQLiteDatabase.openDatabase(DB_PATH, null,
          SQLiteDatabase.OPEN_READONLY);
    } catch (SQLiteException e) {
      e.printStackTrace();
    }

    if (db != null) {
      isCreated = true;
    } else {
      isCreated = false;
    }

    Log.d("DB created?", String.valueOf(isCreated));
    return isCreated;

  }

  /**
   * Retrieves all inventory items, and adds them to custom ArrayAdapter
   * 
   * @return InventoryData ArrayList
   */
  public ArrayList<Item> getInventory() {

    db = SQLiteDatabase.openDatabase(DB_PATH, null,
        SQLiteDatabase.OPEN_READWRITE);

    Cursor c = db
        .query(TABLE_INVENTORY, null, null, null, null, null, null);

    ArrayList<Item> data = new ArrayList<Item>();
    int rowItemId = c.getColumnIndex(COL_ITEM_ID);
    int rowTableId = c.getColumnIndex(COL_TABLE_ID);
    int rowQty = c.getColumnIndex(COL_QTY);

    ItemDB itemDbHelper = new ItemDB(context);

    data = new ArrayList<Item>();
    for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
      Item items = new Item();
      items = itemDbHelper.getItem(c.getInt(rowItemId),
          c.getInt(rowTableId));
      items.quantity = c.getInt(rowQty);
      data.add(items);

    }
    db.close();
    return data;
  }

  public static String getPath() {
    return DB_PATH;
  }

  public static String getDbName() {
    return DB_NAME;
  }

  public static String getTableStats() {
    return TABLE_STATS;
  }

  public static String getTableInventory() {
    return TABLE_INVENTORY;
  }

}
Java Source Code List
