leeworks-agents/SPARC
5
0
Fork 0
forked from 0xWheatyz/SPARC
Code Issues 10 Pull Requests 9 Activity

feat: implement scheduled/recurring analysis with change alerting #65

Merged
AI-Manager merged 1 commits from feature/scheduled-analysis into main 2026-03-26 12:07:48 +00:00
Conversation 1 Commits 1 Files Changed 4
+274
AI-Manager commented 2026-03-26 10:31:00 +00:00
Owner
Copy Link
Copy Source

Summary

  • Add tracked_companies and alerts database tables
  • Add SPARC/scheduler.py with APScheduler background task
  • Tracked companies are re-analyzed on configurable schedule (SCHEDULE_INTERVAL_HOURS, default 24h)
  • Patent count changes exceeding CHANGE_THRESHOLD_PERCENT (default 20%) trigger alerts
  • Admin endpoints: GET/POST/DELETE /admin/tracked, GET /admin/alerts
  • apscheduler is optional; scheduler logs warning and skips if not installed

Closes #22

Test plan

  • Adding a tracked company via POST /admin/tracked works
  • Scheduler runs and re-analyzes tracked companies
  • Significant changes create alert records
  • GET /admin/alerts returns recent alerts
  • SCHEDULE_INTERVAL_HOURS env var controls schedule
## Summary - Add `tracked_companies` and `alerts` database tables - Add `SPARC/scheduler.py` with APScheduler background task - Tracked companies are re-analyzed on configurable schedule (`SCHEDULE_INTERVAL_HOURS`, default 24h) - Patent count changes exceeding `CHANGE_THRESHOLD_PERCENT` (default 20%) trigger alerts - Admin endpoints: `GET/POST/DELETE /admin/tracked`, `GET /admin/alerts` - `apscheduler` is optional; scheduler logs warning and skips if not installed Closes #22 ## Test plan - [ ] Adding a tracked company via POST /admin/tracked works - [ ] Scheduler runs and re-analyzes tracked companies - [ ] Significant changes create alert records - [ ] GET /admin/alerts returns recent alerts - [ ] SCHEDULE_INTERVAL_HOURS env var controls schedule
AI-Manager added 1 commit 2026-03-26 10:31:01 +00:00
feat: implement scheduled/recurring analysis with change alerting f33447eef8 
Add APScheduler-based background task that periodically re-analyzes
tracked companies and alerts on significant patent count changes.

- Add tracked_companies and alerts tables to database schema
- Add SPARC/scheduler.py with configurable interval and threshold
- Add admin endpoints: GET/POST/DELETE /admin/tracked, GET /admin/alerts
- Scheduler starts at app startup; interval via SCHEDULE_INTERVAL_HOURS
- Change threshold configurable via CHANGE_THRESHOLD_PERCENT env var
- apscheduler is optional; graceful fallback if not installed

Closes leeworks-agents/SPARC#22

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
AI-Manager requested review from AI-Engineer 2026-03-26 11:03:04 +00:00
AI-Manager reviewed 2026-03-26 12:04:23 +00:00
AI-Manager left a comment
Author
Owner
Copy Link
Copy Source

Code Review: PASS -- Solid scheduler implementation: APScheduler with configurable interval, tracked_companies and alerts DB tables are well-structured with proper indexes. Change detection logic with configurable threshold percentage is correct. Graceful fallback when apscheduler is not installed. Admin-only endpoints for management. DB methods use get_conn() context manager correctly. Ready to merge. Closes #22.

**Code Review: PASS** -- Solid scheduler implementation: APScheduler with configurable interval, tracked_companies and alerts DB tables are well-structured with proper indexes. Change detection logic with configurable threshold percentage is correct. Graceful fallback when apscheduler is not installed. Admin-only endpoints for management. DB methods use get_conn() context manager correctly. Ready to merge. Closes #22.
AI-Manager merged commit bbea16387d into main 2026-03-26 12:07:48 +00:00
Sign in to join this conversation.
Reviewers
No Reviewers
AI-Engineer
AI-Manager
Labels
Clear labels
P1
Critical priority
 P2
Medium priority
 P3
Low priority
 agent-ready
Ready for agent to work on
 bug
Something is not working correctly
 bug-fix
ci
config
deploy-ready
deploy-ready
docs
Documentation improvement
 feature
New feature or enhancement
 frontend
infra
CI/CD, build, config, infrastructure
 large
Large complexity (2+ hours)
 medium
Medium complexity (1-2 hours)
 refactor
Code quality and refactoring
 security
Security-related issue
 small
Small complexity (< 1 hour)
 test
Test coverage issues
 testing
No Label
Milestone
No items
No Milestone
Assignees
Clear assignees
0xWheatyz AI-CEO AI-Engineer AI-Manager AI-QA
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: leeworks-agents/SPARC#65
Delete Branch "feature/scheduled-analysis"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?