// Get all GameStats
public List<HockeyGameStats> getAllGameStats() {
List<HockeyGameStats> gameStats = new ArrayList<HockeyGameStats>();
SQLiteDatabase db = this.getReadableDatabase();
String selectQuery = "SELECT * FROM " + TABLE_HOCKEY_GAME_STATS;
Log.i(LOG, selectQuery);
Cursor c = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (c.moveToFirst()) {
do {
// create the instance of Games using cursor information
HockeyGameStats stats = new HockeyGameStats();
stats.setgid(c.getLong(c.getColumnIndex(KEY_G_ID)));
stats.setpid(c.getLong(c.getColumnIndex(KEY_P_ID)));
stats.setshots((c.getInt(c.getColumnIndex(KEY_SHOTS))));
stats.setsog((c.getInt(c.getColumnIndex(KEY_SOG))));
stats.setgoals(c.getInt(c.getColumnIndex(KEY_GOALS)));
stats.setast((c.getInt(c.getColumnIndex(KEY_AST))));
stats.setpenminor((c.getInt(c.getColumnIndex(KEY_PEN_MINOR))));
stats.setpenmajor(c.getInt(c.getColumnIndex(KEY_PEN_MAJOR)));
stats.setpenmisconduct(c.getInt(c.getColumnIndex(KEY_PEN_MISCONDUCT)));
stats.setsaves((c.getInt(c.getColumnIndex(KEY_SAVES))));
stats.setgoalsallowed((c.getInt(c.getColumnIndex(KEY_GOALS_ALLOWED))));
// Insert more stats here
// adding to gameStats list
gameStats.add(stats);
} while (c.moveToNext());
}
return gameStats;
}
// get single game stats for single player
public HockeyGameStats getPlayerGameStats(long g_id, long p_id) {
SQLiteDatabase db = this.getReadableDatabase();
// create query to select game
String selectQuery =
"SELECT * FROM "
+ TABLE_HOCKEY_GAME_STATS
+ " WHERE "
+ KEY_G_ID
+ " = "
+ g_id
+ " AND "
+ KEY_P_ID
+ " = "
+ p_id;
// Log the query
Log.i(LOG, selectQuery);
// perform the query and store data in cursor
Cursor c = db.rawQuery(selectQuery, null);
// set cursor to beginning
if (c != null) c.moveToFirst();
// create the instance of Games using cursor information
HockeyGameStats stats = new HockeyGameStats();
stats.setgid(c.getLong(c.getColumnIndex(KEY_G_ID)));
stats.setpid(c.getLong(c.getColumnIndex(KEY_P_ID)));
stats.setshots((c.getInt(c.getColumnIndex(KEY_SHOTS))));
stats.setsog((c.getInt(c.getColumnIndex(KEY_SOG))));
stats.setgoals(c.getInt(c.getColumnIndex(KEY_GOALS)));
stats.setast((c.getInt(c.getColumnIndex(KEY_AST))));
stats.setpenminor((c.getInt(c.getColumnIndex(KEY_PEN_MINOR))));
stats.setpenmajor(c.getInt(c.getColumnIndex(KEY_PEN_MAJOR)));
stats.setpenmisconduct(c.getInt(c.getColumnIndex(KEY_PEN_MISCONDUCT)));
stats.setsaves((c.getInt(c.getColumnIndex(KEY_SAVES))));
stats.setgoalsallowed((c.getInt(c.getColumnIndex(KEY_GOALS_ALLOWED))));
// Insert more stats here
return stats;
}
