Method addSimulation

src/utilities/sql/SqlFile_Impl.cpp:330–403

  }

  void SqlFile_Impl::addSimulation(const openstudio::EpwFile& t_epwFile, const openstudio::DateTime& t_simulationTime,
                                   const openstudio::Calendar& t_calendar) {
    int nextSimulationIndex = getNextIndex("simulations", "SimulationIndex");

    std::stringstream timeStamp;
    timeStamp << t_simulationTime.date().year() << "." << t_simulationTime.date().monthOfYear().value() << "." << t_simulationTime.date().dayOfMonth()
              << " " << t_simulationTime.time().toString();

    std::stringstream version;
    version << "EnergyPlus, VERSION " << energyPlusVersionMajor() << "." << energyPlusVersionMinor() << ", (OpenStudio) YMD=" << timeStamp.str();

    std::string insertSimulation = R"(INSERT INTO Simulations (SimulationIndex, EnergyPlusVersion, TimeStamp,
                                                                 NumTimestepsPerHour, Completed, CompletedSuccessfully)
                                        VALUES (?, ?, ?, ?, ?, ?);)";

    execAndThrowOnError(insertSimulation,
                        // bindArgs
                        nextSimulationIndex, version.str(), timeStamp.str(), 6, 6, 1);

    int nextEnvironmentPeriodIndex = getNextIndex("EnvironmentPeriods", "EnvironmentPeriodIndex");

    std::stringstream envName;
    envName << t_epwFile.stateProvinceRegion() << " WMO#=" << t_epwFile.wmoNumber();

    std::string insertEnvironment = R"(INSERT INTO EnvironmentPeriods (EnvironmentPeriodIndex, SimulationIndex,
                                                                         EnvironmentName, EnvironmentType) VALUES (?, ?, ?, ?);)";
    execAndThrowOnError(insertEnvironment,
                        // bindArgs
                        nextEnvironmentPeriodIndex, nextSimulationIndex, envName.str(), 3);

    int nextTimeIndex = getNextIndex("time", "TimeIndex");

    std::shared_ptr<PreparedStatement> stmt;
    if (hasYear()) {
      stmt = std::make_shared<PreparedStatement>(
        "insert into time (TimeIndex, Year, Month, Day, Hour, Minute, Dst, Interval, IntervalType, SimulationDays, DayType, EnvironmentPeriodIndex, "
        "WarmupFlag) values (?, ?, ?, ?, ?, 0, 0, 60, 1, ?, ?, ?, null)",
        m_db, true);
    } else {
      stmt =
        std::make_shared<PreparedStatement>("insert into time (TimeIndex, Month, Day, Hour, Minute, Dst, Interval, IntervalType, SimulationDays, "
                                            "DayType, EnvironmentPeriodIndex, WarmupFlag) values (?, ?, ?, ?, 0, 0, 60, 1, ?, ?, ?, null)",
                                            m_db, true);
    }

    int simulationDay = 1;
    for (openstudio::Date d = t_calendar.startDate(); d <= t_calendar.endDate(); d += openstudio::Time(1, 0)) {
      for (int i = 1; i <= 24; ++i) {
        int b = 0;
        stmt->bind(++b, nextTimeIndex);
        if (hasYear()) {
          stmt->bind(++b, d.year());
        }
        stmt->bind(++b, d.monthOfYear().value());
        stmt->bind(++b, d.dayOfMonth());
        stmt->bind(++b, i);
        stmt->bind(++b, simulationDay);