Method getSummaryData

src/utilities/sql/SqlFile_Impl.cpp:756–798

  }

  std::vector<SummaryData> SqlFile_Impl::getSummaryData() const {
    std::vector<SummaryData> retval;

    if (m_db) {
      sqlite3_stmt* sqlStmtPtr;

      std::string stmt = "select sum(VariableValue), VariableName, ReportingFrequency, VariableUnits "
                         "from ReportMeterData, ReportMeterDataDictionary "
                         "where (ReportMeterData.ReportMeterDataDictionaryIndex = ReportMeterDataDictionary.ReportMeterDataDictionaryIndex) "
                         "  and VariableType='Sum' "
                         "  group by VariableName, ReportingFrequency, VariableUnits";

      sqlite3_prepare_v2(m_db, stmt.c_str(), -1, &sqlStmtPtr, nullptr);
      while (sqlite3_step(sqlStmtPtr) == SQLITE_ROW) {
        double value = sqlite3_column_double(sqlStmtPtr, 0);
        std::string variablename = columnText(sqlite3_column_text(sqlStmtPtr, 1));
        std::string reportingfrequency = columnText(sqlite3_column_text(sqlStmtPtr, 2));
        std::string units = columnText(sqlite3_column_text(sqlStmtPtr, 3));

        size_t colon = variablename.find(':');

        if (colon == std::string::npos) {
          LOG(Error, "Unable to parse variable name, no ':' found " + variablename);
        } else {
          std::string fueltype = variablename.substr(0, colon);
          std::string installlocation = variablename.substr(colon + 1);

          try {
            retval.push_back(SummaryData(value, openstudio::parseUnitString(units), openstudio::ReportingFrequency(reportingfrequency),
                                         openstudio::FuelType(fueltype), openstudio::InstallLocationType(installlocation))

            );
          } catch (const std::exception& e) {
            LOG(Error, "Error adding / parsing summary data: " << e.what());
          }
        }
      }

      sqlite3_finalize(sqlStmtPtr);
    }

    return retval;
  }

  void SqlFile_Impl::retrieveDataDictionary() {
    std::string table;