result-bitable-reporter
Filter rows from sqlite capture_results and report to Feishu Bitable with retry-safe sqlite writeback. Use for stat/filter/report/retry-reset workflows, especially task-scoped reporting with --task-id.
What this skill does
# Result Bitable Reporter Use this skill to run a deterministic `sqlite -> Feishu Bitable` pipeline around `capture_results`. ## Workflow 1) Select rows - `stat`: print total sqlite row count for one `--task-id`. - `filter`: preview upload candidates from `capture_results`. - Default status filter is `reported IN (0,-1)`. 2) Report rows - `report`: batch create to Feishu Bitable and write back sqlite status. - `--max-rows <n>` sets total cap for one report run. - For per-task workflows, always pass `--task-id <TASK_ID>` to avoid cross-task uploads. - Success writeback: `reported=1`, `reported_at=now_ms`, `report_error=NULL`. - Failure writeback: `reported=-1`, `reported_at=now_ms`, `report_error=<truncated error>`. 3) Retry failures - `retry-reset`: move failed rows (`reported=-1`) back to pending (`reported=0`), then rerun `report`. ## Run ```bash npx tsx scripts/result_reporter.ts <subcommand> [flags] ``` Use `npx tsx scripts/result_reporter.ts --help` as the CLI source of truth. ## Environment Variables Required for `report`: - `FEISHU_APP_ID` - `FEISHU_APP_SECRET` - `RESULT_BITABLE_URL` Optional overrides: - `FEISHU_BASE_URL` (default `https://open.feishu.cn`) - `TRACKING_STORAGE_DB_PATH` (default `$HOME/.eval/records.sqlite`) - `RESULT_SQLITE_TABLE` (default `capture_results`) ## Recommended Command Patterns Task-scoped preview: ```bash npx tsx scripts/result_reporter.ts filter --task-id <TASK_ID> --status 0,-1 --limit 20 ``` Task-scoped report: ```bash export FEISHU_APP_ID=<app_id> export FEISHU_APP_SECRET=<app_secret> export RESULT_BITABLE_URL='https://.../wiki/...?...table=tbl_xxx&view=vew_xxx' npx tsx scripts/result_reporter.ts report --task-id <TASK_ID> --batch-size 100 --max-rows 500 ``` Retry failed rows: ```bash npx tsx scripts/result_reporter.ts retry-reset --app com.tencent.mm --scene onSearch npx tsx scripts/result_reporter.ts report --task-id <TASK_ID> --status 0,-1 ``` ## Failure Handling - Use `report --dry-run` to validate selection before network writes. - Check sqlite `report_error` for root cause when `reported=-1`. - Fix root cause, then rerun `retry-reset` and `report`. ## Resources - `scripts/result_reporter.ts`: CLI behavior and flags. - `references/sqlite-and-field-mapping.md`: sqlite schema and field mapping. - `references/feishu-api-and-errors.md`: Feishu API contract and error triage.
Related in Productivity
gitea-workflow
IncludedOrchestrate agile development workflows for Gitea repositories using the tea CLI. Use when working with Gitea-hosted repos and asking to 'run the workflow', 'continue working', 'what's next', 'complete the task cycle', 'start my day', 'end the sprint', 'implement the next task', or wanting guided step-by-step development assistance. Keywords: workflow, orchestrate, agile, task cycle, sprint, daily, implement, review, PR, standup, retrospective, gitea, tea.
microsoft-graph-gateway
IncludedRoute Microsoft Graph work in this workspace. Use when users want to read or write Outlook mail, calendar events, contacts, OneDrive or SharePoint files, Teams, Planner, To Do, users, groups, directory data, or arbitrary Microsoft Graph endpoints from VS Code. Prefer WorkIQ for common read scenarios. Use Microsoft Graph for write actions and gap-read scenarios that need exact Graph properties, filters, permissions, or endpoints.
copilotkit
IncludedUse when building with CopilotKit — setup, development, integrations, debugging, upgrading, or contributing. Routes to the appropriate specialized skill based on the task.
wordly-wisdom
IncludedProvides calibrated decision analysis using Charlie Munger-style multiple mental models, inversion, incentive mapping, circle-of-competence checks, misjudgment audits, second-order effects, and forecast updates. Use when the user asks for an oracle take, a hard call, a decision memo, a premortem, an outside view, a red-team, a sanity-check, what am I missing, think this through, or wants a strategy, hire, investment, plan, product, partnership, or major life choice analysed. Avoid for simple factual lookups or time-sensitive legal, medical, or market questions without fresh evidence.
swain-session
IncludedSession management and project status dashboard. Owns the full session lifecycle (start/work/close/resume), focus lane, bookmarks, worktree detection, and tab naming. Also serves as the project status dashboard — shows active epics, progress, actionable next steps, blocked items, tasks, GitHub issues, and recommendations. Worktree creation is deferred to swain-do task dispatch (SPEC-195). Triggers on: 'session', 'status', 'what's next', 'dashboard', 'overview', 'where are we', 'what should I work on', 'show me priorities', 'bookmark', 'focus on', 'session info'.
gandi
IncludedComprehensive Gandi domain registrar integration for domain and DNS management. Register and manage domains, create/update/delete DNS records (A, AAAA, CNAME, MX, TXT, SRV, and more), configure email forwarding and aliases, check SSL certificate status, create DNS snapshots for safe rollback, bulk update zone files, and monitor domain expiration. Supports multi-domain management, zone file import/export, and automated DNS backups. Includes both read-only and destructive operations with safety controls.