Index: Riskeer/Integration/test/Riskeer.Integration.Plugin.Test/test-data/AssessmentSectionProvider/project.risk =================================================================== diff -u -r28c4185ad77ec71e79676d96dd125d1688e5761d -ra9a767f788abf3529cf00a741c9ee645c97bb64a Binary files differ Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_23.1_23.2.sql =================================================================== diff -u -ra2a0f02000f2699d6ad4be5c0d560b04a9ca8747 -ra9a767f788abf3529cf00a741c9ee645c97bb64a --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_23.1_23.2.sql (.../Migration_23.1_23.2.sql) (revision a2a0f02000f2699d6ad4be5c0d560b04a9ca8747) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_23.1_23.2.sql (.../Migration_23.1_23.2.sql) (revision a9a767f788abf3529cf00a741c9ee645c97bb64a) @@ -286,7 +286,33 @@ FROM [SOURCEPROJECT].SemiProbabilisticPipingCalculationOutputEntity sppcoe JOIN [SOURCEPROJECT].SemiProbabilisticPipingCalculationEntity USING(SemiProbabilisticPipingCalculationEntityId) WHERE UseAssessmentLevelManualInput = 1; -INSERT INTO SpecificFailureMechanismEntity SELECT * FROM [SOURCEPROJECT].SpecificFailureMechanismEntity; +INSERT INTO SpecificFailureMechanismEntity( + [SpecificFailureMechanismEntityId], + [AssessmentSectionEntityId], + [Name], + [Code], + [Order], + [InAssembly], + [FailureMechanismSectionCollectionSourcePath], + [InAssemblyInputComments], + [InAssemblyOutputComments], + [NotInAssemblyComments], + [FailureMechanismAssemblyResultProbabilityResultType], + [FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability]) +SELECT + [SpecificFailureMechanismEntityId], + [AssessmentSectionEntityId], + [Name], + [Code], + [Order], + [InAssembly], + [FailureMechanismSectionCollectionSourcePath], + [InAssemblyInputComments], + [InAssemblyOutputComments], + [NotInAssemblyComments], + [FailureMechanismAssemblyResultProbabilityResultType], + [FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability] +FROM [SOURCEPROJECT].SpecificFailureMechanismEntity; INSERT INTO SpecificFailureMechanismFailureMechanismSectionEntity SELECT * FROM [SOURCEPROJECT].SpecificFailureMechanismFailureMechanismSectionEntity; INSERT INTO StabilityPointStructureEntity SELECT * FROM [SOURCEPROJECT].StabilityPointStructureEntity; INSERT INTO StabilityPointStructuresCalculationEntity SELECT * FROM [SOURCEPROJECT].StabilityPointStructuresCalculationEntity; Index: Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo232IntegrationTest.cs =================================================================== diff -u -r92d4be8f5b8b0966b56a2361b90bc0d93b59486d -ra9a767f788abf3529cf00a741c9ee645c97bb64a --- Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo232IntegrationTest.cs (.../MigrationTo232IntegrationTest.cs) (revision 92d4be8f5b8b0966b56a2361b90bc0d93b59486d) +++ Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo232IntegrationTest.cs (.../MigrationTo232IntegrationTest.cs) (revision a9a767f788abf3529cf00a741c9ee645c97bb64a) @@ -74,6 +74,8 @@ AssertStabilityStoneCoverFailureMechanismMetaEntity(reader, sourceFilePath); AssertStabilityPointStructuresFailureMechanismMetaEntity(reader, sourceFilePath); AssertWaveImpactAsphaltCoverFailureMechanismMetaEntity(reader, sourceFilePath); + AssertWaveImpactAsphaltCoverFailureMechanismMetaEntity(reader, sourceFilePath); + AssertSpecificFailureMechanismMetaEntity(reader, sourceFilePath); AssertVersions(reader); AssertDatabase(reader); @@ -799,7 +801,34 @@ "DETACH SOURCEPROJECT;"; reader.AssertReturnedDataIsValid(validateMetaEntity); } + + private static void AssertSpecificFailureMechanismMetaEntity(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateMetaEntity = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = " + + "(" + + "SELECT COUNT() " + + "FROM SOURCEPROJECT.SpecificFailureMechanismEntity " + + ") " + + "FROM SpecificFailureMechanismEntity NEW " + + "JOIN SOURCEPROJECT.SpecificFailureMechanismEntity OLD USING(SpecificFailureMechanismEntityId) " + + "WHERE NEW.[AssessmentSectionEntityId] = OLD.[AssessmentSectionEntityId] " + + "AND NEW.[Name] IS OLD.[Name] " + + "AND NEW.[Code] IS OLD.[Code] " + + "AND NEW.\"Order\" = OLD.\"Order\" " + + "AND NEW.[InAssembly] = OLD.[InAssembly] " + + "AND NEW.[FailureMechanismSectionCollectionSourcePath] IS OLD.[FailureMechanismSectionCollectionSourcePath] " + + "AND NEW.[InAssemblyInputComments] IS OLD.[InAssemblyInputComments] " + + "AND NEW.[InAssemblyOutputComments] IS OLD.[InAssemblyOutputComments] " + + "AND NEW.[NotInAssemblyComments] IS OLD.[NotInAssemblyComments] " + + "AND NEW.[FailureMechanismAssemblyResultProbabilityResultType] = OLD.[FailureMechanismAssemblyResultProbabilityResultType] " + + "AND NEW.[FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability] IS OLD.[FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability]; " + + "DETACH SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateMetaEntity); + } + #endregion } } \ No newline at end of file