Method insertIlluminanceMap

src/utilities/sql/SqlFile_Impl.cpp:578–673

  }

  void SqlFile_Impl::insertIlluminanceMap(const std::string& t_zoneName, const std::string& t_name, const std::string& t_environmentName,
                                          const std::vector<DateTime>& t_times, const std::vector<double>& t_xs, const std::vector<double>& t_ys,
                                          double t_z, const std::vector<Matrix>& t_maps) {
    boost::optional<int> zoneIndex = execAndReturnFirstInt("select ZoneIndex from zones where ZoneName=?;", t_zoneName);

    if (!zoneIndex) {
      throw std::runtime_error("Unknown zone name: " + t_zoneName);
    }

    if (t_times.size() != t_maps.size()) {
      throw std::runtime_error("Number of times does not match number of maps");
    }

    int mapIndex = getNextIndex("daylightmaps", "MapNumber");

    std::string referencePt1 = "RefPt1=(" + boost::lexical_cast<std::string>(t_xs.front()) + ":" + boost::lexical_cast<std::string>(t_ys.front())
                               + ":" + boost::lexical_cast<std::string>(t_z) + ")";

    std::string referencePt2 = "RefPt1=(" + boost::lexical_cast<std::string>(t_xs.back()) + ":" + boost::lexical_cast<std::string>(t_ys.back()) + ":"
                               + boost::lexical_cast<std::string>(t_z) + ")";

    std::stringstream mapInsert;
    mapInsert << "insert into daylightmaps (MapNumber, MapName, Environment, Zone, ReferencePt1, ReferencePt2, Z) values (" << mapIndex << ", " << "'"
              << t_name << "', " << "'" << t_environmentName << "', " << *zoneIndex << ", " << "'" << referencePt1 << "', " << "'" << referencePt2
              << "', " << t_z << ");";

    execAndThrowOnError(mapInsert.str());

    int hourlyReportIndex = getNextIndex("daylightmaphourlyreports", "HourlyReportIndex");

    // E+ added the "Year" field to the DaylightMapHourlyReports in version 9.2.0 (NREL/EnergyPlus#7235)
    // assignment of PreparedStatement does not work, so use a pointer to statement to handle the case where you do or do not have Year
    std::shared_ptr<PreparedStatement> stmt1;
    if (hasIlluminanceMapYear()) {
      stmt1 = std::make_shared<PreparedStatement>(
        "insert into daylightmaphourlyreports (HourlyReportIndex, MapNumber, Year, Month, DayOfMonth, Hour) values (?, ?, ?, ?, ?, ?)", m_db, true);
    } else {
      stmt1 = std::make_shared<PreparedStatement>(
        "insert into daylightmaphourlyreports (HourlyReportIndex, MapNumber, Month, DayOfMonth, Hour) values (?, ?, ?, ?, ?)", m_db, true);
    }

    for (size_t dateidx = 0; dateidx < t_times.size(); ++dateidx) {
      int b = 0;
      stmt1->bind(++b, hourlyReportIndex);
      stmt1->bind(++b, mapIndex);

      DateTime dt = t_times[dateidx];

      int year = dt.date().year();
      int monthOfYear = dt.date().monthOfYear().value();
      int dayOfMonth = dt.date().dayOfMonth();
      int hours = dt.time().hours();
      // EnergyPlus deals in a 00:00:01 -> 24:00:00 world instead of
      // 00:00:00 -> 23:59:59 hrs that the real world uses, so
      // we are going to adjust for that, so we subtract an hour,
      // to get it back to the previous day, then we will replace
      // the hours with 24
      // \sa illuminanceMapHourlyReportIndex