docs: public int addPathnameToProfile(int id, String pathname, String actualPath) throws Exception {
          int pathOrder = getPathOrder(id).size() + 1;
          int pathId = -1;
          PreparedStatement statement = null;
          ResultSet results = null;
  
          try (Connection sqlConnection = sqlService.getConnection()) {
              statement = sqlConnection.prepareStatement(
                  "INSERT INTO " + Constants.DB_TABLE_PATH
                      + "(" + Constants.PATH_PROFILE_PATHNAME + ","
                      + Constants.PATH_PROFILE_ACTUAL_PATH + ","
                      + Constants.PATH_PROFILE_GROUP_IDS + ","
                      + Constants.PATH_PROFILE_PROFILE_ID + ","
                      + Constants.PATH_PROFILE_PATH_ORDER + ","
                      + Constants.PATH_PROFILE_CONTENT_TYPE + ","
                      + Constants.PATH_PROFILE_REQUEST_TYPE + ","
                      + Constants.PATH_PROFILE_GLOBAL + ")"
                      + " VALUES (?, ?, ?, ?, ?, ?, ?, ?);",
                  PreparedStatement.RETURN_GENERATED_KEYS
              );
              statement.setString(1, pathname);
              statement.setString(2, actualPath);
              statement.setString(3, "");
              statement.setInt(4, id);
              statement.setInt(5, pathOrder);
              statement.setString(6, Constants.PATH_PROFILE_DEFAULT_CONTENT_TYPE); // should be set by UI/API
              statement.setInt(7, Constants.REQUEST_TYPE_GET); // should be set by UI/API
              statement.setBoolean(8, false);
              statement.executeUpdate();
  
              // execute statement and get resultSet which will have the generated path ID as the first field
              results = statement.getGeneratedKeys();
  
              if (results.next()) {
                  pathId = results.getInt(1);
              } else {
                  // something went wrong
                  throw new Exception("Could not add path");
              }
          } catch (SQLException e) {
              throw e;
          } finally {
              try {
                  if (results != null) {
                      results.close();
                  }
              } catch (Exception e) {
              }
              try {
                  if (statement != null) {
                      statement.close();
                  }
              } catch (Exception e) {
              }
          }
  
          // need to add to request response table for all clients
          for (Client client : ClientService.getInstance().findAllClients(id)) {
              this.addPathToRequestResponseTable(id, client.getUUID(), pathId);
          }
  
          return pathId;
      }