mongodb - 在另一个不起作用的架构中使用架构。错误 : CastError: Cast to [ObjectId] failed for value

Question

我想要实现的目标:在另一个架构(配方架构)中使用一个架构(成分架构)。我的目标是在食谱模式中，我的配料键是我的配料模式的数组。不知道为什么它不起作用或我做错了什么。如果你们有任何想法，我将非常感激。请看下面我的代码。谢谢!

当我调用 seeds.js 时出现错误:

Error: Recipe validation failed: ingredients.0: Cast to [ObjectId] failed for value "[{"ingName":"tomato","ingQty":2,"ingQtyUnit":"piece","ingImageUrl":"https://upload.wikimedia.org/wikipedia/commons/8/89/Tomato_je.jpg"},{"ingName":"onion","ingQty":1,"ingQtyUnit":"piece","ingImageUrl":"https://www.seeds-gallery.shop/9430-large_default/onion-seeds-dutch-yellow.jpg"}]" (type string) at path "ingredients.0

'ingredients.0': CastError: Cast to [ObjectId] failed for value "[{"ingName":"tomato","ingQty":2,"ingQtyUnit":"piece","ingImageUrl":"https://upload.wikimedia.org/wikipedia/commons/8/89/Tomato_je.jpg"},{"ingName":"onion","ingQty":1,"ingQtyUnit":"piece","ingImageUrl":"https://www.seeds-gallery.shop/9430-large_default/onion-seeds-dutch-yellow.jpg"}]" (type string) at path "ingredients.0"

      stringValue: '"[{"ingName":"tomato","ingQty":2,"ingQtyUnit":"piece","ingImageUrl":"https://upload.wikimedia.org/wikipedia/commons/8/89/Tomato_je.jpg"}]"',
      messageFormat: undefined,
      kind: '[ObjectId]',
      value: '[{"ingName":"tomato","ingQty":2,"ingQtyUnit":"piece","ingImageUrl":"https://upload.wikimedia.org/wikipedia/commons/8/89/Tomato_je.jpg"}]',
      path: 'ingredients.0',
      reason: [CastError],
      valueType: 'string'
    }
  },
  _message: 'Recipe validation failed'

我是怎么做到的:

配方模型

const mongoose = require("mongoose");

const recipeSchema = mongoose.Schema({
    title: {
        type: String,
        required: true,
    },
    imageUrl: {
        type: String,
        required: true
    },
    calories: {
        type: Number, 
        required: false,
    }, 
    duration: {
        type: Number,
        required: true,
        min: 0,
    },
    ingredients:[{
        type: mongoose.Schema.Types.ObjectId, 
        ref: "Ingredient"
    }]
})

const Recipe = mongoose.model('Recipe', recipeSchema);

module.exports = Recipe;

成分模型:

const mongoose = require("mongoose");

const ingredientSchema = mongoose.Schema({
    _id: Schema.Types.ObjectId,
    ingName: {
        type: String,
        required: true,
    },
    ingQty: {
        type: Number,
        required: true,
    },
    ingQtyUnit: {
        type: String,
        required: true,
    },
    ingImageUrl: {
        type: String,
        required: true,
    }
})

const Ingredient = mongoose.model('Ingredient', ingredientSchema);

module.exports = Ingredient;

种子.js

const mongoose = require('mongoose');
const Recipe = require('./models/recipe');

mongoose.connect('mongodb://localhost:27017/foodApp', {useNewUrlParser: true, useUnifiedTopology: true})
    .then(() => {
        console.log("Mongo Connection open")
    })
    .catch((error) => {
        console.log("No, Mongo -> Connection Error " + error)
    })

const seedRecipes = [
    {
        title: "Spring vegetable pie",
        imageUrl: "https://recipes.lidl.co.uk/var/site/storage/images/1/9/4/3/243491-2-eng-GB/Spring-vegetable-pie.jpg",
        calories: 300,
        duration: 120,
        ingredients:[
            {
            ingName: "tomato",
            ingQty: 2,
            ingQtyUnit: "piece",
            ingImageUrl:"https://upload.wikimedia.org/wikipedia/commons/8/89/Tomato_je.jpg" 
        },
        {
            ingName: "onion",
            ingQty: 1,
            ingQtyUnit: "piece",
            ingImageUrl:"https://www.seeds-gallery.shop/9430-large_default/onion-seeds-dutch-yellow.jpg" 
        },
      ]
    },
]

Recipe.insertMany(seedRecipes)
.then(response => {
    console.log(response)
})
.catch( error => {
    console.log(error)
});

Answer 1

如果有人正在寻找答案，这就是我所做的。我创建了一个新的 seeds 文件夹，其中包含 2 个文件 index.js seeds.js。

在我的 seeds.js 中，我添加了我的数据配方对象并将其导出，以便我可以在其他地方使用它。

module.exports = [
    {
        title: "Mushroom and courgette fritter burgers",
        imageUrl: "https://recipes.lidl.co.uk/var/site/storage/images/2/5/4/2/252452-2-eng-GB/Mushroom-and-courgette-fritter-burgers.jpg",
        calories: 250,
        duration: 30,
        ingredients: [
            {
                ingName: "mushrooms",
                ingQty: 200,
                ingQtyUnit: "grams",
                ingImageUrl:"https://snaped.fns.usda.gov/sites/default/files/styles/crop_ratio_7_5/public/seasonal-produce/2018-05/mushrooms.jpg?h=b754914e&itok=Kldbq8Du" 
            },
            {
                ingName: "zucchini",
                ingQty: 2,
                ingQtyUnit: "piece",
                ingImageUrl:"https://healme.in/wp-content/uploads/2021/06/zucchini-2-1200.jpg" 
            }
        ]
    },    
]

然后，在我的 index.js 中，来自 seeds 文件夹

const mongoose = require('mongoose');
const Recipe = require('../models/recipe');
const Ingredient = require ('../models/ingredient')
const recipes = require('../seeds/seeds')

mongoose.connect('mongodb://localhost:27017/foodApp', {useNewUrlParser: true, useUnifiedTopology: true})
    .then(() => {
        console.log("Mongo Connection open from seeds")
    })
    .catch((error) => {
        console.log("No, Mongo -> Connection Error " + error)
    })

const seedDB = async () => {
    await Recipe.deleteMany({});
    let title;
    let imageUrl;
    let calories;
    let duration;
    let ingredients;
    for (let i = 0; i < recipes.length; i++) {
        title = recipes[i].title;
        imageUrl = recipes[i].imageUrl;
        calories = recipes[i].calories;
        duration = recipes[i].duration;
        ingredients = recipes[i].ingredients;
        for (let ing of ingredients) {
            ingredients = ing;
        }
    const newRecipe = new Recipe ({
        title: title,
        imageUrl: imageUrl,
        calories: calories,
        duration: duration,
        ingredients: new Ingredient({
            ingName: ingredients.ingName,
            ingQty: ingredients.ingQty,
            ingQtyUnit: ingredients.ingQtyUnit,
            ingImageUrl:ingredients.ingImageUrl,
        })
    })
        await newRecipe.save();
    }
}

seedDB();

食谱架构:

const mongoose = require("mongoose");
const Schema = mongoose.Schema;

const recipeSchema = new Schema({
    title: {
        type: String,
        required: true,
    },
    imageUrl: {
        type: String,
        required: true
    },
    calories: {
        type: Number, 
        required: false,
    }, 
    duration: {
        type: Number,
        required: true,
        min: 0,
    },
    ingredients: {
        _id: {
          type:mongoose.Schema.Types.ObjectId,
          ref:"Ingredient"
        }, 
        ingName: String,
        ingQty: Number, 
        ingQtyUnit: String,
        ingImageUrl: String,
    },
})

const Recipe = mongoose.model('Recipe', recipeSchema);

module.exports = Recipe;

成分架构:

const mongoose = require("mongoose");

const ingredientSchema = mongoose.Schema({
    ingName: {
        type: String,
        required: true,
    },
    ingQty: {
        type: Number,
        required: true,
    },
    ingQtyUnit: {
        type: String,
        required: true,
    },
    ingImageUrl: {
        type: String,
        required: true,
    },
})

const Ingredient = mongoose.model('Ingredient', ingredientSchema);

module.exports = Ingredient;