示例#1
0
  public ExeciseSet getExerciseSetSet(int exerciseId, int order) {
    SQLiteDatabase db = this.getWritableDatabase();
    String query =
        "SELECT * FROM "
            + TABLE_EXERCISE_SET_REPETITIONS
            + " WHERE "
            + TABLE_EXERCISE_DETAIL
            + KEY_ID
            + " = "
            + exerciseId
            + " ORDER BY "
            + KEY_DATE
            + " DESC";

    Cursor c = db.rawQuery(query, null);
    ExeciseSet exerciseSet = new ExeciseSet();

    int i = 0;
    while (c.moveToNext()) {
      if (i == order) {
        exerciseSet.setWeight(c.getInt(c.getColumnIndex(KEY_WEIGHT)));
        exerciseSet.setRepetition(c.getInt(c.getColumnIndex(KEY_REPETITIONS)));
        c.close();
        return exerciseSet;
      } else {
        i++;
      }
    }
    c.close();
    return null;
  }
示例#2
0
  public void saveExerciseSet(List<Exercise> exrcises) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values;
    for (Exercise exercise : exrcises) {

      for (ExeciseSet exerciseSet : exercise.getAllSets()) {
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Date date = new Date();
        values = new ContentValues();

        values.put(TABLE_EXERCISE_DETAIL + KEY_ID, exercise.getId());
        values.put(KEY_WEIGHT, exerciseSet.getWeight());
        values.put(KEY_REPETITIONS, exerciseSet.getRepetition());
        values.put(KEY_DATE, dateFormat.format(date));
        db.insert(TABLE_EXERCISE_SET_REPETITIONS, null, values);
      }
    }
  }