我有一个名为“用户”的mongoDB集合。在“用户”集合中有多个用户。每个用户都有一个名为“购物车”的数组,并且购物车内有类似这样的项目,
现在,我想通过提供用户的ID(_id)来检索用户的所有“购物车”详细信息(或对象)。 我以这种方式尝试过,但抛出异常
router.get('/getCart', (req, res, next) => {
console.log(req.body.userId)
User.findOne({_id: req.body.userId}
,(err, userInfo) => {
userInfo.Cart.find({}, (err, result) => {
if (err) return next(err);
let cart = {
status: 'success',
code: 200,
data : result
};
res.json(cart);
})
})
});
例外
TypeError: #<Object> is not a function
at CoreMongooseArray.find (<anonymous>)
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/src/routes/cart.js:58:23
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/node_modules/mongoose/lib/model.js:4837:16
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/node_modules/mongoose/lib/query.js:4391:12
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/node_modules/mongoose/lib/query.js:2869:28
at processTicksAndRejections (internal/process/task_queues.js:79:11)
Emitted 'error' event on Function instance at:
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/node_modules/mongoose/lib/model.js:4839:13
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/node_modules/mongoose/lib/query.js:4391:12
at /Users/applefactory/WebstormProjects/OnlineFashionStore/src/UserBackend/node_modules/mongoose/lib/query.js:2869:28
at processTicksAndRejections (internal/process/task_queues.js:79:11)
我该如何解决这个问题?还是有其他方法可以做到这一点?提前致谢!
------------------------------ UPDATE --------------------------------------
这是我的用户模型
const UserSchema = new mongoose.Schema({
username: {
type: String,
validate: {
validator: username => User.doesNotExist({username}),
message: "Username already exists"
}
},
email: {
type: String,
validate: {
validator: email => User.doesNotExist({email}),
message: "Email already exists"
}
},
password: {
type: String,
required: true
},
Cart : {
type: Array,
default: []
},
WishList : {
type : Array,
default: []
},
},{timestamps: true});
UserSchema.pre('save', function () {
if(this.isModified('password')){
this.password = hashSync(this.password, 10);
}
});
UserSchema.statics.doesNotExist = async function (field) {
return await this.where(field).countDocuments() === 0;
};
UserSchema.methods.comparePasswords = function (password) {
return compareSync(password, this.password);
};
const User = mongoose.model("User", UserSchema);
export default User;
我认为您在用户模型和Cart模型之间有点困惑,一种方法是使用用户ID并查询Cart模型:
如果我错了,我强烈建议您使用引用而不是单个文档:
然后可以使用填充:
实际上,当持久化时,您的对象将看起来像:
当然,用ObjectId替换整数ID。