Cómo insertar en una matriz de objetos Hay una matriz de objetos, y quiero ponerlos todos en una consulta, y fallé, aquí está mi esquema
const userSchema = new Schema({ user: { type: String, required: true }, roles: { User: { type: Number, default: 2001 }, Editor: Number, Admin: Number }, password: { type: String, required: true }, Stock:[{ sku:String, productname:String, sendout:Number, recived:Number, totalinstock:Number, location:String }], Orders:[{ date:Date, OrderNumber:Number, Address:String, Phone:Number, Country:String, Name:String, Trackingnumber:Number, ZipCode:Number, Province:String, Quantity:Number, Product_Name:String, SKU:String }], }); module.exports = mongoose.model('User', userSchema);Lo que hice fue tomar las órdenes que quería enviar a DB y fusionarlas en un objeto
const producktarray = [ { OrderNumber: '1468313738187862019', Address: 'bbbbbbbb', SKU: [ 'CJNSXZXX00480' ], Quantity: [ 9 ], Province: 'yyyy', Product_Name: [ 'Thick Loose ' ], Name: 'xxxxx' }, { OrderNumber: 546546456456, Address: 'vvvv, SKU: [ 'CJNS' ], Quantity: [ 6 ], Province: 'New York', Product_Name: [ 'Thick Loose ' ], Name: 'Gggggggg' } ]Ahora que estoy tratando de enviarlo a Mongo, recibo errores La forma en que traté de ponerlo es (también probé updateOne)
await User.updateMany({ $push :{ Orders: { producktarray }}});Quiero que todos los datos entren en PedidosEspero ver en el mango
"Orders": [ { "OrderNumber": '1468313738187862019', "Address": 'bbbbbbbb', "SKU": [ 'CJNSXZXX00480' ], "Quantity": [ 9 ], "Province": 'yyyy', "Product_Name": [ 'Thick Loose Three-dimensional Japanese Linen Pants' ], "Name": 'xxxxx' "_id": { "$oid": "62826016005ce00c5f0235c8" } }, { OrderNumber: 546546456456, Address: 'vvvv, SKU: [ 'CJNS' ], Quantity: [ 6 ], Province: 'New York', Product_Name: [ 'Thick Loose Three-dimensional Japanese Linen Pants' ], Name: 'Gggggggg' "_id": { "$oid": "62826035005ce00c5f0235cc" } }si define la matriz del esquema del objeto, cree un esquema diferente para una matriz de objetos y asigne la clave del Valor
const orderSchema=newSchema({ date: { type: Date, default: newDate() }, OrderNumber: { type: Number, required: true }, Address: { type: String, required: true }, Phone: { type: Number }, Country: { type: String }, Name: { type: String, required: true }, Trackingnumber: { type: Number }, ZipCode: { type: Number }, Province: { type: String, required: true }, Quantity: { type: [ Number ], required: true }, Product_Name: { type: [ String ], required: true }, SKU: { type: [ String ], required: true } }); const userSchema=newSchema({ user: { type: String, required: true }, roles: { User: { type: Number, default: 2001 }, Editor: Number, Admin: Number }, password: { type: String, required: true }, Stock: [ { sku: String, productname: String, sendout: Number, recived: Number, totalinstock: Number, location: String } ], Orders: [ orderSchema ], }); module.exports=mongoose.model('User', userSchema);