时间戳

首页 > 解决方案 > 使用 Sequelize CLI 生成的模型时找不到创建

postgresql - 使用 Sequelize CLI 生成的模型时找不到创建

问题描述

我的方法如下命令

npx sequelize-cli model:generate --name User --attributes name:string,email:string,password:string

然后它会生成一个名为user.js& 文件结构的模型文件，如下所示

'use strict';
const {
    Model
} = require('sequelize');
module.exports = (sequelize, DataTypes) => {
    class User extends Model {
        /**
         * Helper method for defining associations.
         * This method is not a part of Sequelize lifecycle.
         * The `models/index` file will call this method automatically.
         */
        static associate(models) {
            // define association here
            User.hasMany(models.Course, {
                foreignKey: 'userId'
            })
        }
    };
    User.init({
        name: DataTypes.STRING
    }, {
        sequelize,
        modelName: 'User',
    });
    return User;
};

此外，创建了Users带有列的表。

以及index.js像下面这样自动生成的文件

'use strict';
// main model file
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 = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);
    db[model.name] = model;
  });

Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db);
  }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

当我尝试像下面的代码一样创建用户时

import { User } from '../../../../models'

try {
    await User.create({
        name: 'john doe',
        email: 'john@gmail.com'
    })

    res.json({"message": "create"})
} catch (error) {
    res.send(error.message)
}

它显示

无法读取未定义的属性“创建”

我在这里做错了什么？

你能帮我解决这个问题吗？

谢谢

标签： postgresqlsequelize.jsnext.jssequelize-cli

解决方案

replace this code in models/index.js for printing database successfully connected or not.






    '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.js')[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);
    }


//for checking database successfully connected or not

    sequelize
      .authenticate()
      .then(() => {

        console.log('Connection has been established successfully.');
      })
      .catch(err => {
        console.error('Unable to connect to the database:', err);
      });
    fs
      .readdirSync(__dirname)
      .filter(file => {
        return (file.indexOf('.') !== 0) && (file !== basename) && (file.slice(-3) === '.js');
      })
      .forEach(file => {
        const model = require(path.join(__dirname, file))(sequelize, Sequelize.DataTypes);
        db[model.name] = model;
      });

    Object.keys(db).forEach(modelName => {
      if (db[modelName].associate) {
        db[modelName].associate(db);
      }
    });

    db.sequelize = sequelize;
    db.Sequelize = Sequelize;

    module.exports = db;








Then try to importing like this.






const admin = require("../../database/models").tbl_admin;

try {
    await admin.create({
        name: 'john doe',
        email: 'john@gmail.com'
    })

    res.json({"message": "create"})
} catch (error) {
    res.send(error.message)
}

推荐阅读