// Return all ScavItems in table
public List<ScavItem> getAllScavItems() {
List<ScavItem> scavItemList = new ArrayList<ScavItem>();
// Select entire table
String selectQuery = "SELECT * FROM " + TABLE_SCAV_ITEMS;
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
// Loop through all rows in cursor object, add them to list
if (cursor.moveToFirst()) {
do {
ScavItem scavItem = new ScavItem();
scavItem.set_id(Integer.parseInt(cursor.getString(0)));
scavItem.set_name(cursor.getString(1));
scavItem.set_address(cursor.getString(2));
scavItem.set_directions(cursor.getString(3));
scavItem.set_image(Integer.parseInt(cursor.getString(4)));
// Add ScavItem to list
scavItemList.add(scavItem);
} while (cursor.moveToNext());
}
cursor.close();
db.close();
return scavItemList;
}
