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}, " +