// 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; }