ok-os-job-change-team / tetsuya-twitter-clone-bootcamp

哲也のtwitter clone作成リポジトリ
1 stars 0 forks source link

#69, 70 Favoriteモデルとコントローラーを実装した #71

Closed kawabuchi-tetsuya closed 2 months ago

kawabuchi-tetsuya commented 2 months ago

今回対応した issue

やったこと

残りの作業

できるようになること(ユーザ目線)

できなくなること(ユーザ目線)

その他

動作確認

https://github.com/ok-os-job-change-team/tetsuya-twitter-clone-bootcamp/assets/95535099/a41896fc-a66b-4335-86f4-53938ae04d2a

kawabuchi-tetsuya commented 2 months ago

@ochi-sho-private-study 修正しました。 https://github.com/ok-os-job-change-team/tetsuya-twitter-clone-bootcamp/pull/71/commits/11b4062ad1e7c5a612d8370fdba245010a79b0ef /postsアクセス時の標準出力(10ポストほどお気に入り登録した状態)

Started GET "/posts" for 192.168.65.1 at 2024-07-18 13:41:12 +0000
Cannot render console from 192.168.65.1! Allowed networks: 127.0.0.0/127.255.255.255, ::1
Processing by PostsController#index as HTML
  User Load (2.6ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 1 LIMIT 1
  ↳ app/helpers/sessions_helper.rb:9:in `current_user'
  SQL (1.8ms)  SELECT `posts`.`id` AS t0_r0, `posts`.`user_id` AS t0_r1, `posts`.`title` AS t0_r2, `posts`.`content` AS t0_r3, `posts`.`created_at` AS t0_r4, `posts`.`updated_at` AS t0_r5, `users`.`id` AS t1_r0, `users`.`email` AS t1_r1, `users`.`password_digest` AS t1_r2, `users`.`created_at` AS t1_r3, `users`.`updated_at` AS t1_r4 FROM `posts` LEFT OUTER JOIN `users` ON `users`.`id` = `posts`.`user_id` LIMIT 100 OFFSET 0
  ↳ app/models/post.rb:35:in `search_all_posts'
  Favorite Count (0.7ms)  SELECT COUNT(*) AS `count_all`, `favorites`.`post_id` AS `favorites_post_id` FROM `favorites` WHERE `favorites`.`post_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20) GROUP BY `favorites`.`post_id`
  ↳ app/controllers/posts_controller.rb:76:in `fetch_favorite_counts'
  Favorite Load (0.3ms)  SELECT `favorites`.* FROM `favorites` WHERE `favorites`.`user_id` = 1 AND `favorites`.`post_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)
  ↳ app/controllers/posts_controller.rb:80:in `fetch_favorites'
  Rendering layout layouts/application.html.erb
  Rendering posts/index.html.erb within layouts/application
  Rendered layouts/_flash.html.erb (Duration: 2.5ms | Allocations: 18)
  Favorite Load (0.5ms)  SELECT `favorites`.* FROM `favorites` WHERE `favorites`.`user_id` = 1
  ↳ app/models/user.rb:6:in `indexed_favorites_by_post_id'
  Rendered collection of posts/_post.html.erb [20 times] (Duration: 7.5ms | Allocations: 5054)
  Rendered posts/index.html.erb within layouts/application (Duration: 25.7ms | Allocations: 6179)
  Rendered shared/_header.html.erb (Duration: 0.1ms | Allocations: 11)
  Rendered shared/_tab_menu.html.erb (Duration: 0.3ms | Allocations: 180)
  Rendered layout layouts/application.html.erb (Duration: 32.0ms | Allocations: 7602)
Completed 200 OK in 59ms (Views: 32.7ms | ActiveRecord: 5.9ms | Allocations: 13637)