Skip to content

Instantly share code, notes, and snippets.

@seak0503

seak0503/rails_query_method_select_and_pluck.md

Created June 15, 2016 01:20
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save seak0503/28c5e7f184c07667bf0138b85ecda28e to your computer and use it in GitHub Desktop.
Save seak0503/28c5e7f184c07667bf0138b85ecda28e to your computer and use it in GitHub Desktop.
Download ZIP
railsクエリメソッドのselectとpluckの違い
Raw
rails_query_method_select_and_pluck.md

Railsのクエリメソッドのselectとpluckは役割が似ているが、それぞれ返り値の型が異なる。

  • selectはActiveRecordが返る
irb(main):285:0* CorporateNumber.where(corporate_number: "H100004").select(:corporate_number)
D, [2016-06-14T17:02:06.443471 #3655] DEBUG -- :   CorporateNumber Load (0.3ms)  SELECT `corporate_numbers`.`corporate_number` FROM `corporate_numbers`  WHERE `corporate_numbers`.`corporate_number` = 'H100004'
=> #<ActiveRecord::Relation [#<CorporateNumber id: nil, corporate_number: "H100004">]>
  • pluckは配列が返る
irb(main):282:0* CorporateNumber.where(corporate_number: "H100004").pluck(:corporate_number)
D, [2016-06-14T17:01:58.253861 #3655] DEBUG -- :    (0.3ms)  SELECT `corporate_numbers`.`corporate_number` FROM `corporate_numbers`  WHERE `corporate_numbers`.`corporate_number` = 'H100004'
=> ["H100004"]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment