Method isValidConnection

src/utilities/sql/SqlFile_Impl.cpp:515–556

  }

  bool SqlFile_Impl::isValidConnection() {
    std::string energyPlusVersion = this->energyPlusVersion();
    if (energyPlusVersion.empty()) {
      return false;
    }

    VersionString version(energyPlusVersion);
    if (version >= VersionString(7, 0) && version <= VersionString(energyPlusVersionMajor(), energyPlusVersionMinor())) {
      m_supportedVersion = true;
    } else {
      m_supportedVersion = false;
      LOG(Warn, "Using unsupported EnergyPlus version " << version.str());
    }

    // v8.9.0 added the year tag, but it seems it's always zero...
    // IlluminanceMap Year started in 9.2.0
    // m_hasYear & m_hasIlluminanceMapYear are both default initialized to true
    if (version < VersionString(9, 2)) {
      m_hasIlluminanceMapYear = false;
    } else if (version < VersionString(9, 6)) {
      m_illuminanceMapHasOnly2RefPts = true;
    }

    if (version < VersionString(8, 9)) {
      m_hasYear = false;
    } else {
      // Check if zero
      boost::optional<int> maxYear = execAndReturnFirstInt("SELECT MAX(Year) FROM Time");
      if (!maxYear.is_initialized() || maxYear.get() <= 0) {
        auto nOtherThanRunPeriod =
          execAndReturnFirstInt("SELECT COUNT(ReportingFrequency) FROM ReportDataDictionary WHERE ReportingFrequency NOT LIKE '%Run Period%'");
        if (nOtherThanRunPeriod > 0) {
          LOG(Warn, "Using EnergyPlusVersion version " << version.str() << " which should have 'Year' field, but it's always zero");
        } else {
          LOG(Info, "Your SQLFile does not contain the 'Year' field since you did not request any outputs at a frequency lower than Run Period");
        }
        m_hasYear = false;
      }
    }

    return true;
  }

  int SqlFile_Impl::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,