{"id":535,"date":"2017-01-29T11:22:18","date_gmt":"2017-01-29T09:22:18","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=535"},"modified":"2018-12-04T13:10:27","modified_gmt":"2018-12-04T11:10:27","slug":"mongodb-mini-user-guide","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=535","title":{"rendered":"MongoDB Mini User Guide"},"content":{"rendered":"

Shell Mongo :
\n<\/strong><\/span>> mongo
\n<\/strong><\/span><\/p>\n

Once you are in terminal\/command line, access the database\/collection you want to use as follows:<\/strong><\/span><\/p>\n

show dbs\r\nuse <db name>\r\nshow collections<\/code><\/pre>\n
choose your collection and type the following to see all contents of that collection<\/span><\/strong>:<\/p>\n
db.collectionName.find()\r\n<\/code><\/pre>\n
for a query below some samples :<\/strong><\/span>
\n<\/code><\/p>\n
db.products.find({ \"_id\": \"apples\", \"qty\": 5 }<\/pre>\n
db.products.find( { qty: { $gt: 25 } } )<\/pre>\n
db.students.find( { score: { $gt: 0, $lt: 2 } } )<\/pre>\n
db.bios.find( { _id: 5 } )<\/pre>\n
db.bios.find( { contribs: \"UNIX\" } ) >>>>>> Array elements<\/pre>\n
Check this link for more : https:\/\/docs.mongodb.com\/manual\/reference\/method\/db.collection.find\/<\/a><\/p>\n
 Import \/ Export command in MongoDB (Unicode files)(json)<\/strong><\/span><\/p>\n
mongoimport -d comedy -c cartoons -file collections.json\r\nmongoexport -d comedy -c cartoons -o collections.json<\/pre>\n
Change collection name in mongodb<\/strong><\/span><\/p>\n
db.oldname.renameCollection(\"newname\")<\/pre>\n
Change type fields :<\/strong><\/span><\/p>\n
\/\/ String to Integer for notice_id\r\ndb.mycollection.find({notice_id : {$exists : true}}).forEach( function(obj) { obj.notice_id = new NumberInt(obj.notice_id); db.mycollection.save(obj); } );<\/pre>\n
\/\/ Integer to String for field-name\r\ndb.db-name.find({field-name : {$exists : true}}).forEach( function(obj) { obj.field-name = \"\"+obj.field-name; db.db-name.save(obj); } );<\/pre>\n
Rename a field in mongoDB :
\n<\/strong><\/span><\/p>\n
db.mycollection.update ( {}, { $rename : { \"notice_id\" : \"isn\" }}, false, true );<\/pre>\n
Delete a collection<\/strong><\/span><\/p>\n
db.compta.drop();<\/pre>\n
Empty a collection<\/strong><\/span><\/p>\n
db.compta.remove();<\/pre>\n
Under the Mongodb shell please import the follwing json file (test.json) listed below with :<\/p>\n
mongoimport -d test -c compta -file d:test.json<\/strong><\/pre>\n
{ “montant” : 3.95, “travel” : “Prague”, “sens” : “credit” }
\n{ “montant” : 6.03, “travel” : “Prague”, “sens” : “credit” }
\n{ “montant” : 5.53, “travel” : “New York”, “sens” : “credit” }
\n{ “montant” : -1.96, “travel” : “New York”, “sens” : “debit” }
\n{ “montant” : 3.95, “tickets” : “eurodisney”, “sens” : “credit” }
\n{ “montant” : 6.03, “tickets” : “asterix”, “sens” : “credit” }<\/p>\n
Mongo Request Sum or Total aggregate :<\/p>\n
db.compta.aggregate({$group:{\r\n_id:\"\",\r\nmontant: {$sum: \"$montant\"}}\r\n}, {$project:{\r\n_id:0,\r\nmontant: \"$montant\"}});\r\n\r\ndb.compta.aggregate({$group:{\r\n_id:\"$travel\",\r\nmontant: {$sum: \"$montant\"}}\r\n}, {$project:{\r\n_id:1,\r\nmontant: \"$montant\"}});\r\n\r\n<br?><\/pre>\n","protected":false},"excerpt":{"rendered":"
Shell Mongo : > mongo Once you are in terminal\/command line, access the database\/collection you want to use as follows: show dbs use <db name> show collections choose your collection and type the following...<\/p>\n","protected":false},"author":1,"featured_media":2845,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[16],"tags":[351,352,110,143],"youtube_video":null,"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/535"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=535"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/535\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/2845"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}