insert document in array field

Question

I'm not good at mongodb, so it is hard to manipulate sub documents. What I want to do is implement address book like this:

{
    [[email protected]]: [
        {
            email: '[email protected]',
            createdAt: '0000-00-00',
            updatedAt: '0000-00-00'
        }
    ],
    [[email protected]]: [
        { ... },
        { ... }
    ]
}

I called that collection 'addressbook', and each item is Array type to contain address information like email, image, date of created something like that.

The problem is I don't know how to do it. Looks like I need to use some operators like $addToSet or $push, but I don't get it how to use them correctly. What I tried:

update({
    email: '[email protected]'
}, {
    $push: {
        'address.$email': {
            email: target,
            createdAt: new Date(),
            updatedAt: new Date()
        }
    }
})

One thing I knew was using upsert option to update collection makes new document if it doesn't exists, but still docs are not creating. It will be very appreciate to gimme a hand.

You might have some trouble nesting the documents so deeply like that. Mongo has had trouble updating deeply nested documents. — Julian Guterman
– Julian Guterman, Commented Jun 4, 2016 at 8:08
You're on the right track, you would use $push or $pull to add or remove content to or from an existing document. — Julian Guterman
– Julian Guterman, Commented Jun 4, 2016 at 8:10

profesor79 · Accepted Answer · 2016-06-04 22:35:29Z

1

It looks like structure presented will hold all user data in one document. This could be very tricky in future handling, as bson document have 16MB capacity limit.

If you could consider simpler form of document:

{
   _id:bsonId,       
   email: '[email protected]',
   createdAt: '0000-00-00',
   updatedAt: '0000-00-00',
   name: "unknown"
 }

then updating and maintaining your collection will be a lot easier.

db.addressbook.update({ email: '[email protected]'},{name:"Happy User"})

answered Jun 4, 2016 at 22:35

profesor79

9,5033 gold badges36 silver badges53 bronze badges

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

1 Comment

modernator Over a year ago

oh... i forgot to limit of each document. i should try it. thanks :)

Collectives™ on Stack Overflow

insert document in array field

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related