{"id":794,"date":"2021-11-11T04:05:34","date_gmt":"2021-11-11T04:05:34","guid":{"rendered":"https:\/\/scrutineer.co.kr\/wordpress\/?p=794"},"modified":"2021-11-12T01:11:01","modified_gmt":"2021-11-12T01:11:01","slug":"%eb%aa%bd%ea%b3%a0-%eb%94%94%eb%b9%84-%ec%9d%b8-%ec%95%a1%ec%85%98-7%ec%9e%a5-1","status":"publish","type":"post","link":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/2021\/11\/11\/%eb%aa%bd%ea%b3%a0-%eb%94%94%eb%b9%84-%ec%9d%b8-%ec%95%a1%ec%85%98-7%ec%9e%a5-1\/","title":{"rendered":"\ubabd\uace0 \ub514\ube44 \uc778 \uc561\uc158 7\uc7a5-1"},"content":{"rendered":"\n

\uc5c5\ub370\uc774\ud2b8, \uc6d0\uc790\uc801\uc5f0\uc0b0, \uc0ad\uc81c<\/p>\n\n\n\n

\ub3c4\ud050\uba3c\ud2b8 \uc5c5\ub370\uc774\ud2b8<\/strong><\/p>\n\n\n\n

MongoDB \uc5c5\ub370\uc774\ud2b8 \ubc29\uc2dd
– \ub3c4\ud050\uba3c\ud2b8 \uc804\uccb4 \ub300\uce58
– \ub3c4\ud050\uba3c\ud2b8 \ub0b4\uc758 \ud2b9\uc815 \ud544\ub4dc\ub97c \uc218\uc815\ud558\uae30 \uc704\ud574 \uc5c5\ub370\uc774\ud2b8 \uc5f0\uc0b0\uc790 \uc0ac\uc6a9<\/p>\n\n\n\n

{\r\n_id: ObjectId(\"4c4b1476238d3b4dd5000001\"),\r\nusername: \"kbanker\",\r\nemail: \"kylebanker@gmail.com\",\r\nfirst_name: \"Kyle\",\r\nlast_name: \"Banker\",\r\nhashed_password: \"bd1cfa194c3a603e7186780824b04419\",\r\naddresses: [\r\n  {\r\n    name: \"work\",\r\n    street: \"1 E. 23rd Street\",\r\n    city: \"New York\",\r\n    state: \"NY\",\r\n    zip: 10010\r\n  }\r\n ]\r\n}\n\ndoc = db.users.findOne({username: \"kbanker\"})\r\nuser_id = doc._id<\/code><\/pre>\n\n\n\n
\ub300\uce58\uc5d0 \uc758\ud55c \uc218\uc815<\/p>\n\n\n\n
user_id = ObjectId(\"4c4b1476238d3b4dd5003981\")  \ndoc = db.users.findOne({_id: user_id})     \/\/\uc0ac\uc6a9\uc790 _id\ub85c \ub3c4\ud050\uba3c\ud2b8 \uc9c8\uc758\ndoc['email'] = 'mongodb-user@mongodb.com' \/\/email \uc18d\uc131 \uc218\uc815\nprint('updating ' + user_id)\ndb.users.update({_id: user_id}, doc)  \/\/update \uba54\uc11c\ub4dc\uc758 \ub9e4\uac1c\ubcc0\uc218\ub85c \ub118\uaca8\uc90c\uc73c\ub85c\uc368 \uc804\uccb4 \ub3c4\ud050\uba3c\ud2b8\ub97c \ub300\uce58\uc2dc\ud0b4<\/code><\/pre>\n\n\n\n
\uc5f0\uc0b0\uc790\uc5d0 \uc758\ud55c \uc218\uc815<\/p>\n\n\n\n
user_id = ObjectId(\"4c4b1476238d3b4dd5000001\")\r\ndb.users.update({_id: user_id},\r\n{$set: {email: 'mongodb-user2@mongodb.com'}})  \/\/$set \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec email \ud544\ub4dc\ub97c \uc218\uc815<\/code><\/pre>\n\n\n\n
\ub450 \ubc29\ubc95\uc758 \ube44\uad50<\/p>\n\n\n\n
\/\/\ub300\uce58\ub97c \uc774\uc6a9\ud55c \uc0c1\ud488 \ub9ac\ubdf0\uc218 \uc99d\uac00 : \uc11c\ubc84\ub85c\ubd80\ud130 \ub3c4\ud050\uba3c\ud2b8\ub97c \uac00\uc838\uc640 \uc218\uc815 \ud6c4 \uc11c\ubc84\ub85c \uc804\uc1a1\nproduct_id = ObjectId(\"4c4b1476238d3b4dd5003982\")\ndoc = db.products.findOne({_id: product_id})\ndoc['total_reviews'] += 1 \/\/ total_reviews\uc758 \uac12\uc5d0 1\uc744 \ub354\ud568\ndb.products.update({_id: product_id}, doc)\n\n\n\/\/\ud0c0\uae43\uc744 \uc774\uc6a9\ud55c \uc0c1\ud488 \ub9ac\ubdf0\uc218 \uc99d\uac00 : $inc \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc5c5\ub370\uc774\ud2b8\ndb.products.update({_id: product_id}, {$inc: {total_reviews: 1}})<\/code><\/pre>\n\n\n\n
\ub300\uce58 Vs \uc5f0\uc0b0\uc790
– \uc0ac\uc6a9\uc790\uc758 \uc5b4\ub5a4 \uc18d\uc131\uc744 \uc218\uc815\ud558\ub4e0\uc9c0 \uc0c1\uad00\uc5c6\uc774 \uc5c5\ub370\uc774\ud2b8\ub97c \uc218\ud589\ud558\ub294 \ucf54\ub4dc\ub294 \ub3d9\uc77c\ud558\ub2e4.
\uc5c5\ub370\uc774\ud2b8\ub97c \uc77c\ubc18\ud654\ud558\ub294 MongoDB \uac1d\uccb4 \ub9e4\ud37c\ub97c \uc791\uc131\ud55c\ub2e4\uba74 \ub300\uce58 \ubc29\uc2dd\uc774 \ud569\ub9ac\uc801
– \ud0c0\ud0b7\ubc29\uc2dd\uc740 \uc880 \ub354 \ub098\uc740 \uc131\ub2a5\uc744 \uac16\ub294\ub2e4. \uc218\uc815\ud560 \ub3c4\ud050\uba3c\ud2b8\ub97c \uc694\uccad\ud560 \ud544\uc694\ub3c4 \uc5c6\uc73c\uba70 \ub3c4\ud050\uba3c\ud2b8\uc758 \ud06c\uae30\uac00 \uc77c\ubc18\uc801\uc73c\ub85c \uc791\ub2e4.
\ub3c4\ud050\uba3c\ud2b8\ub97c \uc6d0\uc790\uc801\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud560 \ub54c \ud6a8\uc728\uc801<\/p>\n\n\n\n
\uc804\uc790\uc0c1\uac70\ub798 \uc5c5\ub370\uc774\ud2b8<\/strong><\/p>\n\n\n\n
\uc0c1\ud488\uc758 \ud3c9\uc810 \ud3c9\uade0 \ub0b4\ubcf4\uae30<\/p>\n\n\n\n
product_id = ObjectId(\"4c4b1476238d3b4dd5003981\")\n\/\/ product_id = db.products.findOne({sku: '9092'}, {'_id': 1})\n\r\ncount = 0\r\ntotal = 0\r\ndb.reviews.find({product_id: product_id}, {rating: 4}).forEach(  \/\/\ud574\ub2f9 \uc0c1\ud488Id\uc5d0 \ub300\ud55c \r\n     function(review) {\r\n          total += review.rating                                         \/\/\ub9ac\ubdf0\ud3c9\uc810 \ud569\uc0b0\r\n          count++                                                          \/\/\ub9ac\ubdf0\uc218 \uce74\uc6b4\ud2b8\r\n     })\r\naverage = total \/ count\r\ndb.products.update({_id: product_id},\r\n      {$set: {total_reviews: count, average_review: average}})<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
db.products.update({_id: product_id},\r\n{\r\n  $set: {\r\n    average_review: average,  \r\n    ratings_total: total           \/\/\ub9ac\ubdf0 \ud3c9\uc810\uc758 \ucd1d\ud569\uc744 \ubcf4\uad00\ud558\ub294 \ud544\ub4dc \ucd94\uac00\r\n  },\r\n  $inc: {\r\n    total_reviews: 1\r\n  }\r\n})<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
\uce74\ud14c\uace0\ub9ac \uacc4\uce35 \uad6c\uc870<\/p>\n\n\n\n
\uc8fc\uc5b4\uc9c4 \uce74\ud14c\uace0\ub9ac\uc5d0 \ub300\ud574 \uc870\uc0c1 \ub9ac\uc2a4\ud2b8 \uc5c5\ub370\uc774\ud2b8\ud558\uae30<\/p>\n\n\n\n
var generate_ancestors = function(_id, parent_id) {\r\n  ancestor_list = []\r\n  var cursor = db.categories.find({_id: parent_id})\n\r  \/\/\ub8e8\ud2b8 \ub178\ub4dc\uc5d0 \ub3c4\ub2ec\ud560 \ub54c\uae4c\uc9c0 \uac00 \ub178\ub4dc\uc758 parent_id \uc18d\uc131\uc744 \uc9c8\uc758\n  while(cursor.size() > 0) {\r\n     parent = cursor.next()\n\r     \/\/ \uc870\uc0c1\ub4e4\uc758 \uc21c\uc11c\uac00 \uc788\ub294 \ub9ac\uc2a4\ud2b8\ub97c \uad6c\ud558\uace0 ancestor_list\uc5d0 \uc800\uc7a5\n     ancestor_list.push(parent)\r\n     parent_id = parent.parent_id\r\n     cursor = db.categories.find({_id: parent_id})\r\n  }\n\r  \/\/$set\uc744 \uc0ac\uc6a9\ud574 \uce74\ud14c\uace0\ub9ac\uc758 ancestor \uc18d\uc131\uc5d0 \uc800\uc7a5\n  db.categories.update({_id: _id}, {$set: {ancestors: ancestor_list}})\r  \n}<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Home \ucd5c\uc0c1\uc704 \uce74\ud14c\uace0\ub9ac\uc5d0 Gardening \uce74\ud14c\uace0\ub9ac \ucd94\uac00\ud558\uae30 (\uc544\ub798) <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
parent_id = ObjectId(\"8b87fb1476238d3b4dd50003\")\ncategory = {\n  parent_id: parent_id,\n  slug: \"gardening\",\n  name: \"Gardening\",\n  description: \"All gardening implements, tools, seeds, and soil.\"\n  \n}\ndb.categories.save(category)  \/\/save\ub97c \uc774\uc6a9\ud558\uc5ec \ub3c4\ud050\uba3c\ud2b8 \uc800\uc7a5\ngenerate_ancestors(category._id, parent_id) \/\/ generate_ancestors \ud638\ucd9c<\/code><\/pre>\n\n\n\n
\/\/Outdoors \uce74\ud14c\uace0\ub9ac\ub97c Gardening \uce74\ud14c\uace0\ub9ac \uc544\ub798\ub85c \uc62e\uae30\uae30\n\/\/Outdoors\uc758 parent_id\ub97c gardening_id\ub85c \ubcc0\uacbd\ndb.categories.update({_id: outdoors_id}, {$set: {parent_id: gardening_id}})\n\/\/Outdoors\uc758 \ud558\uc704 \uce74\ud14c\uace0\ub9ac\ub97c \uc870\ud68c\ud558\uc5ec \uc870\uc0c1 \ub9ac\uc2a4\ud2b8 \uc218\uc815\ndb.categories.find({'ancestors.id': outdoors_id}).forEach(\r\n  function(category) {\r\n          generate_ancestors(category._id, outdoors_id)\r\n   }\n)<\/code><\/pre>\n\n\n\n
\/\/Outdoors \uce74\ud14c\uace0\ub9ac\uba85 \uc218\uc815 -> The Great Outdoors\ndoc = db.categories.findOne({_id: outdoors_id}) \/\/Outdoors \ub3c4\ud050\uba3c\ud2b8\ub97c \ucc3e\uc74c\r\ndoc.name = \"The Great Outdoors\" \/\/name \uc18d\uc131 \ubcc0\uacbd\r\ndb.categories.update({_id: outdoors_id}, doc) \/\/\ub300\uce58\ubc29\uc2dd\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\r\ndb.categories.update(\r\n  {'ancestors._id': outdoors_id},\r\n  {$set: {'ancestors.$': doc}},    \/\/\ubaa8\ub4e0 \uc870\uc0c1 \ub9ac\uc2a4\ud2b8\uc5d0 \ub098\ud0c0\ub098\ub294 Outdoors\ub97c \ubcc0\uacbd\r\n  {multi: true})                     \/\/\uc140\ub809\ud130\uc640 \uc77c\uce58\ud558\ub294 \ubaa8\ub4e0 \ub3c4\ud050\uba3c\ud2b8\uc5d0 \uc5c5\ub370\uc774\ud2b8 \uc801\uc6a9 (\ub2e4\uc911 \uc5c5\ub370\uc774\ud2b8 \uac00\ub2a5)<\/code><\/pre>\n\n\n\n
ancestor.$ : $ \uc704\uce58 \uc5f0\uc0b0\uc790 : \ucffc\ub9ac \uc140\ub809\ud130\uc640 \uc77c\uce58\ud558\ub294 \ubc30\uc5f4 \uc778\ub371\uc2a4\ub97c \uadf8 \uc790\uc2e0\uc73c\ub85c \ub300\uce58\uc5d0 \uc5c5\ub370\uc774\ud2b8 \uc2dc\ud0b4<\/p>\n\n\n\n
db.users.update({\r\n         _id: ObjectId(\"4c4b1476238d3b4dd5000001\"),\r\n         'addresses.name': 'work'},\r\n         {$set: {'addresses.$.street': '155 E 31st St.'}}) \/\/\uc0ac\uc6a9\uc790 \uc8fc\uc18c \ud544\ub4dc \ubcc0\uacbd \uc2dc \uc0ac\uc6a9\ub418\ub294 \uc704\uce58 \uc5f0\uc0b0\uc790<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
\ub9ac\ubdf0<\/p>\n\n\n\n
{\n  helpful_votes: 3,\n  voter_ids: [\n    ObjectId(\"4c4b1476238d3b4dd5000041\"),\n    ObjectId(\"7a4f0376238d3b4dd5000003\"),\n    ObjectId(\"92c21476238d3b4dd5000032\")\n  ]\n}\n\n\ndb.reviews.update({_id: ObjectId(\"4c4b1476238d3b4dd5000041\")}, {\n  \/\/$push \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud574 \ucd94\ucc9c\uc790\uc758 ID\ub97c \ub9ac\uc2a4\ud2b8\uc5d0 \ucd94\uac00\r\n  $push: {\r\n     voter_ids: ObjectId(\"4c4b1476238d3b4dd5000001\")\r\n  },\n\r  \/\/$inc \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud574 \ucd94\ucc9c\uc218 \ud558\ub098\uc529 \uc99d\uac00\n  $inc: {\r\n     helpful_votes: 1\r\n  }\r\n})\n\n\nquery_selector = {\r\n  _id: ObjectId(\"4c4b1476238d3b4dd5000041\"),\r\n  voter_ids: {\r\n     $ne: ObjectId(\"4c4b1476238d3b4dd5000001\")\r\n   }\r\n}\r\ndb.reviews.update(query_selector, {\r\n  $push: {\r\n     voter_ids: ObjectId(\"4c4b1476238d3b4dd5000001\")\r\n  },\r\n  $inc : {\r\n     helpful_votes: 1\r\n  }\r\n})<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
\ub808\uc774\uc2a4 \ucee8\ub514\uc158 (race condition)<\/p>\n\n\n\n
\ud0c0\uae43 \ubc29\uc2dd\uacfc \ub300\uce58 \ubc29\uc2dd\uc73c\ub85c \ub3d9\uc2dc\uc5d0 \uc5c5\ub370\uc774\ud2b8\ub420 \ub54c \ub370\uc774\ud130\uac00 \uc190\uc2e4 \ub420 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n
\uc8fc\ubb38<\/p>\n\n\n\n
\uc5c5\uc11c\ud2b8(upsert) : \uc5c5\ub370\uc774\ud2b8\ud560 \ub3c4\ud050\uba3c\ud2b8\uac00 \uc874\uc7ac\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \uc0c8\ub85c\uc6b4 \ub3c4\ud050\uba3c\ud2b8\ub97c \uc778\uc11c\ud2b8<\/p>\n\n\n\n
cart_item = {\r\n  _id: ObjectId(\"4c4b1476238d3b4dd5003981\"),\r\n  slug: \"wheel-barrow-9092\",\r\n  sku: \"9092\",\r\n  name: \"Extra Large Wheel Barrow\",\r\n  pricing: {\r\n      retail: 5897,\r\n      sale: 4897\r\n  }\r\n}\n\nselector = {\r\n  user_id: ObjectId(\"4c4b1476238d3b4dd5000001\"),\r\n  state: 'CART'\r\n}\r\nupdate = {\r\n  $inc: {\r\n     sub_total: cart_item['pricing']['sale']\r\n  }\r\n}\r\ndb.orders.update(selector, update, {upsert: true})<\/code><\/pre>\n\n\n\n
{\r\nuser_id: ObjectId(\"4c4b1476238d3b4dd5000001\"),\r\nstate: 'CART',\r\nsubtotal: 9794\r\n}\n\nselector = {user_id: ObjectId(\"4c4b1476238d3b4dd5000001\"),\r\nstate: 'CART',\r\n'line_items._id':\r\n{'$ne': cart_item._id}\r\n}\r\nupdate = {'$push': {'line_items': cart_item}}\r\ndb.orders.update(selector, update)\n\n{\r\nuser_id: ObjectId(\"4c4b1476238d3b4dd5000001\"),\r\nstate: 'CART',\r\nline_items: [\r\n{\r\n_id: ObjectId(\"4c4b1476238d3b4dd5003981\"),\r\nquantity: 2,\r\nslug: \"wheel-barrow-9092\",\r\nsku: \"9092\",\r\nname: \"Extra Large Wheel Barrow\",\r\npricing: {\r\nretail: 5897,\r\nsale: 4897\r\n}\r\n}\r\n],\r\nsubtotal: 9794\r\n}\n\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\uc5c5\ub370\uc774\ud2b8, \uc6d0\uc790\uc801\uc5f0\uc0b0, \uc0ad\uc81c \ub3c4\ud050\uba3c\ud2b8 \uc5c5\ub370\uc774\ud2b8 MongoDB \uc5c5\ub370\uc774\ud2b8 \ubc29\uc2dd– \ub3c4\ud050\uba3c\ud2b8 \uc804\uccb4 \ub300\uce58– \ub3c4\ud050\uba3c\ud2b8 \ub0b4\uc758 \ud2b9\uc815 \ud544\ub4dc\ub97c \uc218\uc815\ud558\uae30 \uc704\ud574 \uc5c5\ub370\uc774\ud2b8 \uc5f0\uc0b0\uc790 \uc0ac\uc6a9 \ub300\uce58\uc5d0 \uc758\ud55c \uc218\uc815 \uc5f0\uc0b0\uc790\uc5d0 \uc758\ud55c \uc218\uc815 \ub450 \ubc29\ubc95\uc758 \ube44\uad50 \ub300\uce58 Vs \uc5f0\uc0b0\uc790– \uc0ac\uc6a9\uc790\uc758 \uc5b4\ub5a4 \uc18d\uc131\uc744 \uc218\uc815\ud558\ub4e0\uc9c0 \uc0c1\uad00\uc5c6\uc774 \uc5c5\ub370\uc774\ud2b8\ub97c \uc218\ud589\ud558\ub294 \ucf54\ub4dc\ub294 \ub3d9\uc77c\ud558\ub2e4.\uc5c5\ub370\uc774\ud2b8\ub97c \uc77c\ubc18\ud654\ud558\ub294 MongoDB \uac1d\uccb4 \ub9e4\ud37c\ub97c \uc791\uc131\ud55c\ub2e4\uba74 \ub300\uce58 \ubc29\uc2dd\uc774 \ud569\ub9ac\uc801– \ud0c0\ud0b7\ubc29\uc2dd\uc740 \uc880 \ub354 \ub098\uc740 \uc131\ub2a5\uc744 \uac16\ub294\ub2e4. … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-794","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=794"}],"version-history":[{"count":4,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/794\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/794\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scrutineer.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}