Exemplo n.º 1
0
  public List<Exercise> getAllExerciseDetails() {
    List<Exercise> exercises = new ArrayList<>();
    String selectQuery =
        "SELECT "
            + KEY_ID
            + ", "
            + KEY_NAME
            + ", "
            + KEY_DESCRIPTION
            + ", "
            + TABLE_EXERCISE_CATEGORY
            + KEY_NAME
            + " FROM "
            + TABLE_EXERCISE_DETAIL
            + " INNER JOIN "
            + TABLE_EXERCISE_DETAIL_CATEGORY
            + " ON "
            + KEY_ID
            + " = "
            + TABLE_EXERCISE_DETAIL
            + KEY_ID;

    SQLiteDatabase db = this.getWritableDatabase();
    Cursor c = db.rawQuery(selectQuery, null);

    int id;
    Exercise exercise;
    if (c.moveToFirst()) {
      do {
        id = c.getInt(c.getColumnIndex(KEY_ID));
        exercise = Exercise.getById(exercises, id);
        if (exercise == null) {
          exercise = new Exercise();
          exercise.setId(id);
          exercise.setName(c.getString(c.getColumnIndex(KEY_NAME)));
          exercise.setDescription(c.getString(c.getColumnIndex(KEY_DESCRIPTION)));
          exercise
              .getCategories()
              .add(
                  Category.valueOf(
                      c.getString(c.getColumnIndex(TABLE_EXERCISE_CATEGORY + KEY_NAME))));

          exercises.add(exercise);
        } else {
          exercise
              .getCategories()
              .add(
                  Category.valueOf(
                      c.getString(c.getColumnIndex(TABLE_EXERCISE_CATEGORY + KEY_NAME))));
        }
      } while (c.moveToNext());
    }
    c.close();
    return exercises;
  }
Exemplo n.º 2
0
  public void updateExerciseDetail(Exercise exercise) {
    SQLiteDatabase db = this.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(KEY_DESCRIPTION, exercise.getDescription());

    db.update(TABLE_EXERCISE_DETAIL, values, KEY_NAME + " = ?", new String[] {exercise.getName()});

    deleteExerciseDetailCategory(exercise.getId());
    for (Category category : exercise.getCategories()) {
      createExerciseDetailCategory(exercise.getId(), category);
    }
  }
Exemplo n.º 3
0
  public void createExerciseDetail(Exercise exercise) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    values.put(KEY_NAME, exercise.getName());
    values.put(KEY_DESCRIPTION, exercise.getDescription());

    exercise.setId((int) db.insert(TABLE_EXERCISE_DETAIL, null, values));

    for (Category category : exercise.getCategories()) {
      createExerciseDetailCategory(exercise.getId(), category);
    }
  }