docs: public int getPathId(String pathName, int profileId) {
          PreparedStatement queryStatement = null;
          ResultSet results = null;
          // first get the pathId for the pathName/profileId
          int pathId = -1;
          try (Connection sqlConnection = sqlService.getConnection()) {
              queryStatement = sqlConnection.prepareStatement(
                  "SELECT " + Constants.GENERIC_ID + " FROM " + Constants.DB_TABLE_PATH
                      + " WHERE " + Constants.PATH_PROFILE_PATHNAME + "= ? "
                      + " AND " + Constants.GENERIC_PROFILE_ID + "= ?"
              );
              queryStatement.setString(1, pathName);
              queryStatement.setInt(2, profileId);
              results = queryStatement.executeQuery();
              if (results.next()) {
                  pathId = results.getInt(Constants.GENERIC_ID);
              }
          } catch (Exception e) {
              e.printStackTrace();
          } finally {
              try {
                  if (results != null) {
                      results.close();
                  }
              } catch (Exception e) {
              }
              try {
                  if (queryStatement != null) {
                      queryStatement.close();
                  }
              } catch (Exception e) {
              }
          }
  
          return pathId;
      }