Index: Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs =================================================================== diff -u -r7d89262d3b971dceec1e987e22d0027bf675c196 -rf7036a73fff399ef3c8524ffe9099e9b8fcbf3d8 --- Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 7d89262d3b971dceec1e987e22d0027bf675c196) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision f7036a73fff399ef3c8524ffe9099e9b8fcbf3d8) @@ -63,6 +63,9 @@ AssertPipingSoilLayers(reader); AssertHydraRingPreprocessor(reader); AssertStabilityStoneCoverFailureMechanism(reader); + AssertHeightStructuresFailureMechanism(reader, sourceFilePath); + AssertGrassCoverErosionInwardsFailureMechanism(reader, sourceFilePath); + AssertGrassCoverErosionOutwardsFailureMechanism(reader, sourceFilePath); } AssertLogDatabase(logFilePath); @@ -274,11 +277,50 @@ private static void AssertStabilityStoneCoverFailureMechanism(MigratedDatabaseReader reader) { - const string validatePreprocessorSettings = + const string validateStabilityStoneCoverFailureMechanism = "SELECT COUNT() = 0 " + - "FROM [StabilityStoneCoverFailureMechanismMetaEntity]" + + "FROM [StabilityStoneCoverFailureMechanismMetaEntity] " + "WHERE [N] IS NOT 4;"; - reader.AssertReturnedDataIsValid(validatePreprocessorSettings); + reader.AssertReturnedDataIsValid(validateStabilityStoneCoverFailureMechanism); } + + private static void AssertHeightStructuresFailureMechanism(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateHeightStructuresFailureMechanism = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = 0 " + + "FROM [SOURCEPROJECT].HeightStructuresFailureMechanismMetaEntity AS sourceMetaEntity " + + "INNER JOIN [HeightStructuresFailureMechanismMetaEntity] AS newMetaEntity " + + "ON sourceMetaEntity.HeightStructuresFailureMechanismMetaEntityId = newMetaEntity.HeightStructuresFailureMechanismMetaEntityId " + + "AND sourceMetaEntity.N IS NOT newMetaEntity.N;" + + "DETACH DATABASE SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateHeightStructuresFailureMechanism); + } + + private static void AssertGrassCoverErosionInwardsFailureMechanism(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateGrassCoverErosionInwardsFailureMechanism = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = 0 " + + "FROM [SOURCEPROJECT].GrassCoverErosionInwardsFailureMechanismMetaEntity AS sourceMetaEntity " + + "INNER JOIN [GrassCoverErosionInwardsFailureMechanismMetaEntity] AS newMetaEntity " + + "ON sourceMetaEntity.GrassCoverErosionInwardsFailureMechanismMetaEntityId = newMetaEntity.GrassCoverErosionInwardsFailureMechanismMetaEntityId " + + "AND sourceMetaEntity.N IS NOT newMetaEntity.N;" + + "DETACH DATABASE SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateGrassCoverErosionInwardsFailureMechanism); + } + + private static void AssertGrassCoverErosionOutwardsFailureMechanism(MigratedDatabaseReader reader, string sourceFilePath) + { + string validateGrassCoverErosionOutwardsFailureMechanism = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = 0 " + + "FROM [SOURCEPROJECT].GrassCoverErosionOutwardsFailureMechanismMetaEntity AS sourceMetaEntity " + + "INNER JOIN [GrassCoverErosionOutwardsFailureMechanismMetaEntity] AS newMetaEntity " + + "ON sourceMetaEntity.GrassCoverErosionOutwardsFailureMechanismMetaEntityId = newMetaEntity.GrassCoverErosionOutwardsFailureMechanismMetaEntityId " + + "AND sourceMetaEntity.N IS NOT newMetaEntity.N;" + + "DETACH DATABASE SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateGrassCoverErosionOutwardsFailureMechanism); + } } } \ No newline at end of file