Contents

require 'nokogiri'
require 'cgi'
class RemoteTable
  class Format
    module ProcessedByNokogiri
      def each
        remove_useless_characters!
        first_row = true
        keys = t.properties.headers if t.properties.headers.is_a?(::Array)
        xml = nokogiri_class.parse(unescaped_xml_without_soft_hyphens, nil, 'UTF-8')
        (row_css? ? xml.css(t.properties.row_css) : xml.xpath(t.properties.row_xpath)).each do |row|
          values = if column_css?
            row.css(t.properties.column_css)
          elsif column_xpath?
            row.xpath(t.properties.column_xpath)
          else
            [row]
          end.map { |cell| cell.content.gsub(/\s+/, ' ').strip }
          if first_row and t.properties.use_first_row_as_header?
            keys = values
            first_row = false
            next
          end
          output = if t.properties.output_class == ::Array
            values
          else
            zip keys, values
          end
          if t.properties.keep_blank_rows or values.any?
            yield output
          end
        end
      ensure
        t.local_file.delete
      end

      private

      def row_css?
        !!t.properties.row_css
      end
      
      def column_css?
        !!t.properties.column_css
      end
      
      def column_xpath?
        !!t.properties.column_xpath
      end
      
      # http://snippets.dzone.com/posts/show/406
      def zip(keys, values)
        hash = ::ActiveSupport::OrderedHash.new
        keys.zip(values) { |k,v| hash[k]=v }
        hash
      end

      # should we be doing this in ruby?
      def unescaped_xml_without_soft_hyphens
        str = ::CGI.unescapeHTML utf8(::IO.read(t.local_file.path))
        # get rid of MS Office baddies
        str.gsub! '­', ''
        str
      end
    end
  end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
remote_table-1.2.2	lib/remote_table/format/mixins/processed_by_nokogiri.rb
remote_table-1.2.1	lib/remote_table/format/mixins/processed_by_nokogiri.rb
remote_table-1.2.0	lib/remote_table/format/mixins/processed_by_nokogiri.rb