public void GetTrackIdQuery_Always_ReturnsExpectedValues()
{
// Call
string query = HydraulicBoundaryDatabaseQueryBuilder.GetTrackIdQuery();
// Assert
const string expectedQuery = "SELECT TrackId FROM General LIMIT 0,1;";
Assert.AreEqual(expectedQuery, query);
}
public void GetRelevantLocationsQuery_Always_ReturnsExpectedValues()
{
// Call
string query = HydraulicBoundaryDatabaseQueryBuilder.GetRelevantLocationsQuery();
// Assert
const string expectedQuery = "SELECT HRDLocationId, Name, XCoordinate, YCoordinate FROM HRDLocations WHERE LocationTypeId > 1;";
Assert.AreEqual(expectedQuery, query);
}
public void GetVersionQuery_Always_ReturnsExpectedValues()
{
// Call
string query = HydraulicBoundaryDatabaseQueryBuilder.GetVersionQuery();
// Assert
const string expectedQuery = "SELECT (NameRegion || CreationDate || TrackId) as GeneratedVersion FROM General LIMIT 0,1;";
Assert.AreEqual(expectedQuery, query);
}
