Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_18.1_19.1.sql
===================================================================
diff -u -rd984bb4a0e5af8b6f2b65b2834f1b5b49b4a9ccb -rdc03bf3b0e6ed80357f689c39eee30537718bd9e
--- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_18.1_19.1.sql (.../Migration_18.1_19.1.sql) (revision d984bb4a0e5af8b6f2b65b2834f1b5b49b4a9ccb)
+++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_18.1_19.1.sql (.../Migration_18.1_19.1.sql) (revision dc03bf3b0e6ed80357f689c39eee30537718bd9e)
@@ -188,35 +188,35 @@
[ShouldIllustrationPointsBeCalculated]
FROM [SOURCEPROJECT].ClosingStructuresCalculationEntity
LEFT JOIN (
- SELECT
- ForeshoreProfileEntityId,
- CASE
+ SELECT
+ ForeshoreProfileEntityId,
+ CASE
WHEN (LENGTH(GeometryXML) - LENGTH(REPLACE(REPLACE(GeometryXML, '', ''), '', ''))) / (LENGTH('') + LENGTH('')) = 1
THEN 0
ELSE 1
- END AS ValidForeshoreProfile
- FROM [SOURCEPROJECT].ForeshoreProfileEntity
+ END AS ValidForeshoreProfile
+ FROM [SOURCEPROJECT].ForeshoreProfileEntity
) USING(ForeshoreProfileEntityId);
INSERT INTO ClosingStructuresFailureMechanismMetaEntity SELECT * FROM [SOURCEPROJECT].ClosingStructuresFailureMechanismMetaEntity;
INSERT INTO ClosingStructuresOutputEntity(
- [ClosingStructuresOutputEntityId],
- [ClosingStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability])
+ [ClosingStructuresOutputEntityId],
+ [ClosingStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability])
SELECT
[ClosingStructuresOutputEntityId],
- [ClosingStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability]
+ [ClosingStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability]
FROM [SOURCEPROJECT].ClosingStructuresOutputEntity
JOIN [SOURCEPROJECT].ClosingStructuresCalculationEntity USING(ClosingStructuresCalculationEntityId)
WHERE ForeshoreProfileEntityId IS NULL
UNION
SELECT
- [ClosingStructuresOutputEntityId],
- [ClosingStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability]
+ [ClosingStructuresOutputEntityId],
+ [ClosingStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability]
FROM [SOURCEPROJECT].ClosingStructuresOutputEntity
JOIN [SOURCEPROJECT].ClosingStructuresCalculationEntity USING(ClosingStructuresCalculationEntityId)
JOIN [SOURCEPROJECT].ForeshoreProfileEntity USING(ForeshoreProfileEntityId)
@@ -343,7 +343,7 @@
WHEN [HasOutput] = 1
THEN 2
ELSE 3
- END
+ END
FROM [SOURCEPROJECT].GrassCoverErosionOutwardsWaveConditionsCalculationEntity
JOIN (
SELECT
@@ -358,14 +358,14 @@
GROUP BY GrassCoverErosionOutwardsWaveConditionsCalculationEntityId
) USING(GrassCoverErosionOutwardsWaveConditionsCalculationEntityId)
LEFT JOIN (
- SELECT
- ForeshoreProfileEntityId,
- CASE
+ SELECT
+ ForeshoreProfileEntityId,
+ CASE
WHEN (LENGTH(GeometryXML) - LENGTH(REPLACE(REPLACE(GeometryXML, '', ''), '', ''))) / (LENGTH('') + LENGTH('')) = 1
THEN 0
ELSE 1
- END AS ValidForeshoreProfile
- FROM [SOURCEPROJECT].ForeshoreProfileEntity
+ END AS ValidForeshoreProfile
+ FROM [SOURCEPROJECT].ForeshoreProfileEntity
) USING(ForeshoreProfileEntityId);
INSERT INTO GrassCoverErosionOutwardsWaveConditionsOutputEntity(
[GrassCoverErosionOutwardsWaveConditionsOutputEntityId],
@@ -513,35 +513,35 @@
[ShouldIllustrationPointsBeCalculated]
FROM [SOURCEPROJECT].HeightStructuresCalculationEntity
LEFT JOIN (
- SELECT
- ForeshoreProfileEntityId,
- CASE
+ SELECT
+ ForeshoreProfileEntityId,
+ CASE
WHEN (LENGTH(GeometryXML) - LENGTH(REPLACE(REPLACE(GeometryXML, '', ''), '', ''))) / (LENGTH('') + LENGTH('')) = 1
THEN 0
ELSE 1
- END AS ValidForeshoreProfile
- FROM [SOURCEPROJECT].ForeshoreProfileEntity
+ END AS ValidForeshoreProfile
+ FROM [SOURCEPROJECT].ForeshoreProfileEntity
) USING(ForeshoreProfileEntityId);
INSERT INTO HeightStructuresFailureMechanismMetaEntity SELECT * FROM [SOURCEPROJECT].HeightStructuresFailureMechanismMetaEntity;
INSERT INTO HeightStructuresOutputEntity(
- [HeightStructuresOutputEntityId],
- [HeightStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability])
+ [HeightStructuresOutputEntityId],
+ [HeightStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability])
SELECT
[HeightStructuresOutputEntityId],
- [HeightStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability]
+ [HeightStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability]
FROM [SOURCEPROJECT].HeightStructuresOutputEntity
JOIN [SOURCEPROJECT].HeightStructuresCalculationEntity USING(HeightStructuresCalculationEntityId)
WHERE ForeshoreProfileEntityId IS NULL
UNION
SELECT
- [HeightStructuresOutputEntityId],
- [HeightStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability]
+ [HeightStructuresOutputEntityId],
+ [HeightStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability]
FROM [SOURCEPROJECT].HeightStructuresOutputEntity
JOIN [SOURCEPROJECT].HeightStructuresCalculationEntity USING(HeightStructuresCalculationEntityId)
JOIN [SOURCEPROJECT].ForeshoreProfileEntity USING(ForeshoreProfileEntityId)
@@ -780,35 +780,35 @@
[ShouldIllustrationPointsBeCalculated]
FROM [SOURCEPROJECT].StabilityPointStructuresCalculationEntity
LEFT JOIN (
- SELECT
- ForeshoreProfileEntityId,
- CASE
+ SELECT
+ ForeshoreProfileEntityId,
+ CASE
WHEN (LENGTH(GeometryXML) - LENGTH(REPLACE(REPLACE(GeometryXML, '', ''), '', ''))) / (LENGTH('') + LENGTH('')) = 1
THEN 0
ELSE 1
- END AS ValidForeshoreProfile
- FROM [SOURCEPROJECT].ForeshoreProfileEntity
+ END AS ValidForeshoreProfile
+ FROM [SOURCEPROJECT].ForeshoreProfileEntity
) USING(ForeshoreProfileEntityId);
INSERT INTO StabilityPointStructuresFailureMechanismMetaEntity SELECT * FROM [SOURCEPROJECT].StabilityPointStructuresFailureMechanismMetaEntity;
INSERT INTO StabilityPointStructuresOutputEntity(
- [StabilityPointStructuresOutputEntityId],
- [StabilityPointStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability])
+ [StabilityPointStructuresOutputEntityId],
+ [StabilityPointStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability])
SELECT
[StabilityPointStructuresOutputEntityId],
- [StabilityPointStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability]
+ [StabilityPointStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability]
FROM [SOURCEPROJECT].StabilityPointStructuresOutputEntity
JOIN [SOURCEPROJECT].StabilityPointStructuresCalculationEntity USING(StabilityPointStructuresCalculationEntityId)
WHERE ForeshoreProfileEntityId IS NULL
UNION
SELECT
- [StabilityPointStructuresOutputEntityId],
- [StabilityPointStructuresCalculationEntityId],
- [GeneralResultFaultTreeIllustrationPointEntityId],
- [Reliability]
+ [StabilityPointStructuresOutputEntityId],
+ [StabilityPointStructuresCalculationEntityId],
+ [GeneralResultFaultTreeIllustrationPointEntityId],
+ [Reliability]
FROM [SOURCEPROJECT].StabilityPointStructuresOutputEntity
JOIN [SOURCEPROJECT].StabilityPointStructuresCalculationEntity USING(StabilityPointStructuresCalculationEntityId)
JOIN [SOURCEPROJECT].ForeshoreProfileEntity USING(ForeshoreProfileEntityId)
@@ -883,64 +883,64 @@
3
FROM [SOURCEPROJECT].StabilityStoneCoverWaveConditionsCalculationEntity
LEFT JOIN (
- SELECT
- ForeshoreProfileEntityId,
- CASE
+ SELECT
+ ForeshoreProfileEntityId,
+ CASE
WHEN (LENGTH(GeometryXML) - LENGTH(REPLACE(REPLACE(GeometryXML, '', ''), '', ''))) / (LENGTH('') + LENGTH('')) = 1
THEN 0
ELSE 1
- END AS ValidForeshoreProfile
- FROM [SOURCEPROJECT].ForeshoreProfileEntity
+ END AS ValidForeshoreProfile
+ FROM [SOURCEPROJECT].ForeshoreProfileEntity
) USING(ForeshoreProfileEntityId);
INSERT INTO StabilityStoneCoverWaveConditionsOutputEntity(
- [StabilityStoneCoverWaveConditionsOutputEntityId],
- [StabilityStoneCoverWaveConditionsCalculationEntityId],
- [Order],
+ [StabilityStoneCoverWaveConditionsOutputEntityId],
+ [StabilityStoneCoverWaveConditionsCalculationEntityId],
+ [Order],
[OutputType],
- [WaterLevel],
- [WaveHeight],
- [WavePeakPeriod],
- [WaveAngle],
- [WaveDirection],
- [TargetProbability],
- [TargetReliability],
- [CalculatedProbability],
- [CalculatedReliability],
- [CalculationConvergence])
+ [WaterLevel],
+ [WaveHeight],
+ [WavePeakPeriod],
+ [WaveAngle],
+ [WaveDirection],
+ [TargetProbability],
+ [TargetReliability],
+ [CalculatedProbability],
+ [CalculatedReliability],
+ [CalculationConvergence])
SELECT
- [StabilityStoneCoverWaveConditionsOutputEntityId],
- [StabilityStoneCoverWaveConditionsCalculationEntityId],
- output.[Order],
+ [StabilityStoneCoverWaveConditionsOutputEntityId],
+ [StabilityStoneCoverWaveConditionsCalculationEntityId],
+ output.[Order],
[OutputType],
- [WaterLevel],
- [WaveHeight],
- [WavePeakPeriod],
- [WaveAngle],
- [WaveDirection],
- [TargetProbability],
- [TargetReliability],
- [CalculatedProbability],
- [CalculatedReliability],
- [CalculationConvergence]
+ [WaterLevel],
+ [WaveHeight],
+ [WavePeakPeriod],
+ [WaveAngle],
+ [WaveDirection],
+ [TargetProbability],
+ [TargetReliability],
+ [CalculatedProbability],
+ [CalculatedReliability],
+ [CalculationConvergence]
FROM [SOURCEPROJECT].StabilityStoneCoverWaveConditionsOutputEntity output
JOIN [SOURCEPROJECT].StabilityStoneCoverWaveConditionsCalculationEntity USING(StabilityStoneCoverWaveConditionsCalculationEntityId)
WHERE ForeshoreProfileEntityId IS NULL
UNION
SELECT
- [StabilityStoneCoverWaveConditionsOutputEntityId],
- [StabilityStoneCoverWaveConditionsCalculationEntityId],
- output.[Order],
+ [StabilityStoneCoverWaveConditionsOutputEntityId],
+ [StabilityStoneCoverWaveConditionsCalculationEntityId],
+ output.[Order],
[OutputType],
- [WaterLevel],
- [WaveHeight],
- [WavePeakPeriod],
- [WaveAngle],
- [WaveDirection],
- [TargetProbability],
- [TargetReliability],
- [CalculatedProbability],
- [CalculatedReliability],
- [CalculationConvergence]
+ [WaterLevel],
+ [WaveHeight],
+ [WavePeakPeriod],
+ [WaveAngle],
+ [WaveDirection],
+ [TargetProbability],
+ [TargetReliability],
+ [CalculatedProbability],
+ [CalculatedReliability],
+ [CalculationConvergence]
FROM [SOURCEPROJECT].StabilityStoneCoverWaveConditionsOutputEntity output
JOIN [SOURCEPROJECT].StabilityStoneCoverWaveConditionsCalculationEntity USING(StabilityStoneCoverWaveConditionsCalculationEntityId)
JOIN [SOURCEPROJECT].ForeshoreProfileEntity USING(ForeshoreProfileEntityId)
@@ -1033,61 +1033,61 @@
[CategoryType]
FROM [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsCalculationEntity
LEFT JOIN (
- SELECT
- ForeshoreProfileEntityId,
- CASE
+ SELECT
+ ForeshoreProfileEntityId,
+ CASE
WHEN (LENGTH(GeometryXML) - LENGTH(REPLACE(REPLACE(GeometryXML, '', ''), '', ''))) / (LENGTH('') + LENGTH('')) = 1
THEN 0
ELSE 1
- END AS ValidForeshoreProfile
- FROM [SOURCEPROJECT].ForeshoreProfileEntity
+ END AS ValidForeshoreProfile
+ FROM [SOURCEPROJECT].ForeshoreProfileEntity
) USING(ForeshoreProfileEntityId);
INSERT INTO WaveImpactAsphaltCoverWaveConditionsOutputEntity(
- [WaveImpactAsphaltCoverWaveConditionsOutputEntityId],
- [WaveImpactAsphaltCoverWaveConditionsCalculationEntityId],
- [Order],
- [WaterLevel],
- [WaveHeight],
- [WavePeakPeriod],
- [WaveAngle],
- [WaveDirection],
- [TargetProbability],
- [TargetReliability],
- [CalculatedProbability],
- [CalculatedReliability],
- [CalculationConvergence])
+ [WaveImpactAsphaltCoverWaveConditionsOutputEntityId],
+ [WaveImpactAsphaltCoverWaveConditionsCalculationEntityId],
+ [Order],
+ [WaterLevel],
+ [WaveHeight],
+ [WavePeakPeriod],
+ [WaveAngle],
+ [WaveDirection],
+ [TargetProbability],
+ [TargetReliability],
+ [CalculatedProbability],
+ [CalculatedReliability],
+ [CalculationConvergence])
SELECT
- [WaveImpactAsphaltCoverWaveConditionsOutputEntityId],
- [WaveImpactAsphaltCoverWaveConditionsCalculationEntityId],
- output.[Order],
- [WaterLevel],
- [WaveHeight],
- [WavePeakPeriod],
- [WaveAngle],
- [WaveDirection],
- [TargetProbability],
- [TargetReliability],
- [CalculatedProbability],
- [CalculatedReliability],
- [CalculationConvergence]
+ [WaveImpactAsphaltCoverWaveConditionsOutputEntityId],
+ [WaveImpactAsphaltCoverWaveConditionsCalculationEntityId],
+ output.[Order],
+ [WaterLevel],
+ [WaveHeight],
+ [WavePeakPeriod],
+ [WaveAngle],
+ [WaveDirection],
+ [TargetProbability],
+ [TargetReliability],
+ [CalculatedProbability],
+ [CalculatedReliability],
+ [CalculationConvergence]
FROM [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsOutputEntity output
JOIN [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsCalculationEntity USING(WaveImpactAsphaltCoverWaveConditionsCalculationEntityId)
WHERE ForeshoreProfileEntityId IS NULL
UNION
SELECT
- [WaveImpactAsphaltCoverWaveConditionsOutputEntityId],
- [WaveImpactAsphaltCoverWaveConditionsCalculationEntityId],
- output.[Order],
- [WaterLevel],
- [WaveHeight],
- [WavePeakPeriod],
- [WaveAngle],
- [WaveDirection],
- [TargetProbability],
- [TargetReliability],
- [CalculatedProbability],
- [CalculatedReliability],
- [CalculationConvergence]
+ [WaveImpactAsphaltCoverWaveConditionsOutputEntityId],
+ [WaveImpactAsphaltCoverWaveConditionsCalculationEntityId],
+ output.[Order],
+ [WaterLevel],
+ [WaveHeight],
+ [WavePeakPeriod],
+ [WaveAngle],
+ [WaveDirection],
+ [TargetProbability],
+ [TargetReliability],
+ [CalculatedProbability],
+ [CalculatedReliability],
+ [CalculationConvergence]
FROM [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsOutputEntity output
JOIN [SOURCEPROJECT].WaveImpactAsphaltCoverWaveConditionsCalculationEntity USING(WaveImpactAsphaltCoverWaveConditionsCalculationEntityId)
JOIN [SOURCEPROJECT].ForeshoreProfileEntity USING(ForeshoreProfileEntityId)