My goal is to retrieve the values from the products collection by accessing cart.item for each index in order to obtain the current price of the product.
const CartSchema = mongoose.Schema({
userId: {
type: mongoose.Schema.Types.ObjectId,
required: true
},
cart: [
{
item: {
type: mongoose.Schema.Types.ObjectId,
required: true,
ref: 'product'
},
quantity: {
type: Number,
required: true,
default: 1
},
image: {
type: String,
required: true
},
name: {
type: String,
required: true
}
}
],
active: {
type: Boolean,
default: true
},
modifiedOn: {
type: Date,
default: Date.now
}
},
{
timestamps: true
});
This structure illustrates my cart schema. I aim to access all occurrences of cart.item within the array (although not literally like this). The objective is to associate it with the Product collection to determine the present price of the items listed in the cart, enabling calculation of the total sum thereafter. The local field in the cart item corresponds to cart.item, while the foreign field aligns with _id in the product schema.
const ProductSchema = mongoose.Schema({
title: {
type: String,
required: true,
index: true
},
category: {
type: String,
required: true,
index: true
},
inStock: {
type: Number,
required: true
},
price: {
type: Number,
required: true
}
});
const Products = mongoose.model('product', ProductSchema);