MCP Logger

Instructions

Implementation Reference

• src/main.py:379-392 (handler)

  The handler for the 'upsert_nutrition_day' tool, which inserts or updates a nutrition day record in the database.

  @app.tool()
  def upsert_nutrition_day(date: str, notes: Optional[str] = None) -> dict[str, int]:
      """Create or update a nutrition day entry."""
      date = _ensure_date(date)
      conn = get_connection()
      cursor = conn.cursor()
      cursor.execute(
          "INSERT INTO nutrition_days (date, notes) VALUES (?, ?) ON CONFLICT(date) DO UPDATE SET notes = ?",
          (date, notes, notes),
      )
      day_id = cursor.lastrowid or cursor.execute("SELECT id FROM nutrition_days WHERE date = ?", (date,)).fetchone()[0]
      conn.commit()
      conn.close()
      return {"day_id": day_id}