umputun / tg-spam / 18640987819

83%

push

github

feat(reports): implement user spam reporting feature (#322)

* docs(plan): add user spam reporting feature implementation plan

add comprehensive plan for /report command allowing regular users to report
spam messages for admin review. key features:

- separate Reports storage module in storage/reports.go
- configurable report threshold and rate limiting
- admin notification with approve/reject/ban reporter buttons
- deduplication of reports for same message
- follows existing storage patterns (ApprovedUsers, DetectedSpam)

technical details:
- new reports table with proper indexing and GID support
- admin_msg_id DEFAULT 0 to avoid NULL handling issues
- INSERT...ON CONFLICT...DO NOTHING for duplicate prevention
- report cleanup after 7 days if threshold not reached

plan includes 11 iterations with detailed implementation steps and patterns

* feat(storage): implement reports storage for user spam reporting

add Reports storage implementation with full PostgreSQL and SQLite support:
- Report struct with explicit notification_sent flag and admin_msg_id fields
- CRUD operations: Add, GetByMessage, GetReporterCountSince, UpdateAdminMsgID, DeleteReporter, DeleteByMessage
- automatic cleanup of old unreported reports (7-day expiration)
- Reports interface in events package with generated mocks
- comprehensive test coverage on both SQLite and PostgreSQL
- database-agnostic query handling with r.Adopt() for placeholder conversion

related to user spam reporting feature (iteration 1 complete)

* feat(reports): add configuration and rate limiting for user spam reporting

implement iteration 2 of user spam reporting feature:
- add report configuration struct with threshold, rate limit, and rate period fields
- create reports storage instance and wire to telegram listener and admin handler
- implement checkReportRateLimit method with proper validation and error handling
- add comprehensive tests covering all rate limiting scenarios
- update plan documentation w... (continued)

616 of 768 new or added lines in 6 files covered. (80.21%)

6149 of 7516 relevant lines covered (81.81%)

273.89 hits per line