Method: Sequel::ADO::Dataset#fetch_rows

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

#fetch_rows(sql) ⇒ Object 



246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
 
# File 'lib/sequel/adapters/ado.rb', line 246

def fetch_rows(sql)
  execute(sql) do |recordset|
    cols = []
    conversion_procs = db.conversion_procs

    recordset.Fields.each do |field|
      cols << [output_identifier(field.Name), conversion_procs[field.Type]]
    end

    self.columns = cols.map(&:first)
    return if recordset.EOF
    max = cols.length

    recordset.GetRows.transpose.each do |field_values|
      h = {}

      i = -1
      while (i += 1) < max
        name, cp = cols[i]
        h[name] = if (v = field_values[i]) && cp
          cp.call(v)
        else
          v
        end
      end
      
      yield h
    end
  end
end