sequelize 多对多模型关系中 新增数据问题
image.png 定义好模型后,sequelize会在数据库中生产3张表,客户表、公司表、客户公司关联表、 请问如何在新建客户的时候,同时将客户和公司的关联数据新增到中间表中去 我这样编写然后报错了 image.png
image.png
10 回复
@Rukeith 有的
customer {
dataValues:
{ id: 22,
name: '123',
userName: '133',
phone: '23333322233',
sex: '男',
createTime: 2017年09月28日T05:10:30.961Z,
createId: 4 },
_previousDataValues:
{ name: '123',
userName: '133',
phone: '23333322233',
sex: '男',
createTime: 2017年09月28日T05:10:30.961Z,
createId: 4,
id: 22,
password: undefined,
photoUrl: undefined,
editTime: undefined,
deleteTime: undefined,
editId: undefined,
deleteId: undefined },
_changed:
{ name: false,
userName: false,
phone: false,
sex: false,
createTime: false,
createId: false,
id: false,
password: false,
photoUrl: false,
editTime: false,
deleteTime: false,
editId: false,
deleteId: false },
_modelOptions:
{ timestamps: false,
validate: {},
freezeTableName: false,
underscored: false,
underscoredAll: false,
paranoid: false,
rejectOnEmpty: false,
whereCollection: null,
schema: null,
schemaDelimiter: '',
defaultScope: {},
scopes: [],
hooks: {},
indexes: [],
name: { plural: 'customers', singular: 'customer' },
omitNull: false,
tableName: 'customer',
sequelize:
Sequelize {
options: [Object],
config: [Object],
dialect: [Object],
queryInterface: [Object],
models: [Object],
modelManager: [Object],
connectionManager: [Object],
importCache: [Object],
test: [Object] },
uniqueKeys: { customer_phone_unique: [Object] } },
_options:
{ isNewRecord: true,
_schema: null,
_schemaDelimiter: '',
attributes: undefined,
include: undefined,
raw: undefined,
silent: undefined },
__eagerlyLoadedAssociations: [],
isNewRecord: false }
看起來他是沒有 setCusCompany
我的做法是把關聯表當作 Model 來操作
sequelize.customer_company.create(options);
不然應該也可以參考這邊的資料 Offical website