MongoDB- How to create a master template/document from an existing mongodb document collection?
I am new to the mongodb. I have one mongo database which contains the around 150 collections. Currently I want to create the master document for each collection. Master document will contain all the fields in that collection. e.g. Lets say I have a users collection and it contains the two records as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"pass" : "system",
"email": "em@gm.com"
}
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test1",
"org":{
"name":"My Org"
},
"pass" : "test"
}
After merging the two documents I will get the master record as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"email" : "em@gm.com",
"org":{
"name":"My Org"
},
"pass" : "test"
}
Here I am not worried about the data. I need the structure of the document and data types of the fields. I have thousands of the records which are not managed properly. I need a master template which will contain the all the possible fields in all the documents of one collection. I have to create such template for each collection.
Appreciating your help.
mongodb merge nosql mongodb-query
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
add a comment |
I am new to the mongodb. I have one mongo database which contains the around 150 collections. Currently I want to create the master document for each collection. Master document will contain all the fields in that collection. e.g. Lets say I have a users collection and it contains the two records as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"pass" : "system",
"email": "em@gm.com"
}
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test1",
"org":{
"name":"My Org"
},
"pass" : "test"
}
After merging the two documents I will get the master record as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"email" : "em@gm.com",
"org":{
"name":"My Org"
},
"pass" : "test"
}
Here I am not worried about the data. I need the structure of the document and data types of the fields. I have thousands of the records which are not managed properly. I need a master template which will contain the all the possible fields in all the documents of one collection. I have to create such template for each collection.
Appreciating your help.
mongodb merge nosql mongodb-query
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
how is it possible that, you will be having sameObjectIdfor 2 documents in mongodb?
– Prabhat Mishra
Nov 26 '18 at 9:42
I am not worried about the data. If data is empty then also I am fine. I just need the key and its position in the document.
– Ravindra Nalawade
Nov 26 '18 at 12:33
I don't know whether in mongodb we can combine. My view on this would be, take the all collection data and prepare a master document by processing each and every collection using some scripting languages ...I could have done this using Python scripting and would have stored the master document from Python for each collection.
– Prabhat Mishra
Nov 26 '18 at 12:41
add a comment |
I am new to the mongodb. I have one mongo database which contains the around 150 collections. Currently I want to create the master document for each collection. Master document will contain all the fields in that collection. e.g. Lets say I have a users collection and it contains the two records as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"pass" : "system",
"email": "em@gm.com"
}
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test1",
"org":{
"name":"My Org"
},
"pass" : "test"
}
After merging the two documents I will get the master record as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"email" : "em@gm.com",
"org":{
"name":"My Org"
},
"pass" : "test"
}
Here I am not worried about the data. I need the structure of the document and data types of the fields. I have thousands of the records which are not managed properly. I need a master template which will contain the all the possible fields in all the documents of one collection. I have to create such template for each collection.
Appreciating your help.
mongodb merge nosql mongodb-query
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
I am new to the mongodb. I have one mongo database which contains the around 150 collections. Currently I want to create the master document for each collection. Master document will contain all the fields in that collection. e.g. Lets say I have a users collection and it contains the two records as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"pass" : "system",
"email": "em@gm.com"
}
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test1",
"org":{
"name":"My Org"
},
"pass" : "test"
}
After merging the two documents I will get the master record as
{
"_id" : ObjectId("59e5e384cbead107344e6420"),
"user_name" : "test",
"email" : "em@gm.com",
"org":{
"name":"My Org"
},
"pass" : "test"
}
Here I am not worried about the data. I need the structure of the document and data types of the fields. I have thousands of the records which are not managed properly. I need a master template which will contain the all the possible fields in all the documents of one collection. I have to create such template for each collection.
Appreciating your help.
mongodb merge nosql mongodb-query
mongodb merge nosql mongodb-query
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
asked Nov 26 '18 at 9:10
Ravindra NalawadeRavindra Nalawade
163
163
how is it possible that, you will be having sameObjectIdfor 2 documents in mongodb?
– Prabhat Mishra
Nov 26 '18 at 9:42
I am not worried about the data. If data is empty then also I am fine. I just need the key and its position in the document.
– Ravindra Nalawade
Nov 26 '18 at 12:33
I don't know whether in mongodb we can combine. My view on this would be, take the all collection data and prepare a master document by processing each and every collection using some scripting languages ...I could have done this using Python scripting and would have stored the master document from Python for each collection.
– Prabhat Mishra
Nov 26 '18 at 12:41
add a comment |
how is it possible that, you will be having sameObjectIdfor 2 documents in mongodb?
– Prabhat Mishra
Nov 26 '18 at 9:42
I am not worried about the data. If data is empty then also I am fine. I just need the key and its position in the document.
– Ravindra Nalawade
Nov 26 '18 at 12:33
I don't know whether in mongodb we can combine. My view on this would be, take the all collection data and prepare a master document by processing each and every collection using some scripting languages ...I could have done this using Python scripting and would have stored the master document from Python for each collection.
– Prabhat Mishra
Nov 26 '18 at 12:41
how is it possible that, you will be having same
ObjectId for 2 documents in mongodb?– Prabhat Mishra
Nov 26 '18 at 9:42
how is it possible that, you will be having same
ObjectId for 2 documents in mongodb?– Prabhat Mishra
Nov 26 '18 at 9:42
I am not worried about the data. If data is empty then also I am fine. I just need the key and its position in the document.
– Ravindra Nalawade
Nov 26 '18 at 12:33
I am not worried about the data. If data is empty then also I am fine. I just need the key and its position in the document.
– Ravindra Nalawade
Nov 26 '18 at 12:33
I don't know whether in mongodb we can combine. My view on this would be, take the all collection data and prepare a master document by processing each and every collection using some scripting languages ...I could have done this using Python scripting and would have stored the master document from Python for each collection.
– Prabhat Mishra
Nov 26 '18 at 12:41
I don't know whether in mongodb we can combine. My view on this would be, take the all collection data and prepare a master document by processing each and every collection using some scripting languages ...I could have done this using Python scripting and would have stored the master document from Python for each collection.
– Prabhat Mishra
Nov 26 '18 at 12:41
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477794%2fmongodb-how-to-create-a-master-template-document-from-an-existing-mongodb-docum%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477794%2fmongodb-how-to-create-a-master-template-document-from-an-existing-mongodb-docum%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
how is it possible that, you will be having same
ObjectIdfor 2 documents in mongodb?– Prabhat Mishra
Nov 26 '18 at 9:42
I am not worried about the data. If data is empty then also I am fine. I just need the key and its position in the document.
– Ravindra Nalawade
Nov 26 '18 at 12:33
I don't know whether in mongodb we can combine. My view on this would be, take the all collection data and prepare a master document by processing each and every collection using some scripting languages ...I could have done this using Python scripting and would have stored the master document from Python for each collection.
– Prabhat Mishra
Nov 26 '18 at 12:41