PPLX-72 - trckr

← PPLX-72

feature,backend,database,deep-research

Created: 2025-12-21 • Updated: 2025-12-21

Relationships Loading...

Mark deep research queries separately in database with a flag for filtering in research library.

## Implementation
- Add `is_research_report` boolean field to Query model (default=False)
- Auto-set to True when mode='research' AND model='sonar-deep-research'
- Create Alembic migration to add column
- Add database index on is_research_report for faster filtering
- Update query creation logic in crud.py to set flag
- Backfill existing research queries if needed

## Migration
```python
# Add column
op.add_column('queries', sa.Column('is_research_report', sa.Boolean(), nullable=False, server_default='false'))
# Add index
op.create_index('ix_queries_is_research_report', 'queries', ['is_research_report'])
```

## Files to Modify
- backend/models.py (Query model)
- backend/crud.py (create_query function)
- backend/alembic/versions/XXXXX_add_research_report_flag.py (new migration)

## Acceptance Criteria
- Database migration runs successfully
- Research queries are flagged correctly
- Can filter queries by is_research_report
- Existing queries default to False
- Index improves query performance
- Backend tests cover flag logic
- No breaking changes

Pull Requests (comma-separated URLs)

Attachments

Comments (1)

agent · 2025-12-21

## Implementation Complete ### Changes Made **Models (backend/models.py:77-78)** - Added is_research_report boolean column to Query model with nullable=False and default=False - Added index ix_queries_is_research_report for faster filtering **CRUD (backend/crud.py:157-158, 172)** - Modified create_query() to auto-set is_research_report=True when mode='research' AND model_used='sonar-deep-research' **Migration (backend/alembic/versions/e2f3a4b5c6d7_add_research_report_flag.py)** - Created new migration that adds is_research_report column with server_default='false' - Creates index for the new column - Backfills existing research queries **Research Reports API (backend/crud.py:628-629)** - Updated get_research_reports() to filter by is_research_report=True instead of mode='labs' - This uses the indexed column for better query performance ### Tests Added/Updated - Added 9 new tests in test_crud.py for flag logic - Updated 5 tests in test_research_reports.py to use mode='research' ### Verification - All 281 backend tests pass - Migration includes proper up/down migrations - Backfill handles existing data