예제 #1
0
  public ArrayList getAll() {
    ArrayList<Recipe> list = new ArrayList<Recipe>();
    db.open();
    Cursor cursor = db.fetchAll(KEY_TABLE_NAME);
    if (cursor == null || cursor.getCount() < 1) return null;
    cursor.moveToFirst();

    /*Get column IDs*/
    int col_name = cursor.getColumnIndex(KEY_NAME);
    int col_category = cursor.getColumnIndex(KEY_CATEGORY);
    int col_ingredients = cursor.getColumnIndex(KEY_INGREDIENTS);
    int col_instructions = cursor.getColumnIndex(KEY_INSTRUCTIONS);
    int col__id = cursor.getColumnIndex(KEY__ID);
    do {
      Recipe recipe = new Recipe();

      recipe.name = cursor.getString(col_name);
      recipe.category = cursor.getString(col_category);
      recipe.ingredients = cursor.getString(col_ingredients);
      recipe.instructions = cursor.getString(col_instructions);
      recipe._id = cursor.getInt(col__id);
      Log.e("Test:RECIPE - id", cursor.getInt(col__id) + "");
      list.add(recipe);
    } while (cursor.moveToNext());
    db.close();
    return list;
  }
예제 #2
0
 public Recipe get(int id) {
   Recipe recipe;
   db.open();
   Cursor cursor = db.fetch(KEY_TABLE_NAME, id);
   if (cursor == null || cursor.getCount() < 1) return null;
   cursor.moveToFirst();
   /*Get column IDs*/
   int col_name = cursor.getColumnIndex(KEY_NAME);
   int col_category = cursor.getColumnIndex(KEY_CATEGORY);
   int col_ingredients = cursor.getColumnIndex(KEY_INGREDIENTS);
   int col_instructions = cursor.getColumnIndex(KEY_INSTRUCTIONS);
   int col__id = cursor.getColumnIndex(KEY__ID);
   do {
     recipe = new Recipe();
     recipe.name = cursor.getString(col_name);
     recipe.category = cursor.getString(col_category);
     recipe.ingredients = cursor.getString(col_ingredients);
     recipe.instructions = cursor.getString(col_instructions);
     recipe._id = Integer.parseInt(cursor.getString(col__id));
   } while (cursor.moveToNext());
   db.close();
   return recipe;
 }