自作サービスで使えそうなモデルのメソッド
pluckメソッド:指定したカラムの値だけを配列に入れて返してくれる
code:.rb
AssignedIssue Pluck (0.6ms) SELECT "assigned_issues"."number" FROM "assigned_issues"
AssignedIssue.all.map(&:number) と書くよりも読みやすい👏
カラムの値更新のためにリクエストする時に使えるかも。
sum メソッド:指定したカラムの値の合計を返してくれる
「issueの合計pt」を出す時に活躍しそう!
code:.rb
AssignedIssue.where("98577773 = ANY (assignees)")
AssignedIssue Load (0.6ms) SELECT "assigned_issues".* FROM "assigned_issues" WHERE (98577773 = ANY (assignees))
=>
[#<AssignedIssue:0x00000001115f2690 #1こめ id: 36,
point: 2,
created_at: Sun, 14 Aug 2022 14:21:36.219464000 UTC +00:00,
updated_at: Sun, 14 Aug 2022 14:21:36.219464000 UTC +00:00,
number: 5302>,
id: 39,
point: 2,
created_at: Sun, 14 Aug 2022 15:40:08.259294000 UTC +00:00,
updated_at: Sun, 14 Aug 2022 15:40:08.259294000 UTC +00:00,
number: 5151>]
AssignedIssue.where("98577773 = ANY (assignees)").sum(:point)
AssignedIssue Sum (3.0ms) SELECT SUM("assigned_issues"."point") FROM "assigned_issues" WHERE (98577773 = ANY (assignees))
=> 4