javascript - 以一对一的关系插入数据belongsTo Sequelize

Question

我有两个架构

地址

员工

每个员工都有一个地址，所以我的架构如下

员工.js

const address = conn.define('address', {
    street: Sequelize.TEXT,
    city: Sequelize.STRING,
    postalCode: Sequelize.STRING,
});

const employee = conn.define('employee', {
    empId: {
        type: Sequelize.INTEGER,
    },
    name: {
        type: Sequelize.STRING,
    },
    joinDateTime: {
        type: Sequelize.DATE,
    },
});

address.belongsTo(employee);

employee.sync();
address.sync();
module.exports = employee;

下面是插入逻辑，它不起作用，我如何执行关联插入

项目是数组中的一个对象，我在其中执行了 forEach

const obj = {
    empId: item.empId,
    name: item.name,
    joinDateTime: item.joinDateTime,
};
const address = {
    street: item.street,
    city: item.city,
    postalCode: item.postalCode,
};
Employee.build(obj).save().then((resp) => {
    /* here how can i perform the insertion in associated address schema
obj.address(address) won't work */
    obj.address(address).then(() => console.log('created')).catch(err => 
    console.log(err));
}).catch(err => console.log(err));

Answer 1

您将不得不添加两段代码。

在你的第一个片段中，添加

employee.hasOne(address);

在你的第二个，改变

Employee.build(obj).save().then((resp) => {
    /* here how can i perform the insertion in associated address schema
obj.address(address) won't work */
    obj.address(address).then(() => console.log('created')).catch(err => 
    console.log(err));
}).catch(err => console.log(err));

至

Employee.build(obj).save().then((employee) => {
    employee.setAddress(address).then(() => console.log('created')).catch(err => 
    console.log(err));
}).catch(err => console.log(err));

注意:obj.address(address) 变为 obj.setAddress(address)。

请让我们知道这是否有效!