Method getNextIndex

src/utilities/sql/SqlFile_Impl.cpp:409–420

  }

  int SqlFile_Impl::getNextIndex(const std::string& t_tableName, const std::string& t_columnName) {
    // Interestingly, you CANNOT bind any database identifier (such as the table name / column name) but only litteral values...
    // boost::optional<int> maxindex = execAndReturnFirstInt("SELECT MAX( ? ) FROM ?", t_columnName, t_tableName);
    std::string query = "SELECT MAX(" + t_columnName + ") FROM " + t_tableName + ";";
    boost::optional<int> maxindex = execAndReturnFirstInt(query);

    if (maxindex) {
      return *maxindex + 1;
    } else {
      return 1;
    }
  }

  openstudio::path SqlFile_Impl::path() const {
    return m_path;