Store the output of results.each into array in ruby on rails

Question

Code:

 {   db = Mysql2::Client.new( :host => 'localhost', :username => 'username',
  password => 'password', :database => 'database')

results = db.query("select * from users where exported is not TRUE OR 
  NULL").each(:as => :array)

results.each { | row | puts row[1]}

The results.each line outputs outputs company data, and I want to use each line as an input within an API call. Any ideas as how to do this? Each row should populate an attribute like below.

"requested_item_value_attributes" => {
    "employee_first_name_6000555821" => 'results.each { | row | puts row[0]}',
    "employee_last_name_6000555821" => "results.each { | row | puts row[1]}",
    "hiring_manager_6000555821" => "results.each { | row | puts row[2]}",
    "job_title" => "results.each { | row | puts row[3]}",
    "start_date" => "#results.each { | row | puts row[4]}"
  }

If you want to store the results of a collection iteration use map/collect. — Dave Newton
– Dave Newton, Commented Mar 31, 2018 at 0:50

FlyingFoX · Accepted Answer · 2018-03-30 23:48:23Z

1

You can use

nameArray = Array.new
nameArray.push(nameToSave)

to add the variable nameToSave to the end of the array nameArray. Just call push for each of your results and you have an array with all your names from your query.

answered Mar 30, 2018 at 23:48

FlyingFoX

3,5743 gold badges35 silver badges55 bronze badges

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

Comments

Aleksei Matiushkin · Accepted Answer · 2018-03-31 05:00:41Z

0

Use [Array#map] to map the results to an array:

results.map do |row|
  "requested_item_value_attributes" => {
    "employee_first_name_6000555821" => row[0],
    "employee_last_name_6000555821" => row[1],
    "hiring_manager_6000555821" => row[2],
    "job_title" => row[3],
    "start_date" => row[4]
  }
}

or, even better:

results.map do |row|
  "requested_item_value_attributes" => 
    %w[
      employee_first_name_6000555821,
      employee_last_name_6000555821,
      hiring_manager_6000555821,
      job_title,
      start_date
    ].zip(row.take(5)).to_h
  }
}

answered Mar 31, 2018 at 5:00

Aleksei Matiushkin

121k12 gold badges109 silver badges173 bronze badges

Comments

justapilgrim · Accepted Answer · 2018-03-31 00:18:14Z

0

Use the query method second argument.

results = []
db.query('SELECT * FROM table', results)

answered Mar 31, 2018 at 0:18

justapilgrim

6,9324 gold badges35 silver badges46 bronze badges

Collectives™ on Stack Overflow

Store the output of results.each into array in ruby on rails

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related