public void GetRegionByTrackIdQuery_Always_ReturnsExpectedValue()
{
// Call
string query = HydraulicLocationConfigurationDatabaseQueryBuilder.GetRegionByTrackIdQuery();
// Assert
const string expectedQuery = "SELECT * FROM Regions LEFT JOIN Tracks ON Regions.RegionId = Tracks.RegionId WHERE Tracks.TrackId = @TrackId";
Assert.AreEqual(expectedQuery, query);
}
public void GetLocationIdsByTrackIdQuery_Always_ReturnsExpectedValue()
{
// Call
string query = HydraulicLocationConfigurationDatabaseQueryBuilder.GetLocationIdsByTrackIdQuery();
// Assert
const string expectedQuery = "SELECT LocationId, HRDLocationId FROM Locations WHERE TrackId = @TrackId ORDER BY HRDLocationId;";
Assert.AreEqual(expectedQuery, query);
}
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);
}
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);
}
