Ruby - Splititng Array after getting data from Mysql

Question

I have the following code to fetch the data from MySQL database into my rails controller

@main = $connection.execute("SELECT * FROM builds WHERE platform_type IS NOT NULL")

This returns a mysql2 type object which behaves like an array i guess.

I want to split this into 2 arrays, first one where platform_type is 'TOTAL' and everything else in the other array.

Aleksei Matiushkin · Accepted Answer · 2013-03-27 06:12:29Z

2

It actually returns a Mysql2::Result object. Of course you can do

totals = []
others = []
main.each { |r|
  (r['platform_type'] == 'TOTAL' ? totals : others) << r
}

but why not use a rails way with smth like:

Builds.where("platform_type = ?", 'TOTAL')
Builds.where("platform_type NOT IN ?", [nil, 'TOTAL'])

answered Mar 27, 2013 at 5:41

121k12 gold badges109 silver badges173 bronze badges

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

2 Comments

undefined method `each_hash' for #<Mysql2::Result:0xb73e9790>

@sagarvikani Oooups, sorry, within Mysql2 the method is called each rather than each_hash. My fault.

Community · Accepted Answer · 2017-05-23 12:21:07Z

-1

Try array.select. Something like

total = @main.select { |build| build.platform_type == 'TOTAL' }
not_total = @main.reject { |build| build.platform_type == 'TOTAL' }

Even better, use Enumerable.partition as per this answer: Ruby Select and Reject in one method

CommunityBot

11 silver badge

answered Mar 27, 2013 at 5:41

Simon Woodside

7,3045 gold badges54 silver badges69 bronze badges

Uhmmm… Mysql::Result is not an Array descendant actually.