{"id":76239,"date":"2024-08-07T08:57:06","date_gmt":"2024-08-07T12:57:06","guid":{"rendered":"https:\/\/bangla.sitestree.com\/?p=76239"},"modified":"2024-08-07T08:57:16","modified_gmt":"2024-08-07T12:57:16","slug":"shirt-collection-and-mongo-queries","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76239","title":{"rendered":"Shirt Collection and Mongo Queries"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>db.Shirts.remove({});\n\ndb.Shirts.insertMany(\n    &#91;\n        {\n            Brand:\"Calvin\",\n            Name: \"Name 1\",\n            Color: &#91;\"Blue\", \"Red\"],\n            Price: 100,\n            Size: {\n                height:10, width:5\n            }\n        },\n        \n        {\n            Brand:\"Tommy\",\n            Name: \"Name 2\",\n            Color: &#91;\"Blue\", \"Red\", \"Orange\"],\n            Price: 10,\n            Size: {\n                height:10, width:5\n            }\n        }\n        \n        ,\n        \n        {\n            Brand:\"Calvin Kleins\",\n            Name: \"Name 3\",\n            Color: &#91;\"Blue\", \"Red\", \"Orange\"],\n            Price: 50,\n            Size: {\n                height:10, width:5\n            }\n        }\n        \n        \n    ]\n  );\n  \n  \/\/ related to: Update the Brand to Calvin Klein when you see only Calvin  \n  db.Shirts.find( {Brand:\"Calvin\"} );\n  db.Shirts.find({Brand:{regex:\/Calvin\/}});\n  db.Shirts.find({Brand:\"Calvin\"});  \n  db.Shirts.find({Brand:\"Tommy\"});  \n  db.Shirts.updateMany({Brand:\"Calvin\"}, {$set:{Brand:\"Calvin Klein\"}} );\n  db.Shirts.find({});\n  db.Shirts.find( \n      {\n         Brand:\"Calvin\"\n      } \n  );\n  \n  db.Shirts.find( {\n      Brand:{\n              $gt:2\n          }\n      } \n  );\n  \n  \/\/ https:\/\/www.mongodb.com\/docs\/manual\/reference\/operator\/query\/regex\/\n  db.Shirts.find({            \n       Brand: { $regex: \/Cal\/ }       \n  });\n  \n  \/\/ Find Shirts that costs between 50 and 100  \n  db.Shirts.find(\n      {\n          Price:\n          {\n              $gte:50, $lte:100\n          }\n      }\n  );\n  \n  \/\/ Find Shirts that costs between 50 and 100  \n  db.Shirts.find(\n      {\n          $and:&#91;\n              {Price:{$gte:50}},                  \n              {Price:{$lte:100}}          \n          ]                   \n      }\n  );\n  \n  \n  \/\/ Find shirts where the color is Blue or Red\n  db.Shirts.find (\n      {\n          Color: {$in:&#91;\"Red\", \"Blue\"]}\n      }\n  );\n  \n  \ndb.Shirts.find({\"_id\" : ObjectId(\"660191c185c168d7ae91df2f\")});\ndb.collection.findById('4ecbe7f9e8c1c9092c000027');\n\nlet id = '660191c185c168d7ae91df2f';\nlet o_id = new ObjectId(id);\ndb.Shirts.findOne({\"_id\":o_id});\n\n\n\ndb.runCommand( \n    {\n       create: \"Shirts\",\n       clusteredIndex: { \n           \"key\": { _id: 1 }, \n           \"unique\": true, \n           \"name\": \"ShirtsClusteredKey\" \n      }\n    } \n\n);\n\n\n\ndb.movies.aggregate(&#91;\n  {\n    $search: {\n      index: \"default\", \/\/ optional unless you named your index something other than \"default\"\n      text: {\n        query: \"star wars\",\n        path: \"title\"\n      },\n    },\n  },\n  {\n    $project: {\n      title: 1,\n      year: 1,\n    }\n  }\n])\n\n\ndb.runCommand( {\n   create: \"Shirts\",\n   clusteredIndex: { \"key\": { price: 1 }, \"unique\": true, \"name\": \"products clustered key\" }\n} )\n\n\ndb.Shirts.createIndex( { Price:1 } )\ndb.Shirts.aggregate(&#91;\n  {\n    $search: {\n      index: \"Price\", \/\/ optional unless you named your index something other than \"default\"\n      text: {\n        query: \"Tommy\",\n        path: \"Brand\"\n      },\n    },\n  },\n  {\n    $project: {\n      Brand: 1,\n      Price: 1,\n    }\n  }\n])\n\n\ndb.Shirts.getIndexes()\ndb.Shirts.find({Price:{$gt:10}});\n\nvar shrt = db.Shirts.find({});\nwhile (shrt.hasNext() ) {\n    print(tojson(shrt.next()))\n}\n\nvar shrt = db.Shirts.find({});\nprint(shrt);\nwhile (shrt.hasNext() ) {\n    print(shrt.next())\n}\n\n\n\ndb.Reviews.aggregate(&#91;\n  {\n    $lookup: {\n      from: \"Products\",\n      localField: \"product_id\",\n      foreignField: \"_id\",\n      as: \"movie_details\",\n    },\n  },\n  {\n    $limit: 1\n  }\n])\n\n\n\n\n\n  \n  <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[182],"tags":[],"class_list":["post-76239","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":76236,"url":"http:\/\/bangla.sitestree.com\/?p=76236","url_meta":{"origin":76239,"position":0},"title":"MongoDB: Shirts Colection, and Some Mongo Queries","author":"Sayed","date":"August 7, 2024","format":false,"excerpt":"db.Shirts.remove({}); db.Shirts.drop({}); db.Shirts.insertMany( [ { Brand:\"Calvin\", Name: \"Name 1\", Color: [\"Blue\", \"Red\"], Price: 100, Size: { height:10, width:5 } }, { Brand:\"Tommy\", Name: \"Name 2\", Color: [\"Blue\", \"Red\", \"Orange\"], Price: 10, Size: { height:10, width:5 } } , { Brand:\"Calvin Kleins\", Name: \"Name 3\", Color: [\"Blue\", \"Red\", \"Orange\"], Price: 50,\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10279,"url":"http:\/\/bangla.sitestree.com\/?p=10279","url_meta":{"origin":76239,"position":1},"title":"BetterCircleTest.java","author":"","date":"August 26, 2015","format":false,"excerpt":"********************** BetterCircleTest.java ********************** import java.awt.*; import java.applet.Applet; \/** Position circles down the diagonal so that their borders \u00a0*\u00a0 just touch. Illustrates that Java 1.1 lightweight \u00a0*\u00a0 components can be partially transparent. \u00a0* \u00a0 *\/ public class BetterCircleTest extends Applet { \u00a0 public void init() { \u00a0\u00a0\u00a0 setBackground(Color.lightGray); \u00a0\u00a0\u00a0 setLayout(null); \u00a0\u00a0\u00a0\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27229,"url":"http:\/\/bangla.sitestree.com\/?p=27229","url_meta":{"origin":76239,"position":2},"title":"A demo providing multiple buttons to select a playing card-A Panel, using CardLayout control which of four possible subpanels, holding a different card, to display #Programming Code Examples #Java\/J2EE\/J2ME #Advanced Swing","author":"Author-Check- Article-or-Video","date":"May 14, 2021","format":false,"excerpt":"####################### # CardDemo.java A demo providing multiple buttons to select a playing card. A Panel, using CardLayout control which of four possible subpanels, holding a different card, to display.Uses the following class and images: * CardPanel.java A Panel that displays a playing card. * ImageLabel.java A Canvas for displaying images.\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10295,"url":"http:\/\/bangla.sitestree.com\/?p=10295","url_meta":{"origin":76239,"position":3},"title":"A demo providing multiple buttons to select a playing card-A Panel, using CardLayout control which of four possible subpanels, holding a different card, to display","author":"","date":"August 26, 2015","format":false,"excerpt":"####################### # CardDemo.java A demo providing multiple buttons to select a playing card. A Panel, using CardLayout control which of four possible subpanels, holding a different card, to display.Uses the following class and images: \u00a0\u00a0\u00a0 * CardPanel.java A Panel that displays a playing card. \u00a0\u00a0\u00a0 * ImageLabel.java A Canvas for\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27215,"url":"http:\/\/bangla.sitestree.com\/?p=27215","url_meta":{"origin":76239,"position":4},"title":"BetterCircleTest.java #Programming Code Examples #Java\/J2EE\/J2ME #Advanced Swing","author":"Author-Check- Article-or-Video","date":"May 14, 2021","format":false,"excerpt":"********************** BetterCircleTest.java ********************** import java.awt.*; import java.applet.Applet; \/** Position circles down the diagonal so that their borders * just touch. Illustrates that Java 1.1 lightweight * components can be partially transparent. * *\/ public class BetterCircleTest extends Applet { public void init() { setBackground(Color.lightGray); setLayout(null); BetterCircle circle; int radius =\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10564,"url":"http:\/\/bangla.sitestree.com\/?p=10564","url_meta":{"origin":76239,"position":5},"title":"JavaScript Code","author":"","date":"August 29, 2015","format":false,"excerpt":"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var browser=navigator.appName; \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var b_version=navigator.appVersion; <a href=\"http:\/\/www.justetc.net\" target=\"_blank\"> <img border=\"0\" alt=\"hello\" src=\"b_pink.gif\" id=\"b1\" width=\"26\" height=\"26\" onmouseover=\"mouseOver()\" onmouseout=\"mouseOut()\" \/> Place the following code under script tag\/in a javascript file function mouseOver() { \u00a0\u00a0 document.getElementById(\"b1\").src =\"b_blue.gif\"; } function mouseOut() { \u00a0\u00a0 document.getElementById(\"b1\").src =\"b_pink.gif\"; } <map name=\"planetmap\"> <area shape =\"rect\" coords =\"0,0,82,126\"\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76239"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76239\/revisions"}],"predecessor-version":[{"id":76240,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76239\/revisions\/76240"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}