javascript - Sequelize 与 Nodejs 的连接

Question

我面临 SEQUELIZE(mysql) 与 NodeJs 连接的问题。虽然已建立连接，但模型未正确配置。我已经使用了这种方法--

./config/sequelize-conn.js

'use strict';
var sequelize  = function (config, Sequelize) {
var sql = new Sequelize(config.mysql.db, config.mysql.user, config.mysql.pass, {
    host:        config.mysql.host,
    dialect:     'mysql', //|'sqlite'|'postgres'|'mssql'
    pool:        {
        max:  5,
        min:  0,
        idle: 10000
    },
    //logging:     true,
    underscored: true
});
sql
    .sync({force: true})
    //.authenticate()
    .then(function () {
        console.log('Connection has been established successfully with mysql.');
    }, function (error) {
        console.log('Connection with mysql failed.', error);
    });
return sql;
};
module.exports = sequelize;

//server.js

var sequelize     = require('sequelize');
var sqlConnection = require('./config/sequelize-conn')(config, sequelize);

我希望这样直接使用模型..

models/HotelGroup.js

var Sequelize  = require('sequelize');
var sequelize  = require('../../config/sequelize-conn');
var HotelGroup = Sequelize.define('hotel_chains', {
    id:         {
        type:          Sequelize.INTEGER(11),
        allowNull:     false,
        primaryKey:    true,
        autoIncrement: true
    },
    hotel_name: {
        type:      Sequelize.STRING,
        allowNull: false
    },
    hotel_code: {
        type:      Sequelize.STRING,
        allowNull: false
    },
    status:     {
        type:         Sequelize.BOOLEAN,
        allowNull:    false,
        defaultValue: '1'
    }
}, {
    tableName:       'hotel_chains',
    timestamps:      false,
    paranoid:        true  // Model tableName will be the same as the model name
});
module.exports = HotelGroup;

它给了我错误，sequelize.define 不是一个函数。

虽然正在建立连接，但是当我尝试使用 require 访问服务文件中的任何模型时。它会因此错误消息而中断。我哪里做错了。

Answer 1

我认为你需要使用sequelize的实例，而不是类。所以sequelize.define不是Sequelize.define。

此外，您需要正确实例化它:var Sequelize = new Sequelize(...)