Index: Ringtoets/Common/src/Ringtoets.Common.IO/HydraRing/DesignTablesSettingsProvider.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/Common/src/Ringtoets.Common.IO/HydraRing/DesignTablesSettingsProvider.cs (.../DesignTablesSettingsProvider.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/Common/src/Ringtoets.Common.IO/HydraRing/DesignTablesSettingsProvider.cs (.../DesignTablesSettingsProvider.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -23,7 +23,6 @@ using System.Collections.Generic; using System.ComponentModel; using Core.Common.Base.IO; -using Core.Common.IO.Exceptions; using Ringtoets.HydraRing.Calculation.Data; using Ringtoets.HydraRing.Calculation.Data.Settings; @@ -103,7 +102,7 @@ new DesignTablesSetting(10, 50) }, { - HydraRingFailureMechanismType.HydraulicLoads, + HydraRingFailureMechanismType.DikeHeight, new DesignTablesSetting(2, 4) }, { Index: Ringtoets/Common/src/Ringtoets.Common.IO/HydraRing/NumericsSettingsProvider.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/Common/src/Ringtoets.Common.IO/HydraRing/NumericsSettingsProvider.cs (.../NumericsSettingsProvider.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/Common/src/Ringtoets.Common.IO/HydraRing/NumericsSettingsProvider.cs (.../NumericsSettingsProvider.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -141,7 +141,7 @@ } }, { - HydraRingFailureMechanismType.HydraulicLoads, new Dictionary + HydraRingFailureMechanismType.DikeHeight, new Dictionary { { 102, numericsSettingFDir @@ -246,7 +246,7 @@ 103, numericsSettingFDir } } - }, + } }; } Index: Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/DesignTablesSettingsProviderTest.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/DesignTablesSettingsProviderTest.cs (.../DesignTablesSettingsProviderTest.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/DesignTablesSettingsProviderTest.cs (.../DesignTablesSettingsProviderTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -85,7 +85,7 @@ [TestCase(HydraRingFailureMechanismType.WavePeakPeriod, 700138, 1.0, 5.0)] [TestCase(HydraRingFailureMechanismType.WaveSpectralPeriod, 700138, 2.0, 5.0)] [TestCase(HydraRingFailureMechanismType.WaveHeight, 700138, -2.0, 0.0)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 700132, 2.0, 5.0)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 700132, 2.0, 5.0)] public void GetDesignTablesSetting_KnownLocationIdAndFailureMechanismType_ReturnsExpectedDesignTablesSetting( HydraRingFailureMechanismType failureMechanismType, long locationId, double expectedValueMin, double expectedValueMax) { @@ -107,7 +107,7 @@ [TestCase(HydraRingFailureMechanismType.WaveHeight, -1, 1.0, 4.0)] [TestCase(HydraRingFailureMechanismType.WavePeakPeriod, -1, 5.0, 15.0)] [TestCase(HydraRingFailureMechanismType.WaveSpectralPeriod, -1, 5.0, 15.0)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, -1, 2.0, 4.0)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, -1, 2.0, 4.0)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 700131, double.NaN, double.NaN)] [TestCase(HydraRingFailureMechanismType.StructuresOvertopping, 700131, double.NaN, double.NaN)] [TestCase(HydraRingFailureMechanismType.StructuresClosure, 700131, double.NaN, double.NaN)] Index: Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/NumericsSettingsProviderTest.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/NumericsSettingsProviderTest.cs (.../NumericsSettingsProviderTest.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/NumericsSettingsProviderTest.cs (.../NumericsSettingsProviderTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -99,8 +99,8 @@ [TestCase(HydraRingFailureMechanismType.WaveHeight, 11, 11, 4, 10000, 40000)] [TestCase(HydraRingFailureMechanismType.WavePeakPeriod, 14, 11, 4, 10000, 40000)] [TestCase(HydraRingFailureMechanismType.WaveSpectralPeriod, 16, 11, 4, 10000, 40000)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 102, 11, 4, 10000, 40000)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 103, 11, 4, 10000, 40000)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 102, 11, 4, 10000, 40000)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 103, 11, 4, 10000, 40000)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 102, 11, 4, 10000, 40000)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 103, 11, 4, 10000, 40000)] [TestCase(HydraRingFailureMechanismType.StructuresOvertopping, 421, 11, 4, 10000, 40000)] Index: Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/TimeIntegrationSettingsProviderTest.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/TimeIntegrationSettingsProviderTest.cs (.../TimeIntegrationSettingsProviderTest.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/Common/test/Ringtoets.Common.IO.Test/HydraRing/TimeIntegrationSettingsProviderTest.cs (.../TimeIntegrationSettingsProviderTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -68,7 +68,7 @@ [TestCase(HydraRingFailureMechanismType.WaveHeight, 700131, 1)] [TestCase(HydraRingFailureMechanismType.WavePeakPeriod, 700131, 1)] [TestCase(HydraRingFailureMechanismType.WaveSpectralPeriod, 700131, 1)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 700134, 1)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 700134, 1)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 700134, 1)] [TestCase(HydraRingFailureMechanismType.StructuresOvertopping, 700134, 1)] [TestCase(HydraRingFailureMechanismType.StructuresClosure, 700134, 1)] @@ -94,7 +94,7 @@ [TestCase(HydraRingFailureMechanismType.WavePeakPeriod, 1)] [TestCase(HydraRingFailureMechanismType.WaveSpectralPeriod, 1)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 1)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 1)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 1)] [TestCase(HydraRingFailureMechanismType.StructuresOvertopping, 1)] [TestCase(HydraRingFailureMechanismType.StructuresClosure, 1)] [TestCase(HydraRingFailureMechanismType.StructuresStructuralFailure, 1)] Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Data/HydraRingFailureMechanismType.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Data/HydraRingFailureMechanismType.cs (.../HydraRingFailureMechanismType.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Data/HydraRingFailureMechanismType.cs (.../HydraRingFailureMechanismType.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -35,7 +35,7 @@ WaveHeight = 2, WavePeakPeriod = 3, WaveSpectralPeriod = 4, - HydraulicLoads = 5, + DikeHeight = 5, DikesOvertopping = 6, StructuresOvertopping = 7, StructuresClosure = 8, Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Data/Input/Hydraulics/DikeHeightCalculationInput.cs =================================================================== diff -u -r87f4387086869f85cd07dc03f391bb3c01d51a58 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Data/Input/Hydraulics/DikeHeightCalculationInput.cs (.../DikeHeightCalculationInput.cs) (revision 87f4387086869f85cd07dc03f391bb3c01d51a58) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Data/Input/Hydraulics/DikeHeightCalculationInput.cs (.../DikeHeightCalculationInput.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -101,7 +101,7 @@ this.criticalOvertoppingStandardDeviation = criticalOvertoppingStandardDeviation; } - public override HydraRingFailureMechanismType FailureMechanismType { get; } = HydraRingFailureMechanismType.HydraulicLoads; + public override HydraRingFailureMechanismType FailureMechanismType { get; } = HydraRingFailureMechanismType.DikeHeight; public override int VariableId { get; } = 1; Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Providers/FailureMechanismDefaultsProvider.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Providers/FailureMechanismDefaultsProvider.cs (.../FailureMechanismDefaultsProvider.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Providers/FailureMechanismDefaultsProvider.cs (.../FailureMechanismDefaultsProvider.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -75,7 +75,7 @@ }, 6) }, { - HydraRingFailureMechanismType.HydraulicLoads, new FailureMechanismDefaults(101, new[] + HydraRingFailureMechanismType.DikeHeight, new FailureMechanismDefaults(101, new[] { 102, 103 Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Providers/VariableDefaultsProvider.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Providers/VariableDefaultsProvider.cs (.../VariableDefaultsProvider.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Providers/VariableDefaultsProvider.cs (.../VariableDefaultsProvider.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -100,7 +100,7 @@ } }, { - HydraRingFailureMechanismType.HydraulicLoads, new Dictionary + HydraRingFailureMechanismType.DikeHeight, new Dictionary { { 1, new VariableDefaults(300) @@ -448,7 +448,7 @@ 123, new VariableDefaults(300) } } - }, + } }; } Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Data/HydraRingFailureMechanismTypeTest.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Data/HydraRingFailureMechanismTypeTest.cs (.../HydraRingFailureMechanismTypeTest.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Data/HydraRingFailureMechanismTypeTest.cs (.../HydraRingFailureMechanismTypeTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -39,7 +39,7 @@ Assert.AreEqual(2, (int) HydraRingFailureMechanismType.WaveHeight, message); Assert.AreEqual(3, (int) HydraRingFailureMechanismType.WavePeakPeriod, message); Assert.AreEqual(4, (int) HydraRingFailureMechanismType.WaveSpectralPeriod, message); - Assert.AreEqual(5, (int) HydraRingFailureMechanismType.HydraulicLoads, message); + Assert.AreEqual(5, (int) HydraRingFailureMechanismType.DikeHeight, message); Assert.AreEqual(6, (int) HydraRingFailureMechanismType.DikesOvertopping, message); Assert.AreEqual(7, (int) HydraRingFailureMechanismType.StructuresOvertopping, message); Assert.AreEqual(8, (int) HydraRingFailureMechanismType.StructuresClosure, message); Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Data/Input/Hydraulics/DikeHeightCalculationInputTest.cs =================================================================== diff -u -r87f4387086869f85cd07dc03f391bb3c01d51a58 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Data/Input/Hydraulics/DikeHeightCalculationInputTest.cs (.../DikeHeightCalculationInputTest.cs) (revision 87f4387086869f85cd07dc03f391bb3c01d51a58) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Data/Input/Hydraulics/DikeHeightCalculationInputTest.cs (.../DikeHeightCalculationInputTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -93,7 +93,7 @@ Assert.IsInstanceOf(input); Assert.AreEqual(9, input.CalculationTypeId); Assert.AreEqual(hydraulicBoundaryLocationId, input.HydraulicBoundaryLocationId); - Assert.AreEqual(HydraRingFailureMechanismType.HydraulicLoads, input.FailureMechanismType); + Assert.AreEqual(HydraRingFailureMechanismType.DikeHeight, input.FailureMechanismType); Assert.AreEqual(1, input.VariableId); HydraRingDataEqualityHelper.AreEqual(GetDefaultDikeHeightVariables().ToArray(), input.Variables.ToArray()); CollectionAssert.AreEqual(expectedRingProfilePoints, input.ProfilePoints); Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Providers/FailureMechanismDefaultsProviderTest.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Providers/FailureMechanismDefaultsProviderTest.cs (.../FailureMechanismDefaultsProviderTest.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Providers/FailureMechanismDefaultsProviderTest.cs (.../FailureMechanismDefaultsProviderTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -22,6 +22,7 @@ using System.Collections.Generic; using NUnit.Framework; using Ringtoets.HydraRing.Calculation.Data; +using Ringtoets.HydraRing.Calculation.Data.Defaults; using Ringtoets.HydraRing.Calculation.Providers; namespace Ringtoets.HydraRing.Calculation.Test.Providers @@ -49,7 +50,7 @@ { 5 }, 6)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 101, new[] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 101, new[] { 102, 103 @@ -103,7 +104,7 @@ var failureMechanismDefaultsProvider = new FailureMechanismDefaultsProvider(); // Call - var failureMechanismDefaults = failureMechanismDefaultsProvider.GetFailureMechanismDefaults(failureMechanismType); + FailureMechanismDefaults failureMechanismDefaults = failureMechanismDefaultsProvider.GetFailureMechanismDefaults(failureMechanismType); // Assert Assert.AreEqual(expectedMechanismId, failureMechanismDefaults.MechanismId); Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Providers/VariableDefaultsProviderTest.cs =================================================================== diff -u -r70ae1620471a0015dcc0b73a0aab21bcc8479a36 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Providers/VariableDefaultsProviderTest.cs (.../VariableDefaultsProviderTest.cs) (revision 70ae1620471a0015dcc0b73a0aab21bcc8479a36) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Providers/VariableDefaultsProviderTest.cs (.../VariableDefaultsProviderTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -21,6 +21,7 @@ using NUnit.Framework; using Ringtoets.HydraRing.Calculation.Data; +using Ringtoets.HydraRing.Calculation.Data.Defaults; using Ringtoets.HydraRing.Calculation.Providers; namespace Ringtoets.HydraRing.Calculation.Test.Providers @@ -39,14 +40,14 @@ [TestCase(HydraRingFailureMechanismType.QVariant, 117, 300)] [TestCase(HydraRingFailureMechanismType.QVariant, 118, 300)] [TestCase(HydraRingFailureMechanismType.QVariant, 119, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 1, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 8, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 10, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 11, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 12, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 17, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 120, 300)] - [TestCase(HydraRingFailureMechanismType.HydraulicLoads, 123, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 1, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 8, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 10, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 11, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 12, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 17, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 120, 300)] + [TestCase(HydraRingFailureMechanismType.DikeHeight, 123, 300)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 1, 300)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 8, 300)] [TestCase(HydraRingFailureMechanismType.DikesOvertopping, 10, 300)] @@ -150,7 +151,7 @@ var variableDefaultsProvider = new VariableDefaultsProvider(); // Call - var variableDefaults = variableDefaultsProvider.GetVariableDefaults(failureMechanismType, variableId); + VariableDefaults variableDefaults = variableDefaultsProvider.GetVariableDefaults(failureMechanismType, variableId); // Assert Assert.AreEqual(expectedCorrelationLength, variableDefaults.CorrelationLength); Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Services/HydraRingConfigurationServiceTest.cs =================================================================== diff -u -ra9abc3d7cf7fa7c4c4d4fb9ec80598b3325d66e1 -r8a7d4d070e0644e7bc399b86ce751fcb774a4ea4 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Services/HydraRingConfigurationServiceTest.cs (.../HydraRingConfigurationServiceTest.cs) (revision a9abc3d7cf7fa7c4c4d4fb9ec80598b3325d66e1) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.Calculation.Test/Services/HydraRingConfigurationServiceTest.cs (.../HydraRingConfigurationServiceTest.cs) (revision 8a7d4d070e0644e7bc399b86ce751fcb774a4ea4) @@ -73,7 +73,7 @@ var hydraRingConfigurationService = new HydraRingConfigurationService(HydraRingUncertaintiesType.Model); var calculationInput1 = new HydraRingCalculationInputImplementation(1, 2); var calculationInput2 = new HydraRingCalculationInputImplementation(2, 3); - calculationInput2.SetFailureMechanismType(HydraRingFailureMechanismType.HydraulicLoads); + calculationInput2.SetFailureMechanismType(HydraRingFailureMechanismType.DikeHeight); hydraRingConfigurationService.AddHydraRingCalculationInput(calculationInput1); @@ -104,90 +104,90 @@ TimeIntegrationSetting = new TimeIntegrationSetting(3) }); - var expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + - "INSERT INTO [HydraulicModels] VALUES (1, 2, 'WTI 2017');" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Sections];" + Environment.NewLine + - "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + - "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [DesignTables];" + Environment.NewLine + - "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 4, 5, 0, 0, 0, 0, 6.6, 7.7, 1.1);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Numerics];" + Environment.NewLine + - "INSERT INTO [Numerics] VALUES (1, 1, 1, 1, 1, 8, 9, 10, 11.11, 12.12, 13.13, 14.14, 15, 1, 16, 17, 18.18, 19.19, 20.2, 21);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [VariableDatas];" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [CalculationProfiles];" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (1, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (1, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SectionFaultTreeModels];" + Environment.NewLine + - "INSERT INTO [SectionFaultTreeModels] VALUES (1, 1, 1, 1, 1);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SectionSubMechanismModels];" + Environment.NewLine + - "INSERT INTO [SectionSubMechanismModels] VALUES (1, 1, 1, 1, 1234);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Fetches];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [AreaPoints];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [PresentationSections];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Profiles];" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (1, 2, 11.1, 22.2);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [ForelandModels];" + Environment.NewLine + - "INSERT INTO [ForelandModels] VALUES (1, 1, 3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Forelands];" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (1, 2, 2.2, 3.3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [ProbabilityAlternatives];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SetUpHeights];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [CalcWindDirections];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Swells];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [WaveReductions];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Areas];" + Environment.NewLine + - "INSERT INTO [Areas] VALUES (1, '1', 'Nederland');" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Projects];" + Environment.NewLine + - "INSERT INTO [Projects] VALUES (1, 'WTI 2017', 'Ringtoets calculation');" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Breakwaters];" + Environment.NewLine + - "INSERT INTO [Breakwaters] VALUES (1, 1, 99.9);" + Environment.NewLine; + string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + + "INSERT INTO [HydraulicModels] VALUES (1, 2, 'WTI 2017');" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Sections];" + Environment.NewLine + + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [DesignTables];" + Environment.NewLine + + "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 4, 5, 0, 0, 0, 0, 6.6, 7.7, 1.1);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Numerics];" + Environment.NewLine + + "INSERT INTO [Numerics] VALUES (1, 1, 1, 1, 1, 8, 9, 10, 11.11, 12.12, 13.13, 14.14, 15, 1, 16, 17, 18.18, 19.19, 20.2, 21);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [VariableDatas];" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [CalculationProfiles];" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (1, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (1, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SectionFaultTreeModels];" + Environment.NewLine + + "INSERT INTO [SectionFaultTreeModels] VALUES (1, 1, 1, 1, 1);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SectionSubMechanismModels];" + Environment.NewLine + + "INSERT INTO [SectionSubMechanismModels] VALUES (1, 1, 1, 1, 1234);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Fetches];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [AreaPoints];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [PresentationSections];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Profiles];" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (1, 2, 11.1, 22.2);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [ForelandModels];" + Environment.NewLine + + "INSERT INTO [ForelandModels] VALUES (1, 1, 3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Forelands];" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (1, 2, 2.2, 3.3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [ProbabilityAlternatives];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SetUpHeights];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [CalcWindDirections];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Swells];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [WaveReductions];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Areas];" + Environment.NewLine + + "INSERT INTO [Areas] VALUES (1, '1', 'Nederland');" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Projects];" + Environment.NewLine + + "INSERT INTO [Projects] VALUES (1, 'WTI 2017', 'Ringtoets calculation');" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Breakwaters];" + Environment.NewLine + + "INSERT INTO [Breakwaters] VALUES (1, 1, 99.9);" + Environment.NewLine; - var databaseFilePath = Path.Combine(hydraRingDirectory, "temp.db"); + string databaseFilePath = Path.Combine(hydraRingDirectory, "temp.db"); using (new FileDisposeHelper(databaseFilePath)) { // Call hydraRingConfigurationService.WriteDatabaseCreationScript(databaseFilePath); // Assert - var creationScript = File.ReadAllText(databaseFilePath); + string creationScript = File.ReadAllText(databaseFilePath); Assert.AreEqual(expectedCreationScript, creationScript); } } @@ -232,144 +232,144 @@ TimeIntegrationSetting = new TimeIntegrationSetting(1) }); - var expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + - "INSERT INTO [HydraulicModels] VALUES (1, 2, 'WTI 2017');" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Sections];" + Environment.NewLine + - "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + - "INSERT INTO [Sections] VALUES (2, 1, 1, 2, 2, 0, 0, 0, 0, 700005, 700005, 100, 3.3, 2.2);" + Environment.NewLine + - "INSERT INTO [Sections] VALUES (3, 1, 1, 3, 3, 0, 0, 0, 0, 700006, 700006, 100, 3.3, 2.2);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + - "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 2);" + Environment.NewLine + - "INSERT INTO [SectionCalculationSchemes] VALUES (2, 1, 3);" + Environment.NewLine + - "INSERT INTO [SectionCalculationSchemes] VALUES (3, 1, 1);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [DesignTables];" + Environment.NewLine + - "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 4, 5, 0, 0, 0, 0, 6.6, 7.7, 1.1);" + Environment.NewLine + - "INSERT INTO [DesignTables] VALUES (2, 1, 1, 1, 4, 5, 0, 0, 0, 0, 8.8, 9.9, 1.1);" + Environment.NewLine + - "INSERT INTO [DesignTables] VALUES (3, 1, 1, 1, 4, 5, 0, 0, 0, 0, 10.1, 11.11, 1.1);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Numerics];" + Environment.NewLine + - "INSERT INTO [Numerics] VALUES (1, 1, 1, 1, 1, 8, 9, 10, 11.11, 12.12, 13.13, 14.14, 15, 1, 16, 17, 18.18, 19.19, 20.2, 21);" + Environment.NewLine + - "INSERT INTO [Numerics] VALUES (2, 1, 1, 1, 1, 108, 109, 110, 111.11, 112.12, 113.13, 114.14, 115, 1, 116, 117, 118.18, 119.19, 120.2, 121);" + Environment.NewLine + - "INSERT INTO [Numerics] VALUES (3, 1, 1, 1, 1, 208, 209, 210, 211.11, 212.12, 213.13, 214.14, 215, 1, 216, 217, 218.18, 219.19, 220.2, 221);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [VariableDatas];" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + - "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [CalculationProfiles];" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (1, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (1, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (2, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (2, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (3, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + - "INSERT INTO [CalculationProfiles] VALUES (3, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SectionFaultTreeModels];" + Environment.NewLine + - "INSERT INTO [SectionFaultTreeModels] VALUES (1, 1, 1, 1, 1);" + Environment.NewLine + - "INSERT INTO [SectionFaultTreeModels] VALUES (2, 1, 1, 1, 1);" + Environment.NewLine + - "INSERT INTO [SectionFaultTreeModels] VALUES (3, 1, 1, 1, 1);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SectionSubMechanismModels];" + Environment.NewLine + - "INSERT INTO [SectionSubMechanismModels] VALUES (1, 1, 1, 1, 1234);" + Environment.NewLine + - "INSERT INTO [SectionSubMechanismModels] VALUES (2, 1, 1, 1, 1234);" + Environment.NewLine + - "INSERT INTO [SectionSubMechanismModels] VALUES (3, 1, 1, 1, 1234);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Fetches];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [AreaPoints];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [PresentationSections];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Profiles];" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (1, 2, 11.1, 22.2);" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (2, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (2, 2, 11.1, 22.2);" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (3, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Profiles] VALUES (3, 2, 11.1, 22.2);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [ForelandModels];" + Environment.NewLine + - "INSERT INTO [ForelandModels] VALUES (1, 1, 3);" + Environment.NewLine + - "INSERT INTO [ForelandModels] VALUES (2, 1, 3);" + Environment.NewLine + - "INSERT INTO [ForelandModels] VALUES (3, 1, 3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Forelands];" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (1, 2, 2.2, 3.3);" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (2, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (2, 2, 2.2, 3.3);" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (3, 1, 1.1, 2.2);" + Environment.NewLine + - "INSERT INTO [Forelands] VALUES (3, 2, 2.2, 3.3);" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [ProbabilityAlternatives];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [SetUpHeights];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [CalcWindDirections];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Swells];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [WaveReductions];" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Areas];" + Environment.NewLine + - "INSERT INTO [Areas] VALUES (1, '1', 'Nederland');" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Projects];" + Environment.NewLine + - "INSERT INTO [Projects] VALUES (1, 'WTI 2017', 'Ringtoets calculation');" + Environment.NewLine + - Environment.NewLine + - "DELETE FROM [Breakwaters];" + Environment.NewLine + - "INSERT INTO [Breakwaters] VALUES (1, 1, 99.9);" + Environment.NewLine + - "INSERT INTO [Breakwaters] VALUES (2, 1, 99.9);" + Environment.NewLine + - "INSERT INTO [Breakwaters] VALUES (3, 1, 99.9);" + Environment.NewLine; + string expectedCreationScript = "DELETE FROM [HydraulicModels];" + Environment.NewLine + + "INSERT INTO [HydraulicModels] VALUES (1, 2, 'WTI 2017');" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Sections];" + Environment.NewLine + + "INSERT INTO [Sections] VALUES (1, 1, 1, 1, 1, 0, 0, 0, 0, 700004, 700004, 100, 3.3, 2.2);" + Environment.NewLine + + "INSERT INTO [Sections] VALUES (2, 1, 1, 2, 2, 0, 0, 0, 0, 700005, 700005, 100, 3.3, 2.2);" + Environment.NewLine + + "INSERT INTO [Sections] VALUES (3, 1, 1, 3, 3, 0, 0, 0, 0, 700006, 700006, 100, 3.3, 2.2);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SectionCalculationSchemes];" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (1, 1, 2);" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (2, 1, 3);" + Environment.NewLine + + "INSERT INTO [SectionCalculationSchemes] VALUES (3, 1, 1);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [DesignTables];" + Environment.NewLine + + "INSERT INTO [DesignTables] VALUES (1, 1, 1, 1, 4, 5, 0, 0, 0, 0, 6.6, 7.7, 1.1);" + Environment.NewLine + + "INSERT INTO [DesignTables] VALUES (2, 1, 1, 1, 4, 5, 0, 0, 0, 0, 8.8, 9.9, 1.1);" + Environment.NewLine + + "INSERT INTO [DesignTables] VALUES (3, 1, 1, 1, 4, 5, 0, 0, 0, 0, 10.1, 11.11, 1.1);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Numerics];" + Environment.NewLine + + "INSERT INTO [Numerics] VALUES (1, 1, 1, 1, 1, 8, 9, 10, 11.11, 12.12, 13.13, 14.14, 15, 1, 16, 17, 18.18, 19.19, 20.2, 21);" + Environment.NewLine + + "INSERT INTO [Numerics] VALUES (2, 1, 1, 1, 1, 108, 109, 110, 111.11, 112.12, 113.13, 114.14, 115, 1, 116, 117, 118.18, 119.19, 120.2, 121);" + Environment.NewLine + + "INSERT INTO [Numerics] VALUES (3, 1, 1, 1, 1, 208, 209, 210, 211.11, 212.12, 213.13, 214.14, 215, 1, 216, 217, 218.18, 219.19, 220.2, 221);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [VariableDatas];" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (1, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (2, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 0, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 2, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 2, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 4, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 4, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 19, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 19, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 1, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 1.1, 18, 2.2, 3.3, 4.4, 5.5, 0, 6.6, 300);" + Environment.NewLine + + "INSERT INTO [VariableDatas] VALUES (3, 1, 1, 1, 26, 0, 18, 0, NULL, NULL, NULL, 1, 0, 300);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [CalculationProfiles];" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (1, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (1, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (2, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (2, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (3, 1, 1.1, 2.2, 3.3);" + Environment.NewLine + + "INSERT INTO [CalculationProfiles] VALUES (3, 2, 11.1, 22.2, 33.3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SectionFaultTreeModels];" + Environment.NewLine + + "INSERT INTO [SectionFaultTreeModels] VALUES (1, 1, 1, 1, 1);" + Environment.NewLine + + "INSERT INTO [SectionFaultTreeModels] VALUES (2, 1, 1, 1, 1);" + Environment.NewLine + + "INSERT INTO [SectionFaultTreeModels] VALUES (3, 1, 1, 1, 1);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SectionSubMechanismModels];" + Environment.NewLine + + "INSERT INTO [SectionSubMechanismModels] VALUES (1, 1, 1, 1, 1234);" + Environment.NewLine + + "INSERT INTO [SectionSubMechanismModels] VALUES (2, 1, 1, 1, 1234);" + Environment.NewLine + + "INSERT INTO [SectionSubMechanismModels] VALUES (3, 1, 1, 1, 1234);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Fetches];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [AreaPoints];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [PresentationSections];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Profiles];" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (1, 2, 11.1, 22.2);" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (2, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (2, 2, 11.1, 22.2);" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (3, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Profiles] VALUES (3, 2, 11.1, 22.2);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [ForelandModels];" + Environment.NewLine + + "INSERT INTO [ForelandModels] VALUES (1, 1, 3);" + Environment.NewLine + + "INSERT INTO [ForelandModels] VALUES (2, 1, 3);" + Environment.NewLine + + "INSERT INTO [ForelandModels] VALUES (3, 1, 3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Forelands];" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (1, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (1, 2, 2.2, 3.3);" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (2, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (2, 2, 2.2, 3.3);" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (3, 1, 1.1, 2.2);" + Environment.NewLine + + "INSERT INTO [Forelands] VALUES (3, 2, 2.2, 3.3);" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [ProbabilityAlternatives];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [SetUpHeights];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [CalcWindDirections];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Swells];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [WaveReductions];" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Areas];" + Environment.NewLine + + "INSERT INTO [Areas] VALUES (1, '1', 'Nederland');" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Projects];" + Environment.NewLine + + "INSERT INTO [Projects] VALUES (1, 'WTI 2017', 'Ringtoets calculation');" + Environment.NewLine + + Environment.NewLine + + "DELETE FROM [Breakwaters];" + Environment.NewLine + + "INSERT INTO [Breakwaters] VALUES (1, 1, 99.9);" + Environment.NewLine + + "INSERT INTO [Breakwaters] VALUES (2, 1, 99.9);" + Environment.NewLine + + "INSERT INTO [Breakwaters] VALUES (3, 1, 99.9);" + Environment.NewLine; - var databaseFilePath = Path.Combine(hydraRingDirectory, "temp.db"); + string databaseFilePath = Path.Combine(hydraRingDirectory, "temp.db"); using (new FileDisposeHelper(databaseFilePath)) { // Call hydraRingConfigurationService.WriteDatabaseCreationScript(databaseFilePath); // Assert - var creationScript = File.ReadAllText(databaseFilePath); + string creationScript = File.ReadAllText(databaseFilePath); Assert.AreEqual(expectedCreationScript, creationScript); } } @@ -485,21 +485,13 @@ private class HydraRingProfilePointDerivative : HydraRingProfilePoint { - private readonly double roughness; - public HydraRingProfilePointDerivative(double x, double z, double roughness) : base(x, z) { - this.roughness = roughness; + Roughness = roughness; } - public override double Roughness - { - get - { - return roughness; - } - } + public override double Roughness { get; } } } } \ No newline at end of file