SQL Test Coverage

[JeremyCaney]

Recent and upcoming changes to the core data-loading stored procedures, including a brand-new one that powers sitemaps, currently have no automated test coverage. These tests require Visual Studio's SQL testing tooling, which doesn't run from the command line, so it must be authored manually in the designer (Windows only).

Tests

GetTopics stored procedure

• TopicPayload.Children and/or depth: 1 options (@Depth; Allow specifying depth of ITopicRepository.Load() #120)
• Loading ascendants, including that a shared ancestor isn't duplicated (@LoadAscendants)
• Loading a single topic, without traversal
• Excluding extended attributes, confirming the flag is calculated correctly for both populated and empty content (@IncludeExtended, HasExtendedAttributes)
• Additional data-inclusion toggles:
  • Indexed attributes (@IncludeIndexed)
  • Relationships (@IncludeRelationships)
  • References (@IncludeReferences)
  • Version History (@IncludeHistory)
• Bulk-loading procedure (see Batch load Deferred associations #127)
• Extend the existing default-load test to also confirm the "loaded" vs. "calculated" flag distinction (dbo_GetTopicsTest)

GetSitemap stored procedure

• Sitemap loading, including its attribute filtering