public void GivenResourceRelatedTables_WhenNewIndexesAdded_BulkImportOperationShouldSupportNewIndexes()
{
Table[] resourceRelatedTables = new Table[]
{
VLatest.Resource,
VLatest.ResourceWriteClaim,
VLatest.CompartmentAssignment,
VLatest.DateTimeSearchParam,
VLatest.NumberSearchParam,
VLatest.QuantitySearchParam,
VLatest.ReferenceSearchParam,
VLatest.ReferenceTokenCompositeSearchParam,
VLatest.StringSearchParam,
VLatest.TokenDateTimeCompositeSearchParam,
VLatest.TokenNumberNumberCompositeSearchParam,
VLatest.TokenQuantityCompositeSearchParam,
VLatest.TokenSearchParam,
VLatest.TokenStringCompositeSearchParam,
VLatest.TokenText,
VLatest.TokenTokenCompositeSearchParam,
VLatest.UriSearchParam,
};
string[] excludeIndexNames = new string[]
{
"IX_Resource_ResourceTypeId_ResourceId_Version",
"IX_Resource_ResourceTypeId_ResourceId",
"IX_Resource_ResourceTypeId_ResourceSurrgateId",
"UQIX_Resource_ResourceSurrogateId",
};
string[] supportedIndexesNames = _sqlServerFhirDataBulkOperation.IndexesList().Select(i => i.index.IndexName).ToArray();
int expectedIndexesCount = 0;
foreach (Table table in resourceRelatedTables)
{
string[] indexNames = table.GetType().GetFields(BindingFlags.Instance | BindingFlags.NonPublic).Where(f => (f.Name.StartsWith("IX_") || f.Name.StartsWith("UQIX_"))).Select(f => f.Name).ToArray();
foreach (string indexName in indexNames)
{
if (excludeIndexNames.Contains(indexName))
{
continue;
}
Assert.Contains(indexName, supportedIndexesNames);
expectedIndexesCount++;
}
}
Assert.Equal(expectedIndexesCount, supportedIndexesNames.Length);
}
