MCP Logger

Instructions

Implementation Reference

• src/main.py:198-246 (handler)

  The `add_set` tool is defined here, which registers with the FastMCP app and handles inserting a new set into the database for a given `exercise_id`.

  def add_set(
      exercise_id: int,
      reps: Optional[float] = None,
      weight_kg: Optional[float] = None,
      weight_lbs: Optional[float] = None,
      distance_m: Optional[float] = None,
      distance_yards: Optional[float] = None,
      duration_s: Optional[float] = None,
      side: Optional[str] = None,
      rpe: Optional[float] = None,
      rir: Optional[float] = None,
      is_warmup: bool = False,
  ) -> dict[str, int]:
      """Add a set to an existing exercise.
      
      Args:
          exercise_id: ID of the exercise to add set to
          reps: Number of repetitions
          weight_kg: Weight in kilograms
          weight_lbs: Weight in pounds
          distance_m: Distance in meters
          distance_yards: Distance in yards
          duration_s: Duration in seconds
          side: 'left', 'right', or 'both' for unilateral exercises
          rpe: Rate of Perceived Exertion (1-10)
          rir: Reps In Reserve (0-5)
          is_warmup: Whether this is a warmup set
      """
      conn = get_connection()
      cursor = conn.cursor()
      
      # Get current max set_index
      cursor.execute("SELECT COALESCE(MAX(set_index), 0) FROM sets WHERE exercise_id = ?", (exercise_id,))
      max_set = cursor.fetchone()[0]
      
      cursor.execute(
          """INSERT INTO sets (
              exercise_id, set_index, reps, weight_kg, weight_lbs,
              distance_m, distance_yards, duration_s, side, rpe, rir, is_warmup
          ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)""",
          (
              exercise_id, max_set + 1, reps, weight_kg, weight_lbs,
              distance_m, distance_yards, duration_s, side, rpe, rir, 1 if is_warmup else 0
          ),
      )
      set_id = cursor.lastrowid
      conn.commit()
      conn.close()
      return {"set_id": set_id}