public static global::OpenStudio.SqlFile SqlFile(string path)
{
if (string.IsNullOrWhiteSpace(path) || !System.IO.File.Exists(path))
{
return(null);
}
global::OpenStudio.Path openStudioPath = global::OpenStudio.OpenStudioUtilitiesCore.toPath(path);
if (openStudioPath == null)
{
return(null);
}
global::OpenStudio.SqlFile sqlFile = new global::OpenStudio.SqlFile(openStudioPath);
return(sqlFile);
}
public static List <double> Values(this global::OpenStudio.SqlFile sqlFile, string enviromentPeriodName, string timeSeriesName, ReportingFrequency reportingFrequency = ReportingFrequency.Hourly)
{
if (sqlFile == null || enviromentPeriodName == null || timeSeriesName == null || reportingFrequency == ReportingFrequency.Undefined)
{
return(null);
}
global::OpenStudio.TimeSeriesVector timeSeriesVector = sqlFile.timeSeries(enviromentPeriodName, Core.Query.Description(reportingFrequency), timeSeriesName);
List <double> result = new List <double>();
foreach (global::OpenStudio.TimeSeries timeSeries in timeSeriesVector)
{
List <double> values = timeSeries.values()?.ToSystem();
if (values != null)
{
result.AddRange(values);
}
}
return(result);
}
public static List <string> AvailableEnvironmentPeriodsNames(this global::OpenStudio.SqlFile sqlFile)
{
return(Convert.ToSystem(sqlFile?.availableEnvPeriods()));
}
public static List <string> AvailableTimeSeriesNames(this global::OpenStudio.SqlFile sqlFile)
{
return(Convert.ToSystem(sqlFile?.availableTimeSeries()));
}
