Index: Ringtoets/Migration/src/Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql =================================================================== diff -u -ree67290cbfd58a5022cb117dc9fd9a4a457b1da8 -rd793636169dd75ec39000f5a779533e434e18d11 --- Ringtoets/Migration/src/Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision ee67290cbfd58a5022cb117dc9fd9a4a457b1da8) +++ Ringtoets/Migration/src/Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision d793636169dd75ec39000f5a779533e434e18d11) @@ -732,7 +732,14 @@ 1 FROM [SOURCEPROJECT].MicrostabilitySectionResultEntity; INSERT INTO PipingCalculationEntity SELECT * FROM [SOURCEPROJECT].PipingCalculationEntity; -INSERT INTO PipingCalculationOutputEntity SELECT * FROM [SOURCEPROJECT].PipingCalculationOutputEntity; +INSERT INTO PipingCalculationOutputEntity +SELECT * + FROM [SOURCEPROJECT].PipingCalculationOutputEntity + WHERE PipingCalculationEntityId IN ( + SELECT PipingCalculationEntityId + FROM [SOURCEPROJECT].PipingCalculationEntity + WHERE UseAssessmentLevelManualInput IS 1 + ); INSERT INTO PipingCharacteristicPointEntity SELECT * FROM [SOURCEPROJECT].PipingCharacteristicPointEntity; INSERT INTO PipingFailureMechanismMetaEntity SELECT * FROM [SOURCEPROJECT].PipingFailureMechanismMetaEntity; INSERT INTO PipingSectionResultEntity ( Index: Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs =================================================================== diff -u -ree67290cbfd58a5022cb117dc9fd9a4a457b1da8 -rd793636169dd75ec39000f5a779533e434e18d11 --- Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision ee67290cbfd58a5022cb117dc9fd9a4a457b1da8) +++ Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision d793636169dd75ec39000f5a779533e434e18d11) @@ -85,7 +85,9 @@ AssertHydraulicBoundaryLocationsOnAssessmentSection(reader, sourceFilePath); AssertHydraulicBoundaryLocationsOnGrassCoverErosionOutwardsFailureMechanism(reader, sourceFilePath); AssertFailureMechanisms(reader, sourceFilePath); + AssertFailureMechanismRelatedOutput(reader); + AssertPipingOutput(reader, sourceFilePath); AssertPipingSoilLayers(reader); AssertStabilityStoneCoverFailureMechanism(reader); @@ -444,7 +446,6 @@ "MacroStabilityOutwardsSectionResultEntity", "MicrostabilitySectionResultEntity", "PipingCalculationEntity", - "PipingCalculationOutputEntity", "PipingCharacteristicPointEntity", "PipingFailureMechanismMetaEntity", "PipingSectionResultEntity", @@ -1035,6 +1036,22 @@ } } + private static void AssertPipingOutput(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateOutputCount = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = " + + "( " + + "SELECT COUNT() " + + "FROM [SOURCEPROJECT].PipingCalculationOutputEntity " + + "JOIN [SOURCEPROJECT].PipingCalculationEntity USING(PipingCalculationEntityId) " + + "WHERE [UseAssessmentLevelManualInput] = 1 " + + ") " + + "FROM PipingCalculationOutputEntity;" + + "DETACH DATABASE SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateOutputCount); + } + #region Dune Locations ///