같은 방식으로 코딩을 했는데요 이런 에러가 뜨네요.
해결됨
Node.js 교과서 - 기본부터 프로젝트 실습까지
D:\Study\Server\nodejs\nodejsLib\login\node_modules\sequelize\lib\model.js:230 throw new Error(`A column called 'id' was added to the attributes of '${this.tableName}' but not marked with 'primaryKey: true'`); ^ Error: A column called 'id' was added to the attributes of 'users' but not marked with 'primaryKey: true' at Function._addDefaultAttributes (D:\Study\Server\nodejs\nodejsLib\login\node_modules\sequelize\lib\model.js:230:15) at Function.init (D:\Study\Server\nodejs\nodejsLib\login\node_modules\sequelize\lib\model.js:1052:10) at Sequelize.define (D:\Study\Server\nodejs\nodejsLib\login\node_modules\sequelize\lib\sequelize.js:428:11) at module.exports (D:\Study\Server\nodejs\nodejsLib\login\models\user.js:2:22) at Object.<anonymous> (D:\Study\Server\nodejs\nodejsLib\login\models\index.js:15:28) at Module._compile (internal/modules/cjs/loader.js:971:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1011:10) at Module.load (internal/modules/cjs/loader.js:822:32) at Function.Module._load (internal/modules/cjs/loader.js:730:14) at Module.require (internal/modules/cjs/loader.js:864:19) at require (internal/modules/cjs/helpers.js:74:18) at Object.<anonymous> (D:\Study\Server\nodejs\nodejsLib\login\app.js:11:21) at Module._compile (internal/modules/cjs/loader.js:971:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1011:10) at Module.load (internal/modules/cjs/loader.js:822:32) at Function.Module._load (internal/modules/cjs/loader.js:730:14) at Module.require (internal/modules/cjs/loader.js:864:19) at require (internal/modules/cjs/helpers.js:74:18) at Object.<anonymous> (D:\Study\Server\nodejs\nodejsLib\login\bin\www:7:11) at Module._compile (internal/modules/cjs/loader.js:971:30) at Object.Module._extensions..js (internal/modules/cjs/loader.js:1011:10) at Module.load (internal/modules/cjs/loader.js:822:32) npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! login@0.0.0 start: `node ./bin/www` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the login@0.0.0 start script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above. npm ERR! A complete log of this run can be found in: npm ERR! C:\Users\dnatu\AppData\Roaming\npm-cache\_logs\2019-11-05T13_48_03_653Z-debug.log 테이블 코드는 선생님 코드와 같지는 않고 필드명과 테이블 명만 제가 원하는 대로 살짝 수정하긴 했습니다만 이것이 영향을 미치는 것 같지는 않습니다! index.js는 기본으로 생성되는 페이지 그대로 사용했습니다. user.js module.exports = (sequelize, DataTypes) => { return sequelize.define('user', { name:{ type: DataTypes.STRING(5), allowNULL: false, unique: false, }, id: { type: DataTypes.STRING(30), allowNULL: false, unique: true, }, passwd: { type: DataTypes.STRING(20), allowNULL: false, unique: false, }, age: { type: DataTypes.INTEGER(2).UNSIGNED, allowNULL: false, unique: false, }, phone_num: { type: DataTypes.INTEGER(12).UNSIGNED, allowNULL: false, unique: true, }, created_at: { type: DataTypes.DATE, allowNULL: false, defautlValue: sequelize.literal('now()'), }, store_name:{ type: DataTypes.STRING(20), allowNULL: false, unique: true, } }, { timestamp: false, underscored: true, }); }; // user 테이블 정리 // 이름(5), 아이디(30), 비밀번호(20), 나이(2), 휴대폰 번호(12), 계정생성일(DATE->default(now)), 마켓 이름(20) iteam.js module.exports = (sequelize, DataTypes) => { return sequelize.define('iteam', { iteam_name: { type: DataTypes.STRING(30), allowNULL: false, unique: false, }, item_price: { type: DataTypes.INTEGER(6).UNSIGNED, allowNULL: false, unique: false, }, item_count: { type: DataTypes.INTEGER(6).UNSIGNED, allowNULL: false, unique: false, }, item_description: { type: DataTypes.TEXT, allowNULL: true, unique: false, }, created_at:{ type: DataTypes.DATE, allowNULL: false, defautlValue: sequelize.literal('now()'), }, },{ timestamp: false, underscored: true, }); }; // store 테이블 정리 // 마켓 이름, 물건명, 가격, 물품 개 수, 물품 설명, 등록일자 index.js 'use strict'; const fs = require('fs'); const path = require('path'); const Sequelize = require('sequelize'); const basename = path.basename(__filename); const env = process.env.NODE_ENV || 'development'; const config = require(__dirname + '/../config/config.json')[env]; const db = {}; let sequelize; if (config.use_env_variable) { sequelize = new Sequelize(process.env[config.use_env_variable], config); } else { sequelize = new Sequelize(config.database, config.username, config.password, config); } fs .readdirSync(__dirname) .filter(file => { return (file.indexOf('.') !== 0) && (file !== basename) && (file.slice(-3) === '.js'); }) .forEach(file => { const model = sequelize['import'](path.join(__dirname, file)); db[model.name] = model; }); Object.keys(db).forEach(modelName => { if (db[modelName].associate) { db[modelName].associate(db); } }); db.sequelize = sequelize; db.Sequelize = Sequelize; //테이블 추가 db.User = require('./user')(sequelize, Sequelize); db.Iteam = require('./iteam')(sequelize, Sequelize); //관계 설정 db.User.hasMany(db.Iteam, { foreignKey: 'store_name', sourceKey: 'id' }); db.Iteam.belongsTo(db.User, { foreignKey: 'store_name', targetKey: 'id'}); module.exports = db;
- mongodb
- nodejs
- javascript
- mysql