Contents

# frozen_string_literal: true

module Spandx
  module Rubygems
    class Backup
      SQL = <<~DATA
        SELECT rg.name AS name, v.number AS version, v.licenses AS licenses
        FROM versions v
        INNER JOIN rubygems rg ON rg.id = v.rubygem_id
        WHERE v.licenses IS NOT NULL
        AND v.latest = true
        AND v.yanked_at IS NULL
        ORDER BY rg.name
      DATA
      LOAD_SCRIPT = File.expand_path(File.join(File.dirname(__FILE__), '../../../', 'bin/load'))
      attr_reader :uri

      def initialize(uri, db_connection)
        @uri = uri
        @db_connection = db_connection
      end

      def each
        execute(SQL) do |row|
          yield row
        end
      end

      def execute(sql)
        download do
          @db_connection.exec(sql) do |result|
            result.each do |row|
              yield row
            end
          end
        end
      end

      def to_s
        @uri.to_s
      end

      private

      def download
        yield if system(LOAD_SCRIPT, to_s)
      end
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
spandx-rubygems-0.1.3	lib/spandx/rubygems/backup.rb
spandx-rubygems-0.1.2	lib/spandx/rubygems/backup.rb
spandx-rubygems-0.1.1	lib/spandx/rubygems/backup.rb
spandx-rubygems-0.1.0	lib/spandx/rubygems/backup.rb