Create test fixtures for cross-resource reports API

[halsk]

Description

We need to create comprehensive test fixtures for the cross-resource reports API to ensure proper test coverage and reliability.

Requirements

Test Database Setup

• Create fixtures that generate test teams, users, and cross-resource reports
• Ensure proper database session handling for test transactions
• Set up appropriate teardown to clean up after tests

Authentication Fixtures

• Extend existing team_auth_headers fixture to support different permission levels
• Create fixtures for admin, regular user, and unauthorized access scenarios

Mock Service Dependencies

• Implement mocks for any background tasks or external service dependencies
• Create fixtures for simulating report generation processes

Test Data Creation

• Develop fixtures for creating sample reports with various statuses
• Create fixtures for resource analyses with different types and statuses
• Set up proper relationships between teams, reports, and analyses

Implementation Details

• Fixtures should be isolated to prevent test interference
• Each fixture should be well-documented with clear purpose
• Tests should be updated to use the new fixtures
• Consider using factory pattern for flexible test data generation

Acceptance Criteria

• All tests for the cross-resource reports API should pass
• Test coverage for the API should be at least 80%
• Fixtures should be reusable for future related features
• CI pipeline should successfully run all tests

Related Issues

• Add API endpoints for cross-resource reports #229: Add API endpoints for cross-resource reports

Estimated Effort

• 4-7 hours