How do you create an array from the fields from a database resultset in Ruby on Rails?

Question

Basically I have 3 fields in the database table and I want to return a an array to represent each row.

sqlite database resultset:

row 1)
name: John
gender: male
email: [email protected]

row 2)
name: Sarah
gender: female
email: [email protected]

Desired format from the above resultset:

[['John',male,'[email protected]'],['Sarah',female,'[email protected]']]

I've tried using User.all.map(&:name) but that only gives me ['John','Sarah']

Sean Hill · Accepted Answer · 2012-12-07 03:36:56Z

3

You'll want to use map, but like this:

User.all.map {|u| [u.name, u.gender, u.email]}

answered Dec 7, 2012 at 3:36

Sean Hill

15.1k2 gold badges52 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Evan Keller · Accepted Answer · 2012-12-07 03:39:07Z

0

User.all.map {|u| [u.name, u.gender, u.email] }

answered Dec 7, 2012 at 3:39

Evan Keller

1013 bronze badges