Index: Ringtoets/Migration/src/Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql =================================================================== diff -u -r2ef23cfcb32102f57f0e225f9aa9f76fb84292ca -r19382b3670a64bb81d862b8a423d2d4ed1736420 --- Ringtoets/Migration/src/Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 2ef23cfcb32102f57f0e225f9aa9f76fb84292ca) +++ Ringtoets/Migration/src/Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql (.../Migration_17.3_18.1.sql) (revision 19382b3670a64bb81d862b8a423d2d4ed1736420) @@ -771,7 +771,11 @@ [Name], [ReferenceLineIntersectionX], [ReferenceLineIntersectionY], - [PointsXml], + REPLACE( + REPLACE(PointsXml, ' xmlns="http://schemas.datacontract.org/2004/07/Application.Ringtoets.Storage.Serializers"', ''), + 'Point3DXmlSerializer.SerializablePoint3D', + 'SerializablePoint3D' + ), [Order] FROM [SOURCEPROJECT].SurfaceLineEntity; INSERT INTO TechnicalInnovationSectionResultEntity ( Index: Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs =================================================================== diff -u -r2ef23cfcb32102f57f0e225f9aa9f76fb84292ca -r19382b3670a64bb81d862b8a423d2d4ed1736420 --- Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 2ef23cfcb32102f57f0e225f9aa9f76fb84292ca) +++ Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 19382b3670a64bb81d862b8a423d2d4ed1736420) @@ -127,6 +127,7 @@ MigratedSerializedDataTestHelper.AssertSerializedMacroStabilityInwardsOutput(reader); MigratedSerializedDataTestHelper.AssertSerializedDikeProfile(reader); + MigratedSerializedDataTestHelper.AssertSerializedSurfaceLine(reader); } AssertLogDatabase(logFilePath); @@ -979,10 +980,12 @@ /// public static void AssertSerializedMacroStabilityInwardsOutput(MigratedDatabaseReader reader) { + const string outputEntity = "MacroStabilityInwardsCalculationOutputEntity"; + string validateSlidingCurves = "SELECT " + "COUNT() = 0 " + - "FROM MacroStabilityInwardsCalculationOutputEntity " + + $"FROM {outputEntity} " + "WHERE LIKE('%MacroStabilityInwardsSliceXmlSerializer%', SlidingCurveSliceXML) " + $"OR LIKE('%{oldNamespace}%', SlidingCurveSliceXML)"; @@ -991,7 +994,7 @@ string validateTangentLines = "SELECT " + "COUNT() = 0 " + - "FROM MacroStabilityInwardsCalculationOutputEntity " + + $"FROM {outputEntity} " + "WHERE LIKE('%TangentLinesXmlSerializer%', SlipPlaneTangentLinesXml) " + $"OR LIKE('%{oldNamespace}%', SlipPlaneTangentLinesXml)"; @@ -1018,6 +1021,27 @@ reader.AssertReturnedDataIsValid(validateDikeGeometry); } + + /// + /// Asserts the migrated serialized data related to the surface lines. + /// + /// The reader to read the migrated database. + /// Thrown when: + /// + /// The namespace is still present. + /// The class name of the serialized data is still present. + /// + public static void AssertSerializedSurfaceLine(MigratedDatabaseReader reader) + { + string validateSurfaceLinePoints = + "SELECT " + + "COUNT() = 0 " + + "FROM SurfaceLineEntity " + + "WHERE LIKE('%Point3DXmlSerializer%', PointsXml) " + + $"OR LIKE('%{oldNamespace}%', PointsXml)"; + + reader.AssertReturnedDataIsValid(validateSurfaceLinePoints); + } } #endregion