Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Insert Array inside an object in MongoDB

Tags:

java

mongodb

I am new at MongoDB and I want to insert to mongodb data like this but I couldn't figure out how

{
  image = "cab"
  tags = [
            [ "NNP", 0 ],
            [ "NN", 1 ]
         ]
},
{
  image = "castle"
  tags = [
            [ "NNP", 2 ],
            [ "NN", 1 ],
         ]
}

my code is

    BasicDBObject obj = new BasicDBObject();
    obj.put("images", ....);
    for(Tag tag:tags){
    BasicDBObject tagsObj = new BasicDBObject();
    tagsObj.put("NNP",tag.getNNP());
    tagsObj.put("NN",tag.getNN());
    obj.put("tags",tagsObj);

    }

UPDATE: using this code

Mongo m = new Mongo();
DB db = m.getDB("test");
DBCollection coll = db.getCollection("tags");
for(Tag tag:tags){
    BasicDBList dbl = new BasicDBList();
    dbl.add(new BasicDBObject("NNP",tag.getNNP()));
    dbl.add(new BasicDBObject("NN", tag.getNNP()));
    BasicDBObject outer=new BasicDBObject("images", currentImageName).append("tags", dbl);
    coll.insert(outer);
                }

I store every image alone cause the tags might be like this for the same image

  {
      image = "cab",
      tags = [
                { "NNP", 0 },
                { "NN", 1 }
             ],
             [  {"NNP", 4 },
                { "NN", 5 } 
             ],
             [
                {"NNP", 0 },
                { "NN", 4 }
             ]

},

Thanks

like image 325
Peril Avatar asked Oct 21 '11 17:10

Peril


2 Answers

Basically you use BasicDBObject for key-value mappings and BasicDBList for array objects. For the object in your question, you'd do this:

BasicDBList dbl = new BasicDBList();
dbl.add(new BasicDBObject("NNP",0));
dbl.add(new BasicDBObject("NN", 1));
BasicDBOBject outer=new BasicDBObject("image", "cab").append("tags", dbl);

There's some convenience methods in the api to make this a bit less verbose.

The mapping works like this:

for:  {"A":1}  use: new BasicDBObject("A",1)
for: {"A":1, "B":2}  use: new BasicDBObject("A",1).append("B",2)
for: {"A":{"B":2}}  use: new BasicDBObject("A",new BasicDBObject("B",2))
for: {"A":["B","C"]} use:
        BasicDBList dbl = new BasicDBList();
        dbl.add("B");
        dbl.add("C");
         ->  new BasicDBObject("A",dbl);
like image 194
Steve B. Avatar answered Sep 20 '22 16:09

Steve B.


Did you mean like this?

    BasicDBObject obj = new BasicDBObject();
    obj.put("image", ....);
    for(Tag tag:tags){
        BasicDBObject tagsObj = new BasicDBObject();
        tagsObj.put("NNP",tag.getNNP());
        tagsObj.put("NN",tag.getNN());
        obj.put("tags",tagsObj);
    }
like image 43
Lycha Avatar answered Sep 21 '22 16:09

Lycha