expressでカラムが認識されない
expressでがカラムであるcommentIdが認識されません
なぜ認識されないのでしょうか?
おそらく正しくdbは作成されています
エラー文
commentId is not defined ReferenceError: commentId is not defined at /home/ubuntu/environment/smp/ex/routes/index.js:16:16 at Layer.handle [as handle_request] (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/layer.js:95:5) at next (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/route.js:137:13) at Route.dispatch (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/route.js:112:3) at Layer.handle [as handle_request] (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/layer.js:95:5) at /home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:281:22 at Function.process_params (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:335:12) at next (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:275:10) at Function.handle (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:174:3) at router (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:47:12) at Layer.handle [as handle_request] (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:317:13) at /home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:335:12) at next (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:275:10) at serveStatic (/home/ubuntu/environment/smp/ex/node_modules/serve-static/index.js:75:16) at Layer.handle [as handle_request] (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/layer.js:95:5) at trim_prefix (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:317:13) at /home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:284:7 at Function.process_params (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:335:12) at next (/home/ubuntu/environment/smp/ex/node_modules/express/lib/router/index.js:275:10) at cookieParser (/home/ubuntu/environment/smp/ex/node_modules/cookie-parser/index.js:71:5)
サーバー起動時のターミナルの出力
Executing (default): CREATE TABLE IF NOT EXISTS "comments" ("commentId" INTEGER NOT NULL , "comment" INTEGER NOT NULL, PRIMARY KEY ("commentId")); Executing (default): SELECT i.relname AS name, ix.indisprimary AS primary, ix.indisunique AS unique, ix.indkey AS indkey, array_agg(a.attnum) as column_indexes, array_agg(a.attname) AS column_names, pg_get_indexdef(ix.indexrelid) AS definition FROM pg_class t, pg_class i, pg_index ix, pg_attribute a WHERE t.oid = ix.indrelid AND i.oid = ix.indexrelid AND a.attrelid = t.oid AND t.relkind = 'r' and t.relname = 'comments' GROUP BY i.relname, ix.indexrelid, ix.indisprimary, ix.indisunique, ix.indkey ORDER BY i.relname;
モデルファイル
js
1'use strict'; 2const loader = require('./sequelize-loader'); 3const Sequelize = loader.Sequelize; 4 5const Comment = loader.database.define('comments', { 6 commentId: { 7 type: Sequelize.INTEGER, 8 primaryKey: true, 9 allowNull: false 10 }, 11 comment: { 12 type: Sequelize.INTEGER, 13 allowNull: false 14 }}, 15 { 16 freezeTableName: true, 17 timestamps: false 18 }); 19 20module.exports = Comment;
route/index.js
js
1var express = require('express'); 2var router = express.Router(); 3const Comment = require('../models/comment'); 4 5 6/* GET home page. */ 7router.get('/', function(req, res, next) { 8 res.render('index', { title: 'Express' }); 9}); 10 11router.post('/', function(req, res, next) { 12 13 const updatedAt = new Date(); 14 15 Comment.create({ 16 commentId: commentId, 17 comment:req.body.comment, 18 updatedAt: updatedAt 19 20 }); 21 22}); 23module.exports = router;
index.pug
js
1doctype html 2html(lang="ja") 3 head 4 meta(charset="UTF-8") 5 title comment 6 body 7 h2 新規投稿 8 form(method="post" action="/") 9 div 10 textarea(name="comment" cols=40 rows=4) 11 div 12 button(type="submit") 投稿
環境
aws cloud9
os ubuntu
node.js v8.16.0
express 4.16.0
npm 6.4.1
回答1件
あなたの回答
tips
プレビュー
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2019/07/08 02:41