Method insertTimeSeriesData

src/utilities/sql/SqlFile_Impl.cpp:675–754

  }

  void SqlFile_Impl::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 datadicindex = getNextIndex("reportdatadictionary", "ReportDataDictionaryIndex");

    std::stringstream insertReportDataDictionary;
    insertReportDataDictionary << "insert into reportdatadictionary (ReportDataDictionaryIndex, IsMeter, Type, IndexGroup, TimestepType, KeyValue, "
                                  "Name, ReportingFrequency, ScheduleName, Units) values ("
                               << datadicindex << ", " << "'0'," << "'" << t_variableType << "', " << "'" << t_indexGroup << "', " << "'"
                               << t_timestepType << "', " << "'" << t_keyValue << "', " << "'" << t_variableName << "', " << "'"
                               << t_reportingFrequency.valueName() << "', ";

    if (t_scheduleName) {
      insertReportDataDictionary << "'" << *t_scheduleName << "', ";
    } else {
      insertReportDataDictionary << "null, ";
    }

    insertReportDataDictionary << "'" << t_variableUnits << "');";

    execAndThrowOnError(insertReportDataDictionary.str());

    std::vector<double> values = toStandardVector(t_timeSeries.values());
    std::vector<double> days = toStandardVector(t_timeSeries.daysFromFirstReport());

    openstudio::DateTime firstdate = t_timeSeries.firstReportDateTime();

    std::shared_ptr<PreparedStatement> stmt;
    if (hasYear()) {
      // we'll let stmt1 have the transaction
      stmt =
        std::make_shared<PreparedStatement>("insert into reportdata (ReportDataIndex, TimeIndex, ReportDataDictionaryIndex, Value) values ( ?, "
                                            "(select TimeIndex from time where Year=? and Month=? and Day=? and Hour=? and Minute=? limit 1), ?, ?);",
                                            m_db, true);
    } else {
      stmt = std::make_shared<PreparedStatement>("insert into reportdata (ReportDataIndex, TimeIndex, ReportDataDictionaryIndex, Value) values ( ?, "
                                                 "(select TimeIndex from time where Month=? and Day=? and Hour=? and Minute=? limit 1), ?, ?);",
                                                 m_db, true);
    }

    for (size_t i = 0; i < values.size(); ++i) {
      openstudio::DateTime dt = firstdate + openstudio::Time(days[i]);
      double value = values[i];

      if (dt.time().seconds() == 59) {
        // rounding error, let's help
        dt += openstudio::Time(0, 0, 0, 1);
      }

      if (dt.time().seconds() == 1) {
        // rounding error, let's help
        dt -= openstudio::Time(0, 0, 0, 1);
      }

      int year = dt.date().year();
      int month = dt.date().monthOfYear().value();