Method: Sequel::Oracle::Dataset#fetch_rows

Defined in:
lib/sequel/adapters/oracle.rb

#fetch_rows(sql) ⇒ Object 



361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
 
# File 'lib/sequel/adapters/oracle.rb', line 361

def fetch_rows(sql)
  execute(sql) do |cursor|
    cps = db.conversion_procs
    cols = columns = cursor.get_col_names.map{|c| output_identifier(c)}
    metadata = cursor.column_metadata
    cm = cols.zip(metadata).map{|c, m| [c, cps[m.data_type]]}
    self.columns = columns
    while r = cursor.fetch
      row = {}
      r.zip(cm).each{|v, (c, cp)| row[c] = ((v && cp) ? cp.call(v) : v)}
      yield row
    end
  end
  self
end