Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.IO.Test/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilderTest.cs =================================================================== diff -u -r00cd167e5b3fe6e817e063ab654459c90e550aea -r3b368e38644b163189a58233f9fc1fb9701bf68c --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.IO.Test/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilderTest.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilderTest.cs) (revision 00cd167e5b3fe6e817e063ab654459c90e550aea) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.IO.Test/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilderTest.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilderTest.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. // @@ -20,15 +20,15 @@ // All rights reserved. using NUnit.Framework; -using Ringtoets.HydraRing.IO.HydraulicLocationConfigurationDatabase; +using Riskeer.HydraRing.IO.HydraulicLocationConfigurationDatabase; namespace Ringtoets.HydraRing.IO.Test.HydraulicLocationConfigurationDatabase { [TestFixture] public class HydraulicLocationConfigurationDatabaseQueryBuilderTest { [Test] - public void GetLocationIdsByTrackIdQuery_Always_ReturnsExpectedValues() + public void GetLocationIdsByTrackIdQuery_Always_ReturnsExpectedValue() { // Call string query = HydraulicLocationConfigurationDatabaseQueryBuilder.GetLocationIdsByTrackIdQuery(); @@ -37,5 +37,30 @@ const string expectedQuery = "SELECT LocationId, HRDLocationId FROM Locations WHERE TrackId = @TrackId ORDER BY HRDLocationId;"; Assert.AreEqual(expectedQuery, query); } + + [Test] + public void GetIsScenarioInformationPresentQuery_Always_ReturnsExpectedValue() + { + // Call + string query = HydraulicLocationConfigurationDatabaseQueryBuilder.GetIsScenarioInformationPresentQuery(); + + // Assert + const string expectedQuery = "SELECT COUNT() = 1 AS IsScenarioInformationPresent " + + "FROM sqlite_master WHERE type = 'table' " + + "AND name='ScenarioInformation';"; + Assert.AreEqual(expectedQuery, query); + } + + [Test] + public void GetScenarioInformationQuery_Always_ReturnsExpectedValue() + { + // Call + string query = HydraulicLocationConfigurationDatabaseQueryBuilder.GetScenarioInformationQuery(); + + // Assert + const string expectedQuery = "SELECT ScenarioName, Year, Scope, SeaLevel, RiverDischarge, LakeLevel, WindDirection, WindSpeed, Comment " + + "FROM ScenarioInformation;"; + Assert.AreEqual(expectedQuery, query); + } } } \ No newline at end of file