首页 > 解决方案 > 我如何为此制作 mongo db 架构?

问题描述

我正在尝试抓取数据并将其发送到我的 MonogoDB 数据库,但我对此很陌生,并且在为我的数据库制作架构时也很困惑。这就是我要发送到我的数据库的内容,我尝试了很多搜索但找不到适当的解决方案。我能够制作架构,但它只适用于一个潜艇,但现在我有不止一个潜艇。可以通过为子列表制作模型或架构来完成吗?

{
        sub: [
          {
            code: 'ELA2010',
            sessionals: '54',
            exam: '26',
            total: '80',
            grace: '1',
            grades: 'A+',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60, C:41-50, D:35-40'
          },
          {
            code: 'MEH2450',
            sessionals: '56',
            exam: '26',
            total: '82',
            grace: '0',
            grades: 'A',
            range: 'A+:85-100, A:75-84, B+:61-74, B:51-60, C:41-50, D:35-40'
          },
          {
            code: 'EEC2120',
            sessionals: '64',
            exam: '26',
            total: '90',
            grace: '0',
            grades: 'A+',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60, C:41-50, D:35-40'
          },
          {
            code: 'EEC2210',
            sessionals: '53',
            exam: '26',
            total: '79',
            grace: '0',
            grades: 'A',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60, C:41-50, D:35-40'
          },
          {
            code: 'EEC2310',
            sessionals: '54',
            exam: '26',
            total: '80',
            grace: '1',
            grades: 'A+',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60, C:41-50, D:35-40'
          },
          {
            code: 'EEC2510',
            sessionals: '61',
            exam: '26',
            total: '87',
            grace: '0',
            grades: 'A+',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60, C:41-50, D:35-40'
          },
          {
            code: 'EEC2920',
            sessionals: '61',
            exam: '26',
            total: '87',
            grace: '0',
            grades: 'A+',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60'
          },
          {
            code: 'EEC2930',
            sessionals: '61',
            exam: '26',
            total: '87',
            grace: '0',
            grades: 'A+',
            range: 'A+:81-100, A:71-80, B+:61-70, B:51-60'
          }
        ],
        info: {
          facno: '17EHB116',
          eno: 'GK6147',
          name: 'Steve Jhon',
          cpi: '8.91',
          spi: '9.714'
        }
      }

这就是我想要做的,但我不知道如何为子数组制作模式——

const mongo = require('mongoose');
const result = mongo.Schema({
sub:[
{
    code: { type: String }, sessionals: { type: String },
    exam: { type: String }, total: { type: String },
    grace: { type: String }, grades: { type: String }, range: { type: String}
}],
info: {
    facno: { type: String },
    eno: { type: String }, name: { type: String }, cpi: { type: String }, 
    spi: { type: String }
}
});
   module.exports = Result = mongo.model('result', result);

请告诉我如何为此制作架构:((

标签: javascriptnode.jsmongodbexpressweb-scraping

解决方案


如答案之一中所述,您可以将 mongoose 包与 node.js 一起使用。

您可以通过以下方式创建架构,

new mongoose.Schema({
sub:[ new mongoose.Schema({
        code: String,
        sessionals: String,
        exam: String,
        total: String,
        grace: String,
        grades: String,
        range: String
    })],
    info: {
          facno: String,
          eno: String,
          name: String,
          cpi: String,
          spi: String
        }
})


推荐阅读