- Notifications
You must be signed in to change notification settings - Fork26
Extend ActiveRecord pluck to return array of hashes
License
girishso/pluck_to_hash
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Extends ActiveRecord by addingpluck_to_hash method that returns array of hashes instead of array of arrays. Useful when plucking multiple columns for rendering json or you need to access individual fields in your view for example.
Supportspluck_to_struct since version 0.3.0.pluck_to_struct returns an array ofstructs.
Add this line to your application's Gemfile:
gem'pluck_to_hash'
And then execute:
$ bundleOr install it yourself as:
$ gem install pluck_to_hashUsage is similar toActiveRecord.pluck, for example
Post.limit(2).pluck_to_hash(:id,:title)## [{:id=>213, :title=>"foo"}, {:id=>214, :title=>"bar"}]#Post.limit(2).pluck_to_hash(:id)## [{:id=>213}, {:id=>214}]#
Or use the shorter aliaspluck_h
Post.limit(2).pluck_h(:id)## [{:id=>213}, {:id=>214}]#
Supportsselect alias
User.pluck_to_hash(:id,'created_at::date as my_date','created_at::time as my_time')## [{:id=>23, :my_date=>Fri, 11 Jul 2014, :my_time=>2000-01-01 07:54:36 UTC},# {:id=>2, :my_date=>Tue, 01 Jul 2014, :my_time=>2000-01-01 14:36:15 UTC}]#
Acceptsblock parameter
User.pluck_to_hash(:id,:title)do |user_hash| ...end
Allows specifying the type of hash. Defaults to HashWithIndifferentAccess
User.pluck_to_hash(:id,:title,hash_type:CustomHash)do |custom_hash| ...end
posts=Post.limit(2).pluck_to_struct(:id,:title)## [#<struct id=1, title="foo">, #<struct id=2, title="bar">]#posts.first.id# 1posts.first.title# "foo"
or use the shorter aliaspluck_s
posts=Post.limit(2).pluck_s(:id,:title)## [#<struct id=1, title="foo">, #<struct id=2, title="bar">]#
Supportsblock parameter as well
Post.limit(2).pluck_to_struct(:id,:title)do |post_struct|putspost_struct.titleend
Allows specifying the type of struct. Defaults to standard Struct.
Post.limit(2).pluck_to_struct(:id,:title,struct_type:OtherStructType)do |post_struct|putspost_struct.titleend
Use version0.1.4 that removes ActiveSupport dependency.HashWithIndifferentAccess is not used in that case.
Here are results of "benchmark" tests performed on MacBook Air. Each method did 10 runs, rejected the 2 highest and 2 lowest times and average the remaining 6. Ran these tests on about 40,000 records. We notice thatpluck_to_hash is almost 4x faster thanselect and about 8x faster thanas_json. As with all the "benchmarks", you should take these results with a pinch of salt!
# Node.pluck_h(:id, :title)# Node.select(:id, :title).to_a# Node.select(:id, :title).as_jsonusersystemtotalrealpluck_to_hash0.1450000.0050000.150000(0.164836)select0.5666670.0100000.576667(0.590911)as_json1.1966670.0100001.206667(1.222286)
- Fork it (https://github.com/girishso/pluck_to_hash/fork )
- Create your feature branch (
git checkout -b my-new-feature) - Commit your changes (
git commit -am 'Add some feature') - Push to the branch (
git push origin my-new-feature) - Create a new Pull Request
MIT License
Brought to you by:Cube Root Software © 2016
About
Extend ActiveRecord pluck to return array of hashes