Context

PR #2507 updated unique constraints for Resources and Prompts to include gateway_id, allowing the same uri/name to exist across different gateways for the same team/owner.

Missing Test Coverage

1. Resources - Gateway Namespacing

• Test: Same uri can be registered for different gateways (same team/owner)
• Test: Same uri cannot be registered for the same gateway (same team/owner)
• Test: Local resources (gateway_id=NULL) still enforce uniqueness per team/owner

2. Prompts - Gateway Namespacing

• Test: Same name can be registered for different gateways (same team/owner)
• Test: Same name cannot be registered for the same gateway (same team/owner)
• Test: Local prompts (gateway_id=NULL) still enforce uniqueness per team/owner

3. Migration Idempotency

• Test: Migration can run on fresh DB (tables from models.py)
• Test: Migration can run on existing DB (upgrade path)
• Test: Migration downgrade works correctly

Suggested Test Location

• tests/unit/mcpgateway/services/test_resource_service.py
• tests/unit/mcpgateway/services/test_prompt_service.py
• tests/unit/mcpgateway/db/ (for migration tests)

Related

• PR Consistent duplicate constraints/working in tools, prompts and resources #2507
• Issue [BUG]: Multiple gateway import failing with unique constraint error for resources #2352