Method: Sequel::IBMDB::Dataset#fetch_rows

Defined in:

lib/sequel/adapters/ibmdb.rb

#fetch_rows(sql) ⇒ Object

# File 'lib/sequel/adapters/ibmdb.rb', line 384

def fetch_rows(sql)
  execute(sql) do |stmt|
    columns = []
    convert = convert_smallint_to_bool
    cps = db.conversion_procs
    stmt.num_fields.times do |i|
      k = stmt.field_name i
      key = output_identifier(k)
      type = stmt.field_type(i).downcase.to_sym
      # decide if it is a smallint from precision
      type = :boolean  if type == :int && convert && stmt.field_precision(i) < 8
      type = :blob if type == :clob && db.use_clob_as_blob
      columns << [key, cps[type]]
    end
    cols = columns.map{|c| c[0]}
    self.columns = cols

    while res = stmt.fetch_array
      row = {}
      res.zip(columns).each do |v, (k, pr)|
        row[k] = ((pr ? pr.call(v) : v) if v)
      end
      yield row
    end
  end
  self
end