Sending Array of Objects to MongoDB Atlas using node.js

Question

I am connected to my database using node.js. Now I want to send some data to the database which is as follows:

data

const service=[
    {ServiceChoseByUser:'Cleaning',PriceForService:'100'},
    {ServiceChoseByUser:'Painting',PriceForService:'300'},
    {ServiceChoseByUser:'Electrician',PriceForService:'400'},
    {ServiceChoseByUser:'Plumbing',PriceForService:'50'},
    // may be increased as the number of services selected by the user.
}

My schema is described as :

Schema.js

import mongoose from 'mongoose';

const serviceSchema = new mongoose.Schema({
    service: [
        {
            id: {
                  type: String,
                  trim: true,
                  unique: true
            },
            ServiceChoseByUser: {
                  type: String,
                  trim: true,
                  unique: true,
                  lowercase:true
            },
            PriceForService: {
                  type: String,
                  trim: true,
                  lowercase:true,
                  unique: true,
           },
       },
    ]
});

let Service = mongoose.model('service', serviceSchema);

export default Service;

And my controller of data is :

controller.js

import Service from ".Schema.js";


export const sendService = async (req, res) => {
    try {
        const serviceByUser = req.body;
        console.log(serviceByUser);
        const newService = new Service(service);
        console.log(newService);
        await newService.save();
        console.log('Service data stored');
        res.send(200 + 'Service data stored')
    } catch (error) {
        res.send(500 + ' Error occured');
        console.log('Error: from service controller ', error.message);
    }
}

The app is connected successfully to the database. But when I am sending data to the database, it always shows Error: from service controller E11000 duplicate key error collection: HouseDeck-Cluster.services index: services_1 dup key: { services: null }

I checked for that by using console.log() as you can see in controller.js. When I am displaying the data it shows the data is correct but when I do console.log(newService). It always shows { _id: new ObjectId("6234720c80a5f440ade88d24"), service: [] }

It states that something is wrong with the schema. I tried various things like:

Already Tried These For Schema

1. service=[Object]

2. service=[
       {
          id:String,
          ServiceChoseByUser:String,
          PriceForService:String
       }
    ]
 
3. service=Array

4. service={
      type:Array
     }

5. service=[
      {
          type:Object
      }
   ]

6. // already provided above

I tried many things, also searched for it, read the documentation but I couldn't find any solution.

Please help

Alaindeseine · Accepted Answer · 2022-03-18 14:00:45Z

1

You have indicate in your schema that all fields are unique.

So, all data you insert in all fields must be unique.

Try modifying your schema like this:

const serviceSchema = new mongoose.Schema({
            id: {
                  type: String,
                  trim: true,
                  unique: true
            },
            ServiceChoseByUser: {
                  type: String,
                  trim: true,
                  lowercase:true
            },
            PriceForService: {
                  type: String,
                  trim: true,
                  lowercase:true
           }
});

And then insert your datas with something like this:

newService.insertMany(service);

edited Mar 18, 2022 at 14:00

answered Mar 18, 2022 at 12:46

Alaindeseine

4,6341 gold badge17 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Yash-Sharma2002 Over a year ago

No, its not working just tried. Still getting same error.

Alaindeseine Over a year ago

Have you delete an recreate you collection ?

Alaindeseine Over a year ago

Youn can check indexes of you collection with compass or with atlas.

Yash-Sharma2002 Over a year ago

I also tried deleting my collection but u can see after when I pass the data by my schema it returns null so it doesn't matter if I delete the collection the element it inserts contains service=[] hence it sends null which I don't want

Yash-Sharma2002 Over a year ago

now it is storing like _id : 623489e35e5ab2d299e93bdb, service : Array, __v : 0 and service is not expanding means it is still null

|

Collectives™ on Stack Overflow

Sending Array of Objects to MongoDB Atlas using node.js

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related