CODEWITHSUNDEEP
mysqlruby-on-railsactiverecord
theosp
theosp

Reputation: 7549

Rails: how to select_rows with fields names (mysql)

I am looking for a way to get a result set for a mysql query that is similar to the output of ActiveRecord::Base.connection.select_rows but also includes the result's columns names as the first element.

For example:

ActiveRecord::Base.connection.select_rows_with_fields("SELECT id,name FROM users")
     => [["id", "name"], ["1","amy"],["2","bob"],["3","cam"]]

Upvotes: 0

Views: 825

Answers (1)

theosp
theosp

Reputation: 7549

select_rows_with_fields:

module ActiveRecord
  module ConnectionAdapters
    class Mysql2Adapter
      def select_rows_with_fields(sql)
        result = execute(sql)
        rows = result.to_a
        rows.unshift(result.fields)
      end
    end
  end
end

Upvotes: 1

Related Questions