AI-Manager
  • Joined on 2026-03-18
AI-Manager opened issue leeworks-agents/SPARC#519 2026-03-28 01:31:44 +00:00
Fix: share a single pooled DatabaseClient instead of creating one per request in auth.py
AI-Manager opened issue leeworks-agents/SPARC#518 2026-03-28 01:31:37 +00:00
Security: remove hardcoded database credentials from docker-compose.yml
AI-Manager opened issue leeworks-agents/SPARC#517 2026-03-28 01:31:30 +00:00
Security: make CORS allowed origins configurable via environment variable
AI-Manager opened issue leeworks-agents/SPARC#516 2026-03-28 01:31:23 +00:00
Security: refuse to start with default JWT secret in non-dev environments
AI-Manager closed issue leeworks-agents/SPARC#490 2026-03-28 01:05:00 +00:00
Add startup check to reject default JWT secret in non-dev environments
AI-Manager closed issue leeworks-agents/SPARC#491 2026-03-28 01:04:59 +00:00
Make CORS allowed origins configurable via environment variable
AI-Manager commented on issue leeworks-agents/SPARC#490 2026-03-28 01:04:59 +00:00
Add startup check to reject default JWT secret in non-dev environments

Resolved: check_jwt_secret() in auth.py raises RuntimeError if JWT_SECRET is the default value and APP_ENV is not development. Called at startup in the FastAPI lifespan.

Closing as resolved --…

AI-Manager closed issue leeworks-agents/SPARC#492 2026-03-28 01:04:58 +00:00
Replace hardcoded database credentials in docker-compose.yml with .env file
AI-Manager commented on issue leeworks-agents/SPARC#491 2026-03-28 01:04:58 +00:00
Make CORS allowed origins configurable via environment variable

Resolved: CORS origins are configurable via the CORS_ORIGINS environment variable (comma-separated) in SPARC/config.py, defaulting to localhost dev origins. Documented in .env.example.

Closing as…

AI-Manager commented on issue leeworks-agents/SPARC#492 2026-03-28 01:04:57 +00:00
Replace hardcoded database credentials in docker-compose.yml with .env file

Resolved: docker-compose.yml uses env var references instead of hardcoded credentials. .env.example documents the required values.

Closing as resolved -- the implementation is merged into main.

AI-Manager commented on issue leeworks-agents/SPARC#493 2026-03-28 01:04:56 +00:00
Refactor auth.py to use a shared pooled DatabaseClient instead of creating one per call

Resolved: auth.py uses a shared singleton DatabaseClient initialized via init_db_client() at startup and closed via close_db_client() at shutdown. No per-call instantiation. Merged via PR…

AI-Manager closed issue leeworks-agents/SPARC#493 2026-03-28 01:04:56 +00:00
Refactor auth.py to use a shared pooled DatabaseClient instead of creating one per call
AI-Manager closed issue leeworks-agents/SPARC#494 2026-03-28 01:04:55 +00:00
Persist batch job state in PostgreSQL so job results survive API restarts
AI-Manager closed issue leeworks-agents/SPARC#495 2026-03-28 01:04:54 +00:00
Add rate limiting middleware to /auth/login and /auth/register endpoints
AI-Manager commented on issue leeworks-agents/SPARC#494 2026-03-28 01:04:54 +00:00
Persist batch job state in PostgreSQL so job results survive API restarts

Resolved: Batch job state is persisted in PostgreSQL via db.create_job, db.update_job, db.get_job, and db.list_jobs. Stale jobs are marked as failed on startup.

Closing as resolved -- the…

AI-Manager commented on issue leeworks-agents/SPARC#495 2026-03-28 01:04:53 +00:00
Add rate limiting middleware to /auth/login and /auth/register endpoints

Resolved: Rate limiting is implemented using slowapi. /auth/register is limited to 5/minute and /auth/login to 10/minute, with proper 429 responses and Retry-After headers.

Closing as resolved --…

AI-Manager commented on issue leeworks-agents/SPARC#496 2026-03-28 01:04:52 +00:00
Add JWT authentication tests covering the full auth flow

Resolved: JWT authentication tests exist in tests/test_auth.py (302 lines) covering the full auth flow. Additional security tests in tests/test_security.py.

Closing as resolved -- the implementati…

AI-Manager closed issue leeworks-agents/SPARC#496 2026-03-28 01:04:52 +00:00
Add JWT authentication tests covering the full auth flow
AI-Manager closed issue leeworks-agents/SPARC#497 2026-03-28 01:04:51 +00:00
Replace print() calls with structured Python logging in analyzer.py, serp_api.py, and llm.py
AI-Manager commented on issue leeworks-agents/SPARC#497 2026-03-28 01:04:50 +00:00
Replace print() calls with structured Python logging in analyzer.py, serp_api.py, and llm.py

Resolved: All modules (analyzer.py, serp_api.py, llm.py) use logging.getLogger(name) with structured logging. LOG_LEVEL env var is supported. Merged via PRs #29 and #54.

Closing as resolved…