{"id":9235,"date":"2018-09-04T09:23:42","date_gmt":"2018-09-04T09:23:42","guid":{"rendered":"http:\/\/www.gencayyildiz.com\/blog\/?p=9235"},"modified":"2018-09-04T09:23:42","modified_gmt":"2018-09-04T09:23:42","slug":"mongodb-iliskilendirme-sonucunda-eslesmeyen-verileri-getirme","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/mongodb-iliskilendirme-sonucunda-eslesmeyen-verileri-getirme\/","title":{"rendered":"MongoDB – \u0130li\u015fkilendirme Sonucunda E\u015fle\u015fmeyen Verileri Getirme"},"content":{"rendered":"

<\/div>\n

Merhaba,<\/p>\n

\u00d6nceki yaz\u0131lar\u0131mdan NoSQL \u2013 MongoDB \u0130\u015flevsel Fonksiyonlar ve Aggregate Operat\u00f6rleri<\/a> ba\u015fl\u0131kl\u0131 makalemde “$lookup” operat\u00f6r\u00fc ile MongoDB veritaban\u0131nda iki farkl\u0131 collection\u0131n nas\u0131l ili\u015fkilendirildi\u011fini incelemi\u015ftik. Bu i\u00e7eri\u011fimizde ise ili\u015fkilendirme sonucunda e\u015fle\u015fmeyen verilerinde elde edilmesi i\u00e7in ne yap\u0131lmas\u0131 gerekti\u011fini konu\u015faca\u011f\u0131z.<\/p>\n

\u0130\u00e7eri\u011fimizi anla\u015f\u0131labilir k\u0131lmak i\u00e7in “Employee” ve “Order” olmak \u00fczere iki \u00f6rnek collection \u00fczerinden zenginle\u015ftirece\u011fiz.<\/p>\n\n\n\n\n\n
Employee Collection<\/th>\n Order Collection<\/th>\n<\/tr>\n<\/thead>\n
$\"MongoDB$ <\/a><\/td>\n $\"MongoDB$ <\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Yukar\u0131daki collectionlara g\u00f6z atarsan\u0131z e\u011fer “Employee” collection\u0131ndaki “9” ve “10” idlerine sahip documentlere kar\u015f\u0131l\u0131k “Order” collection\u0131nda bir kay\u0131t bulunmamaktad\u0131r.<\/p>\n
\r\nrouter.get("\/listOrder", (request, response, next) =>\r\n employeeModel.aggregate\r\n ([\r\n {\r\n $lookup: {\r\n from: "order",\r\n localField: "_id",\r\n foreignField: "employeeId",\r\n as: "orderList"\r\n }\r\n },\r\n {\r\n $unwind: "$orderList"\r\n },\r\n {\r\n $project: {\r\n orderNumber: "$orderList.orderNumber",\r\n name: 1,\r\n surName: 1\r\n }\r\n }\r\n ])\r\n .then(data => response.render("home", { data: data }))\r\n .catch(error => response.send("Veriler listelenirken beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131."))\r\n);\r\n<\/pre>\n
Dolay\u0131s\u0131yla bu \u015fekilde bir ili\u015fkilendirme sonucu sadece e\u015fle\u015fen kay\u0131tlar\u0131n geldi\u011fini g\u00f6rmekteyiz.<\/p>\n
$\"MongoDB$ <\/a><\/p>\n
E\u011fer ki e\u015fle\u015fmeyen kay\u0131tlar\u0131n gelmesini istyorsak a\u015fa\u011f\u0131daki gibi “$unwind” operat\u00f6r\u00fcnde “preserveNullAndEmptyArrays” parametresine “true” vermeniz gerekmektedir.<\/p>\n
\r\nrouter.get("\/listOrder", (request, response, next) =>\r\n employeeModel.aggregate\r\n ([\r\n {\r\n $lookup: {\r\n from: "order",\r\n localField: "_id",\r\n foreignField: "employeeId",\r\n as: "orderList"\r\n }\r\n },\r\n {\r\n $unwind: {\r\n path: "$orderList",\r\n preserveNullAndEmptyArrays: true\r\n }\r\n },\r\n {\r\n $project: {\r\n orderNumber: "$orderList.orderNumber",\r\n name: 1,\r\n surName: 1\r\n }\r\n }\r\n ])\r\n .then(data => response.render("home", { data: data }))\r\n .catch(error => response.send("Veriler listelenirken beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131."))\r\n);\r\n<\/pre>\n
Bu i\u015flem neticesinde iki collection aras\u0131nda e\u015fle\u015fen e\u015fle\u015fmeyen t\u00fcm kay\u0131tlar\u0131n elde edildi\u011fini g\u00f6rebilmekteyiz.
\n $\"MongoDB$ <\/a><\/p>\n
\u0130lgilenenlerin faydalanmas\u0131 dile\u011fiyle…<\/p>\n
Sonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere…
\n\u0130yi \u00e7al\u0131\u015fmalar…<\/p>\n","protected":false},"excerpt":{"rendered":"
Merhaba, \u00d6nceki yaz\u0131lar\u0131mdan NoSQL \u2013 MongoDB \u0130\u015flevsel Fonksiyonlar ve Aggregate Operat\u00f6rleri ba\u015fl\u0131kl\u0131 makalemde “$lookup” operat\u00f6r\u00fc ile MongoDB veritaban\u0131nda iki farkl\u0131 collection\u0131n nas\u0131l ili\u015fkilendirildi\u011fini incelemi\u015ftik. Bu i\u00e7eri\u011fimizde ise ili\u015fkilendirme sonucunda e\u015fle\u015fmeyen verilerinde elde edilmesi i\u00e7in...<\/p>\n","protected":false},"author":1,"featured_media":8971,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2539,2145],"tags":[2597,2574,2147,2596],"class_list":["post-9235","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","category-node-js","tag-lookup","tag-lookup-operatoru","tag-node-js","tag-preservenullandemptyarrays"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/9235","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=9235"}],"version-history":[{"count":8,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/9235\/revisions"}],"predecessor-version":[{"id":9247,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/9235\/revisions\/9247"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/8971"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=9235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=9235"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=9235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}