javascript - 我如何从这个 JSON 构建 Mongoose 模型

Question

我是一名初学者，试图将此 json 解析为 Mongoose 模型，以便保存数据。

这是我现在的模型

const commentSchema = new Schema([{

  sectionId: String,comments:
 [{

      id: String,
      authorAvatarUrl: String,
      authorName: String,
      authorId: String,
      authorUrl: String,
      comment: String,

replies:
 [{
        id: String,
        authorAvatarUrl: String,
        authorName: String,
        authorId: String,
        authorUrl: String,
        comment: String,
        parentId: String
      }]
  }]

}]);

const Comment = mongoose.model("Comment", commentSchema);
module.exports = Comment;

这是我要映射的 Json

var existingComments = [{
    "sectionId": "1",
    "comments":
 [{
        "id": 88,
        "authorAvatarUrl": "support/images/jon_snow.png",
        "authorName": "Jon Sno",
        "authorId": 1,
        "authorUrl": "http://en.wikipedia.org/wiki/Kit_Harington",
        "comment": "I'm Ned Stark's bastard",
        "replies":
 [{
          "id": 100,
          "authorAvatarUrl": "support/images/jon_snow.png",
          "authorName": "Jon Sno",
          "authorId": 1,
          "authorUrl": "http://en.wikipedia.org/wiki/Kit_Harington",
          "comment": "P.S.: I know nothing.",
          "parentId": 88
        }]
    }]
}]

在服务器端我试图得到这样的评论

//Comment posted
router.post("/comments", (req, res, next) => {
  //Save the comment on database
  const [{
    sectionId,

comments:
 [{
      id,
      authorAvatarUrl,
      authorName,
      authorId,
      authorUrl,
      comment,

      replies: 
[{
        id,
        authorAvatarUrl,
        authorName,
        authorId,
        authorUrl,
        comment,
        parentId
      }]
    }]
  }] = req.body;


  const newComment = new Comment([{
    sectionId,comments:
 [{ id, }]

 }]);

  newComment
    .save()
    .then(comment => {
      res.redirect("/index");

    })

    .catch(err => {
      console.log(err);
    });

});

但没有用，任何帮助将不胜感激，因为我目前正在尝试更好地理解 moongose ODM。谢谢!!!!!!

Answer 1

您的评论架构有点困惑。您创建了一个“评论”模式(请注意这是单数)，但您正试图将评论模式用作评论数组。

提示:保持模式和单数。

要在保持模型单一的同时实现您想要的设计，您可以尝试这样做:

解决方案 (1):用一个“Section”集合存储所有数据注意:虽然您有多个架构，但我们只对 SectionSchema 建模，这将是我们唯一的集合，其中每个 Section 文档都包含您需要的所有信息。

const sectionSchema = new Schema({
    name: {
        type: String,
        required: [true, 'Section name is required']
    },
    comments: {
        type: [commentSchema]
    }
});

const replySchema = new Schema({
    //id: String, //not needed, mongoose will automatically add an "_id" property when you save 
    authorAvatarUrl: String,
    authorName: String,
    authorId: String,
    authorUrl: String,
    comment: String,
    parentId: String
});

const commentSchema = new Schema({
    //id: String, //not needed, mongoose will automatically add an "_id" property when you save 
    authorAvatarUrl: String,
    authorName: String,
    authorId: String,
    authorUrl: String,
    comment: String,
    replies:{
        type: [replySchema]
    }
});

module.exports =  mongoose.model("Section", sectionSchema);

在上述解决方案中，您仍然可以使用路由来处理特定评论，例如:

router.get("/sections/:id") //gets the entire section document matching the ID
router.post("/sections/:id/comments/") //creates a new comment within section with matching ID. Simply push a new comment into the comments array
router.get("/sections/:id/comments/") //gets all the comments for this section. Simply return only the comments property of the section document.
router.get("/sections/:id/comments/:commentId") //gets a specific comment within a specific section. Filter the comments array to get the comment matching the commentId and then only return that.

etc..

---

最后说明:您可以通过其他方式对数据进行建模。这只是一个例子。例如，您可以有一个部分集合和一个评论集合，其中评论文档存储一个部分 Id，指示该评论文档相关的部分。

看看https://mongoosejs.com/docs/subdocs.html和 https://docs.mongodb.com/manual/core/data-modeling-introduction/它可能会帮助您了解对数据建模的不同方式，以及 mongoose 子文档的工作原理和使用方法。