将外键序列化为返回“ Null”。 [英] sequelize foreign key returning as "Null"

问题描述

我已经使用sequelize将外键添加到了我的项目中。用户是父表，profile_personals是子表。当我发布内容时，外键显示为NULL。我正在尝试创建它，因此当我通过邮递员发布东西时，它可以自动获取用户ID。

I have added foreign keys to my project using sequelize. User is the parent table and profile_personals is the child table. When I post something the foreign key comes out as NULL. I'm trying to create it so when I post something through postman it can grab the User id Automatically.

db.js文件

const db = {}; 
db.sequelize = sequelize;
db.Sequelize = Sequelize;

// Models
db.Users = require('../model/User.js')(sequelize, Sequelize);
db.Personal = require('../model/profile_personal.js')(sequelize, Sequelize);


// Foreign Key Connections
db.Personal.belongsTo(db.Users, {foreignKey: 'fk_user_id', targetKey: 'user_id'});
db.Users.hasOne(db.Personal, {foreignKey: 'fk_user_id', targetKey: 'user_id'});

User.js模型

    module.exports = (sequelize, Sequelize) => {
    const Users = sequelize.define('users', {
        user_id: {
            type: Sequelize.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        email: {
            type: Sequelize.STRING
        },
        password: {
            type: Sequelize.STRING
        }
    },
    {
        timestamps: false
    });

    return Users;
}

profile_personals.js模型

profile_personals.js Model

     module.exports = (sequelize, Sequelize) => {
    const Personal = sequelize.define('profile_personals', {
        ID: {
            type: Sequelize.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        biography: {
            type: Sequelize.STRING
        }
    },
    {
        timestamps: false
    });

    return Personal;
}

Profile_personals.js路线

Profile_personals.js Route

var express = require("express")
var router = express.Router()
const db = require('../database/db.js');
const Personal = db.Personal;

// get all profile personals
router.get("/", (req, res) => {
    Personal.findAll()
      .then(personals => {
          res.json(personals)
      })
      .catch(err => {
          res.send('error: ' + err)
      })
})


// Add job
router.post("/", (req, res) => {
    if(!req.body.biography) {
        res.status(400)
        res.json({
            error: "Bad Data"
        })
    } else {
       Personal.create(req.body)
        .then(() => {
            res.send("Personal Added")
        })
        .catch(err => {
            res.send("Error: " + err)
        })
    }
})

推荐答案

我认为您的hasOne键已反转，请尝试以下操作：

I think your hasOne keys are reversed, give this a try:

db.Users.hasOne(db.Personal, {foreignKey: 'user_id', targetKey: 'fk_user_id'});

FWIW，我的偏好是在数据模型中包括FK字段，以提高可读性...例如

FWIW, my preference is to include the FK fields in the data model, for readability... e.g.

const Personal = sequelize.define('profile_personals', {
        ID: {
            type: Sequelize.INTEGER,
            primaryKey: true,
            autoIncrement: true
        },
        biography: {
            type: Sequelize.STRING
        },
        fk_user_id : {type: Sequelize.INTEGER},
    },
    {
        timestamps: false
    });

这篇关于将外键序列化为返回“ Null”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！