Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs
===================================================================
diff -u -r64d60335b1deab4bafd37f78f3514660cc4afb27 -rf8c28b3b04cdabb62ea37772efcb1f4ebbbf2b9e
--- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 64d60335b1deab4bafd37f78f3514660cc4afb27)
+++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision f8c28b3b04cdabb62ea37772efcb1f4ebbbf2b9e)
@@ -27,16 +27,27 @@
public static class HydraulicLocationConfigurationDatabaseQueryBuilder
{
///
- /// Returns the query to get the LocationIds from the database.
+ /// Gets the query to get the LocationIds from the database.
///
/// The query to get the locationIds from the database.
public static string GetLocationsIdByTrackIdQuery()
{
- return string.Format("SELECT {0}, {1} FROM {2} WHERE {3} = @{3} ORDER BY {1};",
- LocationsTableDefinitions.LocationId,
- LocationsTableDefinitions.HrdLocationId,
- LocationsTableDefinitions.TableName,
- LocationsTableDefinitions.TrackId);
+ return $"SELECT {LocationsTableDefinitions.LocationId}, {LocationsTableDefinitions.HrdLocationId} " +
+ $"FROM {LocationsTableDefinitions.TableName} " +
+ $"WHERE {TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId} " +
+ $"ORDER BY {LocationsTableDefinitions.HrdLocationId};";
}
+
+ ///
+ /// Gets the query to get the UsePreprocessor indicator from the database.
+ ///
+ /// The query to get the UsePreprocessor indicator from the database.
+ public static string GetUsePreprocessorByTrackIdQuery()
+ {
+ return $"SELECT * FROM {RegionsTableDefinitions.TableName} " +
+ $"LEFT JOIN {TracksTableDefinitions.TableName} " +
+ $"ON {RegionsTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} = {TracksTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} " +
+ $"WHERE {TracksTableDefinitions.TableName}.{TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId}";
+ }
}
}
\ No newline at end of file