public Exercise getExerciseDetail(int id) {
SQLiteDatabase db = this.getWritableDatabase();
String selectQuery = "SELECT * FROM " + TABLE_EXERCISE_DETAIL + " WHERE " + KEY_ID + " = " + id;
Cursor c = db.rawQuery(selectQuery, null);
if (c != null) c.moveToFirst();
Exercise exercise = new Exercise();
exercise.setId(c.getInt(c.getColumnIndex(KEY_ID)));
exercise.setName(c.getString(c.getColumnIndex(KEY_NAME)));
exercise.setDescription(c.getString(c.getColumnIndex(KEY_DESCRIPTION)));
selectQuery =
"SELECT * FROM "
+ TABLE_EXERCISE_DETAIL_CATEGORY
+ " WHERE "
+ TABLE_EXERCISE_DETAIL
+ KEY_ID
+ " = "
+ exercise.getId();
c.close();
c = db.rawQuery(selectQuery, null);
while (c.moveToNext()) {
exercise.addCategory(
Category.valueOf(c.getString(c.getColumnIndex(TABLE_EXERCISE_CATEGORY + KEY_NAME))));
}
c.close();
return exercise;
}
