{"id":16166,"date":"2024-01-21T15:37:13","date_gmt":"2024-01-21T12:07:13","guid":{"rendered":"https:\/\/rasanegar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/"},"modified":"2024-01-21T15:37:13","modified_gmt":"2024-01-21T12:07:13","slug":"%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87","status":"publish","type":"post","link":"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/","title":{"rendered":"\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Sequelize ORM \u0628\u0627 Node.js \u0648 ExpressSequelize \u06cc\u06a9 ORM \u0645\u062d\u0628\u0648\u0628 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc Node.js \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0648 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u06cc\u06a9 CRUD API \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.  \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u062c \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u0627\u0637\u0646 \u0627\u0633\u062a.  \u0627\u06cc\u0646 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u067e\u0631\u0633\u200c\u0648\u062c\u0648\u0647\u0627\u06cc SQL \u062e\u0627\u0645 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u06a9\u0647 \u0633\u0627\u062e\u062a\u0646 \u0622\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062f\u0634\u0648\u0627\u0631 \u0628\u0627\u0634\u062f\u060c \u0628\u0647 \u062e\u0635\u0648\u0635&#8230;"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0633\u0631\u0641\u0635\u0644\u0647\u0627\u06cc \u0645\u0637\u0644\u0628<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d9%85%d8%b9%d8%b1%d9%81%db%8c\" >\u0645\u0639\u0631\u0641\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#orm_%da%86%db%8c%d8%b3%d8%aa%d8%9f\" >ORM \u0686\u06cc\u0633\u062a\u061f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d8%b9%d8%a7%d9%82%d8%a8%d8%aa_%d8%b3%d8%a7%d8%b2%db%8c\" >\u0639\u0627\u0642\u0628\u062a \u0633\u0627\u0632\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d9%86%d8%b5%d8%a8_sequelize\" >\u0646\u0635\u0628 Sequelize<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%db%8c%da%a9_%d9%85%d8%af%d9%84_%d8%a8%d8%b1%d8%a7%db%8c_%d9%86%d9%82%d8%b4%d9%87_%d8%a8%d8%b1%d8%af%d8%a7%d8%b1%db%8c\" >\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0645\u062f\u0644 \u0628\u0631\u0627\u06cc \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d9%86%da%af%d8%a7%d8%b4%d8%aa_%d9%85%d8%af%d9%84_%d8%a8%d9%87_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87\" >\u0646\u06af\u0627\u0634\u062a \u0645\u062f\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d9%85%d9%88%d8%ac%d9%88%d8%af%db%8c%d8%aa_%d9%87%d8%a7%db%8c_%d8%ae%d9%88%d8%a7%d9%86%d8%af%d9%86%db%8c\" >\u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\u06cc<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d9%87%d9%85%d9%87_%d9%86%d9%87%d8%a7%d8%af%d9%87%d8%a7_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\" >\u0647\u0645\u0647 \u0646\u0647\u0627\u062f\u0647\u0627 \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#entities_where_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\" >Entities WHERE \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#entities_where_and_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\" >Entities WHERE AND \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#entities_or_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\" >Entities OR \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#entities_limit_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\" >Entities LIMIT \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d8%af%d8%b1%d8%ac_%d9%85%d9%88%d8%ac%d9%88%d8%af%db%8c%d8%aa_%d9%87%d8%a7\" >\u062f\u0631\u062c \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d8%a8%d9%87_%d8%b1%d9%88%d8%b2_%d8%b1%d8%b3%d8%a7%d9%86%db%8c_%d9%86%d9%87%d8%a7%d8%af%d9%87%d8%a7\" >\u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0646\u0647\u0627\u062f\u0647\u0627<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d8%ad%d8%b0%d9%81_%d9%86%d9%87%d8%a7%d8%af%d9%87%d8%a7\" >\u062d\u0630\u0641 \u0646\u0647\u0627\u062f\u0647\u0627<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d8%b3%d8%aa%d9%81%d8%a7%d8%af%d9%87-%d8%a7%d8%b2-sequelize-orm-%d8%a8%d8%a7-node-js-%d9%88-expresssequelize-%db%8c%da%a9-orm-%d9%85%d8%ad%d8%a8%d9%88%d8%a8-%d8%a7%d8%b3%d8%aa-%da%a9%d9%87\/#%d9%86%d8%aa%db%8c%d8%ac%d9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 10<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span><p> <br \/>\n<\/p>\n<div class=\"content\"><noscript><\/p>\n<style>.lazyload-placeholder { display: none;  }<\/style>\n<p><\/noscript><\/p>\n<h2 id=\"introduction\"><span class=\"ez-toc-section\" id=\"%d9%85%d8%b9%d8%b1%d9%81%db%8c\"><\/span>\u0645\u0639\u0631\u0641\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/sequelize\/sequelize\/\">\u0639\u0627\u0642\u0628\u062a \u0633\u0627\u0632\u06cc<\/a> \u06cc\u06a9 ORM \u0645\u062d\u0628\u0648\u0628 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc Node.js \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0648 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 CRUD API \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u062c \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u0627\u0637\u0646 \u0627\u0633\u062a.  \u0627\u06cc\u0646 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u067e\u0631\u0633\u200c\u0648\u200c\u062c\u0648\u0647\u0627\u06cc SQL \u062e\u0627\u0645 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u06a9\u0647 \u0633\u0627\u062e\u062a\u0646 \u0622\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062f\u0634\u0648\u0627\u0631 \u0628\u0627\u0634\u062f\u060c \u0628\u0647\u200c\u0648\u06cc\u0698\u0647 \u0628\u0631\u0627\u06cc \u06a9\u0633\u0627\u0646\u06cc \u06a9\u0647 \u062a\u0627\u0632\u0647 \u0628\u0647 SQL \u06cc\u0627 \u0628\u0647 \u0637\u0648\u0631 \u06a9\u0644\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647\u200c\u0627\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c <em>\u0646\u06af\u0627\u0634\u062a\u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0634\u06cc<\/em> (ORM \u0647\u0627) \u0628\u0647 \u0648\u062c\u0648\u062f \u0622\u0645\u062f\u0646\u062f &#8211; \u0637\u0631\u0627\u062d\u06cc \u0634\u062f\u0646\u062f \u062a\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0622\u0633\u0627\u0646 \u062a\u0631 \u06a9\u0646\u0646\u062f.  \u0622\u0646\u0647\u0627 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0634\u06cc\u0627\u0621 (\u0645\u0648\u062c\u0648\u062f\u0627\u062a) \u0631\u0627 \u0627\u0632 \u06a9\u062f \u0645\u0627 \u062f\u0631 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u062a\u0631\u0633\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u0646\u062f\u060c \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0627\u0632 \u0646\u0627\u0645 \u0622\u0646 \u067e\u06cc\u062f\u0627\u0633\u062a.<\/p>\n<p>\u062f\u06cc\u06af\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc SQL \u062e\u0627\u0645 \u0631\u0627 \u0646\u0645\u06cc \u0646\u0648\u06cc\u0633\u06cc\u0645 \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u062c\u0631\u0627 \u0646\u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0628\u0627 \u0627\u0631\u0627\u0626\u0647 \u06cc\u06a9 \u0631\u0648\u0634 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0646\u0648\u06cc\u0633\u06cc \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u06a9\u062f \u062e\u0648\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062f\u0633\u062a\u06a9\u0627\u0631\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0627\u0646\u062f\u06af\u0627\u0631\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u062a\u0645\u0631\u06a9\u0632 \u0628\u06cc\u0634\u062a\u0631\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645. \u0631\u0648\u06cc \u0645\u0646\u0637\u0642 \u06a9\u0633\u0628 \u0648 \u06a9\u0627\u0631 \u0648 \u06a9\u0645\u062a\u0631 \u0631\u0648\u06cc SQL \u0645\u0633\u062a\u0639\u062f \u062e\u0637\u0627<\/p>\n<h2 id=\"whatisanorm\"><span class=\"ez-toc-section\" id=\"orm_%da%86%db%8c%d8%b3%d8%aa%d8%9f\"><\/span>ORM \u0686\u06cc\u0633\u062a\u061f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em>\u0646\u06af\u0627\u0634\u062a \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0634\u06cc<\/em> \u062a\u06a9\u0646\u06cc\u06a9\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0634\u06cc\u0627\u0621 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0631\u0627 \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0646\u06af\u0627\u0634\u062a \u0645\u06cc \u06a9\u0646\u062f.  \u062a\u0648\u0633\u0639\u0647\u200c\u062f\u0647\u0646\u062f\u06af\u0627\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0627 \u0627\u0634\u06cc\u0627 \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f\u060c \u0628\u0647\u200c\u062c\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0645\u062c\u0628\u0648\u0631 \u0628\u0627\u0634\u0646\u062f \u062f\u0631 \u0648\u0627\u0642\u0639 \u0647\u0631 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0646\u0648\u06cc\u0633\u0646\u062f.  \u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u0634\u06cc \u062e\u0648\u0627\u0646\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f\u060c \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u062f\u060c \u06cc\u0627 \u062d\u0630\u0641 \u0645\u06cc \u0634\u0648\u062f\u060c ORM \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062f\u0631 \u0632\u06cc\u0631 \u0647\u0648\u062f \u0645\u06cc \u0633\u0627\u0632\u062f \u0648 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u06cc\u06a9\u06cc \u062f\u06cc\u06af\u0631 \u0627\u0632 \u0645\u0632\u0627\u06cc\u0627\u06cc ORM \u0647\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a: <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.postgresql.org\/\">Postgres<\/a>\u060c <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.mysql.com\/\" class=\"broken_link\">MySQL<\/a>\u060c <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.sqlite.org\/index.html\" class=\"broken_link\">SQLite<\/a>\u0648 \u063a\u06cc\u0631\u0647. \u0627\u06af\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06cc \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0627\u0645 \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f\u060c \u0627\u0646\u062a\u0642\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u06cc\u06af\u0631\u06cc \u062f\u0634\u0648\u0627\u0631 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f \u0632\u06cc\u0631\u0627 \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627 \u0628\u0627\u06cc\u062f \u062f\u0648\u0628\u0627\u0631\u0647 \u0646\u0648\u0634\u062a\u0647 \u0634\u0648\u0646\u062f.<\/p>\n<p>\u0628\u0627 \u06cc\u06a9 ORM\u060c \u062a\u063a\u06cc\u06cc\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0648\u0633\u0637 \u062e\u0648\u062f ORM \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u062a\u0646\u0647\u0627 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u06cc\u0627 \u062f\u0648 \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n<h2 id=\"sequelize\"><span class=\"ez-toc-section\" id=\"%d8%b9%d8%a7%d9%82%d8%a8%d8%aa_%d8%b3%d8%a7%d8%b2%db%8c\"><\/span>\u0639\u0627\u0642\u0628\u062a \u0633\u0627\u0632\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Node ORM \u0647\u0627\u06cc \u0632\u06cc\u0627\u062f\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 Bookshelf.js \u0645\u062d\u0628\u0648\u0628 \u0648 <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/stackshare.io\/typeorm\" class=\"broken_link\">TypeORM<\/a>.<\/p>\n<blockquote>\n<p>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0686\u0631\u0627 \u0648 \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc Sequelize \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u0645\u061f<\/p>\n<\/blockquote>\n<p>\u0627\u0648\u0644\u0627\u064b\u060c \u0628\u0631\u0627\u06cc \u0645\u062f\u062a \u0637\u0648\u0644\u0627\u0646\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0627\u0633\u062a &#8211; 2011. \u0647\u0632\u0627\u0631\u0627\u0646 \u0633\u062a\u0627\u0631\u0647 GitHub \u062f\u0627\u0631\u062f \u0648 \u062a\u0648\u0633\u0637 \u0647\u0632\u0627\u0631\u0627\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0633\u0646 \u0648 \u0645\u062d\u0628\u0648\u0628\u06cc\u062a \u0622\u0646 \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u0633\u062a \u0648 \u0627\u0633\u0646\u0627\u062f \u0632\u06cc\u0627\u062f\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a \u0622\u0646\u0644\u0627\u06cc\u0646 \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0627\u0633\u062a.<\/p>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0628\u0644\u0648\u063a \u0648 \u062b\u0628\u0627\u062a\u060c Sequelize \u062f\u0627\u0631\u0627\u06cc \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0627\u0633\u062a \u06a9\u0647 \u0634\u0627\u0645\u0644 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0627\u0633\u062a: \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u060c \u062f\u0627\u0645\u0646\u0647 \u0647\u0627\u060c \u0631\u0648\u0627\u0628\u0637\u060c \u062a\u0631\u0627\u06a9\u0646\u0634 \u0647\u0627\u060c \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0627\u0645\u060c \u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627\u060c \u062a\u06a9\u0631\u0627\u0631 \u062e\u0648\u0627\u0646\u062f\u0646 \u0648 \u063a\u06cc\u0631\u0647.<\/p>\n<p>\u0646\u06a9\u062a\u0647 \u0642\u0627\u0628\u0644 \u062a\u0648\u062c\u0647 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 Sequelize \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0639\u062f\u0647 \u0627\u0633\u062a \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062a\u0648\u0627\u0628\u0639 \u0646\u0627\u0647\u0645\u0632\u0645\u0627\u0646 \u0648 \u0627\u0633\u062a\u062b\u0646\u0627\u0647\u0627 \u0631\u0627 \u0622\u0633\u0627\u0646\u200c\u062a\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0627\u0632 \u062a\u0645\u0627\u0645\u06cc \u06af\u0648\u06cc\u0634 \u0647\u0627\u06cc \u0645\u062d\u0628\u0648\u0628 SQL \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f: PostgreSQL\u060c MySQL\u060c MariaDB\u060c SQLite \u0648 MSSQL.<\/p>\n<p>\u0627\u0632 \u0633\u0648\u06cc \u062f\u06cc\u06af\u0631\u060c \u0647\u06cc\u0686 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc NoSQL \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646 \u0622\u0646 \u0631\u0627 \u062f\u0631 ORM \u0647\u0627 (\u06cc\u0627 Object) \u062f\u06cc\u062f <em>\u0633\u0646\u062f<\/em> \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u0627\u0646\u060c \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f) \u0645\u0627\u0646\u0646\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/mongoosejs.com\/\">\u0645\u0627\u0646\u06af\u0648\u0633<\/a>.  \u062f\u0631 \u0648\u0627\u0642\u0639\u060c \u062a\u0635\u0645\u06cc\u0645 \u06af\u06cc\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u062f\u0627\u0645 ORM \u0628\u0647 \u0637\u0648\u0631 \u0639\u0645\u062f\u0647 \u0628\u0633\u062a\u06af\u06cc \u062f\u0627\u0631\u062f \u0631\u0648\u06cc \u0627\u0644\u0632\u0627\u0645\u0627\u062a \u067e\u0631\u0648\u0698\u0647 \u0627\u06cc \u06a9\u0647 \u062f\u0631 \u062d\u0627\u0644 \u06a9\u0627\u0631 \u0622\u0646 \u0647\u0633\u062a\u06cc\u062f \u0631\u0648\u06cc.<\/p>\n<h2 id=\"installingsequelize\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%b5%d8%a8_sequelize\"><\/span>\u0646\u0635\u0628 Sequelize<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f<\/strong>: \u0627\u06af\u0631 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0647\u0645\u0631\u0627\u0647 \u0628\u0627 \u06a9\u062f \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0646 \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/StackAbuse\/sequelize-express-notes-app\">\u0627\u06cc\u0646\u062c\u0627 \u0631\u0648\u06cc GitHub<\/a>.<\/p>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Node \u0627\u0633\u06a9\u0644\u062a \u0628\u0633\u0627\u0632\u06cc\u0645 \u0648 Sequelize \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u0645.  \u0627\u0628\u062a\u062f\u0627\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0628\u0631\u0627\u06cc \u067e\u0631\u0648\u0698\u0647 \u062e\u0648\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645\u060c \u0622\u0646 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u0645 \u0648 \u06cc\u06a9 \u067e\u0631\u0648\u0698\u0647 \u0628\u0627 \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> mkdir notes-app<\/span>\n<span class=\"hljs-meta\">$<\/span><span class=\"bash\"> <span class=\"hljs-built_in\">cd<\/span> notes-app<\/span>\n<span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npm init -y<\/span>\n<\/code><\/pre>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0641\u0627\u06cc\u0644 \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u0648 \u0631\u0648\u062a\u0631 \u0627\u0635\u0644\u06cc Express \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0635\u062f\u0627 \u06a9\u0646\u06cc\u0645 <code>index.js<\/code> \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u0628\u0627 \u0646\u0627\u0645 \u0641\u0627\u06cc\u0644 \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u0632 <code>npm init<\/code>:<\/p>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0622\u0633\u0627\u0646 \u06cc\u06a9 \u0648\u0628 \u0633\u0631\u0648\u0631\u060c Express \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npm install --save express<\/span>\n<\/code><\/pre>\n<p>\u0648 \u0628\u0627 \u0646\u0635\u0628 \u0622\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0633\u0631\u0648\u0631 \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> express = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'express'<\/span>);\n<span class=\"hljs-keyword\">const<\/span> app = express();\n<span class=\"hljs-keyword\">const<\/span> port = <span class=\"hljs-number\">3000<\/span>;\n\napp.get(<span class=\"hljs-string\">'\/'<\/span>, <span class=\"hljs-function\">(<span class=\"hljs-params\">req, res<\/span>) =&gt;<\/span> res.send(<span class=\"hljs-string\">'Notes App'<\/span>));\n\napp.listen(port, <span class=\"hljs-function\">() =&gt;<\/span> <span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">`notes-app listening \u0631\u0648\u06cc port <span class=\"hljs-subst\">${port}<\/span>!`<\/span>));\n<\/code><\/pre>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u062f\u0627\u0645\u0647 \u062f\u0647\u06cc\u0645 \u0648 Sequelize \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0646\u062a\u062e\u0627\u0628\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0622\u0646 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u0645 <code>npm<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npm install --save sequelize<\/span>\n<span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npm install --save sqlite3<\/span>\n<\/code><\/pre>\n<p>\u0641\u0631\u0642\u06cc \u0646\u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u06a9\u062f\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 Sequelize \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647-\u0627\u06af\u0646\u0648\u0633\u062a\u06cc\u06a9 \u0627\u0633\u062a.  \u0631\u0648\u0634\u06cc \u06a9\u0647 \u0645\u0627 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645\u060c \u0628\u062f\u0648\u0646 \u062a\u0648\u062c\u0647 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0635\u0644\u06cc\u060c \u06cc\u06a9\u0633\u0627\u0646 \u0627\u0633\u062a.  \u06a9\u0627\u0631 \u0628\u0627 SQLite3 \u0628\u0631\u0627\u06cc \u062a\u0648\u0633\u0639\u0647 \u0645\u062d\u0644\u06cc \u0622\u0633\u0627\u0646 \u0627\u0633\u062a \u0648 \u06cc\u06a9 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u062d\u0628\u0648\u0628 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0627\u0647\u062f\u0627\u0641 \u0627\u0633\u062a.<\/p>\n<p>\u062d\u0627\u0644\u0627 \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u062f \u0628\u0647 \u0622\u0646 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 <code>index.js<\/code> \u0641\u0627\u06cc\u0644 \u0628\u0631\u0627\u06cc \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0628\u0631\u0631\u0633\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Sequelize.  \u0628\u0633\u062a\u0647 \u0628\u0647 \u0631\u0648\u06cc \u0627\u0632 \u06a9\u062f\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u06af\u0648\u06cc\u0634 \u062f\u06cc\u06af\u0631\u06cc \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> Sequelize = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'sequelize'<\/span>);\n<span class=\"hljs-keyword\">const<\/span> sequelize = <span class=\"hljs-keyword\">new<\/span> Sequelize({\n  <span class=\"hljs-comment\">\/\/ The `host` parameter is required for other databases<\/span>\n  <span class=\"hljs-comment\">\/\/ host: 'localhost'<\/span>\n  <span class=\"hljs-attr\">dialect<\/span>: <span class=\"hljs-string\">'sqlite'<\/span>,\n  <span class=\"hljs-attr\">storage<\/span>: <span class=\"hljs-string\">'.\/database.sqlite'<\/span>\n});\n<\/code><\/pre>\n<p>\u067e\u0633 \u0627\u0632 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 Sequelize\u060c \u0622\u0646 \u0631\u0627 \u0628\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f\u060c \u0645\u0627\u0646\u0646\u062f <code>pool<\/code>\u060c \u0627\u06af\u0631\u0686\u0647 \u0622\u0646\u0686\u0647 \u0645\u0627 \u062f\u0627\u0631\u06cc\u0645 \u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639 \u06a9\u0627\u0641\u06cc \u0627\u0633\u062a.  \u0627\u06cc\u0646 <code>dialect<\/code> \u0628\u0633\u062a\u06af\u06cc \u062f\u0627\u0631\u062f \u0631\u0648\u06cc \u0627\u0632 \u06a9\u062f\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f \u0648 <code>storage<\/code> \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u0628\u0647 \u0641\u0627\u06cc\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0634\u0627\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 <code>database.sqlite<\/code> \u0641\u0627\u06cc\u0644 \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0631 root \u0633\u0637\u062d \u067e\u0631\u0648\u0698\u0647 \u0645\u0627<\/p>\n<p><strong>\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f:<\/strong> \u0627\u0631\u0632\u0634 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f\u0646 \u0631\u0627 \u062f\u0627\u0631\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/sequelize.org\/v5\/manual\/getting-started.html\">\u062f\u0646\u0628\u0627\u0644\u0647 \u062f\u0627\u0631 \u06a9\u0631\u062f\u0646 Docs<\/a> \u0628\u0631\u0627\u06cc \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0631\u0627\u06cc \u0647\u0631 \u06a9\u062f\u0627\u0645.<\/p>\n<p>\u0627\u06af\u0631 \u0627\u0632 MySQL\u060c Postgres\u060c MariaDB \u06cc\u0627 MSSQL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u0628\u0647 \u062c\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0647\u0631 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0631\u0627 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u0631\u0633\u0627\u0644 \u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f URI \u0627\u062a\u0635\u0627\u0644 \u0631\u0627 \u0646\u06cc\u0632 \u0627\u0631\u0633\u0627\u0644 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> sequelize = <span class=\"hljs-keyword\">new<\/span> Sequelize(<span class=\"hljs-string\">'postgres:\/\/user:(email\u00a0protected):5432\/dbname'<\/span>);\n<\/code><\/pre>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0627\u062a\u0635\u0627\u0644 \u0631\u0627 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0622\u0646 \u062a\u0633\u062a \u06a9\u0646\u06cc\u0645 <code>.authenticate()<\/code> \u0631\u0648\u0634.  \u0632\u06cc\u0631 \u06a9\u0627\u067e\u0648\u062a\u060c \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f <code>SELECT<\/code> \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f \u0648 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u067e\u0627\u0633\u062e \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<pre><code class=\"hljs\">sequelize\n  .authenticate()\n  .then(<span class=\"hljs-function\">() =&gt;<\/span> {\n    <span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">'Connection has been established successfully.'<\/span>);\n  })\n  .catch(<span class=\"hljs-function\"><span class=\"hljs-params\">err<\/span> =&gt;<\/span> {\n    <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'Unable to connect to the database:'<\/span>, err);\n  });\n<\/code><\/pre>\n<p>\u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647\u060c \u0628\u0627 \u0627\u0633\u062a\u0642\u0628\u0627\u0644 \u0645\u0648\u0627\u062c\u0647 \u0645\u06cc \u0634\u0648\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> node index.js<\/span>\nnotes-app listening \u0631\u0648\u06cc port 3000!\nExecuting (default): SELECT 1+1 AS result\nConnection has been established successfully.\n<\/code><\/pre>\n<h2 id=\"creatingamodelformapping\"><span class=\"ez-toc-section\" id=\"%d8%a7%db%8c%d8%ac%d8%a7%d8%af_%db%8c%da%a9_%d9%85%d8%af%d9%84_%d8%a8%d8%b1%d8%a7%db%8c_%d9%86%d9%82%d8%b4%d9%87_%d8%a8%d8%b1%d8%af%d8%a7%d8%b1%db%8c\"><\/span>\u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u0645\u062f\u0644 \u0628\u0631\u0627\u06cc \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u0645 \u06cc\u06a9 Notes API \u0628\u0633\u0627\u0632\u06cc\u0645\u060c \u0628\u0627\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0628\u0627\u06cc\u062f a \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u0645 <code>Note<\/code> \u0645\u062f\u0644\u060c \u06a9\u0647 \u0645\u0627 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u06cc\u06a9 \u062b\u0627\u0628\u062a \u0627\u062e\u062a\u0635\u0627\u0635 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u062a\u0627 \u0628\u062a\u0648\u0627\u0646 \u0627\u0632 \u0622\u0646 \u062f\u0631 \u0633\u0631\u0627\u0633\u0631 API \u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.  \u062f\u0631 <code>define<\/code> \u062a\u0627\u0628\u0639 \u0646\u0627\u0645 \u062c\u062f\u0648\u0644 \u0648 \u0641\u06cc\u0644\u062f\u0647\u0627 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u06cc\u0645.  \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u06cc\u06a9 \u0641\u06cc\u0644\u062f \u0645\u062a\u0646\u06cc \u0628\u0631\u0627\u06cc \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0648 \u06cc\u06a9 \u0631\u0634\u062a\u0647 \u0628\u0631\u0627\u06cc \u0628\u0631\u0686\u0633\u0628:<\/p>\n<p>\u0645\u0627\u0646\u0646\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc\u060c \u0642\u0628\u0644 \u0627\u0632 \u0633\u0627\u062e\u062a\u0646 \u06cc\u06a9 API\u060c \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u062c\u062f\u0627\u0648\u0644 \u06a9\u0627\u0641\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0627\u0632 \u0627\u06cc\u062c\u0627\u062f \u0622\u0646 \u0628\u0627 \u062f\u0633\u062a \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL \u0627\u062c\u062a\u0646\u0627\u0628 \u06a9\u0646\u06cc\u0645\u060c a \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>Model<\/code> \u06a9\u0644\u0627\u0633 \u0648 \u0633\u067e\u0633 Sequelize \u0622\u0646 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u062a\u0631\u0633\u06cc\u0645 \u06a9\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u06af\u0633\u062a\u0631\u0634 \u062f\u0627\u062f\u0646 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f <code>Sequelize.Model<\/code> \u06a9\u0644\u0627\u0633 \u0648 \u0627\u062c\u0631\u0627\u06cc <code>.init()<\/code> \u062a\u0627\u0628\u0639\u060c \u0639\u0628\u0648\u0631 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u060c \u06cc\u0627 \u0628\u0627 \u062a\u0639\u0631\u06cc\u0641 a <code>const<\/code> \u0648 \u0628\u0647 \u0622\u0646 \u0645\u0642\u062f\u0627\u0631 \u0628\u0627\u0632\u06af\u0634\u062a\u06cc the \u0631\u0627 \u0646\u0633\u0628\u062a \u0645\u06cc \u062f\u0647\u06cc\u0645 <code>.define()<\/code> \u0631\u0648\u0634 \u0627\u0632 Sequelize.<\/p>\n<p>\u062f\u0648\u0645\u06cc \u0645\u062e\u062a\u0635\u0631\u062a\u0631 \u0627\u0633\u062a\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u0627 \u0628\u0627 \u0622\u0646 \u06cc\u06a9\u06cc \u0645\u06cc\u200c\u0631\u0648\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> Note = sequelize.define(<span class=\"hljs-string\">'notes'<\/span>, { <span class=\"hljs-attr\">note<\/span>: Sequelize.TEXT, <span class=\"hljs-attr\">tag<\/span>: Sequelize.STRING });\n<\/code><\/pre>\n<h3 id=\"mappingthemodeltothedatabase\"><span class=\"ez-toc-section\" id=\"%d9%86%da%af%d8%a7%d8%b4%d8%aa_%d9%85%d8%af%d9%84_%d8%a8%d9%87_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87\"><\/span>\u0646\u06af\u0627\u0634\u062a \u0645\u062f\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u0645\u0627 \u06cc\u06a9 <code>Note<\/code> \u0645\u062f\u0644\u06cc \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 <code>notes<\/code> \u062c\u062f\u0648\u0644 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647  \u062f\u0631 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u062a\u0648\u0644\u06cc\u062f\u060c \u0645\u0627 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/sequelize.org\/v5\/manual\/migrations.html\">\u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627<\/a> \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u06a9\u0646\u062a\u0631\u0644 \u0645\u0646\u0628\u0639 \u0631\u062f\u06cc\u0627\u0628\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u0627\u06af\u0631\u0686\u0647\u060c \u0628\u0631\u0627\u06cc \u0645\u062e\u062a\u0635\u0631 \u0646\u06af\u0647 \u062f\u0627\u0634\u062a\u0646 \u0645\u0648\u0627\u0631\u062f\u060c \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f <code>.sync()<\/code> \u0631\u0648\u0634.  \u0686\u0647 <code>.sync()<\/code> \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f \u0633\u0627\u062f\u0647 \u0627\u0633\u062a &#8211; \u0647\u0645\u0647 \u0645\u062f\u0644 \u0647\u0627\u06cc \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0631\u0627 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0645\u06af\u0627\u0645 \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<pre><code class=\"hljs\">sequelize.sync({ <span class=\"hljs-attr\">force<\/span>: <span class=\"hljs-literal\">true<\/span> })\n  .then(<span class=\"hljs-function\">() =&gt;<\/span> {\n    <span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">`Database &amp; tables created!`<\/span>);\n  });\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627\u060c \u0645\u0627 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u0645 <code>force<\/code> \u067e\u0631\u0686\u0645 \u06af\u0630\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0631\u0648\u06cc \u0622\u0646 \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f <code>true<\/code>.  \u0627\u06af\u0631 \u062c\u062f\u0648\u0644\u06cc \u0627\u0632 \u0642\u0628\u0644 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u0631\u0648\u0634 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f <code>DROP<\/code> \u0622\u0646 \u0648 <code>CREATE<\/code> \u06cc\u06a9 \u062f\u0627\u0646\u0647 \u062c\u062f\u06cc\u062f.  \u0627\u06af\u0631 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u0641\u0642\u0637 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0686\u0646\u062f \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0646\u0645\u0648\u0646\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0633\u067e\u0633 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627\u0642\u06cc \u0645\u06cc\u200c\u0645\u0627\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\">sequelize.sync({ <span class=\"hljs-attr\">force<\/span>: <span class=\"hljs-literal\">true<\/span> })\n  .then(<span class=\"hljs-function\">() =&gt;<\/span> {\n    <span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">`Database &amp; tables created!`<\/span>);\n\n    Note.bulkCreate((\n      { <span class=\"hljs-attr\">note<\/span>: <span class=\"hljs-string\">'pick up some bread after work'<\/span>, <span class=\"hljs-attr\">tag<\/span>: <span class=\"hljs-string\">'shopping'<\/span> },\n      { <span class=\"hljs-attr\">note<\/span>: <span class=\"hljs-string\">'remember to write up meeting notes'<\/span>, <span class=\"hljs-attr\">tag<\/span>: <span class=\"hljs-string\">'work'<\/span> },\n      { <span class=\"hljs-attr\">note<\/span>: <span class=\"hljs-string\">'learn how to use node orm'<\/span>, <span class=\"hljs-attr\">tag<\/span>: <span class=\"hljs-string\">'work'<\/span> }\n    )).then(<span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\"><\/span>) <\/span>{\n      <span class=\"hljs-keyword\">return<\/span> Note.findAll();\n    }).then(<span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">notes<\/span>) <\/span>{\n      <span class=\"hljs-built_in\">console<\/span>.log(notes);\n    });\n  });\n<\/code><\/pre>\n<p>\u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0633\u0631\u0648\u0631\u060c \u06cc\u0627\u062f\u062f\u0627\u0634\u062a\u200c\u0647\u0627\u06cc \u0645\u0627 \u062f\u0631 \u0622\u0646 \u0686\u0627\u067e \u0645\u06cc\u200c\u0634\u0648\u0646\u062f console\u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a SQL \u0627\u0646\u062c\u0627\u0645 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 Sequelize.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u0645 \u062a\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0648\u0627\u0642\u0639\u0627\u064b \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0646\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> sqlite3 database.sqlite<\/span>\n<span class=\"hljs-meta\">sqlite&gt;<\/span><span class=\"bash\"> select * from notes;<\/span>\n1|pick up some bread after work|shopping|2020-02-21 18:24:19.402 +00:00|2020-02-21 18:24:19.402 +00:00\n2|remember to write up meeting notes|work|2020-02-21 18:24:19.402 +00:00|2020-02-21 18:24:19.402 +00:00\n3|learn how to use node orm|work|2020-02-21 18:24:19.402 +00:00|2020-02-21 18:24:19.402 +00:00\n<span class=\"hljs-meta\">sqlite&gt;<\/span><span class=\"bash\"> .<span class=\"hljs-built_in\">exit<\/span><\/span>\n<\/code><\/pre>\n<p>\u0628\u0627 \u0648\u062c\u0648\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644(\u0647\u0627\u06cc) \u0645\u0627\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062c\u0644\u0648 \u0628\u0631\u0648\u06cc\u0645 \u0648 \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u0635\u0644\u06cc CRUD \u0631\u0627 \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<h2 id=\"readingentities\"><span class=\"ez-toc-section\" id=\"%d9%85%d9%88%d8%ac%d9%88%d8%af%db%8c%d8%aa_%d9%87%d8%a7%db%8c_%d8%ae%d9%88%d8%a7%d9%86%d8%af%d9%86%db%8c\"><\/span>\u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u062f\u0644 \u0645\u0627\u060c <code>Note<\/code>\u060c \u0627\u06a9\u0646\u0648\u0646 \u0645\u062a\u062f\u0647\u0627\u06cc \u062f\u0627\u062e\u0644\u06cc \u062f\u0627\u0631\u062f \u06a9\u0647 \u0628\u0647 \u0645\u0627 \u062f\u0631 \u0627\u0646\u062c\u0627\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a \u06a9\u0645\u06a9 \u0645\u06cc \u06a9\u0646\u062f \u0631\u0648\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u0627\u0646\u062f\u06af\u0627\u0631 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<\/p>\n<h3 id=\"readallentities\"><span class=\"ez-toc-section\" id=\"%d9%87%d9%85%d9%87_%d9%86%d9%87%d8%a7%d8%af%d9%87%d8%a7_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\"><\/span>\u0647\u0645\u0647 \u0646\u0647\u0627\u062f\u0647\u0627 \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u062a\u0645\u0627\u0645 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0622\u0646 \u06a9\u0644\u0627\u0633 \u0631\u0627 \u06a9\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0628\u0627\u0631\u062a \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0628\u062e\u0648\u0627\u0646\u06cc\u0645 <code>.findAll()<\/code> \u0631\u0648\u0634.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0633\u0627\u062f\u0647 \u0628\u0633\u0627\u0632\u06cc\u0645 \u06a9\u0647 \u0628\u0647 \u0647\u0645\u0647 \u0645\u0648\u062c\u0648\u062f\u06cc\u062a\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u062f\u0627\u0631 \u062e\u062f\u0645\u0627\u062a \u0645\u06cc\u200c\u062f\u0647\u062f:<\/p>\n<pre><code class=\"hljs\">app.get(<span class=\"hljs-string\">'\/notes'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findAll().then(<span class=\"hljs-function\"><span class=\"hljs-params\">notes<\/span> =&gt;<\/span> res.json(notes));\n});\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 <code>.findAll()<\/code> \u0645\u062a\u062f \u0622\u0631\u0627\u06cc\u0647\u200c\u0627\u06cc \u0627\u0632 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a\u200c\u0647\u0627 \u0631\u0627 \u0628\u0631\u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0622\u0646\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u0631\u0646\u062f\u0631 \u06a9\u0631\u062f\u0646 \u0628\u062f\u0646\u0647 \u067e\u0627\u0633\u062e \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>res.json<\/code>.<\/p>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u0645 <code>curl<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> curl http:\/\/localhost:3000\/notes<\/span>\n({\"id\":1,\"note\":\"pick up some bread after work\",\"tag\":\"shopping\",\"createdAt\":\"2020-02-27T17:02:10.881Z\",\"updatedAt\":\"2020-02-27T17:02:10.881Z\"},{\"id\":2,\"note\":\"remember to write up meeting notes\",\"tag\":\"work\",\"createdAt\":\"2020-02-27T17:02:10.881Z\",\"updatedAt\":\"2020-02-27T17:02:10.881Z\"},{\"id\":3,\"note\":\"learn how to use node orm\",\"tag\":\"work\",\"createdAt\":\"2020-02-27T17:02:10.881Z\",\"updatedAt\":\"2020-02-27T17:02:10.881Z\"})\n<\/code><\/pre>\n<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u0628\u06cc\u0646\u06cc\u062f\u060c \u062a\u0645\u0627\u0645 \u0648\u0631\u0648\u062f\u06cc \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0627 \u0628\u0647 \u0645\u0627 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u062f\u060c \u0627\u0645\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a JSON.<\/p>\n<p>\u0627\u06af\u0631\u0686\u0647\u060c \u0627\u06af\u0631 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f\u0647\u0627\u06cc \u0628\u06cc\u0634\u062a\u0631 \u0647\u0633\u062a\u06cc\u0645\u060c \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0627\u0646\u0646\u062f <code>SELECT<\/code>\u060c <code>WHERE<\/code>\u060c <code>AND<\/code>\u060c <code>OR<\/code>\u060c \u0648 <code>LIMIT<\/code> \u062a\u0648\u0633\u0637 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0644\u06cc\u0633\u062a \u06a9\u0627\u0645\u0644\u06cc \u0627\u0632 \u0631\u0648\u0634 \u0647\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u06cc\u0627\u0641\u062a \u0631\u0648\u06cc \u0631\u0627 <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/sequelize.org\/v5\/manual\/querying.html\">\u062f\u0646\u0628\u0627\u0644\u0647 \u062f\u0627\u0631 \u06a9\u0631\u062f\u0646 Docs<\/a> page.<\/p>\n<h3 id=\"readentitieswhere\"><span class=\"ez-toc-section\" id=\"entities_where_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\"><\/span>Entities WHERE \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0627 \u062f\u0631 \u0646\u0638\u0631 \u06af\u0631\u0641\u062a\u0646 \u0627\u06cc\u0646 \u0645\u0648\u0636\u0648\u0639\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u06cc\u06a9 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0648\u0627\u062d\u062f \u0648 \u062e\u0627\u0635 \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<pre><code class=\"hljs\">app.get(<span class=\"hljs-string\">'\/notes\/:id'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findAll({ <span class=\"hljs-attr\">where<\/span>: { <span class=\"hljs-attr\">id<\/span>: req.params.id } }).then(<span class=\"hljs-function\"><span class=\"hljs-params\">notes<\/span> =&gt;<\/span> res.json(notes));\n});\n<\/code><\/pre>\n<p>\u0646\u0642\u0627\u0637 \u067e\u0627\u06cc\u0627\u0646\u06cc \u06cc\u06a9 \u0631\u0627 \u0645\u06cc \u067e\u0630\u06cc\u0631\u062f <code>id<\/code> \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u060c \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0627\u0632 \u0637\u0631\u06cc\u0642 <code>WHERE<\/code> \u0639\u0628\u0627\u0631\u062a.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0633\u062a \u06a9\u0646\u06cc\u0645 <code>curl<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> curl http:\/\/localhost:3000\/notes\/2<\/span>\n({\"id\":2,\"note\":\"remember to write up meeting notes\",\"tag\":\"work\",\"createdAt\":\"2020-02-27T17:03:17.592Z\",\"updatedAt\":\"2020-02-27T17:03:17.592Z\"})\n<\/code><\/pre>\n<p><strong>\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f<\/strong>: \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u0645\u0633\u06cc\u0631 \u0627\u0632 \u06cc\u06a9 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 wildcard \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f\u060c <code>:id<\/code>\u060c \u0645\u0637\u0627\u0628\u0642\u062a \u062e\u0648\u0627\u0647\u062f \u062f\u0627\u0634\u062a <em>\u0647\u0631<\/em> \u0631\u0634\u062a\u0647 \u0627\u06cc \u06a9\u0647 \u0628\u0639\u062f \u0627\u0632 \u0622\u0646 \u0645\u06cc \u0622\u06cc\u062f <code>\/notes\/<\/code>.  \u0628\u0647 \u0647\u0645\u06cc\u0646 \u062f\u0644\u06cc\u0644\u060c \u0627\u06cc\u0646 \u0645\u0633\u06cc\u0631 \u0628\u0627\u06cc\u062f \u062f\u0631 <em>\u067e\u0627\u06cc\u0627\u0646<\/em> \u0641\u0627\u06cc\u0644 index.js \u0634\u0645\u0627.  \u0627\u06cc\u0646 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0645\u0633\u06cc\u0631\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u060c \u0645\u0627\u0646\u0646\u062f <code>\/notes\/search<\/code>\u060c \u0628\u0631\u0627\u06cc \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u06cc\u06a9 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0642\u0628\u0644 \u0627\u0632 <code>\/notes\/:id<\/code> \u0622\u0646 \u0631\u0627 \u0628\u0631\u0645\u06cc \u062f\u0627\u0631\u062f.  \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a <code>search<\/code> \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc \u062f\u0631 \u0645\u0633\u06cc\u0631 URL \u0645\u0627\u0646\u0646\u062f \u06cc\u06a9 \u0634\u0646\u0627\u0633\u0647 \u0631\u0641\u062a\u0627\u0631 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<h3 id=\"readentitieswhereand\"><span class=\"ez-toc-section\" id=\"entities_where_and_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\"><\/span>Entities WHERE AND \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0627\u0635 \u062a\u0631\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0647\u0631 \u062f\u0648 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 <code>WHERE<\/code> \u0648 <code>AND<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647:<\/p>\n<pre><code class=\"hljs\">app.get(<span class=\"hljs-string\">'\/notes\/search'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findAll({ <span class=\"hljs-attr\">where<\/span>: { <span class=\"hljs-attr\">note<\/span>: req.query.note, <span class=\"hljs-attr\">tag<\/span>: req.query.tag } }).then(<span class=\"hljs-function\"><span class=\"hljs-params\">notes<\/span> =&gt;<\/span> res.json(notes));\n});\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627\u060c \u0645\u0627 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627\u06cc\u06cc \u0647\u0633\u062a\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u0647\u0631 \u062f\u0648 \u0645\u0648\u0631\u062f \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f <code>note<\/code> \u0648 <code>tag<\/code> \u062a\u0648\u0633\u0637 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 \u0645\u0634\u062e\u0635 \u0634\u062f\u0647 \u0627\u0633\u062a.  \u062f\u0648\u0628\u0627\u0631\u0647\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0633\u062a \u06a9\u0646\u06cc\u0645 <code>curl<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> curl <span class=\"hljs-string\">\"http:\/\/localhost:3000\/notes\/search\u061fnote=pick%20up%20some%20bread%20after%20work&amp;tag=shopping\"<\/span><\/span>\n({\"id\":1,\"note\":\"pick up some bread after work\",\"tag\":\"shopping\",\"createdAt\":\"2020-02-27T17:09:53.964Z\",\"updatedAt\":\"2020-02-27T17:09:53.964Z\"})\n<\/code><\/pre>\n<h3 id=\"readentitiesor\"><span class=\"ez-toc-section\" id=\"entities_or_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\"><\/span>Entities OR \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06af\u0631 \u0633\u0639\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0645\u06cc \u0645\u0628\u0647\u0645 \u062a\u0631 \u0628\u0627\u0634\u06cc\u0645\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>OR<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0648 \u062c\u0633\u062a\u062c\u0648\u06cc \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627\u06cc\u06cc \u06a9\u0647 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0631\u0646\u062f <em>\u0647\u0631<\/em> \u0627\u0632 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0634\u062f\u0647  \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0627\u062f\u0646 <code>\/notes\/search<\/code> \u0645\u0633\u06cc\u0631 \u0628\u0647:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> Op = Sequelize.Op;\n\napp.get(<span class=\"hljs-string\">'\/notes\/search'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findAll({\n    <span class=\"hljs-attr\">where<\/span>: {\n      <span class=\"hljs-attr\">tag<\/span>: {\n        (Op.or): ().concat(req.query.tag)\n      }\n    }\n  }).then(<span class=\"hljs-function\"><span class=\"hljs-params\">notes<\/span> =&gt;<\/span> res.json(notes));\n});\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>Sequelize.Op<\/code> \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u06cc\u06a9 <code>OR<\/code> \u067e\u0631\u0633 \u0648 \u062c\u0648.  Sequelize \u0686\u0646\u062f\u06cc\u0646 \u0639\u0645\u0644\u06af\u0631 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0627\u0632 \u062c\u0645\u0644\u0647 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f <code>Op.or<\/code>\u060c <code>Op.and<\/code>\u060c <code>Op.eq<\/code>\u060c <code>Op.ne<\/code>\u060c <code>Op.is<\/code>\u060c <code>Op.not<\/code>\u0648 \u063a\u06cc\u0631\u0647. \u0627\u06cc\u0646\u0647\u0627 \u0639\u0645\u062f\u062a\u0627\u064b \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u06cc\u0686\u06cc\u062f\u0647 \u062a\u0631\u060c \u0645\u0627\u0646\u0646\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0627 \u06cc\u06a9 \u0631\u0634\u062a\u0647 regex \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>req.query.tag<\/code> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0627\u0633\u062a\u062f\u0644\u0627\u0644 \u0628\u0647 <code>.findAll()<\/code>.  Sequelize \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u0631\u0627 \u0627\u0646\u062a\u0638\u0627\u0631 \u062f\u0627\u0631\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0645\u0627 \u0631\u0627 \u0645\u062c\u0628\u0648\u0631 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>tag<\/code> \u0622\u0631\u0627\u06cc\u0647 \u0627\u06cc \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>().concat()<\/code>.  \u062f\u0631 \u0622\u0632\u0645\u0648\u0646 \u0632\u06cc\u0631\u060c \u0686\u0646\u062f\u06cc\u0646 \u0622\u0631\u06af\u0648\u0645\u0627\u0646 \u0631\u0627 \u062f\u0631 URL \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u062e\u0648\u062f \u0627\u0631\u0633\u0627\u0644 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> curl <span class=\"hljs-string\">\"http:\/\/localhost:3000\/notes\/search\u061ftag=shopping&amp;tag=work\"<\/span><\/span>\n({\"id\":1,\"note\":\"pick up some bread after work\",\"tag\":\"shopping\",\"createdAt\":\"2020-02-27T17:11:27.518Z\",\"updatedAt\":\"2020-02-27T17:11:27.518Z\"},{\"id\":2,\"note\":\"remember to write up meeting notes\",\"tag\":\"work\",\"createdAt\":\"2020-02-27T17:11:27.518Z\",\"updatedAt\":\"2020-02-27T17:11:27.518Z\"},{\"id\":3,\"note\":\"learn how to use node orm\",\"tag\":\"work\",\"createdAt\":\"2020-02-27T17:11:27.518Z\",\"updatedAt\":\"2020-02-27T17:11:27.518Z\"})\n<\/code><\/pre>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u06cc\u06a9 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0686\u0646\u062f\u06cc\u0646 \u0628\u0627\u0631 \u0645\u0627\u0646\u0646\u062f \u0627\u06cc\u0646 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0622\u0631\u0627\u06cc\u0647 \u062f\u0631 \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f <code>req.query<\/code> \u0647\u062f\u0641 &#8211; \u0634\u06cc.  \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062f\u0631 \u0645\u062b\u0627\u0644 \u0628\u0627\u0644\u0627\u060c <code>req.query.tag<\/code> \u0627\u0633\u062a <code>('shopping', 'work')<\/code>.<\/p>\n<h3 id=\"readentitieslimit\"><span class=\"ez-toc-section\" id=\"entities_limit_%d8%b1%d8%a7_%d8%a8%d8%ae%d9%88%d8%a7%d9%86%db%8c%d8%af\"><\/span>Entities LIMIT \u0631\u0627 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0622\u062e\u0631\u06cc\u0646 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0628\u0647 \u0622\u0646 \u062e\u0648\u0627\u0647\u06cc\u0645 \u067e\u0631\u062f\u0627\u062e\u062a \u0627\u06cc\u0646 \u0627\u0633\u062a <code>LIMIT<\/code>.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u06af\u0648\u06cc\u06cc\u0645 \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0633\u062a\u06cc\u0645 \u06a9\u0648\u0626\u0631\u06cc \u0642\u0628\u0644\u06cc \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645 \u062a\u0627 \u062d\u062f\u0627\u06a9\u062b\u0631 \u062f\u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u06cc\u0645.  \u0645\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0628\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 <code>limit<\/code> \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0648 \u062a\u062e\u0635\u06cc\u0635 \u06cc\u06a9 \u0639\u062f\u062f \u0635\u062d\u06cc\u062d \u0645\u062b\u0628\u062a \u0628\u0647 \u0622\u0646:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> Op = Sequelize.Op;\n\napp.get(<span class=\"hljs-string\">'\/notes\/search'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findAll({\n    <span class=\"hljs-attr\">limit<\/span>: <span class=\"hljs-number\">2<\/span>,\n    <span class=\"hljs-attr\">where<\/span>: {\n      <span class=\"hljs-attr\">tag<\/span>: {\n        (Op.or): ().concat(req.query.tag)\n      }\n    }\n  }).then(<span class=\"hljs-function\"><span class=\"hljs-params\">notes<\/span> =&gt;<\/span> res.json(notes));\n});\n<\/code><\/pre>\n<p>\u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0644\u06cc\u0633\u062a \u06a9\u0627\u0645\u0644\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u062f\u0631 \u0622\u062f\u0631\u0633 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/sequelize.org\/v5\/manual\/querying.html\">\u0627\u0633\u0646\u0627\u062f \u0631\u0627 \u062f\u0646\u0628\u0627\u0644\u0647 \u062f\u0627\u0631 \u06a9\u0646\u06cc\u062f<\/a>.<\/p>\n<h2 id=\"insertingentities\"><span class=\"ez-toc-section\" id=\"%d8%af%d8%b1%d8%ac_%d9%85%d9%88%d8%ac%d9%88%d8%af%db%8c%d8%aa_%d9%87%d8%a7\"><\/span>\u062f\u0631\u062c \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0647\u0627<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631\u062c \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0647\u0627 \u0628\u0633\u06cc\u0627\u0631 \u0633\u0627\u062f\u0647 \u062a\u0631 \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u0648\u0627\u0642\u0639\u0627\u064b \u062f\u0648 \u0631\u0627\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u0639\u0645\u0644\u06cc\u0627\u062a \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f.<\/p>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> bodyParser = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'body-parser'<\/span>);\napp.use(bodyParser.json());\n\napp.post(<span class=\"hljs-string\">'\/notes'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.create({ <span class=\"hljs-attr\">note<\/span>: req.body.note, <span class=\"hljs-attr\">tag<\/span>: req.body.tag }).then(<span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">note<\/span>) <\/span>{\n    res.json(note);\n  });\n});\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 <code>body-parser<\/code> \u0645\u0627\u0698\u0648\u0644 \u0628\u0631\u0627\u06cc \u067e\u0630\u06cc\u0631\u0634 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc JSON \u062a\u0648\u0633\u0637 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0627\u0633\u062a.  \u0634\u0645\u0627 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u0646\u0635\u0628 \u0635\u0631\u06cc\u062d \u0646\u062f\u0627\u0631\u06cc\u062f <code>body-parser<\/code> \u0628\u0633\u062a\u0647 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0627\u06cc\u0646\u06a9\u0647 \u0642\u0628\u0644\u0627\u064b \u0628\u0627 Express \u0647\u0645\u0631\u0627\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n<p>\u062f\u0631 \u062f\u0627\u062e\u0644 \u0645\u0633\u06cc\u0631\u06cc \u06a9\u0647 \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>.create()<\/code> \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u062f\u0631\u062c \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\u060c \u0628\u0631 \u0627\u0633\u0627\u0633 \u0631\u0648\u06cc \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u062a\u0635\u0648\u06cc\u0628 \u0634\u062f\u0647<\/p>\n<p>\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0622\u0646 \u0631\u0627 \u0628\u0627 \u062f\u06cc\u06af\u0631\u06cc \u0622\u0632\u0645\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u0645 <code>curl<\/code> \u062f\u0631\u062e\u0648\u0627\u0633\u062a:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> curl -d <span class=\"hljs-string\">'{\"note\":\"go the gym\",\"tag\":\"health\"}'<\/span> -H <span class=\"hljs-string\">\"Content-Type: application\/json\"<\/span> -X POST http:\/\/localhost:3000\/notes<\/span>\n{\"id\":4,\"note\":\"go the gym\",\"tag\":\"health\",\"updatedAt\":\"2020-02-27T17:13:42.281Z\",\"createdAt\":\"2020-02-27T17:13:42.281Z\"}\n<\/code><\/pre>\n<p>\u0627\u062c\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0645\u0646\u062c\u0631 \u0628\u0647 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0627 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0634\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0631\u0627 \u0628\u0647 \u0645\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<h2 id=\"updatingentities\"><span class=\"ez-toc-section\" id=\"%d8%a8%d9%87_%d8%b1%d9%88%d8%b2_%d8%b1%d8%b3%d8%a7%d9%86%db%8c_%d9%86%d9%87%d8%a7%d8%af%d9%87%d8%a7\"><\/span>\u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0646\u0647\u0627\u062f\u0647\u0627<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u06af\u0627\u0647\u06cc \u0627\u0648\u0642\u0627\u062a\u060c \u0645\u0627 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u0645.  \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0645\u0627 \u062a\u06a9\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0631\u0648\u06cc \u0631\u0627 <code>.update()<\/code> \u0631\u0648\u0634 \u0631\u0648\u06cc \u0646\u062a\u06cc\u062c\u0647 \u0627\u0632 <code>.findByPk()<\/code> \u0631\u0648\u0634:<\/p>\n<pre><code class=\"hljs\">app.put(<span class=\"hljs-string\">'\/notes\/:id'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findByPk(req.params.id).then(<span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">note<\/span>) <\/span>{\n    note.update({\n      <span class=\"hljs-attr\">note<\/span>: req.body.note,\n      <span class=\"hljs-attr\">tag<\/span>: req.body.tag\n    }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">note<\/span>) =&gt;<\/span> {\n      res.json(note);\n    });\n  });\n});\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 <code>.findByPk()<\/code> \u0645\u062a\u062f \u0646\u06cc\u0632 \u06cc\u06a9 \u0645\u062a\u062f \u0627\u0631\u062b\u06cc \u062f\u0631 \u06a9\u0644\u0627\u0633 \u0645\u062f\u0644 \u0645\u0627 \u0627\u0633\u062a.  \u06cc\u06a9 \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0628\u0627 \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u0633\u0627\u0633\u0627\u060c \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f\u0646 \u0648\u0627\u062d\u062f\u0647\u0627\u06cc \u0645\u0646\u0641\u0631\u062f \u0628\u0627 \u0634\u0646\u0627\u0633\u0647 \u0622\u0646\u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0631\u0648\u0634 \u0622\u0633\u0627\u0646\u062a\u0631 \u0627\u0632 \u0646\u0648\u0634\u062a\u0646 a \u0627\u0633\u062a <code>SELECT WHERE<\/code> \u067e\u0631\u0633 \u0648 \u062c\u0648.<\/p>\n<p>\u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u0628\u0627\u0632\u06af\u0634\u062a\u06cc\u060c \u0645\u0627 \u0622\u0646 \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>.update()<\/code> \u0631\u0648\u0634\u06cc \u0628\u0631\u0627\u06cc \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u062c\u062f\u06cc\u062f \u062f\u0631 \u0648\u0627\u0642\u0639.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u06cc\u0646 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u0645 <code>curl<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> curl -X PUT -H <span class=\"hljs-string\">\"Content-Type: application\/json\"<\/span> -d <span class=\"hljs-string\">'{\"note\":\"pick up some milk after work\",\"tag\":\"shopping\"}'<\/span> http:\/\/localhost:3000\/notes\/1<\/span>\n{\"id\":1,\"note\":\"pick up some milk after work\",\"tag\":\"shopping\",\"createdAt\":\"2020-02-27T17:14:55.621Z\",\"updatedAt\":\"2020-02-27T17:14:58.230Z\"}\n<\/code><\/pre>\n<p>\u0628\u0627 \u0627\u0631\u0633\u0627\u0644 \u0627\u06cc\u0646 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0627\u0648\u0644\u06cc\u0646 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0628\u0627 \u0645\u062d\u062a\u0648\u0627\u06cc \u062c\u062f\u06cc\u062f \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0634\u06cc \u0628\u0647 \u0631\u0648\u0632 \u0634\u062f\u0647 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f:<\/p>\n<h3 id=\"deletingentities\"><span class=\"ez-toc-section\" id=\"%d8%ad%d8%b0%d9%81_%d9%86%d9%87%d8%a7%d8%af%d9%87%d8%a7\"><\/span>\u062d\u0630\u0641 \u0646\u0647\u0627\u062f\u0647\u0627<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0632\u0645\u0627\u0646\u06cc \u06a9\u0647 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u0645 \u0631\u06a9\u0648\u0631\u062f\u0647\u0627 \u0631\u0627 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062e\u0648\u062f \u062d\u0630\u0641 \u06a9\u0646\u06cc\u0645\u060c \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 <code>.destroy()<\/code> \u0631\u0648\u0634 \u0631\u0648\u06cc \u0646\u062a\u06cc\u062c\u0647 \u0627\u0632 <code>.findByPk()<\/code> \u0631\u0648\u0634:<\/p>\n<pre><code class=\"hljs\">app.delete(<span class=\"hljs-string\">'\/notes\/:id'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  Note.findByPk(req.params.id).then(<span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">note<\/span>) <\/span>{\n    note.destroy();\n  }).then(<span class=\"hljs-function\">(<span class=\"hljs-params\">note<\/span>) =&gt;<\/span> {\n    res.sendStatus(<span class=\"hljs-number\">200<\/span>);\n  });\n});\n<\/code><\/pre>\n<p>\u0645\u0633\u06cc\u0631 \u0628\u0631\u0627\u06cc <code>.delete()<\/code> \u0634\u0628\u06cc\u0647 \u0628\u0647 <code>.update()<\/code>.  \u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>.findByPk()<\/code> \u0628\u0631\u0627\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0631\u062f\u0646 \u06cc\u06a9 \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u062e\u0627\u0635 \u0628\u0627 \u0634\u0646\u0627\u0633\u0647  \u0633\u067e\u0633 <code>.destroy()<\/code> \u0645\u062a\u062f \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0631\u0627 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062d\u0630\u0641 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0627\u0644\u0641 <code>200 OK<\/code> \u067e\u0627\u0633\u062e \u0628\u0647 \u0645\u0634\u062a\u0631\u06cc \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\"><\/span>\u0646\u062a\u06cc\u062c\u0647<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><em>\u0646\u06af\u0627\u0634\u062a \u0631\u0627\u0628\u0637\u0647 \u0627\u06cc \u0634\u06cc<\/em> (ORM) \u062a\u06a9\u0646\u06cc\u06a9\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0634\u06cc\u0627\u0621 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0631\u0627 \u0628\u0647 \u062c\u062f\u0627\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0646\u06af\u0627\u0634\u062a \u0645\u06cc \u06a9\u0646\u062f.  Sequelize \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 ORM \u0645\u062d\u0628\u0648\u0628 \u0648 \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u06a9\u0646\u0627\u0631 Node.js \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.  \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647\u060c \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646\u06a9\u0647 ORM \u0647\u0627 \u0686\u06cc\u0633\u062a\u060c \u0686\u06af\u0648\u0646\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u0645\u0632\u0627\u06cc\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0646\u0633\u0628\u062a \u0628\u0647 \u0646\u0648\u0634\u062a\u0646 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0627\u0645 \u0686\u06cc\u0633\u062a\u060c \u0628\u062d\u062b \u06a9\u0631\u062f\u0647 \u0627\u06cc\u0645.<\/p>\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u062f\u0627\u0646\u0634\u060c \u0645\u0627 \u0627\u0642\u062f\u0627\u0645 \u0628\u0647 \u0646\u0648\u0634\u062a\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0633\u0627\u062f\u0647 Node.js\/Express \u06a9\u0631\u062f\u06cc\u0645 \u06a9\u0647 \u0627\u0632 Sequelize \u0628\u0631\u0627\u06cc \u062a\u062f\u0627\u0648\u0645 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. <code>Note<\/code> \u0645\u062f\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647  \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0627\u0631\u062b\u06cc\u060c \u0645\u0627 \u0633\u067e\u0633 \u0639\u0645\u0644\u06cc\u0627\u062a CRUD \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f\u06cc\u0645 \u0631\u0648\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647.<\/p>\n<p>\u0628\u0627 \u062e\u06cc\u0627\u0644 \u0631\u0627\u062d\u062a \u06a9\u062f \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/StackAbuse\/sequelize-express-notes-app\">GitHub<\/a> \u0627\u06af\u0631 \u0645\u0634\u06a9\u0644\u06cc \u062f\u0627\u0634\u062a\u06cc\u062f \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/div>\n<p>    (\u0628\u0631\u0686\u0633\u0628\u200c\u0647\u0627 \u0628\u0631\u0627\u06cc \u062a\u0631\u062c\u0645\u0647)# \u062c\u0627\u0648\u0627 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a<br \/>\n<br \/><br \/>\n<br \/>\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 1403-01-21 15:37:02<br \/>\n<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;16166&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628&quot;,&quot;legend&quot;:&quot;0\\\/5 (0 \u0631\u0627\u06cc)&quot;,&quot;size&quot;:&quot;30&quot;,&quot;title&quot;:&quot;\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Sequelize ORM \u0628\u0627 Node.js \u0648 ExpressSequelize \u06cc\u06a9 ORM \u0645\u062d\u0628\u0648\u0628 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc Node.js \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0648 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u06cc\u06a9 CRUD API \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.  \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u062c \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u0627\u0637\u0646 \u0627\u0633\u062a.  \u0627\u06cc\u0646 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u067e\u0631\u0633\u200c\u0648\u062c\u0648\u0647\u0627\u06cc SQL \u062e\u0627\u0645 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u06a9\u0647 \u0633\u0627\u062e\u062a\u0646 \u0622\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062f\u0634\u0648\u0627\u0631 \u0628\u0627\u0634\u062f\u060c \u0628\u0647 \u062e\u0635\u0648\u0635...&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} ({count} \u0631\u0627\u06cc)&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 24px;\">\n            <span class=\"kksr-muted\">\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 10<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span>\u0645\u0639\u0631\u0641\u06cc \u0639\u0627\u0642\u0628\u062a \u0633\u0627\u0632\u06cc \u06cc\u06a9 ORM \u0645\u062d\u0628\u0648\u0628 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0627\u06cc Node.js \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0648 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 CRUD API \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u06cc\u0627\u062f\u062f\u0627\u0634\u062a \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645. \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u062c \u0628\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0628\u0627\u0637\u0646 \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0645\u0639\u0645\u0648\u0644\u0627\u064b \u0627\u0632 \u0637\u0631\u06cc\u0642 \u067e\u0631\u0633\u200c\u0648\u200c\u062c\u0648\u0647\u0627\u06cc SQL \u062e\u0627\u0645 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u06a9\u0647 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":9049,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1772,620],"tags":[],"class_list":["post-16166","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-javascript","category-programming"],"acf":[],"_links":{"self":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/16166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/comments?post=16166"}],"version-history":[{"count":0,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/16166\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media\/9049"}],"wp:attachment":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media?parent=16166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/categories?post=16166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/tags?post=16166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}