Index: Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo212IntegrationTest.cs =================================================================== diff -u -r8dcce8b9957cc35a8425fc206c78b9e6bbf46e83 -ra03304f0aa0f2ea003667e746b4813d56c4a061c --- Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo212IntegrationTest.cs (.../MigrationTo212IntegrationTest.cs) (revision 8dcce8b9957cc35a8425fc206c78b9e6bbf46e83) +++ Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo212IntegrationTest.cs (.../MigrationTo212IntegrationTest.cs) (revision a03304f0aa0f2ea003667e746b4813d56c4a061c) @@ -309,8 +309,62 @@ "AND NEW.[FailurePathAssemblyProbabilityResultType] = 1 " + "AND NEW.[ManualFailurePathAssemblyProbability] IS NULL; " + "DETACH SOURCEPROJECT;"; + + for (var i = 1; i < 13; i++) + { + string validateFailureMechanism2 = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = " + + "(" + + "SELECT COUNT() " + + "FROM SOURCEPROJECT.FailureMechanismEntity " + + "WHERE [FailureMechanismType] = {0} " + + ") " + + "FROM FailureMechanismEntity NEW " + + "JOIN SOURCEPROJECT.FailureMechanismEntity OLD USING(FailureMechanismEntityId) " + + "WHERE NEW.[AssessmentSectionEntityId] = OLD.[AssessmentSectionEntityId] " + + "AND NEW.[CalculationGroupEntityId] IS OLD.[CalculationGroupEntityId] " + + "AND NEW.[FailureMechanismType] = {0} " + + "AND NEW.[InAssembly] = OLD.[IsRelevant] " + + "AND NEW.[FailureMechanismSectionCollectionSourcePath] IS OLD.[FailureMechanismSectionCollectionSourcePath] " + + "AND NEW.[InAssemblyInputComments] IS OLD.[InputComments] " + + "AND NEW.[InAssemblyOutputComments] IS OLD.[OutputComments] " + + "AND NEW.[NotInAssemblyComments] IS OLD.[NotRelevantComments] " + + "AND NEW.[CalculationsInputComments] IS NULL " + + "AND NEW.[FailurePathAssemblyProbabilityResultType] = 1 " + + "AND NEW.[ManualFailurePathAssemblyProbability] IS NULL; " + + "DETACH SOURCEPROJECT;"; + + reader.AssertReturnedDataIsValid(string.Format(validateFailureMechanism2, i.ToString())); + } + string validateRenumberedFailureMechanism = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = " + + "(" + + "SELECT COUNT() " + + "FROM SOURCEPROJECT.FailureMechanismEntity " + + "WHERE [FailureMechanismType] = {0} " + + ") " + + "FROM FailureMechanismEntity NEW " + + "JOIN SOURCEPROJECT.FailureMechanismEntity OLD USING(FailureMechanismEntityId) " + + "WHERE NEW.[AssessmentSectionEntityId] = OLD.[AssessmentSectionEntityId] " + + "AND NEW.[CalculationGroupEntityId] IS OLD.[CalculationGroupEntityId] " + + "AND NEW.[FailureMechanismType] = {1} " + + "AND NEW.[InAssembly] = OLD.[IsRelevant] " + + "AND NEW.[FailureMechanismSectionCollectionSourcePath] IS OLD.[FailureMechanismSectionCollectionSourcePath] " + + "AND NEW.[InAssemblyInputComments] IS OLD.[InputComments] " + + "AND NEW.[InAssemblyOutputComments] IS OLD.[OutputComments] " + + "AND NEW.[NotInAssemblyComments] IS OLD.[NotRelevantComments] " + + "AND NEW.[CalculationsInputComments] IS NULL " + + "AND NEW.[FailurePathAssemblyProbabilityResultType] = 1 " + + "AND NEW.[ManualFailurePathAssemblyProbability] IS NULL; " + + "DETACH SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateFailureMechanism); + reader.AssertReturnedDataIsValid(string.Format(validateRenumberedFailureMechanism, "14", "13")); + reader.AssertReturnedDataIsValid(string.Format(validateRenumberedFailureMechanism, "15", "14")); + reader.AssertReturnedDataIsValid(string.Format(validateRenumberedFailureMechanism, "16", "15")); } private static void AssertFailureMechanismSection(MigratedDatabaseReader reader, string sourceFilePath)