public List<Players> getAllPlayers() {
if (_local) {
SQLiteDatabase db = this.getReadableDatabase();
List<Players> players = new ArrayList<Players>();
String selectPlayerQuery = "SELECT * FROM " + TABLE_PLAYERS;
Log.i(LOG, selectPlayerQuery);
Cursor c = db.rawQuery(selectPlayerQuery, null);
if (c != null && c.moveToFirst()) {
do {
// create the instance of Players using cursor information
Players player = new Players();
player.setpid(c.getLong(c.getColumnIndex(KEY_P_ID)));
player.settid(c.getLong(c.getColumnIndex(KEY_T_ID)));
player.setpname((c.getString(c.getColumnIndex(KEY_P_NAME))));
player.setpnum((c.getInt(c.getColumnIndex(KEY_P_NUM))));
// adding to players list
players.add(player);
} while (c.moveToNext());
}
return players;
} else {
return _net.getAllPlayers();
}
}
