編集履歴

質問編集履歴

サーバーログを追記

2021/07/24 02:05

投稿

Shuno

スコア5

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -36,19 +36,19 @@
       get reservations_path(user_id: other_user.id, from_user_id: user.id)
-      get new_reservation_path(user_id: other_user.id), params:  { day: "2021-07-24",
+      get new_reservation_path(user_id: other_user.id), params:  { day: "2021-07-25",
-                                                                   time: "9:00",
+                                                                   time: "10:00",
                                                                    user_id: other_user.id }
       expect {
-        post "/reservations", params: { reservation: { day: "2021-07-24",
+        post "/reservations", params: { reservation: { day: "2021-07-25",
-                                                       time: "9:00",
+                                                       time: "10:00",
-                                                       start_time: "2021-07-24T09:00:00+09:00",
+                                                       start_time: "2021-07-25T10:00:00+09:00",
                                                        user_id: other_user.id } }
@@ -108,49 +108,95 @@
 ### 該当のソースコード
-app/models/reservation.rb
+app/controllers/reservations_controller.rb
-```
+```
-class Reservation < ApplicationRecord
+class ReservationsController < ApplicationController
-  belongs_to :user
-  validates :user_id, presence: true
-  validates :from_user_id, presence: true
-  validates :day, presence: true
-  validates :time, presence: true
-  validates :start_time, presence: true, uniqueness: true
-  def self.reservations_after_one_month
+  before_action :logged_in_user
+  def index
-    # 今日から1ヶ月先までのデータを取得
+    @user = User.find(params[:user_id])
-    reservations = Reservation.all.where("day >= ?", Date.current).where("day < ?", Date.current >> 1).order(day: :desc)
+    @reservations = Reservation.where("day >= ?", Date.current).where("day < ?", Date.current >> 3).order(day: :desc).where("user_id = ? or from_user_id = ?", @user.id, current_user.id)
+  end
-    # 配列を作成し、データを格納
+  def new
-    # DBアクセスを減らすために必要なデータを配列にデータを入れる
-    reservation_data = []
+    @user = User.find(params[:user_id])
-    reservations.each do |reservation|
+    @reservation = Reservation.new
-      reservations_hash = {}
+    @day = params[:day]
+    @time = params[:time]
-      reservations_hash.merge!(day: reservation.day.strftime("%Y-%m-%d"), time: reservation.time)
+    @start_time = DateTime.parse(@day + " " + @time + " " + "JST")
+  end
+  def show
+    @reservation = Reservation.find(params[:id])
+  end
+  def create
-      reservation_data.push(reservations_hash)
+    @reservation = Reservation.new(reservation_params)
+    if @reservation.save
+      flash[:success] = "ビデオ通話予約しました"
+      redirect_to reservation_path @reservation.id
+    else
+      render :new
     end
+  end
+  def destroy
+    @reservation = Reservation.find(params[:id])
+    if @reservation.destroy
+      flash[:success] = "予約を削除しました。"
+      redirect_to user_path(current_user.id)
+    else
+      render :reserve
+    end
+  end
+  private
-    reservation_data
+  def reservation_params
+    params.require(:reservation).permit(:day, :time, :user_id, :from_user_id, :start_time)
   end
@@ -158,102 +204,6 @@
 ```
-app/controllers/reservations_controller.rb
-```
-class ReservationsController < ApplicationController
-  before_action :logged_in_user
-  def index
-    @user = User.find(params[:user_id])
-    @reservations = Reservation.where("day >= ?", Date.current).where("day < ?", Date.current >> 3).order(day: :desc).where("user_id = ? or from_user_id = ?", @user.id, current_user.id)
-  end
-  def new
-    @user = User.find(params[:user_id])
-    @reservation = Reservation.new
-    @day = params[:day]
-    @time = params[:time]
-    @start_time = DateTime.parse(@day + " " + @time + " " + "JST")
-  end
-  def show
-    @reservation = Reservation.find(params[:id])
-  end
-  def create
-    @reservation = Reservation.new(reservation_params)
-    if @reservation.save
-      flash[:success] = "ビデオ通話予約しました"
-      redirect_to reservation_path @reservation.id
-    else
-      render :new
-    end
-  end
-  def destroy
-    @reservation = Reservation.find(params[:id])
-    if @reservation.destroy
-      flash[:success] = "予約を削除しました。"
-      redirect_to user_path(current_user.id)
-    else
-      render :reserve
-    end
-  end
-  private
-  def reservation_params
-    params.require(:reservation).permit(:day, :time, :user_id, :from_user_id, :start_time)
-  end
-end
-```
 app/views/reservations/new.html.erb
 ```
@@ -320,6 +270,168 @@
+サーバーログ
+```
+Started GET "/reservations?user_id=1" for ::1 at 2021-07-24 11:00:07 +0900
+Processing by ReservationsController#index as HTML
+  Parameters: {"user_id"=>"1"}
+  User Load (0.9ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/helpers/sessions_helper.rb:43
+  User Load (0.8ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/controllers/reservations_controller.rb:5
+  Rendering reservations/index.html.erb within layouts/application
+  Reservation Load (53.0ms)  SELECT "reservations".* FROM "reservations" WHERE (day >= '2021-07-24') AND (day < '2021-10-24') AND (user_id = 1 or from_user_id = 1) ORDER BY "reservations"."day" DESC
+  ↳ app/views/reservations/index.html.erb:11
+  Reservation Load (0.8ms)  SELECT "reservations".* FROM "reservations" WHERE (day >= '2021-07-24') AND (day < '2021-08-24') ORDER BY "reservations"."day" DESC
+  ↳ app/models/reservation.rb:15
+  Rendered simple_calendar/_week_calendar.html.erb (15.1ms)
+  Rendered reservations/index.html.erb within layouts/application (89.1ms)
+  Rendered layouts/_rails_default.html.erb (24.8ms)
+  Rendered layouts/_shim.html.erb (0.5ms)
+  Rendered layouts/_navigation.html.erb (3.4ms)
+  Rendered layouts/_search.html.erb (4.4ms)
+  Rendered layouts/_footer.html.erb (0.5ms)
+  Rendered layouts/_js.html.erb (16.7ms)
+Completed 200 OK in 188ms (Views: 107.2ms | ActiveRecord: 55.5ms)
+Started GET "/reservations/new?day=2021-07-25&time=10%3A00&user_id=1" for ::1 at 2021-07-24 11:00:08 +0900
+Processing by ReservationsController#new as HTML
+  Parameters: {"day"=>"2021-07-25", "time"=>"10:00", "user_id"=>"1"}
+  User Load (3.9ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/helpers/sessions_helper.rb:43
+  User Load (0.8ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/controllers/reservations_controller.rb:10
+  Rendering reservations/new.html.erb within layouts/application
+  Rendered shared/_error_messages.html.erb (0.9ms)
+  Rendered reservations/new.html.erb within layouts/application (93.1ms)
+  Rendered layouts/_rails_default.html.erb (21.5ms)
+  Rendered layouts/_shim.html.erb (0.4ms)
+  Rendered layouts/_navigation.html.erb (2.3ms)
+  Rendered layouts/_search.html.erb (1.0ms)
+  Rendered layouts/_footer.html.erb (0.3ms)
+  Rendered layouts/_js.html.erb (7.1ms)
+Completed 200 OK in 147ms (Views: 135.9ms | ActiveRecord: 4.6ms)
+Started POST "/reservations" for ::1 at 2021-07-24 11:00:11 +0900
+Processing by ReservationsController#create as HTML
+  Parameters: {"utf8"=>"✓", "authenticity_token"=>"uzBu1Xyew30viLVC/AypLZ/h0zfOq9VxzEUyOloFyV8niK9bO8hOX6HmF6Y+UhAX/dul3TDfqlkpIgPgEkzxcA==", "reservation"=>{"day"=>"2021-07-25", "time"=>"10:00", "from_user_id"=>"1", "user_id"=>"1", "start_time"=>"2021-07-25T10:00:00+09:00"}, "commit"=>"登録する"}
+  User Load (1.2ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/helpers/sessions_helper.rb:43
+   (0.2ms)  BEGIN
+  ↳ app/controllers/reservations_controller.rb:23
+  CACHE User Load (0.0ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/controllers/reservations_controller.rb:23
+  Reservation Exists (7.6ms)  SELECT  1 AS one FROM "reservations" WHERE "reservations"."start_time" = $1 LIMIT $2  [["start_time", "2021-07-25 01:00:00"], ["LIMIT", 1]]
+  ↳ app/controllers/reservations_controller.rb:23
+  Reservation Create (15.5ms)  INSERT INTO "reservations" ("day", "time", "user_id", "created_at", "updated_at", "start_time", "from_user_id") VALUES ($1, $2, $3, $4, $5, $6, $7) RETURNING "id"  [["day", "2021-07-25"], ["time", "10:00"], ["user_id", 1], ["created_at", "2021-07-24 02:00:11.467966"], ["updated_at", "2021-07-24 02:00:11.467966"], ["start_time", "2021-07-25 01:00:00"], ["from_user_id", 1]]
+  ↳ app/controllers/reservations_controller.rb:23
+   (47.0ms)  COMMIT
+  ↳ app/controllers/reservations_controller.rb:23
+Redirected to http://localhost:3000/reservations/20
+Completed 302 Found in 125ms (ActiveRecord: 71.9ms)
+Started GET "/reservations/20" for ::1 at 2021-07-24 11:00:11 +0900
+Processing by ReservationsController#show as HTML
+  Parameters: {"id"=>"20"}
+  User Load (0.6ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = $1 LIMIT $2  [["id", 1], ["LIMIT", 1]]
+  ↳ app/helpers/sessions_helper.rb:43
+  Reservation Load (0.5ms)  SELECT  "reservations".* FROM "reservations" WHERE "reservations"."id" = $1 LIMIT $2  [["id", 20], ["LIMIT", 1]]
+  ↳ app/controllers/reservations_controller.rb:18
+  Rendering reservations/show.html.erb within layouts/application
+  Rendered reservations/show.html.erb within layouts/application (1.1ms)
+  Rendered layouts/_rails_default.html.erb (8.4ms)
+  Rendered layouts/_shim.html.erb (0.3ms)
+  Rendered layouts/_navigation.html.erb (3.1ms)
+  Rendered layouts/_search.html.erb (1.8ms)
+  Rendered layouts/_footer.html.erb (0.3ms)
+  Rendered layouts/_js.html.erb (7.2ms)
+Completed 200 OK in 37ms (Views: 30.7ms | ActiveRecord: 1.2ms)
+```
 ### 補足情報（FW/ツールのバージョンなど）