Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Parsers/IllustrationPoints/IllustrationPointQueries.cs
===================================================================
diff -u -rb75888ac4a86ce24369ba0dad93cfe5bcd3fc794 -r288827a5a3e825d8e47cff85d76495e2601483f1
--- Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Parsers/IllustrationPoints/IllustrationPointQueries.cs (.../IllustrationPointQueries.cs) (revision b75888ac4a86ce24369ba0dad93cfe5bcd3fc794)
+++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.Calculation/Parsers/IllustrationPoints/IllustrationPointQueries.cs (.../IllustrationPointQueries.cs) (revision 288827a5a3e825d8e47cff85d76495e2601483f1)
@@ -29,7 +29,7 @@
///
/// Selects all the closing situations.
///
- public static readonly string ClosingSituations =
+ public static readonly string ClosingSituations =
$"SELECT {IllustrationPointsDatabaseConstants.ClosingSituationId}, " +
"ClosingSituationName " +
"FROM ClosingSituations;";
@@ -47,6 +47,24 @@
"WHERE OuterIterationId = (SELECT MAX(OuterIterationID) FROM GoverningWind);";
///
+ /// Selects all the sub mechanisms.
+ ///
+ public static readonly string SubMechanisms =
+ "SELECT " +
+ $"{IllustrationPointsDatabaseConstants.SubMechanismId}, " +
+ $"{IllustrationPointsDatabaseConstants.SubMechanismName} " +
+ "FROM SubMechanisms;";
+
+ ///
+ /// Selects all the fault trees.
+ ///
+ public static readonly string FaultTrees =
+ "SELECT " +
+ $"{IllustrationPointsDatabaseConstants.FaultTreeId}, " +
+ $"{IllustrationPointsDatabaseConstants.FaultTreeName} " +
+ "FROM FaultTrees;";
+
+ ///
/// Selects the alpha values for a general result.
///
public static readonly string GeneralAlphaValues =
@@ -72,7 +90,7 @@
///
/// Selects the alpha values for each fault tree illustration point.
///
- public static readonly string FaultTreeAlphaValues =
+ public static readonly string FaultTreeAlphaValues =
"SELECT " +
$"{IllustrationPointsDatabaseConstants.FaultTreeId}, " +
$"{IllustrationPointsDatabaseConstants.WindDirectionId}, " +
@@ -90,7 +108,7 @@
///
/// Selects the beta values for each fault tree illustration point.
///
- public static readonly string FaultTreeBetaValues =
+ public static readonly string FaultTreeBetaValues =
"SELECT " +
$"{IllustrationPointsDatabaseConstants.FaultTreeId}, " +
$"{IllustrationPointsDatabaseConstants.WindDirectionId}, " +