Geek asks and answers

Mongo Pallets Update

I seem to have encountered roadblock when using MongoDB and would like to know if all this is around it without changing my database structure. Now my database structure is as follows:

Company= 
{
   _id:1,
   properties:[
       {
           property_id: 1
           tags : [
             {
                 tag_id: 1
                 tag_value: 1000
                 channels: [
                       {
                          channel_id:1
                          channel_name:"test1"
                       },
                       {
                          channel_id:2
                          channel_name:"test2"
                       }]
             },
             {
                 tag_id:2
                 tag_value: 2500
                 channels: [
                       {
                          channel_id:2
                          channel_name:"test2"
                       },
                       {
                          channel_id:3
                          channel_name:"test3"
                       }]

             }]
       },
       {
           property_id: 2
           tags : [
             {
                 tag_id: 3
                 tag_value: 500
                 channels: [
                       {
                          channel_id:1
                          channel_name:"test1"
                       },
                       {
                          channel_id:3
                          channel_name:"test3"
                       }]
             },
             {
                 tag_id: 4
                 tag_value: 5000
                 channels: [
                       {
                          channel_id:1
                          channel_name:"test1"
                       }]                    
             }]
       }]       
}

I am having a problem where I cannot find a way to update certain tags in a property. For example, I want to change the value of tag_id 4 in property 2 to 100. Or I want to add a channel to the channel array in tag_id 3.

I would like to do something similar to this:

db.company.update({_id:1, "properties.property_id":2, "tags.tag_id":4}, {"properties.$.tags.$.tag_value":100});

, MongoDB, JIRA. , , . , properties.1.tags.0, , .

, , .

+2
1

, ( ).

, , , Jira (SERVER-831)

  • ,

, :

doc = db.xx.findOne( {_id:1} );
doc.properties.forEach( function(p) {
    if ( p.property_id == 2 ) { 
        p.tags.forEach( function(t) {
           if ( t.tag_id == 3 ) {
               t.tag_value = 100;
           }
           else if ( t.tag_id == 4 ) {
               newChannel = {};
               newChannel.channel_id = 5;
               newChannel.channel_name = "test5";
               t.channels.push(newChannel);
           }
        })
    }
});
db.xx.update({_id:1},{$set:{properties:doc.properties}});

:

doc = db.xx.findOne({_id:1})
{
    "_id" : 1,
    "properties" : [
        {
            "property_id" : 1,
            "tags" : [
                {
                    "tag_id" : 1,
                    "tag_value" : 1000,
                    "channels" : [
                        {
                            "channel_id" : 1,
                            "channel_name" : "test1"
                        },
                        {
                            "channel_id" : 2,
                            "channel_name" : "test2"
                        }
                    ]
                },
                {
                    "tag_id" : 2,
                    "tag_value" : 2500,
                    "channels" : [
                        {
                            "channel_id" : 2,
                            "channel_name" : "test2"
                        },
                        {
                            "channel_id" : 3,
                            "channel_name" : "test3"
                        }
                    ]
                }
            ]
        },
        {
            "property_id" : 2,
            "tags" : [
                {
                    "tag_id" : 3,
                    "tag_value" : 100,
                    "channels" : [
                        {
                            "channel_id" : 1,
                            "channel_name" : "test1"
                        },
                        {
                            "channel_id" : 3,
                            "channel_name" : "test3"
                        }
                    ]
                },
                {
                    "tag_id" : 4,
                    "tag_value" : 5000,
                    "channels" : [
                        {
                            "channel_id" : 1,
                            "channel_name" : "test1"
                        },
                        {
                            "channel_id" : 5,
                            "channel_name" : "test5"
                        }
                    ]
                }
            ]
        }
    ]
}
+1

More articles:


All Articles