How to create nested object in MongoDB schema

Question

I currently have the following schema for a MongoDB document which is supposed to save user data:

var userSchema =  new mongoose.Schema({
  username: {type: String, unique : true},
  password: {type: String},
  firstname: String,
  lastname: String,
  sketches: 
              [ 
                {name: String, 
                 sketch: Array}
              ]

The sketches attribute needs to be an array objects where each object associates the name of a sketch and an array which holds the sketch data. For some reason, the schema ends up being created as the following:

{
    "__v" : 1,
    "_id" : ObjectId("57c4d7693aa85cea2acf4d4d"),
    "firstname" : "test",
    "lastname" : "name",
    "password" : "password123",
    "sketches" : [ 
        {
            "sketch" : []
        }
    ],
    "username" : "testname"
}

I'm not exactly sure the correct format for creating nested objects in MongoDB but I was assuming that it would be the same as it would for JSON. How should the schema be structured to yield an array of objects.

EDIT:

web service to insert into document from PUT request:

app.route("/addSketch/:username").put(function(req, res, next) {
  var user_name = req.params.username;
  User.findOne({username:user_name},function(err,foundObject){
    if(err){
      console.log("error");
      res.status(500).send();
    }
    else{
      if(!foundObject){
        res.status(404).send();
      }
      else{
        
        if(req.body.strokes && req.body.sketchName){
          var sketchObj = [];
          sketchObj[req.body.sketchName] = req.body.strokes;
          foundObject.sketches.push(req.body.sketchData);
        }
        foundObject.save(function(err,updatedObject){
          if(err){
            console.log(err);
            res.status(500).send();
          }
          else{
            res.send(updatedObject);
          }
        });
      }
    }

  });


  console.log('saving on server');
   var form = formidable.IncomingForm();

   console.log(form);
   console.log('the type of the request received is', (typeof req));

  form.parse(req, function(err, fields, files) {
      res.writeHead(200, {"content-type": "text/plain"});
      res.write('received upload:\n\n');
    var name = fields.name;
    var newSketch = new SavedSketch();
      newSketch.name = name;
      newSketch.sketchData =  fields.value;
      newSketch.save(function(err,savedObject){
        if(err){
               console.log(err);
               res.status(500).json({status:'failure'})
            }
            else{
              console.log("ID: " + fields.value.id + " strokeData:" + fields.value.strokes);
               res.json({status: 'success'});
            } 
      });

         res.end();
  });
  });

How are you inserting the documents in your Mongoose code, can you show that part as well? — chridam
– chridam, Commented Aug 30, 2016 at 15:16
@chridam I just updated the post. I was also thinking of making the sketches array a subdocument of the User document but I wasn't sure the best way to go about doing that exactly. — loremIpsum1771
– loremIpsum1771, Commented Aug 30, 2016 at 15:26

wscourge · Accepted Answer · 2019-03-12 07:07:41Z

5

Schema

var userSchema =  new mongoose.Schema({
  username: {type: String, unique : true},
  password: {type: String},
  firstname:{type: String},
  lastname: {type: String},
  sketches: [
    {
      name: String,
      sketch : {type : Array}
    }
  ]
});

edited Mar 12, 2019 at 7:07

wscourge

11.4k17 gold badges65 silver badges87 bronze badges

answered Aug 30, 2016 at 15:40

Wasiq Muhammad

3,1483 gold badges19 silver badges30 bronze badges

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

1 Comment

loremIpsum1771 Over a year ago

That seems like it works, I ended up creating a sub document for sketches instead. I'll post another answer with what I did.

loremIpsum1771 · Accepted Answer · 2016-08-30 15:45:53Z

3

I ended up creating a sub document for sketches and making that a child of the User Schema:

var sketchSchema =  mongoose.Schema({ name: String, sketchData : Array
  });
var SavedSketch = mongoose.model('Sketch', sketchSchema);
// });


var userSchema =  new mongoose.Schema({
  username: {type: String, unique : true},
  password: {type: String},
  firstname: String,
  lastname: String,

  sketches:[sketchSchema]


var User = mongoose.model('User', userSchema);

module.exports = User;

answered Aug 30, 2016 at 15:45

loremIpsum1771

2,5276 gold badges47 silver badges92 bronze badges

2 Comments

Sunny Over a year ago

What is the difference between declaration: password: {type: String} vs firstname: String ?.

Tkaewkunha Over a year ago

@Sunny {type : String} is equal : String. The first pattern, we can add more option like password: {type: String, unique: true, requried: true }.

Collectives™ on Stack Overflow

How to create nested object in MongoDB schema

EDIT:

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

EDIT:

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related