{"id":76236,"date":"2024-08-07T08:54:38","date_gmt":"2024-08-07T12:54:38","guid":{"rendered":"https:\/\/bangla.sitestree.com\/?p=76236"},"modified":"2024-08-07T08:54:44","modified_gmt":"2024-08-07T12:54:44","slug":"mongodb-shirts-colection-and-some-mongo-queries","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76236","title":{"rendered":"MongoDB: Shirts Colection, and Some Mongo Queries"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>db.Shirts.remove({});\n\ndb.Shirts.drop({});\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  <\/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-76236","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":76239,"url":"http:\/\/bangla.sitestree.com\/?p=76239","url_meta":{"origin":76236,"position":0},"title":"Shirt Collection and Mongo Queries","author":"Sayed","date":"August 7, 2024","format":false,"excerpt":"db.Shirts.remove({}); 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, Size:\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":76236,"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":76236,"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":76236,"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":76236,"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":76236,"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\/76236","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=76236"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76236\/revisions"}],"predecessor-version":[{"id":76237,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76236\/revisions\/76237"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76236"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76236"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76236"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}