#include <SqlFile.hpp>
Public Member Functions | |
Constructors | |
SqlFile () | |
default constructor More... | |
SqlFile (const openstudio::path &path, const bool createIndexes=true) | |
constructor from path Creates indexes by default, pass in false for no new indexes and quicker opening More... | |
SqlFile (const openstudio::path &t_path, const openstudio::EpwFile &t_epwFile, const openstudio::DateTime &t_simulationTime, const openstudio::Calendar &t_calendar, const bool createIndexes=true) | |
initializes a new sql file for output Creates indexes by default, pass in false for no indexes and quicker creation More... | |
virtual | ~SqlFile () |
void | removeIndexes () |
void | createIndexes () |
File Queries and Operations | |
bool | connectionOpen () const |
returns whether or not connection is open More... | |
openstudio::path | path () const |
get the path More... | |
bool | supportedVersion () const |
bool | close () |
close the file More... | |
bool | reopen () |
re-open the file More... | |
std::string | energyPlusSqliteFile () const |
Energy Plus eplusout.sql file name. More... | |
Standard Queries | |
boost::optional< double > | hoursSimulated () const |
hours simulated More... | |
boost::optional< double > | netSiteEnergy () const |
net site energy in GJ More... | |
boost::optional< double > | netSourceEnergy () const |
net source energy in GJ More... | |
boost::optional< double > | totalSiteEnergy () const |
total site energy in GJ More... | |
boost::optional< double > | totalSourceEnergy () const |
total source energy in GJ More... | |
boost::optional< double > | annualTotalCost (const FuelType &fuel) const |
Returns the annual total cost associated with the given fuel type in dollars. More... | |
boost::optional< double > | annualTotalCostPerBldgArea (const FuelType &fuel) const |
Returns the annual total cost per total building area associated with the given fuel type in dollars per square meter. More... | |
boost::optional< double > | annualTotalCostPerNetConditionedBldgArea (const FuelType &fuel) const |
Returns the annual total cost per net conditioned building area associated with the given fuel type in dollars per square meter. More... | |
boost::optional< double > | annualTotalUtilityCost () const |
Returns the annual total cost for all fuel types in dollars. More... | |
boost::optional< double > | economicsEnergyCost () const |
Returns the total energy cost over the analysis period in dollars according to the discounting convention. More... | |
OptionalDouble | getElecOrGasUse (bool getGas=true) const |
OptionalDouble | getElecOrGasCost (bool bGetGas=true) const |
boost::optional< EndUses > | endUses () const |
Returns an EndUses object containing all end uses for the simulation. More... | |
boost::optional< double > | energyConsumptionByMonth (const openstudio::EndUseFuelType &t_fuelType, const openstudio::EndUseCategoryType &t_categoryType, const openstudio::MonthOfYear &t_monthOfYear) const |
Returns the energy consumption for the given fuel type, category and month. More... | |
boost::optional< double > | peakEnergyDemandByMonth (const openstudio::EndUseFuelType &t_fuelType, const openstudio::EndUseCategoryType &t_categoryType, const openstudio::MonthOfYear &t_monthOfYear) const |
Returns the energy demand for the given fuel type, category and month. More... | |
boost::optional< double > | electricityHeating () const |
Returns the electric energy used for heating in gigajoules. More... | |
boost::optional< double > | electricityCooling () const |
Returns the electric energy used for cooling in gigajoules. More... | |
boost::optional< double > | electricityInteriorLighting () const |
Returns the electric energy used for interior lighting in gigajoules. More... | |
boost::optional< double > | electricityExteriorLighting () const |
Returns the electric energy used for exterior lighting in gigajoules. More... | |
boost::optional< double > | electricityInteriorEquipment () const |
Returns the electric energy used for interior equipment in gigajoules. More... | |
boost::optional< double > | electricityExteriorEquipment () const |
Returns the electric energy used for exterior equipment in gigajoules. More... | |
boost::optional< double > | electricityFans () const |
Returns the electric energy used for fans in gigajoules. More... | |
boost::optional< double > | electricityPumps () const |
Returns the electric energy used for pumps in gigajoules. More... | |
boost::optional< double > | electricityHeatRejection () const |
Returns the electric energy used for heat rejection in gigajoules. More... | |
boost::optional< double > | electricityHumidification () const |
Returns the electric energy used for humidification in gigajoules. More... | |
boost::optional< double > | electricityHeatRecovery () const |
Returns the electric energy used for heat recovery in gigajoules. More... | |
boost::optional< double > | electricityWaterSystems () const |
Returns the electric energy used for water systems in gigajoules. More... | |
boost::optional< double > | electricityRefrigeration () const |
Returns the electric energy used for refrigeration in gigajoules. More... | |
boost::optional< double > | electricityGenerators () const |
Returns the electric energy used for generators in gigajoules. More... | |
boost::optional< double > | electricityTotalEndUses () const |
Returns the electric energy used for all uses in gigajoules. More... | |
boost::optional< double > | naturalGasHeating () const |
Returns the natural gas energy used for heating in gigajoules. More... | |
boost::optional< double > | naturalGasCooling () const |
Returns the natural gas energy used for cooling in gigajoules. More... | |
boost::optional< double > | naturalGasInteriorLighting () const |
Returns the natural gas energy used for interior lighting in gigajoules. More... | |
boost::optional< double > | naturalGasExteriorLighting () const |
Returns the natural gas energy used for exterior lighting in gigajoules. More... | |
boost::optional< double > | naturalGasInteriorEquipment () const |
Returns the natural gas energy used for interior equipment in gigajoules. More... | |
boost::optional< double > | naturalGasExteriorEquipment () const |
Returns the natural gas energy used for exterior equipment in gigajoules. More... | |
boost::optional< double > | naturalGasFans () const |
Returns the natural gas energy used for fans in gigajoules. More... | |
boost::optional< double > | naturalGasPumps () const |
Returns the natural gas energy used for pumps in gigajoules. More... | |
boost::optional< double > | naturalGasHeatRejection () const |
Returns the natural gas energy used for heat rejection in gigajoules. More... | |
boost::optional< double > | naturalGasHumidification () const |
Returns the natural gas energy used for humidification in gigajoules. More... | |
boost::optional< double > | naturalGasHeatRecovery () const |
Returns the natural gas energy used for heat recovery in gigajoules. More... | |
boost::optional< double > | naturalGasWaterSystems () const |
Returns the natural gas energy used for water systems in gigajoules. More... | |
boost::optional< double > | naturalGasRefrigeration () const |
Returns the natural gas energy used for refrigeration in gigajoules. More... | |
boost::optional< double > | naturalGasGenerators () const |
Returns the natural gas energy used for generators in gigajoules. More... | |
boost::optional< double > | naturalGasTotalEndUses () const |
Returns the natural gas energy used for all end uses in gigajoules. More... | |
boost::optional< double > | otherFuelHeating () const |
Returns the energy used for heating from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelCooling () const |
Returns the energy used for cooling from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelInteriorLighting () const |
Returns the energy used for interior lighting from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelExteriorLighting () const |
Returns the energy used for exterior lighting from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelInteriorEquipment () const |
Returns the energy used for interior equipment from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelExteriorEquipment () const |
Returns the energy used for exterior equipment from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelFans () const |
Returns the energy used for fans from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelPumps () const |
Returns the energy used for pumps from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelHeatRejection () const |
Returns the energy used for heat rejection from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelHumidification () const |
Returns the energy used for humidification from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelHeatRecovery () const |
Returns the energy used for heat recovery from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelWaterSystems () const |
Returns the energy used for water systems from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelRefrigeration () const |
Returns the energy used for refrigeration from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelGenerators () const |
Returns the energy used for generators from other fuel in gigajoules. More... | |
boost::optional< double > | otherFuelTotalEndUses () const |
Returns the energy used for all end uses from other fuel in gigajoules. More... | |
boost::optional< double > | districtCoolingHeating () const |
Returns the district cooling energy used for heating in gigajoules. More... | |
boost::optional< double > | districtCoolingCooling () const |
Returns the district cooling energy used for cooling in gigajoules. More... | |
boost::optional< double > | districtCoolingInteriorLighting () const |
Returns the district cooling energy used for interior lighting in gigajoules. More... | |
boost::optional< double > | districtCoolingExteriorLighting () const |
Returns the district cooling energy used for exterior lighting in gigajoules. More... | |
boost::optional< double > | districtCoolingInteriorEquipment () const |
Returns the district cooling energy used for interior equipment in gigajoules. More... | |
boost::optional< double > | districtCoolingExteriorEquipment () const |
Returns the district cooling energy used for exterior equipment in gigajoules. More... | |
boost::optional< double > | districtCoolingFans () const |
Returns the district cooling energy used for fans in gigajoules. More... | |
boost::optional< double > | districtCoolingPumps () const |
Returns the district cooling energy used for pumps in gigajoules. More... | |
boost::optional< double > | districtCoolingHeatRejection () const |
Returns the district cooling energy used for heat rejection in gigajoules. More... | |
boost::optional< double > | districtCoolingHumidification () const |
Returns the district cooling energy used for humidification in gigajoules. More... | |
boost::optional< double > | districtCoolingHeatRecovery () const |
Returns the district cooling energy used for heat recovery in gigajoules. More... | |
boost::optional< double > | districtCoolingWaterSystems () const |
Returns the district cooling energy used for water systems in gigajoules. More... | |
boost::optional< double > | districtCoolingRefrigeration () const |
Returns the district cooling energy used for refrigeration in gigajoules. More... | |
boost::optional< double > | districtCoolingGenerators () const |
Returns the district cooling energy used for generators in gigajoules. More... | |
boost::optional< double > | districtCoolingTotalEndUses () const |
Returns the district cooling energy used for all end uses in gigajoules. More... | |
boost::optional< double > | districtHeatingHeating () const |
Returns the district heating energy used for heating in gigajoules. More... | |
boost::optional< double > | districtHeatingCooling () const |
Returns the district heating energy used for cooling in gigajoules. More... | |
boost::optional< double > | districtHeatingInteriorLighting () const |
Returns the district heating energy used for interior lighting in gigajoules. More... | |
boost::optional< double > | districtHeatingExteriorLighting () const |
Returns the district heating energy used for exterior lighting in gigajoules. More... | |
boost::optional< double > | districtHeatingInteriorEquipment () const |
Returns the district heating energy used for interior equipment in gigajoules. More... | |
boost::optional< double > | districtHeatingExteriorEquipment () const |
Returns the district heating energy used for exterior equipment in gigajoules. More... | |
boost::optional< double > | districtHeatingFans () const |
Returns the district heating energy used for fans in gigajoules. More... | |
boost::optional< double > | districtHeatingPumps () const |
Returns the district heating energy used for pumps in gigajoules. More... | |
boost::optional< double > | districtHeatingHeatRejection () const |
Returns the district heating energy used for heat rejection in gigajoules. More... | |
boost::optional< double > | districtHeatingHumidification () const |
Returns the district heating energy used for humidification in gigajoules. More... | |
boost::optional< double > | districtHeatingHeatRecovery () const |
Returns the district heating energy used for heat recovery in gigajoules. More... | |
boost::optional< double > | districtHeatingWaterSystems () const |
Returns the district heating energy used for water systems in gigajoules. More... | |
boost::optional< double > | districtHeatingRefrigeration () const |
Returns the district heating energy used for refrigeration in gigajoules. More... | |
boost::optional< double > | districtHeatingGenerators () const |
Returns the district heating energy used for generators in gigajoules. More... | |
boost::optional< double > | districtHeatingTotalEndUses () const |
Returns the district heating energy used for all end uses in gigajoules. More... | |
boost::optional< double > | waterHeating () const |
Returns the water used for heating in cubic meters. More... | |
boost::optional< double > | waterCooling () const |
Returns the water used for cooling in cubic meters. More... | |
boost::optional< double > | waterInteriorLighting () const |
Returns the water used for interior lighting in cubic meters. More... | |
boost::optional< double > | waterExteriorLighting () const |
Returns the water used for exterior lighting in cubic meters. More... | |
boost::optional< double > | waterInteriorEquipment () const |
Returns the water used for interior equipment in cubic meters. More... | |
boost::optional< double > | waterExteriorEquipment () const |
Returns the water used for exterior equipment in cubic meters. More... | |
boost::optional< double > | waterFans () const |
Returns the water used for fans in cubic meters. More... | |
boost::optional< double > | waterPumps () const |
Returns the water used for pumps in cubic meters. More... | |
boost::optional< double > | waterHeatRejection () const |
Returns the water used for heat rejection in cubic meters. More... | |
boost::optional< double > | waterHumidification () const |
Returns the water used for humidification in cubic meters. More... | |
boost::optional< double > | waterHeatRecovery () const |
Returns the water used for heat recovery in cubic meters. More... | |
boost::optional< double > | waterWaterSystems () const |
Returns the water used for water systems in cubic meters. More... | |
boost::optional< double > | waterRefrigeration () const |
Returns the water used for refrigeration in cubic meters. More... | |
boost::optional< double > | waterGenerators () const |
Returns the water used for generators in cubic meters. More... | |
boost::optional< double > | waterTotalEndUses () const |
Returns the water used for all uses in cubic meters. More... | |
boost::optional< double > | hoursHeatingSetpointNotMet () const |
Returns the total number of hours the heating setpoint is not met. More... | |
boost::optional< double > | hoursCoolingSetpointNotMet () const |
Returns the total number of hours the cooling setpoint is not met. More... | |
boost::optional< std::pair < DateTime, DateTime > > | daylightSavingsPeriod () const |
std::string | energyPlusVersion () const |
Energy plus version number. More... | |
Generic TimeSeries Interface | |
std::vector< std::string > | availableTimeSeries () |
boost::optional < openstudio::EnvironmentType > | environmentType (const std::string &envPeriod) const |
std::vector< std::string > | availableEnvPeriods () const |
std::vector< std::string > | availableReportingFrequencies (const std::string &envPeriod) |
boost::optional < openstudio::ReportingFrequency > | reportingFrequencyFromDB (const std::string &dbReportingFrequency) |
std::vector< std::string > | availableVariableNames (const std::string &envPeriod, const std::string &reportingFrequency) const |
std::vector< TimeSeries > | timeSeries (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName) |
std::vector< std::string > | availableKeyValues (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName) |
boost::optional< double > | runPeriodValue (const std::string &envPeriod, const std::string &timeSeriesName, const std::string &keyValue) |
boost::optional< TimeSeries > | timeSeries (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName, const std::string &keyValue) |
std::vector < SqlFileTimeSeriesQuery > | expandQuery (const SqlFileTimeSeriesQuery &query) |
Expands query to create a vector of all matching queries. More... | |
std::vector< TimeSeries > | timeSeries (const SqlFileTimeSeriesQuery &query) |
Executes query. More... | |
Illuminance Map Interface | |
std::vector< std::string > | illuminanceMapNames () const |
get names of all available illuminance maps More... | |
std::vector< std::string > | illuminanceMapNames (const std::string &envPeriod) const |
std::vector< std::string > | illuminanceMapZoneNames (const std::string &name) const |
get zone names of for specified illuminance map More... | |
std::vector< std::string > | illuminanceMapZoneNames (const int &mapIndex) const |
boost::optional< std::string > | illuminanceMapRefPt (const std::string &name, const int &ptNum) const |
reference point for map - form RefPtn=(x:y:illuminance) More... | |
boost::optional< std::string > | illuminanceMapRefPt (const int &mapIndex, const int &ptNum) const |
boost::optional< double > | illuminanceMapMinValue (const std::string &name) const |
minimum value of map More... | |
boost::optional< double > | illuminanceMapMinValue (const int &mapIndex) const |
boost::optional< double > | illuminanceMapMaxValue (const std::string &name) const |
maximum value of map More... | |
boost::optional< double > | illuminanceMapMaxValue (const int &mapIndex) const |
void | illuminanceMapMaxValue (const std::string &name, double &minValue, double &maxValue) const |
minimum and maximum of map More... | |
void | illuminanceMapMaxValue (const int &mapIndex, double &minValue, double &maxValue) const |
boost::optional< int > | illuminanceMapIndex (const std::string &name) const |
Vector | illuminanceMapX (const std::string &name, const DateTime &dateTime) const |
x position (m) of the illuminance map More... | |
Vector | illuminanceMapY (const std::string &name, const DateTime &dateTime) const |
y position (m) of the illuminance map More... | |
Vector | illuminanceMapX (const int &hourlyReportIndex) const |
x position (m) of the illuminance map More... | |
Vector | illuminanceMapY (const int &hourlyReportIndex) const |
y position (m) of the illuminance map More... | |
boost::optional< int > | illuminanceMapHourlyReportIndex (const int &mapIndex, const DateTime &dateTime) const |
hourly report index for mapIndex at date and time More... | |
boost::optional< DateTime > | illuminanceMapDate (const int &hourlyReportIndex) const |
date time at hourly report index More... | |
std::vector< int > | illuminanceMapHourlyReportIndices (const std::string &name) const |
hourly report indices of the illuminance map More... | |
std::vector< std::pair< int, DateTime > > | illuminanceMapHourlyReportIndicesDates (const int &mapIndex) const |
hourly report indices of the illuminance map More... | |
std::vector< std::pair< int, DateTime > > | illuminanceMapHourlyReportIndicesDates (const std::string &name) const |
hourly report indices of the illuminance map More... | |
std::vector< int > | illuminanceMapHourlyReportIndices (const int &mapIndex) const |
hourly report indices of the illuminance map More... | |
Matrix | illuminanceMap (const std::string &name, const DateTime &dateTime) const |
value (lux) of the illuminance map at date and time value(i,j) is the illuminance at x(i), y(j) More... | |
Matrix | illuminanceMap (const int &hourlyReportIndex) const |
value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j) More... | |
void | illuminanceMap (const int &hourlyReportIndex, std::vector< double > &x, std::vector< double > &y, std::vector< double > &illuminance) const |
value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j) fills in x,y, illuminance More... | |
std::vector< SummaryData > | getSummaryData () const |
Returns the summary data for each installlocation and fuel type found in report variables. More... | |
int | insertZone (const std::string &t_name, double t_relNorth, double t_originX, double t_originY, double t_originZ, double t_centroidX, double t_centroidY, double t_centroidZ, int t_ofType, double t_multiplier, double t_listMultiplier, double t_minimumX, double t_maximumX, double t_minimumY, double t_maximumY, double t_minimumZ, double t_maximumZ, double t_ceilingHeight, double t_volume, int t_insideConvectionAlgo, int t_outsideConvectionAlgo, double t_floorArea, double t_extGrossWallArea, double t_extNetWallArea, double t_extWindowArea, bool t_isPartOfTotalArea) |
void | insertIlluminanceMap (const std::string &t_zoneName, const std::string &name, const std::string &t_environmentName, const std::vector< DateTime > &t_times, const std::vector< double > &t_xs, const std::vector< double > &t_ys, double t_z, const std::vector< Matrix > &t_maps) |
Generic Query Interface | |
boost::optional< double > | execAndReturnFirstDouble (const std::string &statement) const |
execute a statement and return the first (if any) value as a double More... | |
boost::optional< int > | execAndReturnFirstInt (const std::string &statement) const |
execute a statement and return the first (if any) value as a int More... | |
boost::optional< std::string > | execAndReturnFirstString (const std::string &statement) const |
execute a statement and return the first (if any) value as a string More... | |
boost::optional< std::vector < double > > | execAndReturnVectorOfDouble (const std::string &statement) const |
execute a statement and return the results (if any) in a vector of double More... | |
boost::optional< std::vector < int > > | execAndReturnVectorOfInt (const std::string &statement) const |
execute a statement and return the results (if any) in a vector of int More... | |
boost::optional< std::vector < std::string > > | execAndReturnVectorOfString (const std::string &statement) const |
execute a statement and return the results (if any) in a vector of string More... | |
int | execute (const std::string &statement) |
execute a statement and return the error code, used for create/drop tables More... | |
void | insertTimeSeriesData (const std::string &t_variableType, const std::string &t_indexGroup, const std::string &t_timestepType, const std::string &t_keyValue, const std::string &t_variableName, const openstudio::ReportingFrequency &t_reportingFrequency, const boost::optional< std::string > &t_scheduleName, const std::string &t_variableUnits, const openstudio::TimeSeries &t_timeSeries) |
Operators | |
bool | operator== (const SqlFile &other) const |
bool | operator< (const SqlFile &other) const |
SqlFile class is a transaction script around the sql output of EnergyPlus.
openstudio::SqlFile::SqlFile | ( | ) |
default constructor
|
explicit |
constructor from path Creates indexes by default, pass in false for no new indexes and quicker opening
openstudio::SqlFile::SqlFile | ( | const openstudio::path & | t_path, |
const openstudio::EpwFile & | t_epwFile, | ||
const openstudio::DateTime & | t_simulationTime, | ||
const openstudio::Calendar & | t_calendar, | ||
const bool | createIndexes = true |
||
) |
initializes a new sql file for output Creates indexes by default, pass in false for no indexes and quicker creation
|
virtual |
boost::optional<double> openstudio::SqlFile::annualTotalCost | ( | const FuelType & | fuel | ) | const |
Returns the annual total cost associated with the given fuel type in dollars.
Requires EnergyPlus simulation output to calculate.
boost::optional<double> openstudio::SqlFile::annualTotalCostPerBldgArea | ( | const FuelType & | fuel | ) | const |
Returns the annual total cost per total building area associated with the given fuel type in dollars per square meter.
Requires EnergyPlus simulation output to calculate.
boost::optional<double> openstudio::SqlFile::annualTotalCostPerNetConditionedBldgArea | ( | const FuelType & | fuel | ) | const |
Returns the annual total cost per net conditioned building area associated with the given fuel type in dollars per square meter.
Requires EnergyPlus simulation output to calculate.
boost::optional<double> openstudio::SqlFile::annualTotalUtilityCost | ( | ) | const |
Returns the annual total cost for all fuel types in dollars.
Requires EnergyPlus simulation output to calculate. Attribute name: annualTotalUtilityCost
std::vector<std::string> openstudio::SqlFile::availableEnvPeriods | ( | ) | const |
std::vector<std::string> openstudio::SqlFile::availableKeyValues | ( | const std::string & | envPeriod, |
const std::string & | reportingFrequency, | ||
const std::string & | timeSeriesName | ||
) |
std::vector<std::string> openstudio::SqlFile::availableReportingFrequencies | ( | const std::string & | envPeriod | ) |
std::vector<std::string> openstudio::SqlFile::availableTimeSeries | ( | ) |
std::vector<std::string> openstudio::SqlFile::availableVariableNames | ( | const std::string & | envPeriod, |
const std::string & | reportingFrequency | ||
) | const |
bool openstudio::SqlFile::close | ( | ) |
close the file
bool openstudio::SqlFile::connectionOpen | ( | ) | const |
returns whether or not connection is open
void openstudio::SqlFile::createIndexes | ( | ) |
boost::optional<std::pair<DateTime, DateTime> > openstudio::SqlFile::daylightSavingsPeriod | ( | ) | const |
boost::optional<double> openstudio::SqlFile::districtCoolingCooling | ( | ) | const |
Returns the district cooling energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingCooling
boost::optional<double> openstudio::SqlFile::districtCoolingExteriorEquipment | ( | ) | const |
Returns the district cooling energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingExteriorEquipment
boost::optional<double> openstudio::SqlFile::districtCoolingExteriorLighting | ( | ) | const |
Returns the district cooling energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingExteriorLighting
boost::optional<double> openstudio::SqlFile::districtCoolingFans | ( | ) | const |
Returns the district cooling energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingFans
boost::optional<double> openstudio::SqlFile::districtCoolingGenerators | ( | ) | const |
Returns the district cooling energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingRefrigeration
boost::optional<double> openstudio::SqlFile::districtCoolingHeating | ( | ) | const |
Returns the district cooling energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingHeating
boost::optional<double> openstudio::SqlFile::districtCoolingHeatRecovery | ( | ) | const |
Returns the district cooling energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingHeatRecovery
boost::optional<double> openstudio::SqlFile::districtCoolingHeatRejection | ( | ) | const |
Returns the district cooling energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingHeatRejection
boost::optional<double> openstudio::SqlFile::districtCoolingHumidification | ( | ) | const |
Returns the district cooling energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingHumidification
boost::optional<double> openstudio::SqlFile::districtCoolingInteriorEquipment | ( | ) | const |
Returns the district cooling energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingInteriorEquipment
boost::optional<double> openstudio::SqlFile::districtCoolingInteriorLighting | ( | ) | const |
Returns the district cooling energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingInteriorLighting
boost::optional<double> openstudio::SqlFile::districtCoolingPumps | ( | ) | const |
Returns the district cooling energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingPumps
boost::optional<double> openstudio::SqlFile::districtCoolingRefrigeration | ( | ) | const |
Returns the district cooling energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingRefrigeration
boost::optional<double> openstudio::SqlFile::districtCoolingTotalEndUses | ( | ) | const |
Returns the district cooling energy used for all end uses in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingRefrigeration
boost::optional<double> openstudio::SqlFile::districtCoolingWaterSystems | ( | ) | const |
Returns the district cooling energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtCoolingWaterSystems
boost::optional<double> openstudio::SqlFile::districtHeatingCooling | ( | ) | const |
Returns the district heating energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingCooling
boost::optional<double> openstudio::SqlFile::districtHeatingExteriorEquipment | ( | ) | const |
Returns the district heating energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingExteriorEquipment
boost::optional<double> openstudio::SqlFile::districtHeatingExteriorLighting | ( | ) | const |
Returns the district heating energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingExteriorLighting
boost::optional<double> openstudio::SqlFile::districtHeatingFans | ( | ) | const |
Returns the district heating energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingFans
boost::optional<double> openstudio::SqlFile::districtHeatingGenerators | ( | ) | const |
Returns the district heating energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingGenerators
boost::optional<double> openstudio::SqlFile::districtHeatingHeating | ( | ) | const |
Returns the district heating energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingHeating
boost::optional<double> openstudio::SqlFile::districtHeatingHeatRecovery | ( | ) | const |
Returns the district heating energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingHeatRecovery
boost::optional<double> openstudio::SqlFile::districtHeatingHeatRejection | ( | ) | const |
Returns the district heating energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingHeatRejection
boost::optional<double> openstudio::SqlFile::districtHeatingHumidification | ( | ) | const |
Returns the district heating energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingHumidification
boost::optional<double> openstudio::SqlFile::districtHeatingInteriorEquipment | ( | ) | const |
Returns the district heating energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingInteriorEquipment
boost::optional<double> openstudio::SqlFile::districtHeatingInteriorLighting | ( | ) | const |
Returns the district heating energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingInteriorLighting
boost::optional<double> openstudio::SqlFile::districtHeatingPumps | ( | ) | const |
Returns the district heating energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingPumps
boost::optional<double> openstudio::SqlFile::districtHeatingRefrigeration | ( | ) | const |
Returns the district heating energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingRefrigeration
boost::optional<double> openstudio::SqlFile::districtHeatingTotalEndUses | ( | ) | const |
Returns the district heating energy used for all end uses in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingTotalEndUses
boost::optional<double> openstudio::SqlFile::districtHeatingWaterSystems | ( | ) | const |
Returns the district heating energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: districtHeatingWaterSystems
boost::optional<double> openstudio::SqlFile::economicsEnergyCost | ( | ) | const |
Returns the total energy cost over the analysis period in dollars according to the discounting convention.
Requires EnergyPlus simulation output and LifeCycleCost_Parameters input object to calculate. Attribute name: economicsEnergyCost
boost::optional<double> openstudio::SqlFile::electricityCooling | ( | ) | const |
Returns the electric energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityCooling
boost::optional<double> openstudio::SqlFile::electricityExteriorEquipment | ( | ) | const |
Returns the electric energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityExteriorEquipment
boost::optional<double> openstudio::SqlFile::electricityExteriorLighting | ( | ) | const |
Returns the electric energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityExteriorLighting
boost::optional<double> openstudio::SqlFile::electricityFans | ( | ) | const |
Returns the electric energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityFans
boost::optional<double> openstudio::SqlFile::electricityGenerators | ( | ) | const |
Returns the electric energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityGenerators
boost::optional<double> openstudio::SqlFile::electricityHeating | ( | ) | const |
Returns the electric energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityHeating
boost::optional<double> openstudio::SqlFile::electricityHeatRecovery | ( | ) | const |
Returns the electric energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityHeatRecovery
boost::optional<double> openstudio::SqlFile::electricityHeatRejection | ( | ) | const |
Returns the electric energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityHeatRejection
boost::optional<double> openstudio::SqlFile::electricityHumidification | ( | ) | const |
Returns the electric energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityHumidification
boost::optional<double> openstudio::SqlFile::electricityInteriorEquipment | ( | ) | const |
Returns the electric energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityInteriorEquipment
boost::optional<double> openstudio::SqlFile::electricityInteriorLighting | ( | ) | const |
Returns the electric energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityInteriorLighting
boost::optional<double> openstudio::SqlFile::electricityPumps | ( | ) | const |
Returns the electric energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityPumps
boost::optional<double> openstudio::SqlFile::electricityRefrigeration | ( | ) | const |
Returns the electric energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityRefrigeration
boost::optional<double> openstudio::SqlFile::electricityTotalEndUses | ( | ) | const |
Returns the electric energy used for all uses in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityTotalEndUses
boost::optional<double> openstudio::SqlFile::electricityWaterSystems | ( | ) | const |
Returns the electric energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: electricityWaterSystems
boost::optional<EndUses> openstudio::SqlFile::endUses | ( | ) | const |
Returns an EndUses object containing all end uses for the simulation.
boost::optional<double> openstudio::SqlFile::energyConsumptionByMonth | ( | const openstudio::EndUseFuelType & | t_fuelType, |
const openstudio::EndUseCategoryType & | t_categoryType, | ||
const openstudio::MonthOfYear & | t_monthOfYear | ||
) | const |
Returns the energy consumption for the given fuel type, category and month.
Requires BUILDING ENERGY PERFORMANCE tabular report. Value is energy use in J.
std::string openstudio::SqlFile::energyPlusSqliteFile | ( | ) | const |
Energy Plus eplusout.sql file name.
std::string openstudio::SqlFile::energyPlusVersion | ( | ) | const |
Energy plus version number.
boost::optional<openstudio::EnvironmentType> openstudio::SqlFile::environmentType | ( | const std::string & | envPeriod | ) | const |
boost::optional<double> openstudio::SqlFile::execAndReturnFirstDouble | ( | const std::string & | statement | ) | const |
execute a statement and return the first (if any) value as a double
boost::optional<int> openstudio::SqlFile::execAndReturnFirstInt | ( | const std::string & | statement | ) | const |
execute a statement and return the first (if any) value as a int
boost::optional<std::string> openstudio::SqlFile::execAndReturnFirstString | ( | const std::string & | statement | ) | const |
execute a statement and return the first (if any) value as a string
boost::optional<std::vector<double> > openstudio::SqlFile::execAndReturnVectorOfDouble | ( | const std::string & | statement | ) | const |
execute a statement and return the results (if any) in a vector of double
boost::optional<std::vector<int> > openstudio::SqlFile::execAndReturnVectorOfInt | ( | const std::string & | statement | ) | const |
execute a statement and return the results (if any) in a vector of int
boost::optional<std::vector<std::string> > openstudio::SqlFile::execAndReturnVectorOfString | ( | const std::string & | statement | ) | const |
execute a statement and return the results (if any) in a vector of string
int openstudio::SqlFile::execute | ( | const std::string & | statement | ) |
execute a statement and return the error code, used for create/drop tables
std::vector<SqlFileTimeSeriesQuery> openstudio::SqlFile::expandQuery | ( | const SqlFileTimeSeriesQuery & | query | ) |
Expands query to create a vector of all matching queries.
The returned queries will have one environment period, one reporting frequency, and one time series name specified. The returned queries will also be "vetted".
OptionalDouble openstudio::SqlFile::getElecOrGasCost | ( | bool | bGetGas = true | ) | const |
OptionalDouble openstudio::SqlFile::getElecOrGasUse | ( | bool | getGas = true | ) | const |
std::vector<SummaryData> openstudio::SqlFile::getSummaryData | ( | ) | const |
Returns the summary data for each installlocation and fuel type found in report variables.
boost::optional<double> openstudio::SqlFile::hoursCoolingSetpointNotMet | ( | ) | const |
Returns the total number of hours the cooling setpoint is not met.
Requires EnergyPlus simulation output to calculate.
boost::optional<double> openstudio::SqlFile::hoursHeatingSetpointNotMet | ( | ) | const |
Returns the total number of hours the heating setpoint is not met.
Requires EnergyPlus simulation output to calculate.
boost::optional<double> openstudio::SqlFile::hoursSimulated | ( | ) | const |
hours simulated
Matrix openstudio::SqlFile::illuminanceMap | ( | const std::string & | name, |
const DateTime & | dateTime | ||
) | const |
value (lux) of the illuminance map at date and time value(i,j) is the illuminance at x(i), y(j)
Matrix openstudio::SqlFile::illuminanceMap | ( | const int & | hourlyReportIndex | ) | const |
value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j)
void openstudio::SqlFile::illuminanceMap | ( | const int & | hourlyReportIndex, |
std::vector< double > & | x, | ||
std::vector< double > & | y, | ||
std::vector< double > & | illuminance | ||
) | const |
value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j) fills in x,y, illuminance
boost::optional<DateTime> openstudio::SqlFile::illuminanceMapDate | ( | const int & | hourlyReportIndex | ) | const |
date time at hourly report index
boost::optional<int> openstudio::SqlFile::illuminanceMapHourlyReportIndex | ( | const int & | mapIndex, |
const DateTime & | dateTime | ||
) | const |
hourly report index for mapIndex at date and time
std::vector<int> openstudio::SqlFile::illuminanceMapHourlyReportIndices | ( | const std::string & | name | ) | const |
hourly report indices of the illuminance map
std::vector<int> openstudio::SqlFile::illuminanceMapHourlyReportIndices | ( | const int & | mapIndex | ) | const |
hourly report indices of the illuminance map
std::vector< std::pair<int, DateTime> > openstudio::SqlFile::illuminanceMapHourlyReportIndicesDates | ( | const int & | mapIndex | ) | const |
hourly report indices of the illuminance map
std::vector< std::pair<int, DateTime> > openstudio::SqlFile::illuminanceMapHourlyReportIndicesDates | ( | const std::string & | name | ) | const |
hourly report indices of the illuminance map
boost::optional<int> openstudio::SqlFile::illuminanceMapIndex | ( | const std::string & | name | ) | const |
boost::optional<double> openstudio::SqlFile::illuminanceMapMaxValue | ( | const std::string & | name | ) | const |
maximum value of map
boost::optional<double> openstudio::SqlFile::illuminanceMapMaxValue | ( | const int & | mapIndex | ) | const |
void openstudio::SqlFile::illuminanceMapMaxValue | ( | const std::string & | name, |
double & | minValue, | ||
double & | maxValue | ||
) | const |
minimum and maximum of map
void openstudio::SqlFile::illuminanceMapMaxValue | ( | const int & | mapIndex, |
double & | minValue, | ||
double & | maxValue | ||
) | const |
boost::optional<double> openstudio::SqlFile::illuminanceMapMinValue | ( | const std::string & | name | ) | const |
minimum value of map
boost::optional<double> openstudio::SqlFile::illuminanceMapMinValue | ( | const int & | mapIndex | ) | const |
std::vector<std::string> openstudio::SqlFile::illuminanceMapNames | ( | ) | const |
get names of all available illuminance maps
std::vector<std::string> openstudio::SqlFile::illuminanceMapNames | ( | const std::string & | envPeriod | ) | const |
boost::optional<std::string> openstudio::SqlFile::illuminanceMapRefPt | ( | const std::string & | name, |
const int & | ptNum | ||
) | const |
reference point for map - form RefPtn=(x:y:illuminance)
boost::optional<std::string> openstudio::SqlFile::illuminanceMapRefPt | ( | const int & | mapIndex, |
const int & | ptNum | ||
) | const |
Vector openstudio::SqlFile::illuminanceMapX | ( | const std::string & | name, |
const DateTime & | dateTime | ||
) | const |
x position (m) of the illuminance map
Vector openstudio::SqlFile::illuminanceMapX | ( | const int & | hourlyReportIndex | ) | const |
x position (m) of the illuminance map
Vector openstudio::SqlFile::illuminanceMapY | ( | const std::string & | name, |
const DateTime & | dateTime | ||
) | const |
y position (m) of the illuminance map
Vector openstudio::SqlFile::illuminanceMapY | ( | const int & | hourlyReportIndex | ) | const |
y position (m) of the illuminance map
std::vector<std::string> openstudio::SqlFile::illuminanceMapZoneNames | ( | const std::string & | name | ) | const |
get zone names of for specified illuminance map
std::vector<std::string> openstudio::SqlFile::illuminanceMapZoneNames | ( | const int & | mapIndex | ) | const |
void openstudio::SqlFile::insertIlluminanceMap | ( | const std::string & | t_zoneName, |
const std::string & | name, | ||
const std::string & | t_environmentName, | ||
const std::vector< DateTime > & | t_times, | ||
const std::vector< double > & | t_xs, | ||
const std::vector< double > & | t_ys, | ||
double | t_z, | ||
const std::vector< Matrix > & | t_maps | ||
) |
void openstudio::SqlFile::insertTimeSeriesData | ( | const std::string & | t_variableType, |
const std::string & | t_indexGroup, | ||
const std::string & | t_timestepType, | ||
const std::string & | t_keyValue, | ||
const std::string & | t_variableName, | ||
const openstudio::ReportingFrequency & | t_reportingFrequency, | ||
const boost::optional< std::string > & | t_scheduleName, | ||
const std::string & | t_variableUnits, | ||
const openstudio::TimeSeries & | t_timeSeries | ||
) |
int openstudio::SqlFile::insertZone | ( | const std::string & | t_name, |
double | t_relNorth, | ||
double | t_originX, | ||
double | t_originY, | ||
double | t_originZ, | ||
double | t_centroidX, | ||
double | t_centroidY, | ||
double | t_centroidZ, | ||
int | t_ofType, | ||
double | t_multiplier, | ||
double | t_listMultiplier, | ||
double | t_minimumX, | ||
double | t_maximumX, | ||
double | t_minimumY, | ||
double | t_maximumY, | ||
double | t_minimumZ, | ||
double | t_maximumZ, | ||
double | t_ceilingHeight, | ||
double | t_volume, | ||
int | t_insideConvectionAlgo, | ||
int | t_outsideConvectionAlgo, | ||
double | t_floorArea, | ||
double | t_extGrossWallArea, | ||
double | t_extNetWallArea, | ||
double | t_extWindowArea, | ||
bool | t_isPartOfTotalArea | ||
) |
boost::optional<double> openstudio::SqlFile::naturalGasCooling | ( | ) | const |
Returns the natural gas energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasCooling
boost::optional<double> openstudio::SqlFile::naturalGasExteriorEquipment | ( | ) | const |
Returns the natural gas energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasInteriorEquipment
boost::optional<double> openstudio::SqlFile::naturalGasExteriorLighting | ( | ) | const |
Returns the natural gas energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasExteriorLighting
boost::optional<double> openstudio::SqlFile::naturalGasFans | ( | ) | const |
Returns the natural gas energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasFans
boost::optional<double> openstudio::SqlFile::naturalGasGenerators | ( | ) | const |
Returns the natural gas energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasGenerators
boost::optional<double> openstudio::SqlFile::naturalGasHeating | ( | ) | const |
Returns the natural gas energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasHeating
boost::optional<double> openstudio::SqlFile::naturalGasHeatRecovery | ( | ) | const |
Returns the natural gas energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasHeatRecovery
boost::optional<double> openstudio::SqlFile::naturalGasHeatRejection | ( | ) | const |
Returns the natural gas energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasHeatRejection
boost::optional<double> openstudio::SqlFile::naturalGasHumidification | ( | ) | const |
Returns the natural gas energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasHumidification
boost::optional<double> openstudio::SqlFile::naturalGasInteriorEquipment | ( | ) | const |
Returns the natural gas energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasInteriorEquipment
boost::optional<double> openstudio::SqlFile::naturalGasInteriorLighting | ( | ) | const |
Returns the natural gas energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasInteriorLighting
boost::optional<double> openstudio::SqlFile::naturalGasPumps | ( | ) | const |
Returns the natural gas energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasPumps
boost::optional<double> openstudio::SqlFile::naturalGasRefrigeration | ( | ) | const |
Returns the natural gas energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasRefrigeration
boost::optional<double> openstudio::SqlFile::naturalGasTotalEndUses | ( | ) | const |
Returns the natural gas energy used for all end uses in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasGenerators
boost::optional<double> openstudio::SqlFile::naturalGasWaterSystems | ( | ) | const |
Returns the natural gas energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: naturalGasWaterSystems
boost::optional<double> openstudio::SqlFile::netSiteEnergy | ( | ) | const |
net site energy in GJ
boost::optional<double> openstudio::SqlFile::netSourceEnergy | ( | ) | const |
net source energy in GJ
bool openstudio::SqlFile::operator< | ( | const SqlFile & | other | ) | const |
bool openstudio::SqlFile::operator== | ( | const SqlFile & | other | ) | const |
boost::optional<double> openstudio::SqlFile::otherFuelCooling | ( | ) | const |
Returns the energy used for cooling from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelCooling
boost::optional<double> openstudio::SqlFile::otherFuelExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelExteriorEquipment
boost::optional<double> openstudio::SqlFile::otherFuelExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelExteriorLighting
boost::optional<double> openstudio::SqlFile::otherFuelFans | ( | ) | const |
Returns the energy used for fans from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelFans
boost::optional<double> openstudio::SqlFile::otherFuelGenerators | ( | ) | const |
Returns the energy used for generators from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelGenerators
boost::optional<double> openstudio::SqlFile::otherFuelHeating | ( | ) | const |
Returns the energy used for heating from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelHeating
boost::optional<double> openstudio::SqlFile::otherFuelHeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelHeatRecovery
boost::optional<double> openstudio::SqlFile::otherFuelHeatRejection | ( | ) | const |
Returns the energy used for heat rejection from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelHeatRejection
boost::optional<double> openstudio::SqlFile::otherFuelHumidification | ( | ) | const |
Returns the energy used for humidification from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelHumidification
boost::optional<double> openstudio::SqlFile::otherFuelInteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelInteriorEquipment
boost::optional<double> openstudio::SqlFile::otherFuelInteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelInteriorLighting
boost::optional<double> openstudio::SqlFile::otherFuelPumps | ( | ) | const |
Returns the energy used for pumps from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelPumps
boost::optional<double> openstudio::SqlFile::otherFuelRefrigeration | ( | ) | const |
Returns the energy used for refrigeration from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelRefrigeration
boost::optional<double> openstudio::SqlFile::otherFuelTotalEndUses | ( | ) | const |
Returns the energy used for all end uses from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelTotalEndUses
boost::optional<double> openstudio::SqlFile::otherFuelWaterSystems | ( | ) | const |
Returns the energy used for water systems from other fuel in gigajoules.
Requires EnergyPlus simulation output to calculate. Attribute name: otherFuelWaterSystems
openstudio::path openstudio::SqlFile::path | ( | ) | const |
get the path
boost::optional<double> openstudio::SqlFile::peakEnergyDemandByMonth | ( | const openstudio::EndUseFuelType & | t_fuelType, |
const openstudio::EndUseCategoryType & | t_categoryType, | ||
const openstudio::MonthOfYear & | t_monthOfYear | ||
) | const |
Returns the energy demand for the given fuel type, category and month.
Requires BUILDING ENERGY PERFORMANCE tabular report. Value is energy use in W.
void openstudio::SqlFile::removeIndexes | ( | ) |
bool openstudio::SqlFile::reopen | ( | ) |
re-open the file
boost::optional<openstudio::ReportingFrequency> openstudio::SqlFile::reportingFrequencyFromDB | ( | const std::string & | dbReportingFrequency | ) |
boost::optional<double> openstudio::SqlFile::runPeriodValue | ( | const std::string & | envPeriod, |
const std::string & | timeSeriesName, | ||
const std::string & | keyValue | ||
) |
bool openstudio::SqlFile::supportedVersion | ( | ) | const |
std::vector<TimeSeries> openstudio::SqlFile::timeSeries | ( | const std::string & | envPeriod, |
const std::string & | reportingFrequency, | ||
const std::string & | timeSeriesName | ||
) |
boost::optional<TimeSeries> openstudio::SqlFile::timeSeries | ( | const std::string & | envPeriod, |
const std::string & | reportingFrequency, | ||
const std::string & | timeSeriesName, | ||
const std::string & | keyValue | ||
) |
std::vector<TimeSeries> openstudio::SqlFile::timeSeries | ( | const SqlFileTimeSeriesQuery & | query | ) |
Executes query.
ReportingFrequency must be specified. Use expandQuery first to break query down by ReportingFrequency and determine how many TimeSeries will be returned.
boost::optional<double> openstudio::SqlFile::totalSiteEnergy | ( | ) | const |
total site energy in GJ
boost::optional<double> openstudio::SqlFile::totalSourceEnergy | ( | ) | const |
total source energy in GJ
boost::optional<double> openstudio::SqlFile::waterCooling | ( | ) | const |
Returns the water used for cooling in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterCooling
boost::optional<double> openstudio::SqlFile::waterExteriorEquipment | ( | ) | const |
Returns the water used for exterior equipment in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterExteriorEquipment
boost::optional<double> openstudio::SqlFile::waterExteriorLighting | ( | ) | const |
Returns the water used for exterior lighting in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterExteriorLighting
boost::optional<double> openstudio::SqlFile::waterFans | ( | ) | const |
Returns the water used for fans in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterFans
boost::optional<double> openstudio::SqlFile::waterGenerators | ( | ) | const |
Returns the water used for generators in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterGenerators
boost::optional<double> openstudio::SqlFile::waterHeating | ( | ) | const |
Returns the water used for heating in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterHeating
boost::optional<double> openstudio::SqlFile::waterHeatRecovery | ( | ) | const |
Returns the water used for heat recovery in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterHeatRecovery
boost::optional<double> openstudio::SqlFile::waterHeatRejection | ( | ) | const |
Returns the water used for heat rejection in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterHeatRejection
boost::optional<double> openstudio::SqlFile::waterHumidification | ( | ) | const |
Returns the water used for humidification in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterHumidification
boost::optional<double> openstudio::SqlFile::waterInteriorEquipment | ( | ) | const |
Returns the water used for interior equipment in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterInteriorEquipment
boost::optional<double> openstudio::SqlFile::waterInteriorLighting | ( | ) | const |
Returns the water used for interior lighting in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterInteriorLighting
boost::optional<double> openstudio::SqlFile::waterPumps | ( | ) | const |
Returns the water used for pumps in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterPumps
boost::optional<double> openstudio::SqlFile::waterRefrigeration | ( | ) | const |
Returns the water used for refrigeration in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterRefrigeration
boost::optional<double> openstudio::SqlFile::waterTotalEndUses | ( | ) | const |
Returns the water used for all uses in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterTotalEndUses
boost::optional<double> openstudio::SqlFile::waterWaterSystems | ( | ) | const |
Returns the water used for water systems in cubic meters.
Requires EnergyPlus simulation output to calculate. Attribute name: waterWaterSystems