Ruby and mysql2- iterating a subset of rows in result set

Question

I'm writing a Ruby script that accesses a MySQL database using the Mysql2 gem.

After I get a set of results from a query, I want to examine a subset of the rows of the result set (e.g. rows 5 to 8) rather than the whole set.

I know I can do this with a while loop, something like this:

db = Mysql2::Client.new(:host => "myserver", :username => "user", :password => "pass", :database => "books")

rs = db.query "select * from bookslist"

i = 5
while i <= 8
    puts rs.entries[i]
    i += 1
end

db.close

But I'm aware this is probably not the best way to write this in Ruby. How can I make this more "idiomatic" Ruby code?

(I know my other option is to modify the query to return only the data I want. I still want to know how to do this in Ruby)

nerding_it · Accepted Answer · 2018-02-02 09:32:02Z

1

Ruby provides range operator in for loop, Probably you can use following code

for i in 5..8
  puts rs.entries[i]
end

answered Feb 2, 2018 at 9:32

nerding_it

7027 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Ruby and mysql2- iterating a subset of rows in result set

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related