Function regressionTestSqlFile

src/utilities/sql/Test/SqlFile_GTest.cpp:385–588

}

void regressionTestSqlFile(const std::string& name, double netSiteEnergy, double firstVal, double lastVal) {
  openstudio::path fromPath = resourcesPath() / toPath("utilities/SqlFile") / toPath(name);
  openstudio::path path = toPath(name);

  if (openstudio::filesystem::exists(path)) {
    openstudio::filesystem::remove(path);
  }
  ASSERT_FALSE(openstudio::filesystem::exists(path));
  ASSERT_TRUE(openstudio::filesystem::exists(fromPath)) << toString(fromPath);
  openstudio::filesystem::copy(fromPath, path);
  ASSERT_TRUE(openstudio::filesystem::exists(path));

  boost::optional<SqlFile> sqlFile;
  EXPECT_NO_THROW(sqlFile = SqlFile(path));
  ASSERT_TRUE(sqlFile);

  // Capture the version (1st group)
  boost::regex re("1ZoneEvapCooler-V(.*)\\.sql");
  boost::smatch m;
  ASSERT_TRUE(boost::regex_match(name, m, re));
  VersionString expected(m[1]);
  VersionString actual(sqlFile->energyPlusVersion());
  EXPECT_EQ(expected.major(), actual.major());
  EXPECT_EQ(expected.minor(), actual.minor());
  EXPECT_EQ(expected.patch().get(), actual.patch().get());

  // Check if the SqlFile has the 'Year' field
  if (expected >= VersionString(9, 0)) {
    EXPECT_TRUE(sqlFile->hasYear());
  } else if (expected < VersionString(8, 9)) {
    EXPECT_FALSE(sqlFile->hasYear());
  } else {
    // For 8.9.0, seems that it has the 'Year' field but it's always zero...
    EXPECT_FALSE(sqlFile->hasYear()) << "Failed for " << name;
  }

  // Check if the SqlFile has the 'Year' field for IlluminanceMap, which was added later in 9.2.0
  if (expected < VersionString(9, 2)) {
    EXPECT_FALSE(sqlFile->hasIlluminanceMapYear());
  } else {
    EXPECT_TRUE(sqlFile->hasIlluminanceMapYear());
  }

  ASSERT_TRUE(sqlFile->hoursSimulated());
  EXPECT_EQ(8760.0, sqlFile->hoursSimulated().get()) << name;
  ASSERT_TRUE(sqlFile->netSiteEnergy());
  EXPECT_NEAR(netSiteEnergy, sqlFile->netSiteEnergy().get(), 0.1) << name;

  std::vector<std::string> availableEnvPeriods = sqlFile->availableEnvPeriods();
  ASSERT_FALSE(availableEnvPeriods.empty());
  EXPECT_EQ(static_cast<unsigned>(3), availableEnvPeriods.size());
  std::string availableEnvPeriod;
  for (size_t i = 0; i < availableEnvPeriods.size(); i++) {
    if (availableEnvPeriods[i].find("CONDNS") == std::string::npos) {
      availableEnvPeriod = availableEnvPeriods[i];
    }
  }