Index: Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs =================================================================== diff -u -r5a740ab3ad2654ef7a892e85cc8f317ac9b3f986 -r8b620c03d0746846c6b13e343c417b6273d50d63 --- Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 5a740ab3ad2654ef7a892e85cc8f317ac9b3f986) +++ Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 8b620c03d0746846c6b13e343c417b6273d50d63) @@ -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 ///