class Sequel::ODBC::Dataset

Constants

BOOL_FALSE
BOOL_TRUE
DatasetClass
ODBC_DATE_FORMAT
TIMESTAMP_FORMAT

Public Instance Methods

fetch_rows(sql) { |hash| ... } click to toggle source
# File lib/sequel/adapters/odbc.rb, line 103
def fetch_rows(sql)
  execute(sql) do |s|
    i = -1
    cols = s.columns(true).map{|c| [output_identifier(c.name), i+=1]}
    columns = cols.map{|c| c.at(0)}
    if opts[:offset] && offset_returns_row_number_column?
      rn = row_number_column
      columns.delete(rn)
    end
    @columns = columns
    if rows = s.fetch_all
      rows.each do |row|
        hash = {}
        cols.each{|n,i| hash[n] = convert_odbc_value(row[i])}
        hash.delete(rn) if rn
        yield hash
      end
    end
  end
  self
end