FactoryBot.definedofactory:memos,class: Micropostdotrait:memo_1dotime{240}memo{"I just ate an orange!"}picture{nil}user_id{1}created_at{10.minutes.ago}endtrait:memo_2dotime{180}memo{"Check out the @tauday site by @mhartl: http://tauday.com"}picture{nil}user_id{1}created_at{3.years.ago}endtrait:memo_3dotime{59}memo{"Sad cats are sad: http://youtu.be/PKffm2uI4dk"}picture{nil}user_id{1}created_at{2.hours.ago}endtrait:memo_4dotime{207}memo{"Writing a short test"}picture{nil}user_id{1}created_at{Time.zone.now}endassociation:user,factory: :userendend
require'rails_helper'RSpec.describeMicropost,type: :modeldolet(:user){create(:user)}let(:micropost){user.microposts.build(time: 240,memo: "Lorem ipsum",user_id: user.id)}describe"Micropost"doit"should be valid"doexpect(micropost).tobe_validendit"should not be valid"domicropost.update_attributes(time: 1,memo: " ",picture: nil,user_id: user.id)expect(micropost).tobe_validmicropost.update_attributes(time: nil,memo: " ",picture: nil,user_id: user.id)expect(micropost).tobe_invalidendit"should be most recent first"docreate(:memos,:memo_1,created_at: 10.minutes.ago)create(:memos,:memo_2,created_at: 3.years.ago)create(:memos,:memo_3,created_at: 2.hours.ago)memo_4=create(:memos,:memo_4,created_at: Time.zone.now)expect(Micropost.first).toeqmemo_4endenddescribe"user_id"doit"should not be present"domicropost.user_id=nilexpect(micropost).tobe_invalidendenddescribe"memo"doit"should not be at most 255 characters"domicropost.memo="a"*255expect(micropost).tobe_validmicropost.memo="a"*256expect(micropost).tobe_invalidendendend
User.eager_load(:comments).find(1)# SELECT DISTINCT `users`.`id` FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 LIMIT 1# SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 AND `users`.`id` = 1User.eager_load(:comments).find_by(id: 1)# SELECT DISTINCT `users`.`id` FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 LIMIT 1# SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 AND `users`.`id` = 1User.eager_load(:comments).where(id: 1).first# SELECT DISTINCT `users`.`id` AS alias_0, `users`.`id` FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 ORDER BY `users`.`id` ASC LIMIT 1# SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 AND `users`.`id` = 1 ORDER BY `users`.`id` ASC
WHERE `users`.`id` = 1 AND `users`.`id` = 1 とかめっちゃ冗長そうなクエリがある。
２回目のクエリだけでほしい情報は取れるはず
なんとかして1回のクエリにしたい
User.eager_load(:comments).where(id: 1).load.first# SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1
ｷﾀ━━━━(ﾟ∀ﾟ)━━━━!!
おわり。
クエリ整形ver
User.eager_load(:comments).find(1)# SQL (4.0ms) SELECT DISTINCT `users`.`id` FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 LIMIT 1# SQL (2.8ms) SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 AND `users`.`id` = 1# -- pretty format.# SELECT# DISTINCT `users`.`id`# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1# LIMIT# 1;## SELECT# `users`.`id` AS t0_r0,# `users`.`name` AS t0_r1,# `users`.`created_at` AS t0_r2,# `users`.`updated_at` AS t0_r3,# `comments`.`id` AS t1_r0,# `comments`.`user_id` AS t1_r1,# `comments`.`created_at` AS t1_r2,# `comments`.`updated_at` AS t1_r3# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1# AND `users`.`id` = 1;#=> #<User id: 1, name: "hogehoge", created_at: "2019-11-15 04:54:42", updated_at: "2019-11-15 04:54:42">User.eager_load(:comments).find_by(id: 1)# SQL (1.0ms) SELECT DISTINCT `users`.`id` FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 LIMIT 1# SQL (2.7ms) SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 AND `users`.`id` = 1# SELECT# DISTINCT `users`.`id`# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1# LIMIT# 1;## SELECT# `users`.`id` AS t0_r0,# `users`.`name` AS t0_r1,# `users`.`created_at` AS t0_r2,# `users`.`updated_at` AS t0_r3,# `comments`.`id` AS t1_r0,# `comments`.`user_id` AS t1_r1,# `comments`.`created_at` AS t1_r2,# `comments`.`updated_at` AS t1_r3# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1# AND `users`.`id` = 1;##=> #<User id: 1, name: "hogehoge", created_at: "2019-11-15 04:54:42", updated_at: "2019-11-15 04:54:42">User.eager_load(:comments).where(id: 1).first# SQL (0.6ms) SELECT DISTINCT `users`.`id` AS alias_0, `users`.`id` FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 ORDER BY `users`.`id` ASC LIMIT 1# SQL (0.6ms) SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1 AND `users`.`id` = 1 ORDER BY `users`.`id` ASC## SELECT# DISTINCT `users`.`id` AS alias_0,# `users`.`id`# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1# ORDER BY# `users`.`id` ASC# LIMIT# 1;## SELECT# `users`.`id` AS t0_r0,# `users`.`name` AS t0_r1,# `users`.`created_at` AS t0_r2,# `users`.`updated_at` AS t0_r3,# `comments`.`id` AS t1_r0,# `comments`.`user_id` AS t1_r1,# `comments`.`created_at` AS t1_r2,# `comments`.`updated_at` AS t1_r3# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1# AND `users`.`id` = 1# ORDER BY# `users`.`id` ASC;#=> #<User id: 1, name: "hogehoge", created_at: "2019-11-15 04:54:42", updated_at: "2019-11-15 04:54:42">User.eager_load(:comments).where(id: 1).load.first# SQL (1.0ms) SELECT `users`.`id` AS t0_r0, `users`.`name` AS t0_r1, `users`.`created_at` AS t0_r2, `users`.`updated_at` AS t0_r3, `comments`.`id` AS t1_r0, `comments`.`user_id` AS t1_r1, `comments`.`created_at` AS t1_r2, `comments`.`updated_at` AS t1_r3 FROM `users` LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id` WHERE `users`.`id` = 1# SELECT# `users`.`id` AS t0_r0,# `users`.`name` AS t0_r1,# `users`.`created_at` AS t0_r2,# `users`.`updated_at` AS t0_r3,# `comments`.`id` AS t1_r0,# `comments`.`user_id` AS t1_r1,# `comments`.`created_at` AS t1_r2,# `comments`.`updated_at` AS t1_r3# FROM# `users`# LEFT OUTER JOIN `comments` ON `comments`.`user_id` = `users`.`id`# WHERE# `users`.`id` = 1;#=> #<User id: 1, name: "hogehoge", created_at: "2019-11-15 04:54:42", updated_at: "2019-11-15 04:54:42">
コントローラ(Controller)
ページを表示するときに、Railsではコントローラを経由してビューをブラウザに返す。
「rails g controller home top」を実行したとき、「home_controller.rb」というコントローラファイルが生成され、ファイルの中に「topメソッド」が追加される。
コントローラーのメソッドを「アクション」と呼ぶ。
moduleFoodefdo_taskputs"I'm in Foo class!"endendmoduleBardefdo_taskputs"I'm in Bar class!"endendclassChildincludeFooincludeBardefexecutedo_taskendendinstance=Child.newinstance.execute# which task is called?
結果：後勝ち
$ ruby case1.rb
I'm in Bar class!
ケース２：親クラス継承＋Module取り込み
moduleFoodefdo_taskputs"I'm in Foo class!"endendmoduleBardefdo_taskputs"I'm in Bar class!"endendclassParentdefdo_taskputs"I'm in the Parent class!"endendclassChild<ParentincludeFooincludeBardefexecute1do_taskenddefdo_tasksuperendendinstance=Child.newinstance.execute1# which task is called?instance.do_task# which task is called?
結果：取り込むModuleの後勝ち
$ ruby case2.rb
I'm in Bar class!
I'm in Bar class!
ケース３：菱形継承（ダイヤモンド継承）
moduleParentdefdo_taskputs"I'm in the Parent class!"endendmoduleFooincludeParentendmoduleBarincludeParentendclassChildincludeFooincludeBardefexecutedo_taskendendinstance=Child.newinstance.execute# which task is called?
follower (フォローする人)
followed(フォローされる人)
