Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql =================================================================== diff -u -r9e87591d99c3f1a53f2c93e4dbba8c8ebae492a3 -r1ebdaee18b80bcc8d7472ebec68c57f286a1db2f --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 9e87591d99c3f1a53f2c93e4dbba8c8ebae492a3) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 1ebdaee18b80bcc8d7472ebec68c57f286a1db2f) @@ -81,7 +81,27 @@ [GeneralResultFaultTreeIllustrationPointEntityId], [Reliability] FROM [SOURCEPROJECT].HeightStructuresOutputEntity; -INSERT INTO HeightStructuresSectionResultEntity SELECT * FROM [SOURCEPROJECT].HeightStructuresSectionResultEntity; +INSERT INTO HeightStructuresSectionResultEntity ( + [HeightStructuresSectionResultEntityId], + [FailureMechanismSectionEntityId], + [HeightStructuresCalculationEntityId], + [SimpleAssessmentResult], + [DetailedAssessmentResult], + [TailorMadeAssessmentResult], + [TailorMadeAssessmentProbability], + [UseManualAssemblyProbability], + [ManualAssemblyProbability]) +SELECT + [HeightStructuresSectionResultEntityId], + [FailureMechanismSectionEntityId], + [HeightStructuresCalculationEntityId], + 1, + 1, + 1, + NULL, + 0, + NULL +FROM [SOURCEPROJECT].HeightStructuresSectionResultEntity; INSERT INTO HydraRingPreprocessorEntity SELECT * FROM [SOURCEPROJECT].HydraRingPreprocessorEntity; INSERT INTO HydraulicLocationEntity ( [HydraulicLocationEntityId], Index: Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs =================================================================== diff -u -r852559199a215bbc7443751b755d28ec49b577b6 -r1ebdaee18b80bcc8d7472ebec68c57f286a1db2f --- Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 852559199a215bbc7443751b755d28ec49b577b6) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 1ebdaee18b80bcc8d7472ebec68c57f286a1db2f) @@ -95,6 +95,8 @@ AssertStabilityPointStructuresOutput(reader, sourceFilePath); AssertGrassCoverErosionOutwardsFailureMechanismMetaEntity(reader, sourceFilePath); + + AssertHeightStructuresSectionResultEntity(reader, sourceFilePath); } AssertLogDatabase(logFilePath); @@ -509,6 +511,25 @@ reader.AssertReturnedDataIsValid(validateMetaEntity); } + private static void AssertHeightStructuresSectionResultEntity(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateSectionResult = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT " + + "COUNT() = (SELECT COUNT() FROM [SOURCEPROJECT].HeightStructuresSectionResultEntity) " + + "FROM HeightStructuresSectionResultEntity NEW " + + "JOIN [SOURCEPROJECT].HeightStructuresSectionResultEntity OLD USING (HeightStructuresSectionResultEntityId) " + + "WHERE NEW.FailureMechanismSectionEntityId = OLD.FailureMechanismSectionEntityId " + + "AND NEW.HeightStructuresCalculationEntityId IS OLD.HeightStructuresCalculationEntityId " + + "AND NEW.SimpleAssessmentResult = 1 " + + "AND NEW.DetailedAssessmentResult = 1 " + + "AND NEW.TailorMadeAssessmentResult = 1 " + + "AND NEW.TailorMadeAssessmentProbability IS NULL " + + "AND NEW.UseManualAssemblyProbability = 0 " + + "AND NEW.ManualAssemblyProbability IS NULL; " + + "DETACH DATABASE SOURCEPROJECT;"; + } + #region Migrated Hydraulic Boundary Locations on Assessment section private static void AssertWaveHeightCalculationEntitiesOnAssessmentSection(MigratedDatabaseReader reader,