Overview

Integration tests verify that the persistence layer works correctly with Spring Boot and Spring Data JPA, including entity mappings and repository queries executed against the test database. These tests are slower than unit tests but provide confidence that the repository layer behaves correctly in a realistic environment.

Implemented Integration Test Suites

• src/test/java/edu/tus/guitarstore/repository/GuitarRepositoryIntegrationTest.java
  Validates repository queries and persistence behaviour using Spring’s test support and the configured test database.
• src/test/java/edu/tus/guitarstore/repository/GuitarRepositoryTest.java
  Additional repository tests covering CRUD/query behaviour and mapping assumptions.
• src/test/java/edu/tus/guitarstore/config/TestJpaAuditingConfig.java
  Test-only auditing configuration required for entities that use auditing fields (e.g., created/updated metadata).

GuitarRepositoryIntegrationTests.java (Integration Tests)

1. Basic query behaviour (happy path + not found)
   • testFindByModelNameExactMatch()
   • testFindByModelNameNotFound()
2. Query correctness with multiple records (precision / false positives)
   • testFindByModelNameAmongMultipleRecords()
   • testFindByModelNameDoesNotReturnSimilarNames()
3. Data integrity / constraints (database rules)
   • testModelNameUniqueConstraint()
4. Mapping completeness (all columns / attributes)
   • testFindByModelNameRetrievesAllAttributes()
5. Relationships (Brand association correctness)
   • testFindByModelNamePreservesBrandRelationship()
6. Optional semantics / repository contract behaviour
   • testFindByModelNameReturnsIndependentOptionals()
7. Edge cases in querying (case sensitivity, special characters)
   • testFindByModelNameCaseSensitivity()
   • testFindByModelNameWithSpecialCharacters()
8. JPA fetch strategy / lazy loading behaviour
   • testFindByModelNameBrandLazyLoading()

GuitarRepositoryTest.java (Mock-based “Unit-Style” Repository Tests)

1. Basic query behaviour (happy path + not found)
   • testFindByModelNameSuccess()
   • testFindByModelNameNotFound()
2. Multiple calls / different inputs (repository contract behaviour)
   • testFindByModelNameMultipleCalls()
3. Entity integrity (returned object contains expected fields)
   • testFindByModelNameEntityIntegrity()