Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_19.1_20.1.sql =================================================================== diff -u -r8f223d35ced102ff207cff304cefadde224a17ef -rbd1d7eb233cb8f3d16e6e2821e2904d590df274b --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_19.1_20.1.sql (.../Migration_19.1_20.1.sql) (revision 8f223d35ced102ff207cff304cefadde224a17ef) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_19.1_20.1.sql (.../Migration_19.1_20.1.sql) (revision bd1d7eb233cb8f3d16e6e2821e2904d590df274b) @@ -734,6 +734,24 @@ WHERE [NrDeleted] > 0 LIMIT 1; +INSERT INTO TempLogOutputDeleted +SELECT COUNT() +FROM [SOURCEPROJECT].PipingCalculationOutputEntity + JOIN [SOURCEPROJECT].PipingCalculationEntity USING(PipingCalculationEntityId) +WHERE UseAssessmentLevelManualInput = 1; + +INSERT INTO [LOGDATABASE].MigrationLogEntity ( + [FromVersion], + [ToVersion], +[LogMessage]) +SELECT + "19.1", + "20.1", + "* Alle berekende resultaten van het toetsspoor 'Piping' waarbij de waterstand handmatig is ingevuld zijn verwijderd." +FROM TempLogOutputDeleted +WHERE [NrDeleted] > 0 + LIMIT 1; + DROP TABLE TempLogOutputDeleted; INSERT INTO [LOGDATABASE].MigrationLogEntity ( Index: Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo201IntegrationTest.cs =================================================================== diff -u -r8f223d35ced102ff207cff304cefadde224a17ef -rbd1d7eb233cb8f3d16e6e2821e2904d590df274b --- Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo201IntegrationTest.cs (.../MigrationTo201IntegrationTest.cs) (revision 8f223d35ced102ff207cff304cefadde224a17ef) +++ Riskeer/Migration/test/Riskeer.Migration.Integration.Test/MigrationTo201IntegrationTest.cs (.../MigrationTo201IntegrationTest.cs) (revision bd1d7eb233cb8f3d16e6e2821e2904d590df274b) @@ -864,13 +864,16 @@ { ReadOnlyCollection messages = reader.GetMigrationLogMessages(); - Assert.AreEqual(2, messages.Count); + Assert.AreEqual(3, messages.Count); var i = 0; MigrationLogTestHelper.AssertMigrationLogMessageEqual( new MigrationLogMessage("19.1", newVersion, "Gevolgen van de migratie van versie 19.1 naar versie 20.1:"), messages[i++]); MigrationLogTestHelper.AssertMigrationLogMessageEqual( new MigrationLogMessage("19.1", newVersion, "* Alle berekende resultaten van het toetsspoor 'Macrostabiliteit binnenwaarts' zijn verwijderd."), + messages[i++]); + MigrationLogTestHelper.AssertMigrationLogMessageEqual( + new MigrationLogMessage("19.1", newVersion, "* Alle berekende resultaten van het toetsspoor 'Piping' waarbij de waterstand handmatig is ingevuld zijn verwijderd."), messages[i]); } }