method

result_as_array

v3.0.9 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters::PostgreSQLAdapter

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0 (0)
2.2.1 (0)
2.3.8 (0)
3.0.0 (0)
3.0.9 (-3)
3.1.0 (0)
3.2.1 (0)
3.2.8 (0)
3.2.13 (0)
4.0.2
4.1.8
4.2.1
4.2.7
4.2.9
5.0.0.1
5.1.7
5.2.3
6.0.0
6.1.3.1
6.1.7.7
7.0.0
7.1.3.2
7.1.3.4
What's this?

result_as_array(res) public

create a 2D array representing the result set

# File activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb, line 458
      def result_as_array(res) #:nodoc:
        # check if we have any binary column and if they need escaping
        unescape_col = []
        res.nfields.times do |j|
          unescape_col << res.ftype(j)
        end

        ary = []
        res.ntuples.times do |i|
          ary << []
          res.nfields.times do |j|
            data = res.getvalue(i,j)
            case unescape_col[j]

            # unescape string passed BYTEA field (OID == 17)
            when BYTEA_COLUMN_TYPE_OID
              data = unescape_bytea(data) if String === data

            # If this is a money type column and there are any currency symbols,
            # then strip them off. Indeed it would be prettier to do this in
            # PostgreSQLColumn.string_to_decimal but would break form input
            # fields that call value_before_type_cast.
            when MONEY_COLUMN_TYPE_OID
              # Because money output is formatted according to the locale, there are two
              # cases to consider (note the decimal separators):
              #  (1) $12,345,678.12
              #  (2) $12.345.678,12
              case data
              when /^-?\D+[\d,]+\.\d{2}$/  # (1)
                data.gsub!(/[^-\d\.]/, '')
              when /^-?\D+[\d\.]+,\d{2}$/  # (2)
                data.gsub!(/[^-\d,]/, '').sub!(/,/, '.')
              end
            end
            ary[i] << data
          end
        end
        return ary
      end

result_as_array

Related methods