use Csv.open and not File.open?

[ldonnet]

Hi,

First, thanks for your greate work! I must deal with a pgsql batch copy but I need to use converters from CSV for hash for examples. I see that you use File.open why not use CSV.open? Is it faster with File.open?
(I use v 0.6 because I'm in rails 3.2)

I need to do this trick for example :

CSV::Converters[:hash] = lambda do |string|
        hash = {}
        begin
          string.gsub!(/[{}]/, '')
          string.split(',').each do |pair|
            key,value = pair.split(/=>/)
            hash[key] = value
          end
        rescue ArgumentError
          string
        end
      end

ActiveRoad::StreetNumber.pg_copy_from "/tmp/street_numbers.csv", :converters => converters

[diogob]

Yes, I use the File.open to leave all CSV parsing to the PostgreSQL server. You can transform data passing a block to pg_copy_from and altering the variable that will be yielded with the values.