Index: Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs =================================================================== diff -u -ra7d7482b8e6bad505902bbb3bd6f500c036e974c -rbb9d6faa76b184fceed4375d1f217ec0ad0964e0 --- Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision a7d7482b8e6bad505902bbb3bd6f500c036e974c) +++ Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision bb9d6faa76b184fceed4375d1f217ec0ad0964e0) @@ -132,6 +132,8 @@ AssertClosingStructure(reader, sourceFilePath); AssertClosingStructureCalculationInput(reader, sourceFilePath); + + AssertStabilityPointStructureCalculationInput(reader, sourceFilePath); } AssertLogDatabase(logFilePath); @@ -236,6 +238,47 @@ reader.AssertReturnedDataIsValid(validateIdenticalApertures); } + private static void AssertStabilityPointStructureCalculationInput(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateLevellingCount = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCE; " + + "SELECT " + + "SUM([IsInvalid]) = 0 " + + "FROM " + + "( " + + "SELECT " + + "CASE WHEN (NEW.[LevellingCount] != OLD.[LevellingCount] " + + "AND OLD.[LevellingCount] >= 0) " + + "OR (NEW.[LevellingCount] != 0 AND OLD.[LevellingCount] < 0) " + + "THEN 1 " + + "ELSE 0 " + + "END AS [IsInvalid] " + + "FROM StabilityPointStructuresCalculationEntity NEW " + + "JOIN [SOURCE].StabilityPointStructuresCalculationEntity OLD USING (StabilityPointStructuresCalculationEntityId) " + + "); " + + "DETACH DATABASE SOURCE;"; + reader.AssertReturnedDataIsValid(validateLevellingCount); + + string validateVerticalDistance = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCE; " + + "SELECT " + + "SUM([IsInvalid]) = 0 " + + "FROM " + + "( " + + "SELECT " + + "CASE WHEN (NEW.[VerticalDistance] IS NOT OLD.[VerticalDistance] " + + "AND OLD.[VerticalDistance] >= 0) " + + "OR (NEW.[VerticalDistance] IS NOT NULL AND OLD.[VerticalDistance] < 0) " + + "THEN 1 " + + "ELSE 0 " + + "END AS [IsInvalid] " + + "FROM StabilityPointStructuresCalculationEntity NEW " + + "JOIN [SOURCE].StabilityPointStructuresCalculationEntity OLD USING (StabilityPointStructuresCalculationEntityId) " + + "); " + + "DETACH DATABASE SOURCE;"; + reader.AssertReturnedDataIsValid(validateVerticalDistance); + } + private static void AssertTablesContentMigrated(MigratedDatabaseReader reader, string sourceFilePath) { string[] tables =