Method firstDateTime

src/utilities/sql/SqlFile_Impl.cpp:2883–2931

  }

  openstudio::DateTime SqlFile_Impl::firstDateTime(bool includeHourAndMinute, int envPeriodIndex) {
    // default until added to eplusout.sql from energy plus
    boost::optional<unsigned> year;
    unsigned month = 1;
    unsigned day = 1;
    unsigned hour = 1;
    unsigned minute = 0;

    if (m_db) {
      std::stringstream s;
      s << "SELECT ";
      if (hasYear()) {
        s << "Year, ";
      }
      s << "Month, Day, Hour, Minute from Time where Month is not NULL and Day is not null and EnvironmentPeriodIndex = " << envPeriodIndex
        << " LIMIT 1";

      sqlite3_stmt* sqlStmtPtr;
      int code = sqlite3_prepare_v2(m_db, s.str().c_str(), -1, &sqlStmtPtr, nullptr);

      code = sqlite3_step(sqlStmtPtr);
      if (code == SQLITE_ROW) {
        int b = 0;
        if (hasYear()) {
          year = sqlite3_column_int(sqlStmtPtr, b++);
        }
        month = sqlite3_column_int(sqlStmtPtr, b++);
        day = sqlite3_column_int(sqlStmtPtr, b++);
        if (includeHourAndMinute) {
          hour = sqlite3_column_int(sqlStmtPtr, b++);
          minute = sqlite3_column_int(sqlStmtPtr, b++);
        } else {
          hour = 1;
          minute = 0;
        }
      }
      sqlite3_finalize(sqlStmtPtr);
    }

    // Note JM 2019-03-14: Starting with E+ v8.9.0, we actually have Year in the SQL file
    // So if we can, we use the actual year, otherwise we initialze with defaults
    // and let the Date Ctor figure out the assumed year
    openstudio::Date date = year ? Date(monthOfYear(month), day, *year) : Date(monthOfYear(month), day);

    // DLM: get standard time zone?
    openstudio::Time time(0, hour, minute, 0);

    return openstudio::DateTime(date, time);
  }

  openstudio::DateTime SqlFile_Impl::lastDateTime(bool includeHourAndMinute, int envPeriodIndex) {
    // default until added to eplusout.sql from energy plus