Creating a mongodb entry for my schema using the java driver

Question

The below displays a "profile" object recorded in mongodb. I know this type of schema is very possible on mongoDB where you would create an inner object called "name" and "alias" inside your profile object. I have done it myself and tested this already.

{"name": {"name": "Peter", "show": false},
 "alias": {"alias":"GoofyDuck", "show": false}}

I feel that "name" and "alias" inner objects are not really necessary as I have an inner object called alias with a field called alias and would like my "profile" object to look like this instead -Is this even possible on mongoDB? Please show me with code if it is.

{{"name": "Peter", "show": false},
  {"alias":"GoofyDuck", "show": false}}

I also know that this is possible but don't really want to embed it into an array:

{[{"name": "Peter", "show": false},
  {"alias":"GoofyDuck", "show": false}]}

What is the question here? How to reorganize your schema? Yes, that is very possible. — David says Reinstate Monica
– David says Reinstate Monica, Commented Nov 26, 2015 at 20:02
No - is it possible to create the schema I want (the schema in the middle) on mongoDB? If so, please show me with code. I don't see how it is possible because you can either create an inner object like how I have shown in the first example, or you can put the inner DBObjects into an array like I shown in the third example. — Simon
– Simon, Commented Nov 26, 2015 at 20:05
Anything that is valid JSON is a valid document in Mongo. Since the middle code block is not valid JSON (the inner objects are missing keys) it is not valid for Mongo. On the same note the 3rd code block is also not valid JSON: the array is missing a key. — David says Reinstate Monica
– David says Reinstate Monica, Commented Nov 26, 2015 at 20:22
Agreed. I think this is the correct answer. Thanks! I will just have to change my schema to a valid json then which is most likely going to be the embedded inner objects as per my first example. The reason for my question is because I do not want to duplicate my field name and object name (you can see 'alias' appears twice in my first eg) but I guess it has to be done like that to create the valid json. — Simon
– Simon, Commented Nov 26, 2015 at 20:28

David says Reinstate Monica · Accepted Answer · 2015-11-26 20:33:58Z

1

Anything that is valid JSON is a valid document in Mongo. Since the middle code block is not valid JSON (the inner objects are missing keys) it is not valid for Mongo. On the same note the 3rd code block is also not valid JSON: the array is missing a key.

I think that the schema design you are looking for may be:

{
    name: "...",
    showName: true/false,
    alias: "...",
    showAlias: true/false
}

answered Nov 26, 2015 at 20:33

David says Reinstate Monica

20.2k22 gold badges84 silver badges124 bronze badges

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

Collectives™ on Stack Overflow

Creating a mongodb entry for my schema using the java driver

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related