Index: Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs =================================================================== diff -u -r83af36537e4c5b7760260de67d2f361ff2a71ed2 -rc34002da854486928c4dfa4a718d39561f10a973 --- Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision 83af36537e4c5b7760260de67d2f361ff2a71ed2) +++ Ringtoets/Migration/test/Ringtoets.Migration.Integration.Test/MigrationTo181IntegrationTest.cs (.../MigrationTo181IntegrationTest.cs) (revision c34002da854486928c4dfa4a718d39561f10a973) @@ -1041,15 +1041,12 @@ reader.AssertReturnedDataIsValid(queryGenerator.GetDuneLocationCalculationsCountValidationQuery( DuneErosionFailureMechanismValidationQueryGenerator.CalculationType.CalculationsForLowerFactorizedLimitNorm)); - reader.AssertReturnedDataIsValid(queryGenerator.GetMigratedDuneLocationCalculationOutputValidationQuery(NormativeNormType.SignalingNorm)); - reader.AssertReturnedDataIsValid(queryGenerator.GetMigratedDuneLocationCalculationOutputValidationQuery(NormativeNormType.LowerLimitNorm)); - - reader.AssertReturnedDataIsValid(DuneErosionFailureMechanismValidationQueryGenerator.GetNewDuneLocationCalculationOutputValidationQuery( - DuneErosionFailureMechanismValidationQueryGenerator.CalculationType.CalculationsForMechanismSpecificFactorizedSignalingNorm)); - reader.AssertReturnedDataIsValid(DuneErosionFailureMechanismValidationQueryGenerator.GetNewDuneLocationCalculationOutputValidationQuery( - DuneErosionFailureMechanismValidationQueryGenerator.CalculationType.CalculationsForLowerLimitNorm)); - reader.AssertReturnedDataIsValid(DuneErosionFailureMechanismValidationQueryGenerator.GetNewDuneLocationCalculationOutputValidationQuery( - DuneErosionFailureMechanismValidationQueryGenerator.CalculationType.CalculationsForLowerFactorizedLimitNorm)); + string validateDuneLocationOutput = + $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + + "SELECT COUNT() = 0 " + + "FROM DuneLocationCalculationOutputEntity; " + + "DETACH DATABASE SOURCEPROJECT;"; + reader.AssertReturnedDataIsValid(validateDuneLocationOutput); } private static void AssertGrassCoverErosionOutwardsFailureMechanismMetaEntity(MigratedDatabaseReader reader, string sourceFilePath) @@ -1188,53 +1185,6 @@ "DETACH DATABASE SOURCEPROJECT;"; } - /// - /// Generates a query to validate the new dune location outputs that are not based on migrated data. - /// - /// The type of calculation on which the output should be validated. - /// The query to validate the dune location output. - public static string GetNewDuneLocationCalculationOutputValidationQuery(CalculationType calculationType) - { - return "SELECT COUNT() = 0 " + - GetDuneLocationCalculationsQuery(calculationType) + - "JOIN DuneLocationCalculationOutputEntity USING(DuneLocationCalculationEntityId);"; - } - - /// - /// Generates a query to validate if the dune location outputs are migrated correctly to the - /// corresponding calculation entities. - /// - /// The norm type to generate the query for. - /// A query to validate the dune location outputs. - /// Thrown when - /// is an invalid value of . - /// Thrown when is a valid value, - /// but unsupported. - public string GetMigratedDuneLocationCalculationOutputValidationQuery(NormativeNormType normType) - { - return $"ATTACH DATABASE \"{sourceFilePath}\" AS SOURCEPROJECT; " + - "SELECT COUNT() = ( " + - "SELECT COUNT() " + - "FROM [SOURCEPROJECT].DuneLocationOutputEntity " + - "JOIN [SOURCEPROJECT].DuneLocationEntity USING(DuneLocationEntityId) " + - "JOIN [SOURCEPROJECT].FailureMechanismEntity USING(FailureMechanismEntityId) " + - "JOIN [SOURCEPROJECT].AssessmentSectionEntity USING(AssessmentSectionEntityId) " + - $"WHERE NormativeNormType = {(int) normType} " + - ") " + - GetDuneLocationCalculationsQuery(ConvertToCalculationType(normType)) + - "JOIN DuneLocationCalculationOutputEntity NEW USING(DuneLocationCalculationEntityId) " + - "JOIN [SOURCEPROJECT].DuneLocationOutputEntity OLD ON OLD.DuneLocationOutputEntityId = NEW.DuneLocationCalculationOutputEntityId " + - "WHERE NEW.WaterLevel IS OLD.WaterLevel " + - "AND NEW.WaveHeight IS OLD.WaveHeight " + - "AND NEW.WavePeriod IS OLD.WavePeriod " + - "AND NEW.TargetProbability IS OLD.TargetProbability " + - "AND NEW.TargetReliability IS OLD.TargetReliability " + - "AND NEW.CalculatedProbability IS OLD.CalculatedProbability " + - "AND NEW.CalculatedReliability IS OLD.CalculatedReliability " + - "AND NEW.CalculationConvergence = OLD.CalculationConvergence; " + - "DETACH DATABASE SOURCEPROJECT;"; - } - private static string GetDuneLocationCalculationsQuery(CalculationType calculationType) { return "FROM DuneErosionFailureMechanismMetaEntity fme " + @@ -2529,10 +2479,10 @@ } /// - /// Converts the to the corresponding category type from . + /// Converts the to the corresponding category type from . /// /// The norm type to convert. - /// Returns the converted . + /// Returns the converted . /// Thrown when /// is an invalid value of . /// Thrown when is a valid value, @@ -2556,10 +2506,10 @@ } /// - /// Converts the to the corresponding category type from . + /// Converts the to the corresponding category type from . /// /// The norm type to convert. - /// Returns the converted . + /// Returns the converted . /// Thrown when /// is an invalid value of . /// Thrown when is a valid value,