Unit testing - business logic and database layer

Objective This issue focuses on implementing comprehensive unit testing for the backend business logic and database/repository layers of the eHRS system. The goal is to ensure that core services and repository functions are validated against real-world scenarios, business rules, and edge cases.

Scope of Work

1. Write structured unit tests for:

• Doctor Service
• Medical Camp Service
• Medicine Service
• Consultation Queue Service
• Patient Consultation Service
• User Service
• Auth & API Route layers

2. Validate service-layer business logic workflows and edge cases
3. Test repository/database CRUD operations
4. Ensure proper constraint and integrity handling

Test Strategy ✔️ Valid Success Scenarios Correct workflow execution Expected business rule behavior Valid database interactions

❌ Intentional Failure Scenarios Business rule violations Invalid states and constraint failures Duplicate entries and invalid inputs

⚠️ Warning-Triggering Scenarios Deprecation alerts Logical edge cases Operational warnings

Structural Improvements

• Refactor existing tests to validate actual business logic instead of force-passing cases
• Implement centralized database session handling using conftest.py
• Apply clean Pytest structure and fixture reuse
• Ensure proper Pydantic schema validation testing
• Remove isolated “failure-only” and “warning-only” test files to maintain maintainable structure

Expected Outcome

• Balanced test coverage across success, failure, and warning cases
• Deterministic and isolated tests
• Accurate validation of business rules
• Improved reliability of the backend system
• A test suite that exposes logical gaps instead of masking them