public void setFridge(Set<Ingredient> ingredients) { db.delete(DBHelper.fridgeTableName, null, null); ContentValues cv = new ContentValues(); for (Ingredient ingredient : ingredients) { cv.put(DBHelper.ingredientIdColName, ingredient.getId()); cv.put(DBHelper.ingredientNameColName, ingredient.getName()); db.insert(DBHelper.fridgeTableName, null, cv); } }
public Set<Ingredient> getFridge() { Set<Ingredient> fridge = null; Cursor cursor = db.rawQuery("select * from " + DBHelper.fridgeTableName, null); if (cursor.moveToFirst()) { fridge = new HashSet<Ingredient>(); int ingredientIdColIndex = cursor.getColumnIndex(DBHelper.ingredientIdColName); int ingredientNameColIndex = cursor.getColumnIndex(DBHelper.ingredientNameColName); do { String ingedientId = cursor.getString(ingredientIdColIndex); String ingredientName = cursor.getString(ingredientNameColIndex); Ingredient ingredient = new Ingredient(); ingredient.setId(ingedientId); ingredient.setName(ingredientName); fridge.add(ingredient); } while (cursor.moveToNext()); } cursor.close(); return fridge; }