<\/div>\n
Merhaba,<\/p>\n
Bu i\u00e7eri\u011fimizde Node.js ortam\u0131nda MongoDB’ye CRUD i\u015flemlerinin nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131 ele alaca\u011f\u0131z. \u0130lk olarak bir adet Node.js projesi in\u015fa<\/a> ediyoruz ve ard\u0131ndan projeye gerekli paketleri(express, mongoose vs.) entegre ediyoruz.<\/p>\n
\u0130\u00e7eri\u011fimizde yapaca\u011f\u0131m\u0131z t\u00fcm \u00f6rneklendirmeleri a\u015fa\u011f\u0131daki uygulama \u00e7er\u00e7evesinde ele alaca\u011f\u0131z.<\/p>\n
\r\nconst mongoose = require("mongoose");\r\nconst express = require("express");\r\nconst app = express();\r\n\r\nmongoose.connect("mongodb:\/\/localhost\/companydb")\r\n    .then(() => console.log("Veritaban\u0131 ba\u011flant\u0131s\u0131 ba\u015far\u0131yla sa\u011flanm\u0131\u015ft\u0131r..."))\r\n    .catch(error => console.log("Veritaban\u0131 ba\u011flant\u0131s\u0131 sa\u011flan\u0131rken beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...", error.message));\r\n\r\nconst employeeRoter = require(".\/routes\/employeeRouter");\r\napp.use("\/employee\/", employeeRoter);\r\n\r\napp.listen(5000, () => console.log("Yay\u0131n ba\u015flad\u0131..."));\r\n<\/pre>\nVe ayriyetten makale boyunca kullanaca\u011f\u0131m\u0131z mod\u00fcl\u00fcm\u00fcz a\u015fa\u011f\u0131daki olacakt\u0131r.<\/p>\n\r\nconst mongoose = require("mongoose");\r\n\r\nmodule.exports = mongoose.model("Employees", new mongoose.Schem a({\r\n    _id: Number,\r\n    userName: String,\r\n    name: String,\r\n    surName: String,\r\n    age: Number\r\n}));\r\n<\/pre>\nKay\u0131t Ekleme<\/h3>\nMongoDB’ye veri eklemeyi \u00f6nceki Node.js \u2013 MongoDB\u2019ye Mongoose \u0130le \u015eema Olu\u015fturma ve Kay\u0131t Ekleme<\/a> ba\u015fl\u0131kl\u0131 yaz\u0131m\u0131zda incelemi\u015ftik.<\/p>\n
Tekrardan de\u011finmemiz gerekirse e\u011fer;<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/addEmployee", (request, response, next) => {\r\n    let employee = new model({\r\n        _id: 3,\r\n        userName: "abc",\r\n        name: "X",\r\n        surName: "Y",\r\n        age: 35\r\n    });\r\n\r\n    employee.save((error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        } else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\n\r\nmodule.exports = router;\r\n<\/pre>\ng\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere “save” fonksiyonu ile veritaban\u0131na ilgili documenti kaydedebilmekteyiz.<\/p>\nSorgu Olu\u015fturmak(Find)<\/h3>\nVeritaban\u0131ndaki herhangi bir collectiondaki verilerin t\u00fcm\u00fcn\u00fc ya da \u015farta ba\u011fl\u0131 bir k\u0131sm\u0131n\u0131 elde etmek i\u00e7in “find”, “findOne” ya da “findById” fonksiyonlar\u0131n\u0131 a\u015fa\u011f\u0131daki durumlarda kullanabiliriz.<\/p>\n\n\nT\u00fcm Kay\u0131tlar\u0131 \u00c7ekmek<\/strong><\/p>\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getEmployeeList", (request, response, next) => {\r\n    model.find({}, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\n\r\nmodule.exports = router;\r\n<\/pre>\n“find” fonksiyonu ile veritaban\u0131ndaki t\u00fcm kay\u0131tlar\u0131 bu \u015fekilde elde edebilmekteyiz. Dikkat edilmesi gereken husus, ilgili fonksiyonun ilk parametresine “{ }” de\u011ferinin verilmesidir. Bu \u015fekilde \u015farta ba\u011fl\u0131 kalmaks\u0131z\u0131n veritaban\u0131ndaki t\u00fcm kay\u0131tlar belirtilmi\u015f bulunmaktad\u0131r.\n<\/li>\n\n\u015eartl\u0131 Sorgu Olu\u015fturmak<\/strong>
\nBelirli kriterlere uygun verileri getirmek i\u00e7in “find” fonksiyonunu a\u015fa\u011f\u0131daki gibi kullanabiliriz.<\/p>\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getEmployee", (request, response, next) => {\r\n    model.find({ name: "Gen\u00e7ay" }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\nDikkat ederseniz “find” fonksiyonunun ilk parametresine “{ name: “Gen\u00e7ay” }” de\u011ferini belirtmi\u015f bulunmaktay\u0131z. Bu de\u011fer, collectiondaki “name” kolonu “Gen\u00e7ay” olan t\u00fcm documentleri getir manas\u0131na gelmektedir.
\n<\/a>
\nBenzer mant\u0131kla \u015fartlar\u0131 \u00e7o\u011faltabilir ve a\u015fa\u011f\u0131daki gibi birden fazla kolon i\u00e7in kriter belirleyebiliriz.<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getEmployee", (request, response, next) => {\r\n    model.find({ name: "Gen\u00e7ay", surName: "Y\u0131ld\u0131z", userName: "gncy" }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\n<\/a><\/p>\n
Ayr\u0131ca sorgu sonucu listelemek istenilen kolonlarda a\u015fa\u011f\u0131daki gibi ayarlanabilmektedir.<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getEmployee", (request, response, next) => {\r\n    model.find({ name: "Gen\u00e7ay" }, "name", (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\n“find” fonksiyonunun ikinci parametresine bakarsan\u0131z e\u011fer string olarak belirtilen “name” ifadesi bu sorgulama sonucunda e\u015fle\u015fen kay\u0131tlar\u0131n sadece “name” kolonlar\u0131n\u0131n listelenmesini ifade etmektedir.
\n<\/a><\/p>\n
Birden fazla kolon listelemek istenirse e\u011fer;<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getEmployee", (request, response, next) => {\r\n    model.find({ name: "Gen\u00e7ay" }, "name surName", (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\n\u015feklinde kolon isimlerinin yanyana yaz\u0131lmas\u0131 yeterlidir.<\/p>\n<\/a>\n<\/li>\n
\nTekil Sorgu Olu\u015fturmak(findOne)<\/strong>
\nE\u011fer ki veritaban\u0131nda aranan tek bir veri ise o veriye \u00f6zel “findOne” fonksiyonu ile tekil sorgu olu\u015fturulabilir.<\/p>\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getSingleEmployee", (request, response, next) => {\r\n    model.findOne({ name: "Gen\u00e7ay" }, "name surName", (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\n<\/a><\/p>\n
“findOne” fonksiyonunun “find” fonksiyonundan fark\u0131; “find” fonksiyonu collection i\u00e7erisindeki t\u00fcm kay\u0131tlar\u0131n \u015farta e\u015fitlik durumunu incelerken, “findOne” fonksiyonu ise ilk buldu\u011fu kayd\u0131 getirecek ve di\u011fer verilerin e\u015fitlik durumunu incelemeyecektir.\n<\/li>\n
\nID Bazl\u0131 Arama(findById)<\/strong>
\nVeriler \u00fczerinde id bazl\u0131 arama yapabilmek i\u00e7inde “findById” fonksiyonunu kullanabilmekteyiz.<\/p>\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/getByIdEmployee", (request, response, next) => {\r\n    model.findById("1", "name surName", (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\nDirekt olarak parametreye verilen id de\u011ferine sahip olan veri elde edilecektir.
\n<\/a>\n<\/li>\n<\/ul>\n
Veri G\u00fcncelleme<\/h3>\nVeri g\u00fcncellemek i\u00e7in “update” fonksiyonu kullan\u0131lmaktad\u0131r.<\/p>\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/updateEmployee", (request, response, next) => {\r\n    model.update({ name: "Gen\u00e7ay" }, { surName: "Y\u0131ld\u0131z (Yeni)" }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\nYukar\u0131daki kod blo\u011funu incelerseniz e\u011fer; “name” kolonu “Gen\u00e7ay” olan verinin “surName” kolonunu “Y\u0131ld\u0131z (Yeni)” yap! demekteyiz. Burada dikkat ederseniz \u015farta uyan t\u00fcm veriler i\u00e7in \u00e7o\u011ful de\u011fil, tekil bir tarifte bulunmu\u015f bulunmaktay\u0131m. Bunun sebebi, “update” fonksiyonu bu \u015fekilde kullan\u0131ld\u0131\u011f\u0131nda sadece \u015farta uyan ilk veride ilgili i\u015flemi uygulamaktad\u0131r.
\n<\/a><\/p>\n
E\u011fer ki \u015farta uyan t\u00fcm verilerde update i\u015flemini uygulamak istiyorsan\u0131z sorguya “multi : true” de\u011ferini a\u015fa\u011f\u0131daki gibi belirtmeniz gerekmektedir.<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/updateEmployee", (request, response, next) => {\r\n    model.update({ name: "Gen\u00e7ay" }, { surName: "Y\u0131ld\u0131z (Yeni)" }, { multi: true }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\nBu \u015fekilde g\u00fcncelleme i\u015flemi yapt\u0131\u011f\u0131m\u0131z taktirde \u015farta uyan t\u00fcm veriler etkilenecektir.
\n<\/a><\/p>\n
Upsert Anahtar Kelimesi<\/strong>
\nYapaca\u011f\u0131m\u0131z g\u00fcncelleme i\u015flemlerinde e\u011fer ki \u015farta uygun veri varsa ilgili i\u015flemi icra edebiliriz. Ya yoksa! ve b\u00f6yle bir durumda olmayan veriyi kaydetmek istiyorsak! Evet… Bu i\u015flemi kontrollerle sa\u011flayabiliriz lakin Upsert keyword\u00fc tam da bu ihtiyaca istinaden \u00fcretilmi\u015f bir i\u015flevselli\u011fe sahiptir.<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/updateEmployee", (request, response, next) => {\r\n    model.update({ name: "Gen\u00e7ay" }, { surName: "Y\u0131ld\u0131z (Yeni)" }, { upsert: true }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\nBurada; e\u011fer “name” kolunu “Gen\u00e7ay” olan veri varsa<\/u> “surName” kolonunu “Y\u0131ld\u0131z (Yeni)” olarak g\u00fcncelle, yok e\u011fer yoksa<\/u> “name” kolonu “Gen\u00e7ay” “surName” kolonuda “Y\u0131ld\u0131z (Yeni)” olan veriyi ekle demi\u015f bulunmaktay\u0131z.<\/p>\n
ID Bazl\u0131 G\u00fcncelleme(findByIdAndUpdate)<\/strong>
\nId bazl\u0131 g\u00fcncelleme i\u015flemi i\u00e7in;<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/updateByIdEmployee", (request, response, next) => {\r\n    model.findByIdAndUpdate("1", { surName: "Y\u0131ld\u0131z (Yeni)" }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\n\u015feklinde \u00e7al\u0131\u015f\u0131labilir.<\/p>\n
Veri Silme<\/h3>\n\u00dc\u00e7 farkl\u0131 y\u00f6ntemle veri silebiliriz. Bunlar;<\/p>\n
\n\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/deleteById", (request, response, next) => {\r\n    model.findById("1", (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            data.remove(error => console.log("Veri silinirken beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131..."));\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\nmodule.exports = router;\r\n<\/pre>\n\u00d6nce “findById” fonksiyonuyla ilgili veri getirilir, ard\u0131ndan veri \u00fczerinden “remove” metodu ile veritaban\u0131ndan fiziksel olarak iligli veri silinir.\n<\/li>\n
\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/delete", (request, response, next) => {\r\n    model.findOneAndRemove({ userName: "gncy2" }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\n\r\nmodule.exports = router;\r\n<\/pre>\n“findOneAndRemove” fonksiyonu ile \u015farta uyan ilk eleman\u0131 silecektir.\n<\/li>\n
\n\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/delete", (request, response, next) => {\r\n    model.remove({ userName: "gncy2" }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\n\r\nmodule.exports = router;\r\n<\/pre>\n\u015earta uyan t\u00fcm verileri silecektir.\n<\/li>\n<\/ol>\n
Modeldeki Alt Propertylere Eri\u015fmek<\/h3>\nE\u011fer ki elimizdeki model a\u015fa\u011f\u0131daki gibi alt propertylerden olu\u015fuyorsa;<\/p>\n
\r\nconst mongoose = require("mongoose");\r\n\r\nmodule.exports = mongoose.model("Employees", new mongoose.Schem a({\r\n    _id: Number,\r\n    userName: String,\r\n    name: String,\r\n    surName: String,\r\n    age: Number,\r\n    country: {\r\n        city: String,\r\n        county: String,\r\n        adress: {\r\n            postcode: Number\r\n        }\r\n    }\r\n}));\r\n<\/pre>\nbu propertylere eri\u015febilmek i\u00e7in a\u015fa\u011f\u0131daki gibi \u00e7al\u0131\u015fmak gerekmektedir.<\/p>\n
\r\nconst express = require("express");\r\nconst router = express.Router();\r\n\r\nconst model = require("..\/models\/employee");\r\n\r\nrouter.get("\/updateExample", (request, response, next) => {\r\n    model.update({ "country.city": "Ankara" }, { "country.adress.postcode": "06130" }, { upsert: true }, (error, data) => {\r\n        if (error) {\r\n            response.send("Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131...");\r\n        }\r\n        else {\r\n            response.json(data);\r\n        }\r\n    });\r\n});\r\n\r\nmodule.exports = router;\r\n<\/pre>\n\u0130lgililenlerin 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, Bu i\u00e7eri\u011fimizde Node.js ortam\u0131nda MongoDB’ye CRUD i\u015flemlerinin nas\u0131l yap\u0131ld\u0131\u011f\u0131n\u0131 ele alaca\u011f\u0131z. \u0130lk olarak bir adet Node.js projesi in\u015fa ediyoruz ve ard\u0131ndan projeye gerekli paketleri(express, mongoose vs.) entegre ediyoruz. \u0130\u00e7eri\u011fimizde yapaca\u011f\u0131m\u0131z t\u00fcm \u00f6rneklendirmeleri a\u015fa\u011f\u0131daki...<\/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,2538],"tags":[2556,2559,2557,2558,2565,2561,2560,2562,2563,2564],"class_list":["post-9049","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","category-node-js","category-nosql","tag-mongodb-crud","tag-mongodb-find","tag-mongodb-insert","tag-mongodb-select","tag-mongodb-upsert","tag-node-js-crud","tag-node-js-find","tag-node-js-insert","tag-node-js-select","tag-node-js-upsert"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/9049","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=9049"}],"version-history":[{"count":39,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/9049\/revisions"}],"predecessor-version":[{"id":9096,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/9049\/revisions\/9096"}],"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=9049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=9049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=9049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}