report-active-reviews

# Report Active Reviews ## When to Use - Listing which API reviews were active during a time period - Checking which packages were reviewed for a specific language - Verifying which revisions were approved vs unapproved - Investigating review activity for a language ## Defaults Unless the user says otherwise, always apply these defaults: - **Environment**: `production` - **Summary**: Include `--summary` for a quick overview (skip if user asks for full details or JSON) - **Approved only**: Do NOT pass `--approved-only` unless the user explicitly asks ## Date Resolution The user will typically specify a calendar month by name (e.g. "March", "January 2025"). Resolve to the full month date range: | User says | start_date | end_date | |-----------|-----------|----------| | "March" (current year) | `YYYY-03-01` | `YYYY-03-31` | | "January 2025" | `2025-01-01` | `2025-01-31` | | "March 1 to March 15" | `YYYY-03-01` | `YYYY-03-15` | When only a month name is given without a year, use the current year. Be careful with month lengths (28/29/30/31 days). ## Language The `--language` flag is **optional**. If omitted, the command returns results for all languages. When a language is provided, results are filtered to that language only. ## Running the Command ### Step 1: Run the Command Show the resolved command and run it immediately in a **foreground terminal** with a **120-second timeout** (`timeout: 120000`). Always redirect output to a file so follow-up questions can be answered without re-querying. **Full terminal command** (cleanup + run): ```powershell New-Item -ItemType Directory -Path output -Force | Out-Null; if (Test-Path output/active_reviews_output.txt) { Remove-Item output/active_reviews_output.txt }; python cli.py report active-reviews -s <start_date> -e <end_date> -l <language> --summary 2>&1 | Out-File -Encoding UTF8 output/active_reviews_output.txt ``` After the command completes, **read the output file** with `read_file` to get the results. Summarize the findings for the user. For **JSON mode** (no `--summary`), use `.json` extension and do NOT use `2>&1`: ```powershell New-Item -ItemType Directory -Path output -Force | Out-Null; if (Test-Path output/active_reviews_output.json) { Remove-Item output/active_reviews_output.json }; python cli.py report active-reviews -s <start_date> -e <end_date> -l <language> | Out-File -Encoding UTF8 output/active_reviews_output.json ``` ### Step 2: Answer Follow-up Questions For follow-up questions about the same data (filtering, counting, searching), **read the output file** with `read_file` instead of re-running the command. The file is at `output/active_reviews_output.txt` (summary) or `output/active_reviews_output.json` (JSON). ### Examples ```powershell # Python reviews for March 2025 (summary) python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l python --summary # C# reviews, approved only python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l dotnet --approved-only --summary # Full JSON output for Java python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l java # Staging environment python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l python --summary --environment staging ``` ## Available Flags | Flag | Type | Default | Description | |------|------|---------|-------------| | `--start-date` / `-s` | string | required | Start date (`YYYY-MM-DD`) | | `--end-date` / `-e` | string | required | End date (`YYYY-MM-DD`) | | `--language` / `-l` | string | `None` | Language to filter by (e.g., `python`, `Go`, `C#`). If omitted, returns all languages. | | `--environment` | string | `production` | `production` or `staging` | | `--summary` | flag | off | Table format instead of JSON (package, version, status, copilot) | | `--approved-only` | flag | off | Show only approved revisions | ## Output Formats - **Summary mode** (`--summary`): Formatted table with PACKAGE, VERSION, STATUS (APPROVED/unapproved), COPILOT (YES/no), TYPE, APPROVED timestamp. - **JSON mode** (default): Array of objects with `review_id`, `name`, and `revisions` list. ## Gotchas - **Use `python cli.py` not `.\avc`**: The `avc.bat` script may resolve to system Python. - **Month end dates**: February has 28/29 days, April/June/Sept/Nov have 30 days.