Method retrieveDataDictionary

src/utilities/sql/SqlFile_Impl.cpp:800–878

  }

  void SqlFile_Impl::retrieveDataDictionary() {
    std::string table;
    std::string name;
    std::string keyValue;
    std::string units;
    std::string rf;

    if (m_db) {
      int dictionaryIndex;
      int code;

      std::stringstream s;
      sqlite3_stmt* sqlStmtPtr;
      std::map<int, std::string> envPeriods;
      std::map<int, std::string>::iterator envPeriodsItr;

      s << "SELECT EnvironmentPeriodIndex, EnvironmentName FROM EnvironmentPeriods";
      sqlite3_prepare_v2(m_db, s.str().c_str(), -1, &sqlStmtPtr, nullptr);
      code = sqlite3_step(sqlStmtPtr);
      while (code == SQLITE_ROW) {
        std::string queryEnvPeriod = boost::to_upper_copy(columnText(sqlite3_column_text(sqlStmtPtr, 1)));
        envPeriods.insert(std::pair<int, std::string>(sqlite3_column_int(sqlStmtPtr, 0), queryEnvPeriod));
        code = sqlite3_step(sqlStmtPtr);
      }
      sqlite3_finalize(sqlStmtPtr);

      s.str("");
      s << "SELECT ReportMeterDataDictionaryIndex, VariableName, KeyValue, ReportingFrequency, VariableUnits";
      s << " FROM ReportMeterDataDictionary";
      code = sqlite3_prepare_v2(m_db, s.str().c_str(), -1, &sqlStmtPtr, nullptr);

      table = "ReportMeterData";

      code = sqlite3_step(sqlStmtPtr);
      while (code == SQLITE_ROW) {
        dictionaryIndex = sqlite3_column_int(sqlStmtPtr, 0);
        name = columnText(sqlite3_column_text(sqlStmtPtr, 1));
        keyValue = columnText(sqlite3_column_text(sqlStmtPtr, 2));
        rf = columnText(sqlite3_column_text(sqlStmtPtr, 3));
        units = columnText(sqlite3_column_text(sqlStmtPtr, 4));

        for (envPeriodsItr = envPeriods.begin(); envPeriodsItr != envPeriods.end(); ++envPeriodsItr) {
          std::string queryEnvPeriod = boost::to_upper_copy(envPeriodsItr->second);
          m_dataDictionary.insert(DataDictionaryItem(dictionaryIndex, envPeriodsItr->first, name, keyValue, queryEnvPeriod, rf, units, table));
          LOG(Trace, "Creating data dictionary item " << dictionaryIndex << ", " << (*envPeriodsItr).first << ", " << name << ", " << keyValue << ", "
                                                      << queryEnvPeriod << ", " << rf << ", " << units << ", " << table << ".");
        }

        code = sqlite3_step(sqlStmtPtr);
      }
      sqlite3_finalize(sqlStmtPtr);

      s.str("");
      s << "SELECT ReportVariableDatadictionaryIndex, VariableName, KeyValue, ReportingFrequency, VariableUnits";
      s << " FROM ReportVariableDatadictionary";
      code = sqlite3_prepare_v2(m_db, s.str().c_str(), -1, &sqlStmtPtr, nullptr);

      table = "ReportVariableData";