devdocs/lib/docs/scrapers/postgresql.rb

module Docs
  class Postgresql < UrlScraper
    include FixInternalUrlsBehavior

    self.name = 'PostgreSQL'
    self.type = 'postgres'
    self.root_path = 'reference.html'
    self.initial_paths = %w(sql.html admin.html internals.html appendixes.html tutorial.html)
    self.links = {
      home: 'https://www.postgresql.org/',
      code: 'https://git.postgresql.org/gitweb/?p=postgresql.git'
    }

    html_filters.insert_before 'normalize_urls', 'postgresql/extract_metadata'
    html_filters.push 'postgresql/clean_html', 'postgresql/entries', 'title'

    options[:title] = false
    options[:root_title] = 'PostgreSQL'
    options[:follow_links] = ->(filter) { filter.initial_page? }
    options[:rate_limit] = 200

    options[:skip] = %w(
      index.html
      ddl-others.html
      functions-event-triggers.html
      functions-trigger.html
      textsearch-migration.html
      supported-platforms.html
      error-message-reporting.html
      error-style-guide.html
      plhandler.html
      sourcerepo.html
      git.html
      bug-reporting.html
      client-interfaces.html)

    options[:skip_patterns] = [
      /\Ainstall/,
      /\Aregress/,
      /\Aprotocol/,
      /\Asource/,
      /\Anls/,
      /\Afdw/,
      /\Atablesample/,
      /\Acustom-scan/,
      /\Abki/,
      /\Arelease/,
      /\Acontrib-prog/,
      /\Aexternal/,
      /\Adocguide/,
      /\Afeatures/,
      /\Aunsupported-features/ ]

    options[:attribution] = <<-HTML
      &copy; 1996&ndash;2025 The PostgreSQL Global Development Group<br>
      Licensed under the PostgreSQL License.
    HTML

    version '17' do
      self.release = '17.5'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '16' do
      self.release = '16.1'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end
    
    version '15' do
      self.release = '15.4'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '14' do
      self.release = '14.5'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '13' do
      self.release = '13.4'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '12' do
      self.release = '12.1'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '11' do
      self.release = '11.6'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '10' do
      self.release = '10.11'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"
    end

    version '9.6' do
      self.release = '9.6.16'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"

      html_filters.insert_before 'postgresql/extract_metadata', 'postgresql/normalize_class_names'
    end

    version '9.5' do
      self.release = '9.5.20'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"

      html_filters.insert_before 'postgresql/extract_metadata', 'postgresql/normalize_class_names'
    end

    version '9.4' do
      self.release = '9.4.25'
      self.base_url = "https://www.postgresql.org/docs/#{version}/"

      html_filters.insert_before 'postgresql/extract_metadata', 'postgresql/normalize_class_names'
    end

    def get_latest_version(opts)
      doc = fetch_doc('https://www.postgresql.org/docs/current/index.html', opts)
      label = doc.at_css('#pgContentWrap h1.title').content
      label.scan(/([0-9.]+)/)[0][0]
    end
  end
end