Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilder.cs =================================================================== diff -u -r00cd167e5b3fe6e817e063ab654459c90e550aea -r3b368e38644b163189a58233f9fc1fb9701bf68c --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 00cd167e5b3fe6e817e063ab654459c90e550aea) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 3b368e38644b163189a58233f9fc1fb9701bf68c) @@ -1,4 +1,4 @@ -// Copyright (C) Stichting Deltares 2017. All rights reserved. +// Copyright (C) Stichting Deltares 2018. All rights reserved. // // This file is part of Ringtoets. // @@ -19,7 +19,7 @@ // Stichting Deltares and remain full property of Stichting Deltares at all times. // All rights reserved. -namespace Ringtoets.HydraRing.IO.HydraulicLocationConfigurationDatabase +namespace Riskeer.HydraRing.IO.HydraulicLocationConfigurationDatabase { /// /// Defines queries to execute on a hydraulic location configuration database. @@ -37,5 +37,34 @@ $"WHERE {LocationsTableDefinitions.TrackId} = @{LocationsTableDefinitions.TrackId} " + $"ORDER BY {LocationsTableDefinitions.HrdLocationId};"; } + + /// + /// Gets the query to determine whether data related to the scenario information is present in the database. + /// + /// The query to determine the presence of the scenario information in the database. + public static string GetIsScenarioInformationPresentQuery() + { + return $"SELECT COUNT() = 1 AS {ScenarioInformationTableDefinitions.IsScenarioInformationPresent} " + + "FROM sqlite_master WHERE type = 'table' " + + $"AND name='{ScenarioInformationTableDefinitions.TableName}';"; + } + + /// + /// Gets the query to get the scenario information from the database. + /// + /// The query to get the scenario information from the database. + public static string GetScenarioInformationQuery() + { + return $"SELECT {ScenarioInformationTableDefinitions.ScenarioName}, " + + $"{ScenarioInformationTableDefinitions.Year}, " + + $"{ScenarioInformationTableDefinitions.Scope}, " + + $"{ScenarioInformationTableDefinitions.SeaLevel}, " + + $"{ScenarioInformationTableDefinitions.RiverDischarge}, " + + $"{ScenarioInformationTableDefinitions.LakeLevel}, " + + $"{ScenarioInformationTableDefinitions.WindDirection}, " + + $"{ScenarioInformationTableDefinitions.WindSpeed}, " + + $"{ScenarioInformationTableDefinitions.Comment} " + + $"FROM {ScenarioInformationTableDefinitions.TableName};"; + } } } \ No newline at end of file