Android Open Source - Turn-of-War Database

• Back to Game/strategy  ↑

From Project

Back to project page Turn-of-War.

License

The source code is released under:

Apache License

Java Source Code

/* This file is part of Dragon Wars.
 *// w ww.j  ava 2 s  .  c  o m
 * Dragon Wars 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.
 *
 * Dragon Wars 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 Dragon Wars. If not, see <http://www.gnu.org/licenses/>.
 */

package uk.co.fuuzetsu.turnofwar.engine.Database;

import java.util.ArrayList;
import java.util.List;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public final class Database {
    public class Entry {
        public Double DAMAGEDEALT;
        public Double DAMAGERECEIVED;
        public Double DISTANCETRAVELLED;
        public Integer GOLDCOLLECTED;
        public Integer UNITSKILLED;
        public Integer UNITSMADE;
    }

    private static final String DATABASE_NAME = "dragonwars.db";
    private static final String DATABASE_TABLE_NAME = "statistics";
    private static final int DATABASE_VERSION = 1;

    private static final String DATABASE_CREATE = "create table if not exists "
            + DATABASE_TABLE_NAME + " (" + " GAMETIME INT NOT NULL,"
            + " DAMAGEDEALT DOUBLE NOT NULL,"
            + " DAMAGERECEIVED DOUBLE NOT NULL,"
            + " DISTANCETRAVELLED DOUBLE NOT NULL,"
            + " GOLDCOLLECTED INT NOT NULL," + " UNITSKILLED INT NOT NULL,"
            + " UNITSMADE INT NOT NULL," + " PRIMARY KEY(GAMETIME)" + ");";

    private SQLiteDatabase database;

    public Database(final Context con) {
        database = con.openOrCreateDatabase(DATABASE_NAME, 0, null);
        CreateTable();
    }

    public void CreateTable() {
        // creates the high_scores table
        database.execSQL(DATABASE_CREATE);
    }

    public void DeleteTable() {
        Close();
    }

    // should be called when the DB is no longer needed
    public void Close() {
        database.close();
    }

    // use to add a new high score to the database
    public void AddEntry(final Double damageDealt, final Double damageReceived,
                         final Double distanceTravelled, final Integer goldCollected,
                         final Integer unitsKilled, final Integer unitsMade) {
        // create content values
        ContentValues values = new ContentValues();

        values.put("GAMETIME", System.currentTimeMillis());
        values.put("DAMAGEDEALT", damageDealt);
        values.put("DAMAGERECEIVED", damageReceived);
        values.put("DISTANCETRAVELLED", distanceTravelled);
        values.put("GOLDCOLLECTED", goldCollected);
        values.put("UNITSKILLED", unitsKilled);
        values.put("UNITSMADE", unitsMade);

        // add content values as a row
        database.insert(DATABASE_TABLE_NAME, null, values);
    }

    public List<Entry> GetEntries() {
        // gets all entries from the high scores table
        List<Entry> entries = new ArrayList<Entry>();

        // get cursor to DB from query
        String[] query = { "GAMETIME", "DAMAGEDEALT", "DAMAGERECEIVED",
                           "DISTANCETRAVELLED", "GOLDCOLLECTED", "UNITSKILLED",
                           "UNITSMADE"
                         };

        Cursor cursor = database.query(DATABASE_TABLE_NAME, query, null, null,
                                       null, null, null);

        // count the number of entries
        Integer numberOfEntries = cursor.getCount();
        cursor.moveToFirst();

        for (Integer entry = 0; entry < numberOfEntries; entry++) {
            Entry record = new Entry();
            /* We don't care about the game time */
            record.DAMAGEDEALT = cursor.getDouble(1);
            record.DAMAGERECEIVED = cursor.getDouble(2);
            record.DISTANCETRAVELLED = cursor.getDouble(3);
            record.GOLDCOLLECTED = cursor.getInt(4);
            record.UNITSKILLED = cursor.getInt(5);
            record.UNITSMADE = cursor.getInt(6);
            entries.add(record);
            cursor.moveToNext();
        }

        return entries;
    }

    public Entry GetSummedEntries() {
        List<Entry> entries = GetEntries();
        Entry rec = new Entry();
        rec.DAMAGEDEALT = 0.0;
        ;
        rec.DAMAGERECEIVED = 0.0;
        ;
        rec.DISTANCETRAVELLED = 0.0;
        ;
        rec.GOLDCOLLECTED = 0;
        rec.UNITSKILLED = 0;
        rec.UNITSMADE = 0;

        for (Entry ent : entries) {
            rec.DAMAGEDEALT += ent.DAMAGEDEALT;
            rec.DAMAGERECEIVED += ent.DAMAGERECEIVED;
            rec.DISTANCETRAVELLED += ent.DISTANCETRAVELLED;
            rec.GOLDCOLLECTED += ent.GOLDCOLLECTED;
            rec.UNITSKILLED += ent.UNITSKILLED;
            rec.UNITSMADE += ent.UNITSMADE;
        }

        return rec;
    }
}

Java Source Code List

• Back to Game/strategy  ↑