質問編集履歴
5
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -50,9 +50,9 @@
|
|
|
50
50
|
|
|
51
51
|
syntax error, unexpected tINTEGER, expecting ')'
|
|
52
52
|
|
|
53
|
-
...
|
|
53
|
+
...eate_date >= SUBTIME(NOW(), '00:05:00')')
|
|
54
54
|
|
|
55
|
-
... ^~
|
|
55
|
+
... ^~ ^~
|
|
56
56
|
|
|
57
57
|
|
|
58
58
|
|
4
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -34,7 +34,7 @@
|
|
|
34
34
|
|
|
35
35
|
select('*')
|
|
36
36
|
|
|
37
|
-
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND c.create_date >= SUBTIME(NOW(), '00:05:00')
|
|
37
|
+
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND c.create_date >= SUBTIME(NOW(), '00:05:00')')
|
|
38
38
|
|
|
39
39
|
.where('id = 20')
|
|
40
40
|
|
|
@@ -66,7 +66,7 @@
|
|
|
66
66
|
|
|
67
67
|
select('*')
|
|
68
68
|
|
|
69
|
-
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND c.create_date >= NOW()
|
|
69
|
+
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND c.create_date >= NOW()')
|
|
70
70
|
|
|
71
71
|
.where('id = 20')
|
|
72
72
|
|
3
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -24,7 +24,7 @@
|
|
|
24
24
|
|
|
25
25
|
|
|
26
26
|
|
|
27
|
-
rails のモデルでは以下のように記述しました。
|
|
27
|
+
rails の Reservation モデルでは以下のように記述しました。
|
|
28
28
|
|
|
29
29
|
|
|
30
30
|
|
2
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -4,7 +4,7 @@
|
|
|
4
4
|
|
|
5
5
|
reservationsテーブルで、cartsテーブルをそれぞれのcart_idとidとでleft joinで結合し、
|
|
6
6
|
|
|
7
|
-
cartsのレコードが作成されてから5分間経過したものは、nullにする、という条件を加えます。
|
|
7
|
+
cartsのレコードが作成されてから5分間経過したものは、結合先の内容をnullにする、という条件を加えます。
|
|
8
8
|
|
|
9
9
|
|
|
10
10
|
|
1
間違い
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -34,7 +34,7 @@
|
|
|
34
34
|
|
|
35
35
|
select('*')
|
|
36
36
|
|
|
37
|
-
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND
|
|
37
|
+
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND c.create_date >= SUBTIME(NOW(), '00:05:00'))')
|
|
38
38
|
|
|
39
39
|
.where('id = 20')
|
|
40
40
|
|
|
@@ -66,7 +66,7 @@
|
|
|
66
66
|
|
|
67
67
|
select('*')
|
|
68
68
|
|
|
69
|
-
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND
|
|
69
|
+
.joins('LEFT OUTER JOIN carts AS c ON lock_id = c.id AND c.create_date >= NOW())')
|
|
70
70
|
|
|
71
71
|
.where('id = 20')
|
|
72
72
|
|