Write MySQL2 result to an array in Ruby

Question

I want to convert this:

courses = client.query("SELECT LCASE(name) FROM courses")

into an array, so I can easily loop through elements in some existing code, much appreciated.

Did you read the docs? rubydoc.info/gems/mysql2/0.2.6/file/README.rdoc — Casper
– Casper, Commented Mar 8, 2017 at 12:55
yeah I have read through the relevant areas of what you have linked me. I feel really stupid asking such a basic question, but I think I just need to see a working example to wrap my head around it. — Kyle
– Kyle, Commented Mar 8, 2017 at 13:13
Ok..I see. Look at the answers here for some more concrete examples: stackoverflow.com/questions/10836805/… . Maybe those help a little bit to get started. — Casper
– Casper, Commented Mar 8, 2017 at 13:36

Ursus · Accepted Answer · 2017-03-08 13:19:56Z

1

If that courses object is a Mysql2::Result you already can because it includes the Enumerable module. So you can use each, select, first and all the others methods from the module. Anyway, if you actually want an array object

courses = client.query("SELECT LCASE(name) FROM courses").to_a

to_a is from Enumerable module as well

courses = client.query("SELECT LCASE(name) AS name FROM courses")
course_names = courses.map { |course| course['name'] }
course_names.each { |course_name| puts course_name }

edited Mar 8, 2017 at 13:19

answered Mar 8, 2017 at 12:53

Ursus

30.1k3 gold badges36 silver badges52 bronze badges

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

8 Comments

Kyle Over a year ago

doesn't seem to work still, it says something about hash converting to a string, I will show you how I am using it to see if you can spot the errors of my ways, thanks in advance you are a life saver! gyazo.com/bd696eb4cad4262d4849c2be872c7908

Ursus Over a year ago

I saw the code but what are you trying to accomplish?

Kyle Over a year ago

Basically I want the variable "courses", to be an array that contains a bunch of strings from one of the columns in my database. Thanks again.

Ursus Over a year ago

I updated my answer. Try those three lines to see if you can print the course names

Kyle Over a year ago

yeah that worked perfectly (it prints off the course names), is "course_names" now a string array containing the variables?

|

Collectives™ on Stack Overflow

Write MySQL2 result to an array in Ruby

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related