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