class ActiveRecord::Result
end
puts row + “ ” + row[‘body’]
result.each do |row|
# ActiveRecord::Result also includes Enumerable.
]
…
{“id” => 2, “title” => “title_2”, “body” => “body_2”},
# => [{“id” => 1, “title” => “title_1”, “body” => “body_1”},
result.to_hash
# Get an array of hashes representing the result (column => value):
]
…
[2, “title_2”, “body_2”],
# => [[1, “title_1”, “body_1”],
result.rows
# Get the record values of the result:
# => [“id”, “title”, “body”]
result.columns
# Get the column names of the result:
result # => #<ActiveRecord::Result:0xdeadbeef>
result = ActiveRecord::Base.connection.exec_query(‘SELECT id, title, body FROM posts’)
database connection adapter. For example:
This class encapsulates a Result returned from calling exec_query
on any
##
def [](idx)
def [](idx) hash_rows[idx] end
def cast_values(type_overrides = {}) # :nodoc:
def cast_values(type_overrides = {}) # :nodoc: types = columns.map { |name| column_type(name, type_overrides) } result = rows.map do |values| types.zip(values).map { |type, value| type.type_cast_from_database(value) } end columns.one? ? result.map!(&:first) : result end
def column_type(name, type_overrides = {})
def column_type(name, type_overrides = {}) type_overrides.fetch(name) do column_types.fetch(name, IDENTITY_TYPE) end end
def each
def each if block_given? hash_rows.each { |row| yield row } else hash_rows.to_enum { @rows.size } end end
def empty?
def empty? rows.empty? end
def hash_rows
def hash_rows @hash_rows ||= begin # We freeze the strings to prevent them getting duped when # used as keys in ActiveRecord::Base's @attributes hash columns = @columns.map { |c| c.dup.freeze } @rows.map { |row| # In the past we used Hash[columns.zip(row)] # though elegant, the verbose way is much more efficient # both time and memory wise cause it avoids a big array allocation # this method is called a lot and needs to be micro optimised hash = {} index = 0 length = columns.length while index < length hash[columns[index]] = row[index] index += 1 end hash } end end
def initialize(columns, rows, column_types = {})
def initialize(columns, rows, column_types = {}) @columns = columns @rows = rows @hash_rows = nil @column_types = column_types end
def initialize_copy(other)
def initialize_copy(other) @columns = columns.dup @rows = rows.dup @column_types = column_types.dup @hash_rows = nil end
def last
def last hash_rows.last end
def length
def length @rows.length end
def to_ary
def to_ary hash_rows end
def to_hash
def to_hash hash_rows end