javascript - Node.JS & Sequelize 定义关系

Question

有 2 种型号，客户和订单
在模型订单中定义

Order.belongsTo(Customer {foreignKey: 'customer_id', as: 'customer'});

在模型客户定义

Customer.hasMany(Order, {foreignKey: 'customer_id', as: 'orders'});

得到这个错误

Error: customer.hasMany called with something that's not a subclass of Sequelize.Model

....

如何定义这些没有错误？

感谢帮助

Answer 1

试试这个

    var config = require('../config/environment');
    var Sequelize = require('sequelize');

    var db = {
      Sequelize,
      sequelize: new Sequelize(config.mysql.uri, config.mysql.options)
    };

   db.Customer = db.sequelize.import(modal_path);  //your schema
   db.Order = db.sequelize.import(modal_path);  //your schema

   db.Customer.hasMany(db.Order, {
      foreignKey: 'customer_id'
    });

    db.Order.belongsTo(db.Customer, {
      foreignKey: 'customer_id',
      targetKey: 'Id'
    });