 |
OpenStudio:utilities |
|
OpenStudio:utilities |
#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 | hasYear () const |
| bool | hasIlluminanceMapYear () 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.
| bool openstudio::SqlFile::hasIlluminanceMapYear | ( | ) | const |
| bool openstudio::SqlFile::hasYear | ( | ) | const |
| 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)
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
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
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