用户如何使用sequelize-postgres nodejs发帖



我正在努力实现用户可以互相喜欢帖子。

这是我喜欢的型号:

const Likes = db.define("Likes", {
id: {
allowNull: false,
autoIncrement: true,
primaryKey: true,
type: Sequelize.INTEGER,
},
PostId: {
type: Sequelize.INTEGER,
references: {
model: "Post",
key: "id",
},
onUpdate: "cascade",
onDelete: "cascade",
},
userId: {
type: Sequelize.INTEGER,
references: {
model: "User",
key: "id",
},
onUpdate: "cascade",
onDelete: "cascade",
},
createdAt: {
allowNull: false,
type: Sequelize.DATE,
},
updatedAt: {
allowNull: false,
type: Sequelize.DATE,
},

这是我的邮政模型:

id: {
type: Sequelize.INTEGER,
primaryKey: true,
autoIncrement: true,
},
title: {
type: Sequelize.STRING,
},
userId: {
type: Sequelize.INTEGER,
},

这是我的用户模型:

id: {
type: Sequelize.INTEGER,
primaryKey: true,
autoIncrement: true,
},
name: {
type: Sequelize.STRING,
},

以下是我的联想:

db.Likes.belongsTo(db.User, { foreignKey: "userId", targetKey: "id" });
db.Likes.belongsTo(db.Post, { foreignKey: "PostId", targetKey: "id" });
db.Post.hasMany(db.Likes, { foreignKey: "PostId", targetKey: "id" });
db.User.hasMany(db.Likes, { foreignKey: "userId", targetKey: "id" });

这是我的帖子和删除请求:

router.post("/:id/likes", async (req, res, next) => {
const { userId } = req;
const PostId = req.params.id;
const post = await Post.findByPk(PostId);
if (!post)
return res
.status(404)
.send({ message: "Post cannot be found or has been removed" });
let like = await Likes.findOne({
where: { [Op.and]: [{ PostId: req.params.id }, { userId: 
req.userId  }] },
});
if (!like) {
let newLike = await Likes.create({
userId: userId,
PostId: req.params.id,
});
return res.json(newLike);
} else {
await like.destroy();
return res.send();
}
});

我一直得到未处理的PromiseRetention警告:错误:WHERE参数"userId";具有无效的";未定义的";价值

在我的前端,当我做console.log(user.id(时,我会得到喜欢帖子的用户的id,而当我做onsole.log(post.id(的时候,我会获得喜欢帖子的id。

更新

在前端,以下是我如何将数据发送到后端:

const likePost = (like) => {
const data = new FormData();
data.append("userId",like.userId);
data.append("PostId",like.PostId)
console.log(like.PostId) // the post id is shown in terminal
console.log(like.userId) // the user id is shown in terminal
console.log(like)
return client.post(`/posts/${like.PostId}/likes`, data);
}

console.log(like(返回这个

Object {
"PostId": 489,
"userId": 43,
}

这是帖子的正确id和喜欢帖子的用户。

在后台这是我的帖子请求:

router.post("/:id/likes", async (req, res, next) => {
console.log(req.body); // returns an empty object {}
const PostId = req.params.id;
const post = await Post.findByPk(PostId);
if (!post)
return res
.status(404)
.send({ message: "Post cannot be found or has been removed" });
let like = await Likes.findOne({
where: {
[Op.and]: [
{ PostId: req.params.id },
//  { userId: req.body.userId }
],
},
});
if (!like) {
let newLike = await Likes.create({
// userId: req.body.userId,
PostId: req.params.id,
});
return res.json(newLike);
} else {
await like.destroy();
return res.send();
}
});

这样做之后,我仍然无法在req.body 中获得userId

findOne查询中似乎需要req.params.userId,假设userId在请求的参数中传递:

{ userId: req.params.userId }
client.post(/posts/${like.PostId}/likes, { userId: like.userId, PostId:like.PostId }) 

在前端使用这个,我能够访问后端的req.body,谢谢@Anatoly

您可以应用它来获得isLiked true或false

const gender = await db.SubProduct.findAll(userId && {
attributes: {
include: [
[Sequelize.cast(Sequelize.where(Sequelize.col("likes.userId"), userId), "boolean"), "isLiked"]
],

},
include: [
{ model: db.Like, as: "likes", attributes: [], required: false },

],
group: ['SubProduct.id', 'likes.id']
});

最新更新