質問編集履歴
2
エラーメッセージ修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -12,10 +12,10 @@
|
|
|
12
12
|
|
|
13
13
|
|
|
14
14
|
|
|
15
|
-
```
|
|
16
|
-
|
|
17
15
|
~~SequelizeDatabaseError: Unknown column 'productId' in 'field list'~~
|
|
18
16
|
|
|
17
|
+
```
|
|
18
|
+
|
|
19
19
|
SequelizeDatabaseError: Column 'product_id' in field list is ambiguous
|
|
20
20
|
|
|
21
21
|
```
|
1
sequelize.col('productId'))からsequelize.col('product_id'))へ変更したら、列が認識されましたが、別のエラー発生
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -14,7 +14,9 @@
|
|
|
14
14
|
|
|
15
15
|
```
|
|
16
16
|
|
|
17
|
-
SequelizeDatabaseError: Unknown column 'productId' in 'field list'
|
|
17
|
+
~~SequelizeDatabaseError: Unknown column 'productId' in 'field list'~~
|
|
18
|
+
|
|
19
|
+
SequelizeDatabaseError: Column 'product_id' in field list is ambiguous
|
|
18
20
|
|
|
19
21
|
```
|
|
20
22
|
|
|
@@ -34,7 +36,7 @@
|
|
|
34
36
|
|
|
35
37
|
( select product_id, count(*) as sales_num
|
|
36
38
|
|
|
37
|
-
from order
|
|
39
|
+
from order_detail
|
|
38
40
|
|
|
39
41
|
group by product_id
|
|
40
42
|
|
|
@@ -236,7 +238,7 @@
|
|
|
236
238
|
|
|
237
239
|
'productId',
|
|
238
240
|
|
|
239
|
-
[sequelize.fn('count', sequelize.col('product
|
|
241
|
+
[sequelize.fn('count', sequelize.col('product_id')), 'sales_num']
|
|
240
242
|
|
|
241
243
|
],
|
|
242
244
|
|