{"id":16216,"date":"2024-01-22T05:52:23","date_gmt":"2024-01-22T02:22:23","guid":{"rendered":"https:\/\/rasanegar.com\/blog\/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/"},"modified":"2024-01-22T05:52:23","modified_gmt":"2024-01-22T02:22:23","slug":"%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku","status":"publish","type":"post","link":"https:\/\/rasanegaar.com\/blog\/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/","title":{"rendered":"\u0627\u0641\u0632\u0648\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 Node.js \u0631\u0648\u06cc HerokuHeroku \u06cc\u06a9 \u0633\u0631\u0648\u06cc\u0633 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc Node.js \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a \u0648 \u0639\u0645\u0644\u06a9\u0631\u062f \u0622\u0646 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0627\u062f.  \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0686\u06cc\u0632\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u067e\u06cc\u0627\u0645\u200c\u0631\u0633\u0627\u0646\u06cc\/\u0635\u0641\u200c\u0647\u0627\u060c \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645\u060c \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u0648 \u0627\u0644\u0628\u062a\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.  \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062d\u0628\u0648\u0628 \u0645\u0627\u0646\u0646\u062f PostgreSQL\u060c Redis \u0648 &#8230; \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f."},"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%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%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%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#postgresql\" >PostgreSQL<\/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%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d8%a7%d8%af%d8%ba%d8%a7%d9%85_postgres_%d8%af%d8%b1_%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87_node\" >\u0627\u062f\u063a\u0627\u0645 Postgres \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 Node<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d9%85%d9%87%d8%a7%d8%ac%d8%b1%d8%aa_%d9%87%d8%a7\" >\u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d8%b0%d8%ae%db%8c%d8%b1%d9%87_url_%d9%87%d8%a7\" >\u0630\u062e\u06cc\u0631\u0647 URL \u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d9%86%d9%85%d8%a7%db%8c%d8%b4_url_%d9%87%d8%a7_%d8%af%d8%b1_%d8%b1%d8%a7%d8%a8%d8%b7_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%db%8c\" >\u0646\u0645\u0627\u06cc\u0634 URL \u0647\u0627 \u062f\u0631 \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc<\/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%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d8%a7%d8%b3%d8%aa%d9%82%d8%b1%d8%a7%d8%b1_%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87_%d8%af%d8%b1_heroku\" >\u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0631 Heroku<\/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%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87\" >\u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<\/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%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%d9%85%d8%af%db%8c%d8%b1%db%8c%d8%aa_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_heroku\" >\u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 Heroku<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%a7%d9%81%d8%b2%d9%88%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-postgresql-%d8%a8%d9%87-%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87-node-js-%d8%b1%d9%88%db%8c-herokuheroku\/#%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\"> 8<\/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>Heroku \u06cc\u06a9 \u0633\u0631\u0648\u06cc\u0633 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc Node.js \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0622\u0646 \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0627\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/elements.heroku.com\/addons\">\u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627<\/a>.  \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0686\u06cc\u0632\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u067e\u06cc\u0627\u0645\u200c\u0631\u0633\u0627\u0646\u06cc\/\u0635\u0641\u200c\u0647\u0627\u060c \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645\u060c \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u0648 \u0627\u0644\u0628\u062a\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.  \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062d\u0628\u0648\u0628 \u0645\u0627\u0646\u0646\u062f PostgreSQL\u060c Redis \u0648 DynamoDB \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0645\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0628\u0647 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Node \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 URL \u0647\u0627 \u0631\u0627 \u06a9\u0648\u062a\u0627\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u0633\u067e\u0633 \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u062f\u0631 Heroku \u0645\u0633\u062a\u0642\u0631 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u0648 \u0627\u0641\u0632\u0648\u062f\u0646\u06cc PostgreSQL \u0631\u0627 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645.\u0631\u0648\u06cc.<\/p>\n<h2 id=\"postgresql\"><span class=\"ez-toc-section\" id=\"postgresql\"><\/span>PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06af\u0631 \u0642\u0628\u0644\u0627\u064b \u0622\u0646 \u0631\u0627 \u0646\u062f\u0627\u0631\u06cc\u062f\u060c \u0628\u0627\u06cc\u062f Postgres \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc \u0645\u0627\u0634\u06cc\u0646 \u0634\u0645\u0627  \u0628\u0633\u062a\u0647 \u0628\u0647 \u0631\u0648\u0634 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0627\u06cc \u0646\u0635\u0628 \u0622\u0646 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0631\u0648\u06cc \u0633\u06cc\u0633\u062a\u0645 \u0639\u0627\u0645\u0644 \u0634\u0645\u0627  \u0628\u0627\u0632\u062f\u06cc\u062f \u06a9\u0646\u06cc\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.postgresql.org\/download\">\u062f\u0627\u0646\u0644\u0648\u062f\u0647\u0627\u06cc PostgreSQL page<\/a>  \u0628\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u06cc\u0634\u062a\u0631.<\/p>\n<p>\u0628\u0627 \u0646\u0635\u0628 PostgreSQL\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u06a9\u0648\u062a\u0627\u0647\u200c\u06a9\u0646\u0646\u062f\u0647 URL \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> psql<\/span>\npsql (11.6)\nType \"help\" for help.\n\ntomkadwill=#\n<\/code><\/pre>\n<p>\u0648 \u0633\u067e\u0633 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <code>CREATE DATABASE<\/code> \u062f\u0633\u062a\u0648\u0631 SQL:<\/p>\n<pre><code class=\"hljs\">tomkadwill=# CREATE DATABASE urlshortener_development;\nCREATE DATABASE\ntomkadwill=# \\l\n                                         List of databases\n            Name          |   Owner    | Encoding |   Collate   |    Ctype    |   Access privileges\n--------------------------+------------+----------+-------------+-------------+-----------------------\n urlshortener_development | tomkadwill | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>urlshortener_development<\/code> \u0648 \u0633\u067e\u0633 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f <code>\\l<\/code> \u0628\u0647 print \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u062a\u0645\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 PostgreSQL \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645.<\/p>\n<p>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0645\u0627 <code>urlshortener_development<\/code> \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u062a\u0627 \u0628\u062f\u0627\u0646\u06cc\u0645 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a \u0627\u06cc\u062c\u0627\u062f \u0634\u062f.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0647 \u0645\u0627\u0644\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0648\u062c\u0647 \u06a9\u0646\u06cc\u062f \u0632\u06cc\u0631\u0627 \u0628\u0639\u062f\u0627\u064b \u0628\u0647 \u0622\u0646 \u0646\u06cc\u0627\u0632 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u0634\u062a \u0631\u0648\u06cc (\u0645\u0627\u0644 \u0634\u0645\u0627 \u0628\u0627 \u0645\u0646 \u0645\u062a\u0641\u0627\u0648\u062a \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f).<\/p>\n<h2 id=\"integratingpostgresintoanodeapp\"><span class=\"ez-toc-section\" id=\"%d8%a7%d8%af%d8%ba%d8%a7%d9%85_postgres_%d8%af%d8%b1_%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87_node\"><\/span>\u0627\u062f\u063a\u0627\u0645 Postgres \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 Node<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0631\u0646\u0627\u0645\u0647 Node \u06a9\u0647 \u0645\u0627 \u06a9\u0627\u0631 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f \u0631\u0648\u06cc \u0646\u0633\u0628\u062a\u0627 \u0633\u0627\u062f\u0647 \u0627\u0633\u062a  \u0627\u06af\u0631 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u0632 \u0627\u0628\u062a\u062f\u0627 \u0628\u0633\u0627\u0632\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u0645\u0627\u060c \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Node.js \u062f\u0631 Heroku \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f\u060c \u06cc\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u0632 \u0622\u0646 \u062f\u0627\u0646\u0644\u0648\u062f \u06a9\u0646\u06cc\u062f. <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/tomkadwill\/url-shortener\/tree\/adding-a-postgres-database-to-a-node-app-on-heroku\">GitHub<\/a>.<\/p>\n<p>\u0645\u0646\u0637\u0642 \u0628\u0631\u0646\u0627\u0645\u0647 Express \u0647\u0645\u0647 \u062f\u0631 \u062f\u0627\u062e\u0644 \u0627\u0633\u062a <code>app.js<\/code>:<\/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> path = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'path'<\/span>);\n<span class=\"hljs-keyword\">const<\/span> port = process.env.PORT || <span class=\"hljs-number\">3000<\/span>;\n<span class=\"hljs-keyword\">const<\/span> urlShortener = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'node-url-shortener'<\/span>);\n\n<span class=\"hljs-keyword\">const<\/span> bodyParser = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'body-parser'<\/span>)\napp.use(bodyParser.urlencoded({<span class=\"hljs-attr\">extended<\/span>: <span class=\"hljs-literal\">true<\/span>}));\napp.use(express.urlencoded());\n\napp.get(<span class=\"hljs-string\">'\/'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  res.sendFile(path.join(__dirname + <span class=\"hljs-string\">'\/index.html'<\/span>));\n});\n\napp.post(<span class=\"hljs-string\">'\/url'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  <span class=\"hljs-keyword\">const<\/span> url = req.body.url\n\n  urlShortener.short(url, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">err, shortUrl<\/span>)<\/span>{\n    res.send(shortUrl);\n  });\n});\n\napp.listen(port, <span class=\"hljs-function\">() =&gt;<\/span> <span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">`url-shortener listening \u0631\u0648\u06cc port <span class=\"hljs-subst\">${port}<\/span>!`<\/span>));\n<\/code><\/pre>\n<p>\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f <code>npm start<\/code>.  \u067e\u0633 \u0627\u0632 \u0634\u0631\u0648\u0639\u060c \u0645\u0631\u0648\u0631 \u0628\u0647 <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/localhost:3000\">localhost: 3000<\/a> \u0648 \u0634\u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u062f homepage:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2024\/01\/adding-a-postgresql-database-to-a-node-js-app-on-heroku-1.png\" alt=\"app_homepage\" title=\"\"><\/p>\n<p>\u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0627\u0633\u062a <code>app.js<\/code> \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0647\u0631 URL \u0648 URL \u06a9\u0648\u062a\u0627\u0647 \u0634\u062f\u0647 \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 DB \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0633\u067e\u0633 5 \u0646\u062a\u06cc\u062c\u0647 \u0622\u062e\u0631 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u062f \u0631\u0648\u06cc UI<\/p>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u0646\u0635\u0628 an <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/en.wikipedia.org\/wiki\/Object-relational_mapping\">ORM<\/a> \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 (Object Relation Mapper).  \u062a\u0639\u0627\u0645\u0644 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0628\u0627 PostgreSQL \u062f\u0634\u0648\u0627\u0631 \u0627\u0633\u062a \u0632\u06cc\u0631\u0627 \u0645\u0627 \u0628\u0627\u06cc\u062f \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc SQL \u062e\u0627\u0645 \u062e\u0648\u062f \u0631\u0627 \u0628\u0646\u0648\u06cc\u0633\u06cc\u0645.<\/p>\n<p>\u06cc\u06a9 ORM \u0628\u0647 \u0645\u0627 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u0647\u0627\u06cc \u0633\u0627\u062f\u0647 \u062a\u0631 API \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645.  \u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 ORM \u0647\u0627 \u062c\u0646\u0628\u0647 \u0647\u0627\u06cc \u0645\u0646\u0641\u06cc \u062f\u0627\u0631\u062f\u060c \u0627\u0645\u0627 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0622\u0646\u0647\u0627 \u0646\u0645\u06cc \u067e\u0631\u062f\u0627\u0632\u0645.<\/p>\n<p>\u062a\u0639\u062f\u0627\u062f\u06cc \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 ORM \u0645\u062e\u062a\u0644\u0641 \u0628\u0631\u0627\u06cc Node \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f\u060c \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0645\u0627 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/sequelize\/sequelize\">\u0639\u0627\u0642\u0628\u062a \u0633\u0627\u0632\u06cc<\/a>:<\/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 pg pg-hstore<\/span>\n<\/code><\/pre>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0646\u0635\u0628 \u0645\u06cc \u0634\u0648\u062f <em>\u0639\u0627\u0642\u0628\u062a \u0633\u0627\u0632\u06cc<\/em> \u0648 \u062f\u0648\u0645\u06cc \u062f\u0631\u0627\u06cc\u0648\u0631 PostgreSQL \u0631\u0627 \u0628\u0631\u0627\u06cc Node \u0646\u0635\u0628 \u0645\u06cc \u06a9\u0646\u062f.  Sequelize \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f\u060c \u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0628\u0627\u06cc\u062f \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0627\u0632 \u06a9\u062f\u0627\u0645 \u06cc\u06a9 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u0648 \u062f\u0631\u0627\u06cc\u0648\u0631 Node \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u062f\u0647\u06cc\u0645.<\/p>\n<h3 id=\"migrations\"><span class=\"ez-toc-section\" id=\"%d9%85%d9%87%d8%a7%d8%ac%d8%b1%d8%aa_%d9%87%d8%a7\"><\/span>\u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0627 \u0646\u0635\u0628 \u0648 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc Sequelize\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0628\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0641\u06a9\u0631 \u06a9\u0646\u06cc\u0645.  \u0645\u0627 \u0641\u0642\u0637 \u0628\u0647 \u0686\u06cc\u0632\u06cc \u0633\u0627\u062f\u0647 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u0645\u060c \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0627 3 \u0633\u062a\u0648\u0646: \u06cc\u06a9 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f\u060c URL \u0627\u0635\u0644\u06cc \u0648 URL \u06a9\u0648\u062a\u0627\u0647 \u0634\u062f\u0647.<\/p>\n<p>\u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u062f\u06cc\u062f \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0633\u062a\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645\u060c \u0627\u0645\u0627 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0631\u0627 \u062f\u0631\u062f\u0646\u0627\u06a9 \u0645\u06cc\u200c\u06a9\u0646\u062f.  \u0645\u0627 \u0628\u0627\u06cc\u062f \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u062e\u0627\u0637\u0631 \u0628\u0633\u067e\u0627\u0631\u06cc\u0645 \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645 \u0631\u0648\u06cc \u0647\u0631 \u0645\u062d\u06cc\u0637<\/p>\n<p>\u06cc\u06a9 \u0631\u0627\u0647 \u0628\u0647\u062a\u0631 \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0645\u0647\u0627\u062c\u0631\u062a \u0627\u0633\u062a\u060c \u062c\u0627\u06cc\u06cc \u06a9\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u062f\u0627\u062e\u0644 \u0628\u0631\u0646\u0627\u0645\u0647 \u06a9\u062f\u06af\u0630\u0627\u0631\u06cc \u0645\u06cc \u0634\u0648\u062f.  \u062e\u0648\u0634\u0628\u062e\u062a\u0627\u0646\u0647\u060c Sequelize \u0627\u0632 \u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627\u06cc \u062e\u0627\u0631\u062c \u0627\u0632 \u062c\u0639\u0628\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0645\u0647\u0627\u062c\u0631\u062a \u0628\u0646\u0648\u06cc\u0633\u06cc\u0645 \u062a\u0627 \u062c\u062f\u0648\u0644\u06cc \u0628\u0631\u0627\u06cc URL \u0647\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u0627\u0628\u062a\u062f\u0627\u060c Sequelize CLI \u0631\u0627 \u0646\u0635\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npm install --save sequelize-cli<\/span>\n<\/code><\/pre>\n<p>\u0633\u067e\u0633 Sequelize \u0631\u0627 \u0645\u0642\u062f\u0627\u0631\u062f\u0647\u06cc \u0627\u0648\u0644\u06cc\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npx sequelize-cli init<\/span>\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 \u06cc\u06a9 \u0627\u06cc\u062c\u0627\u062f \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f <code>config\/config.json<\/code> \u0641\u0627\u06cc\u0644 \u0648 <code>models<\/code>\u060c <code>migrations<\/code>\u060c \u0648 <code>seeders<\/code> \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0647\u0627<\/p>\n<p>\u067e\u0633 \u0627\u0632 \u0622\u0646\u060c \u0645\u0627 \u0628\u0627\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0627\u0635\u0644\u0627\u062d \u06a9\u0646\u06cc\u0645 <code>config.json<\/code> \u0641\u0627\u06cc\u0644 \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0645\u0627 \u0645\u062a\u0635\u0644 \u0634\u0648\u062f:<\/p>\n<pre><code class=\"hljs\">{\n  <span class=\"hljs-attr\">\"development\"<\/span>: {\n    <span class=\"hljs-attr\">\"username\"<\/span>: <span class=\"hljs-string\">\"tomkadwill\"<\/span>,\n    <span class=\"hljs-attr\">\"password\"<\/span>: <span class=\"hljs-string\">\"password\"<\/span>,\n    <span class=\"hljs-attr\">\"database\"<\/span>: <span class=\"hljs-string\">\"urlshortener_development\"<\/span>,\n    <span class=\"hljs-attr\">\"host\"<\/span>: <span class=\"hljs-string\">\"localhost\"<\/span>,\n    <span class=\"hljs-attr\">\"dialect\"<\/span>: <span class=\"hljs-string\">\"postgres\"<\/span>,\n    <span class=\"hljs-attr\">\"operatorsAliases\"<\/span>: <span class=\"hljs-literal\">false<\/span>\n  }\n}\n<\/code><\/pre>\n<p>\u067e\u0633 \u0627\u0632 \u0627\u062a\u0645\u0627\u0645 \u0641\u0627\u06cc\u0644\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0645\u0647\u0627\u062c\u0631\u062a \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Sequelize CLI \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627\u060c \u0641\u06cc\u0644\u062f\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062a\u0639\u0631\u06cc\u0641 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>attributes<\/code> \u067e\u0631\u0686\u0645.  \u0645\u0627 \u0634\u0627\u0645\u0644 \u0622\u0646 \u0646\u062e\u0648\u0627\u0647\u06cc\u0645 \u0634\u062f <code>id<\/code> \u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npx sequelize-cli model:generate --name Url --attributes url:string,shortUrl:string<\/span>\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0645\u0647\u0627\u062c\u0631\u062a \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0686\u06cc\u0632\u06cc \u0634\u0628\u06cc\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u0627\u0633\u062a:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">'use strict'<\/span>;\n<span class=\"hljs-built_in\">module<\/span>.exports = {\n  <span class=\"hljs-attr\">up<\/span>: <span class=\"hljs-function\">(<span class=\"hljs-params\">queryInterface, Sequelize<\/span>) =&gt;<\/span> {\n    <span class=\"hljs-keyword\">return<\/span> queryInterface.createTable(<span class=\"hljs-string\">'Urls'<\/span>, {\n      <span class=\"hljs-attr\">id<\/span>: {\n        <span class=\"hljs-attr\">allowNull<\/span>: <span class=\"hljs-literal\">false<\/span>,\n        <span class=\"hljs-attr\">autoIncrement<\/span>: <span class=\"hljs-literal\">true<\/span>,\n        <span class=\"hljs-attr\">primaryKey<\/span>: <span class=\"hljs-literal\">true<\/span>,\n        <span class=\"hljs-attr\">type<\/span>: Sequelize.INTEGER\n      },\n      <span class=\"hljs-attr\">url<\/span>: {\n        <span class=\"hljs-attr\">type<\/span>: Sequelize.STRING\n      },\n      <span class=\"hljs-attr\">shortUrl<\/span>: {\n        <span class=\"hljs-attr\">type<\/span>: Sequelize.STRING\n      },\n      <span class=\"hljs-attr\">createdAt<\/span>: {\n        <span class=\"hljs-attr\">allowNull<\/span>: <span class=\"hljs-literal\">false<\/span>,\n        <span class=\"hljs-attr\">type<\/span>: Sequelize.DATE\n      },\n      <span class=\"hljs-attr\">updatedAt<\/span>: {\n        <span class=\"hljs-attr\">allowNull<\/span>: <span class=\"hljs-literal\">false<\/span>,\n        <span class=\"hljs-attr\">type<\/span>: Sequelize.DATE\n      }\n    });\n  },\n  <span class=\"hljs-attr\">down<\/span>: <span class=\"hljs-function\">(<span class=\"hljs-params\">queryInterface, Sequelize<\/span>) =&gt;<\/span> {\n    <span class=\"hljs-keyword\">return<\/span> queryInterface.dropTable(<span class=\"hljs-string\">'Urls'<\/span>);\n  }\n};\n<\/code><\/pre>\n<p>\u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627 \u062d\u0627\u0648\u06cc \u06cc\u06a9 <code>up<\/code> \u0648 <code>down<\/code> \u062a\u0627\u0628\u0639. <code>up<\/code> \u0628\u0631\u0627\u06cc \u062c\u0644\u0648 \u0628\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0648 <code>down<\/code> \u0628\u0631\u0627\u06cc \u0639\u0642\u0628 \u0631\u0641\u062a\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f <code>up<\/code> \u0627\u0644\u0641 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f <code>Urls<\/code> \u062c\u062f\u0648\u0644\u06cc \u06a9\u0647 5 \u0641\u06cc\u0644\u062f \u062f\u0627\u0631\u062f.  \u0622\u0646 \u0631\u0627 \u062f\u0627\u0631\u062f <code>url<\/code> \u0648 <code>shortUrl<\/code> \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627 \u0648 \u0647\u0645\u0686\u0646\u06cc\u0646 <code>id<\/code>\u060c <code>createdAt<\/code>\u060c \u0648 <code>updatedAt<\/code>\u060c \u06a9\u0647 \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 <code>down<\/code> \u0645\u0647\u0627\u062c\u0631\u062a \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u062d\u0630\u0641 \u062e\u0648\u0627\u0647\u062f \u0634\u062f <code>Urls<\/code> \u062c\u062f\u0648\u0644.<\/p>\n<p>\u062f\u0631 \u0646\u0647\u0627\u06cc\u062a\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0645\u0647\u0627\u062c\u0631\u062a \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npx sequelize-cli db:migrate<\/span>\n<\/code><\/pre>\n<p>\u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627\u06cc \u0622\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u0645 \u062a\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0647\u0645\u0647 \u0686\u06cc\u0632 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> psql -p 5432 <span class=\"hljs-string\">\"urlshortener_development\"<\/span><\/span>\npsql (11.6)\nType \"help\" for help.\n\nurlshortener_development=# \\dt\n              List of relations\n Schema |     Name      | Type  |   Owner\n--------+---------------+-------+------------\n public | SequelizeMeta | table | tomkadwill\n public | Urls          | table | tomkadwill\n(2 rows)\n\nurlshortener_development=# \\d \"Urls\"\n                                       Table \"public.Urls\"\n  Column   |           Type           | Collation | Nullable |              Default\n-----------+--------------------------+-----------+----------+------------------------------------\n id        | integer                  |           | not null | nextval('\"Urls_id_seq\"'::regclass)\n url       | character varying(255)   |           |          |\n shortUrl  | character varying(255)   |           |          |\n createdAt | timestamp with time zone |           | not null |\n updatedAt | timestamp with time zone |           | not null |\nIndexes:\n    \"Urls_pkey\" PRIMARY KEY, btree (id)\n<\/code><\/pre>\n<p>\u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u0645\u06cc \u0628\u06cc\u0646\u06cc\u062f \u062f\u0648 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f: <code>SequelizeMeta<\/code> \u0648 <code>Urls<\/code>.  \u0648 \u0627\u06af\u0631 \u0628\u0627\u0632\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645 <code>Urls<\/code>\u060c \u0632\u0645\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0627\u0646\u062a\u0638\u0627\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.<\/p>\n<h3 id=\"savingurls\"><span class=\"ez-toc-section\" id=\"%d8%b0%d8%ae%db%8c%d8%b1%d9%87_url_%d9%87%d8%a7\"><\/span>\u0630\u062e\u06cc\u0631\u0647 URL \u0647\u0627<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 PostgreSQL \u0631\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0631\u062f\u0647 \u0627\u06cc\u0645 \u0648 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0633\u0627\u062e\u062a\u0627\u0631 \u0635\u062d\u06cc\u062d \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u0647 \u0627\u06cc\u0645\u060c \u06af\u0627\u0645 \u0628\u0639\u062f\u06cc \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u0631\u0648\u0632 \u06a9\u0646\u06cc\u0645 \u062a\u0627 URL \u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062d\u0641\u0638 \u06a9\u0646\u062f.  \u0628\u0647 \u06cc\u0627\u062f \u0628\u06cc\u0627\u0648\u0631\u06cc\u062f \u06a9\u0647 <code>npx sequelize-cli model:generate<\/code> \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0645\u062f\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u0645\u060c \u0627\u0632 \u0622\u0646 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 URL \u0647\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0645\u0627 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u0645 import \u0645\u062f\u0644 \u0647\u0627 \u0628\u0647 <code>app.js<\/code>\u060c \u0628\u0627 \u0646\u06cc\u0627\u0632 <code>models\/index.js<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-keyword\">const<\/span> db = <span class=\"hljs-built_in\">require<\/span>(<span class=\"hljs-string\">'.\/models\/index.js'<\/span>);\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 <code>models\/index.js<\/code> \u0641\u0627\u06cc\u0644 \u062a\u0648\u0633\u0637 Sequelize \u062a\u0648\u0644\u06cc\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0647\u062f\u0641 \u0622\u0646 \u0634\u0627\u0645\u0644 \u062a\u0645\u0627\u0645 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0645\u062f\u0644 \u0627\u0633\u062a.<\/p>\n<p>\u0628\u0639\u062f\u060c \u0645\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u0645 <code>post<\/code> \u0645\u0633\u06cc\u0631 \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.  \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 <code>findOrCreate()<\/code> \u062a\u0627\u0628\u0639 \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0647\u0631 URL \u0641\u0642\u0637 \u06cc\u06a9 \u0648\u0631\u0648\u062f\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u062f\u0627\u0631\u062f:<\/p>\n<pre><code class=\"hljs\">app.post(<span class=\"hljs-string\">'\/url'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  <span class=\"hljs-keyword\">const<\/span> url = req.body.url\n\n  urlShortener.short(url, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">err, shortUrl<\/span>) <\/span>{\n    db.Url.findOrCreate({<span class=\"hljs-attr\">where<\/span>: {<span class=\"hljs-attr\">url<\/span>: url, <span class=\"hljs-attr\">shortUrl<\/span>: shortUrl}})\n    .then(<span class=\"hljs-function\">(<span class=\"hljs-params\">(urlObj, created)<\/span>) =&gt;<\/span> {\n      res.send(shortUrl)\n    });\n  });\n});\n<\/code><\/pre>\n<p>\u0686\u0647 \u0632\u0645\u0627\u0646\u06cc <code>db.Url.findOrCreate()<\/code> \u0646\u0627\u0645\u06cc\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u060c \u0633\u0639\u06cc \u0645\u06cc \u06a9\u0646\u062f \u0631\u06a9\u0648\u0631\u062f\u06cc \u0631\u0627 \u067e\u06cc\u062f\u0627 \u06a9\u0646\u062f \u06a9\u0647 \u0628\u0627 \u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f <code>url<\/code> \u0648 \u062a\u0648\u0644\u06cc\u062f \u0634\u062f <code>shortUrl<\/code>.  \u0627\u06af\u0631 \u06cc\u06a9\u06cc \u067e\u06cc\u062f\u0627 \u0634\u0648\u062f\u060c Sequelize \u0647\u06cc\u0686 \u06a9\u0627\u0631\u06cc \u0627\u0646\u062c\u0627\u0645 \u0646\u0645\u06cc \u062f\u0647\u062f\u060c \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c \u06cc\u06a9 \u0631\u06a9\u0648\u0631\u062f \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<h3 id=\"displayingurlsintheui\"><span class=\"ez-toc-section\" id=\"%d9%86%d9%85%d8%a7%db%8c%d8%b4_url_%d9%87%d8%a7_%d8%af%d8%b1_%d8%b1%d8%a7%d8%a8%d8%b7_%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%db%8c\"><\/span>\u0646\u0645\u0627\u06cc\u0634 URL \u0647\u0627 \u062f\u0631 \u0631\u0627\u0628\u0637 \u06a9\u0627\u0631\u0628\u0631\u06cc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u067e\u0633\u0646\u062f\u06cc\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u06a9\u0646\u06cc\u0645 \u062a\u0627 5 \u0646\u0634\u0627\u0646\u06cc \u0627\u06cc\u0646\u062a\u0631\u0646\u062a\u06cc \u0628\u0627\u0642\u06cc\u200c\u0645\u0627\u0646\u062f\u0647 \u0631\u0627 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631\u060c \u0645\u0627 \u06cc\u06a9 \u0645\u0648\u062a\u0648\u0631 \u0642\u0627\u0644\u0628 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u062a\u0627 Express \u0628\u062a\u0648\u0627\u0646\u062f URL \u0647\u0627 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u067e\u0648\u06cc\u0627 \u0627\u0631\u0627\u0626\u0647 \u06a9\u0646\u062f.  \u0645\u0648\u062a\u0648\u0631\u0647\u0627\u06cc \u0642\u0627\u0644\u0628 \u0632\u06cc\u0627\u062f\u06cc \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0647\u0633\u062a\u0646\u062f \u0627\u0645\u0627 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f \u0645\u0627 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/ericf\/express-handlebars\">\u062f\u0633\u062a\u0647 \u0627\u06a9\u0633\u067e\u0631\u0633<\/a>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> npm install --save express-handlebars<\/span>\n<\/code><\/pre>\n<p>\u067e\u0633 \u0627\u0632 \u0646\u0635\u0628 \u0628\u0633\u062a\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0622\u0646 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 <code>app.js<\/code>:<\/p>\n<pre><code class=\"hljs\">const exphbs = require('express-handlebars');\n\napp.engine('handlebars', exphbs());\napp.set('view engine', 'handlebars');\n<\/code><\/pre>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0628\u0627\u06cc\u062f \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645. <code>express-handlebars<\/code> \u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0646\u0645\u0627\u0647\u0627 \u062f\u0631 a \u0642\u0631\u0627\u0631 \u062f\u0627\u0631\u0646\u062f <code>views<\/code> \u0641\u0647\u0631\u0633\u062a \u0631\u0627\u0647\u0646\u0645\u0627.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0641\u0631\u0636 \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u0645\u0627 \u06cc\u06a9 <code>views\/layouts\/main.handlebars<\/code> \u0641\u0627\u06cc\u0644:<\/p>\n<pre><code class=\"hljs\">.\n\u251c\u2500\u2500 app.js\n\u2514\u2500\u2500 views\n    \u251c\u2500\u2500 index.handlebars\n    \u2514\u2500\u2500 layouts\n        \u2514\u2500\u2500 main.handlebars\n<\/code><\/pre>\n<p>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u062d\u0631\u06a9\u062a \u06a9\u0646\u06cc\u0645 \u0648 \u0646\u0627\u0645 \u0622\u0646 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u0645 <code>index.html<\/code> \u0641\u0627\u06cc\u0644:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> mv index.html views\/index.handlebars<\/span>\n<\/code><\/pre>\n<p>\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0637\u0631\u062d \u0628\u0646\u062f\u06cc \u0628\u0633\u0627\u0632\u06cc\u0645\u060c <code>views\/layouts\/main.handlebars<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">html<\/span>&gt;<\/span>\n<span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">head<\/span>&gt;<\/span>\n    <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">title<\/span>&gt;<\/span>Url Shortener<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">title<\/span>&gt;<\/span>\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">head<\/span>&gt;<\/span>\n<span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">body<\/span>&gt;<\/span>\n    {{{body}}}\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">body<\/span>&gt;<\/span>\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">html<\/span>&gt;<\/span>\n<\/code><\/pre>\n<p>\u062a\u0631\u062a\u06cc\u0628 \u062e\u0627\u0635\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0642\u0627\u0644\u0628 \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f: <code>express-handlebars<\/code> \u0627\u0631\u0627\u0626\u0647 \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f <code>views\/layouts\/main.handlebars<\/code> \u06a9\u0647 \u0633\u067e\u0633 \u0631\u0646\u062f\u0631 \u0645\u06cc \u06a9\u0646\u062f <code>views\/index.handlebars<\/code> \u062f\u0631\u0648\u0646 <code>{{{body}}}<\/code> \u0628\u0631\u0686\u0633\u0628 \u0632\u062f\u0646<\/p>\n<p>\u062d\u0627\u0644\u0627 \u06a9\u0647 \u0633\u0627\u062e\u062a\u0627\u0631 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u062f\u0631\u0633\u062a\u06cc \u062f\u0627\u0631\u06cc\u0645\u060c \u0627\u062c\u0627\u0632\u0647 \u062f\u0647\u06cc\u062f \u0645\u0642\u062f\u0627\u0631\u06cc \u06a9\u062f HTML \u0628\u0647 \u0622\u0646 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 <code>index.handlebars<\/code> \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u067e\u0648\u06cc\u0627 URL \u0647\u0627:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">ul<\/span>&gt;<\/span>\n  {{#each urlObjs}}\n  <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">li<\/span>&gt;<\/span>{{this.url}} -- <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">b<\/span>&gt;<\/span>{{this.shortUrl}}<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">b<\/span>&gt;<\/span><span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">li<\/span>&gt;<\/span>\n  {{\/each}}\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">ul<\/span>&gt;<\/span>\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0627 \u0627\u0632 Handlebars \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645 <code>each<\/code> \u06a9\u0645\u06a9 \u06a9\u0646\u0646\u062f\u0647 \u0628\u0631\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631 \u0631\u0648\u06cc \u0647\u0631 \u0634\u06cc URL \u0648 \u0646\u0645\u0627\u06cc\u0634 URL \u0627\u0635\u0644\u06cc \u0648 URL \u06a9\u0648\u062a\u0627\u0647.<\/p>\n<p>\u0622\u062e\u0631\u06cc\u0646 \u06a9\u0627\u0631\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645\u060c \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0627\u0633\u062a <code>GET<\/code> \u0645\u0633\u06cc\u0631 \u062f\u0631 <code>app.js<\/code> \u0628\u0631\u0627\u06cc \u0627\u0631\u0633\u0627\u0644 URL \u0647\u0627 \u0628\u0647 view:<\/p>\n<pre><code class=\"hljs\">app.get(<span class=\"hljs-string\">'\/'<\/span>, <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span>(<span class=\"hljs-params\">req, res<\/span>) <\/span>{\n  db.Url.findAll({<span class=\"hljs-attr\">order<\/span>: ((<span class=\"hljs-string\">'createdAt'<\/span>, <span class=\"hljs-string\">'DESC'<\/span>)), <span class=\"hljs-attr\">limit<\/span>: <span class=\"hljs-number\">5<\/span>})\n  .then(<span class=\"hljs-function\"><span class=\"hljs-params\">urlObjs<\/span> =&gt;<\/span> {\n    res.render(<span class=\"hljs-string\">'index'<\/span>, {\n      <span class=\"hljs-attr\">urlObjs<\/span>: urlObjs\n    });\n  });\n});\n<\/code><\/pre>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u0632 \u0622\u0646\u0686\u0647 \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0627\u062a\u0641\u0627\u0642 \u0645\u06cc \u0627\u0641\u062a\u062f \u0639\u0628\u0648\u0631 \u06a9\u0646\u06cc\u0645.  \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc <code>\/<\/code> \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0634\u062f\u0647 \u0627\u0633\u062a\u060c Sequelize \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u06cc \u06a9\u0646\u062f <code>Urls<\/code> \u062c\u062f\u0648\u0644.  \u067e\u0631\u0633 \u0648 \u062c\u0648 \u062a\u0648\u0633\u0637 <code>createdAt<\/code> \u0648 \u0645\u062d\u062f\u0648\u062f \u0628\u0647 5 \u0627\u0633\u062a \u06a9\u0647 \u062a\u0636\u0645\u06cc\u0646 \u0645\u06cc \u06a9\u0646\u062f \u0641\u0642\u0637 5 \u0646\u062a\u06cc\u062c\u0647 \u0627\u062e\u06cc\u0631 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0647 \u0622\u0646 \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc \u0634\u0648\u062f <code>res.render<\/code> \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062a\u063a\u06cc\u0631 \u0645\u062d\u0644\u06cc <code>urlObjs<\/code>\u060c \u06a9\u0647 \u062a\u0648\u0633\u0637 \u0627\u0644\u06af\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.<\/p>\n<p>\u0627\u0631\u0627\u0626\u0647 \u0634\u062f\u0647 page \u0628\u0647 \u0646\u0638\u0631 \u0645\u06cc \u0631\u0633\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2024\/01\/adding-a-postgresql-database-to-a-node-js-app-on-heroku-2.png\" alt=\"app_homepage_with_db\" title=\"\"><\/p>\n<p>\u0627\u06af\u0631 \u0645\u0634\u06a9\u0644\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u062f \u062a\u06a9\u0645\u06cc\u0644 \u0634\u062f\u0647 \u0631\u0627 \u0627\u0632 \u0627\u06cc\u0646\u062c\u0627 \u062f\u0627\u0646\u0644\u0648\u062f \u06a9\u0646\u06cc\u062f <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/github.com\/tomkadwill\/url-shortener\/tree\/adding-a-postgres-database-to-a-node-app-on-heroku\">GitHub<\/a>.<\/p>\n<h2 id=\"deployingtheapptoheroku\"><span class=\"ez-toc-section\" id=\"%d8%a7%d8%b3%d8%aa%d9%82%d8%b1%d8%a7%d8%b1_%d8%a8%d8%b1%d9%86%d8%a7%d9%85%d9%87_%d8%af%d8%b1_heroku\"><\/span>\u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0631 Heroku<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u06a9\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u062d\u0644\u06cc \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f\u060c \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0631\u0648\u0634 \u0627\u062c\u0631\u0627\u06cc \u0622\u0646 \u0631\u0627 \u062a\u0648\u0636\u06cc\u062d \u0645\u06cc \u062f\u0647\u062f \u0631\u0648\u06cc Heroku \u0648 \u0631\u0648\u0634 \u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0647 \u0622\u0646 \u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627.<\/p>\n<p>\u0627\u0628\u062a\u062f\u0627\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0647\u0645\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062e\u0648\u062f \u0631\u0627 \u062f\u0631 Heroku \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> git push heroku master<\/span>\n<\/code><\/pre>\n<p>\u0628\u0631\u0627\u06cc \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u062f\u0642\u06cc\u0642 \u0628\u0647 \u0627\u0633\u062a\u0642\u0631\u0627\u0631 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 Node.js \u062f\u0631 Heroku \u0645\u0631\u0627\u062c\u0639\u0647 \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc \u0627\u0639\u0632\u0627\u0645 \u0628\u0647 \u0647\u0631\u0648\u06a9\u0648<\/p>\n<h3 id=\"connectingthedatabase\"><span class=\"ez-toc-section\" id=\"%d8%a7%d8%aa%d8%b5%d8%a7%d9%84_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87\"><\/span>\u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0641\u0632\u0648\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06a9\u0627\u0631 \u0633\u062e\u062a\u06cc \u0646\u06cc\u0633\u062a \u0648 \u062a\u0646\u0647\u0627 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u062f \u06cc\u06a9 \u062e\u0637 \u0641\u0631\u0645\u0627\u0646 \u0627\u0633\u062a:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> heroku addons:create heroku-postgresql:hobby-dev<\/span>\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631 \u0627\u0641\u0632\u0648\u0646\u0647 PostgreSQL \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.\u0631\u0648\u06cc \u0628\u0631\u0627\u06cc Heroku \u0648 \u06cc\u06a9 \u0645\u062a\u063a\u06cc\u0631 \u0645\u062d\u06cc\u0637\u06cc \u0628\u0647 \u0646\u0627\u0645 \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f <code>DATABASE_URL<\/code> &#8211; \u0641\u0642\u0637 \u0628\u0627\u06cc\u062f \u0628\u0647 Sequelize \u0628\u06af\u0648\u06cc\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0641\u0627\u06cc\u0644 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u062f:<\/p>\n<pre><code class=\"hljs\">{\n  <span class=\"hljs-attr\">\"development\"<\/span>: {\n    <span class=\"hljs-attr\">\"username\"<\/span>: <span class=\"hljs-string\">\"tomkadwill\"<\/span>,\n    <span class=\"hljs-attr\">\"password\"<\/span>: <span class=\"hljs-string\">\"password\"<\/span>,\n    <span class=\"hljs-attr\">\"database\"<\/span>: <span class=\"hljs-string\">\"urlshortener_development\"<\/span>,\n    <span class=\"hljs-attr\">\"host\"<\/span>: <span class=\"hljs-string\">\"localhost\"<\/span>,\n    <span class=\"hljs-attr\">\"dialect\"<\/span>: <span class=\"hljs-string\">\"postgres\"<\/span>,\n    <span class=\"hljs-attr\">\"operatorsAliases\"<\/span>: <span class=\"hljs-literal\">false<\/span>\n  },\n  <span class=\"hljs-attr\">\"production\"<\/span>: {\n    <span class=\"hljs-attr\">\"username\"<\/span>: <span class=\"hljs-string\">\"tomkadwill\"<\/span>,\n    <span class=\"hljs-attr\">\"password\"<\/span>: <span class=\"hljs-string\">\"password\"<\/span>,\n    <span class=\"hljs-attr\">\"database\"<\/span>: <span class=\"hljs-string\">\"urlshortener_production\"<\/span>,\n    <span class=\"hljs-attr\">\"host\"<\/span>: <span class=\"hljs-string\">\"localhost\"<\/span>,\n    <span class=\"hljs-attr\">\"dialect\"<\/span>: <span class=\"hljs-string\">\"postgres\"<\/span>,\n    <span class=\"hljs-attr\">\"operatorsAliases\"<\/span>: <span class=\"hljs-literal\">false<\/span>,\n    <span class=\"hljs-attr\">\"use_env_variable\"<\/span>: <span class=\"hljs-string\">\"DATABASE_URL\"<\/span>\n  }\n}\n<\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0627 \u06cc\u06a9 \u0628\u062e\u0634 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u062c\u062f\u06cc\u062f \u0628\u0631\u0627\u06cc \u062a\u0648\u0644\u06cc\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645\u060c \u0628\u0647 \u062c\u0632 \u0646\u0627\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 <code>use_env_variable<\/code> \u0631\u0634\u062a\u0647.<\/p>\n<p>\u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f <code>use_env_variable<\/code> \u0628\u0631\u0627\u06cc \u0648\u0627\u06a9\u0634\u06cc \u0646\u0627\u0645 \u0645\u062a\u063a\u06cc\u0631 \u0645\u062d\u06cc\u0637\u06cc \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647.<\/p>\n<p>\u0647\u06cc\u0631\u0648\u06a9\u0648 \u062f\u0627\u0631\u062f <code>NODE_ENV<\/code> \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634 \u0641\u0631\u0636 \u0631\u0648\u06cc &#8220;production&#8221; \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f\u060c \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0639\u0646\u06cc \u06a9\u0647 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u062a\u0646\u0638\u06cc\u0645\u0627\u062a \u062a\u0648\u0644\u06cc\u062f \u0645\u06cc \u0634\u0648\u062f.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0645\u062a\u0639\u0647\u062f \u0634\u0648\u06cc\u0645 \u0648 \u0628\u0647 \u0647\u0631\u0648\u06a9\u0648 \u0641\u0634\u0627\u0631 \u0628\u06cc\u0627\u0648\u0631\u06cc\u0645.<\/p>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u0628\u0627\u06cc\u062f \u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645 \u0631\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0647\u06cc\u0631\u0648\u06a9\u0648 <code>sequelize db:migrate<\/code>:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> heroku run bash<\/span>\nRunning bash \u0631\u0648\u06cc \u2b22 nameful-wolf-12818... up, run.5074 (Free)\n~ $ sequelize db:migrate\n<\/code><\/pre>\n<p>\u0627\u06af\u0631 \u0642\u0628\u0644\u0627\u064b \u0645\u0647\u0627\u062c\u0631\u062a \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0646\u06a9\u0631\u062f\u0647\u200c\u0627\u06cc\u0645\u060c \u0627\u06a9\u0646\u0648\u0646 \u0627\u0633\u06a9\u0631\u06cc\u067e\u062a\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062f\u0633\u062a\u06cc \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647\u060c \u0628\u0631\u0646\u0627\u0645\u0647 \u0628\u0627\u06cc\u062f \u062f\u0631 \u0645\u0631\u0648\u0631\u06af\u0631 \u06a9\u0627\u0631 \u06a9\u0646\u062f.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2024\/01\/adding-a-postgresql-database-to-a-node-js-app-on-heroku-3.png\" alt=\"app_homepage_with_db_on_heroku\" title=\"\"><\/p>\n<h3 id=\"managingtheherokudatabase\"><span class=\"ez-toc-section\" id=\"%d9%85%d8%af%db%8c%d8%b1%db%8c%d8%aa_%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87_%d8%af%d8%a7%d8%af%d9%87_heroku\"><\/span>\u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 Heroku<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u062d\u062a\u0645\u0627\u0644\u0627\u064b \u062f\u0631 \u0628\u0631\u062e\u06cc \u0645\u0648\u0627\u0642\u0639 \u0646\u06cc\u0627\u0632 \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u0627\u0634\u062a \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0648\u0644\u06cc\u062f \u062e\u0648\u062f \u0631\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06cc\u0627 \u0627\u0635\u0644\u0627\u062d \u06a9\u0646\u06cc\u062f.  \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0645\u06a9 \u0628\u0647 \u062a\u0634\u062e\u06cc\u0635 \u06cc\u06a9 \u0627\u0634\u06a9\u0627\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0644\u0627\u0632\u0645 \u0628\u0627\u0634\u062f \u0628\u0631\u062e\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f.  \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0628\u0628\u06cc\u0646\u06cc\u0645 \u0686\u06af\u0648\u0646\u0647 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645.<\/p>\n<h4 id=\"runningsequelizemigrationtasks\">\u0627\u062c\u0631\u0627\u06cc Sequelize Migration Tasks<\/h4>\n<p>\u0627\u0648\u0644\u06cc\u0646 \u0686\u06cc\u0632\u06cc \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u062f\u0627\u0646\u06cc\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 Sequelize migrations \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f \u0631\u0648\u06cc \u0647\u06cc\u0631\u0648\u06a9\u0648.  \u0631\u0648\u0634 \u0645\u0634\u0627\u0647\u062f\u0647 \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0645\u0648\u062c\u0648\u062f \u0628\u0647 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0627\u0633\u062a:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> heroku run bash<\/span>\nRunning bash \u0631\u0648\u06cc \u2b22 nameful-wolf-12818... up, run.1435 (Free)\n~ $ sequelize\n<\/code><\/pre>\n<p>\u0627\u06cc\u0646\u0647\u0627 \u0628\u0631\u062e\u06cc \u0627\u0632 \u0645\u0641\u06cc\u062f\u062a\u0631\u06cc\u0646 \u0622\u0646\u0647\u0627 \u0647\u0633\u062a\u0646\u062f:<\/p>\n<ul>\n<li><code>sequelize db:migrate:undo<\/code>: \u0628\u0627\u0632\u06af\u0634\u062a \u06cc\u06a9 \u0645\u0647\u0627\u062c\u0631\u062a \u0648\u0627\u062d\u062f<\/li>\n<li><code>sequelize db:migrate:undo:all<\/code>: \u0647\u0645\u0647 \u0645\u0647\u0627\u062c\u0631\u062a \u0647\u0627 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u06cc\u062f.  \u0628\u0647 \u0637\u0648\u0631 \u0645\u0648\u062b\u0631 \u0628\u0647 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0645\u06cc\u0632 \u0628\u0631\u06af\u0631\u062f\u06cc\u062f<\/li>\n<li><code>sequelize db:migrate:status<\/code>: \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0634\u0645\u0627 \u06a9\u062f\u0627\u0645 \u0645\u0647\u0627\u062c\u0631\u062a \u0627\u0633\u062a \u0631\u0648\u06cc<\/li>\n<\/ul>\n<h4 id=\"usingsequelizemodelsintheconsole\">\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Sequelize Models \u062f\u0631 \u06a9\u0646\u0633\u0648\u0644<\/h4>\n<p>\u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0648\u0638\u0627\u06cc\u0641 CLI\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u0632 \u0645\u062f\u0644\u200c\u0647\u0627\u06cc Sequelize \u0645\u0633\u062a\u0642\u06cc\u0645\u0627\u064b \u062f\u0631 Node \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 console:<\/p>\n<pre><code class=\"hljs\"><span class=\"hljs-meta\">$<\/span><span class=\"bash\"> heroku run bash<\/span>\n~ $ node\nWelcome to Node.js v12.14.0.\nType \".help\" for more information.\n<span class=\"hljs-meta\">&gt;<\/span><span class=\"bash\">\n<\/span><\/code><\/pre>\n<p>\u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0686\u0646\u062f \u0646\u0645\u0648\u0646\u0647 \u06a9\u062f \u0642\u0627\u0628\u0644 \u0627\u062c\u0631\u0627 \u062f\u0631 Node \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a console.  \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0645\u062a\u0648\u062c\u0647 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0622\u0646\u0647\u0627 \u0634\u0628\u06cc\u0647 Node REPL \u0647\u0633\u062a\u0646\u062f.<\/p>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0631\u0627\u06cc \u06cc\u06a9 URL \u0641\u0631\u062f\u06cc \u0628\u0627 \u0634\u0646\u0627\u0633\u0647:<\/p>\n<pre><code class=\"hljs\">db.Url.findByPk(<span class=\"hljs-number\">1<\/span>).then(<span class=\"hljs-function\"><span class=\"hljs-params\">url<\/span> =&gt;<\/span> {\n  <span class=\"hljs-built_in\">console<\/span>.log(\n    url.get({<span class=\"hljs-attr\">plain<\/span>: <span class=\"hljs-literal\">true<\/span>})\n  );\n});\n<\/code><\/pre>\n<p>\u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0628\u0631\u0627\u06cc \u0647\u0645\u0647 \u0622\u062f\u0631\u0633\u200c\u0647\u0627\u06cc \u0627\u06cc\u0646\u062a\u0631\u0646\u062a\u06cc:<\/p>\n<pre><code class=\"hljs\">db.Url.findAll().then(<span class=\"hljs-function\"><span class=\"hljs-params\">urls<\/span> =&gt;<\/span> {\n  urls.map(<span class=\"hljs-function\"><span class=\"hljs-params\">url<\/span> =&gt;<\/span> {\n    <span class=\"hljs-built_in\">console<\/span>.log(\n      url.get({<span class=\"hljs-attr\">plain<\/span>: <span class=\"hljs-literal\">true<\/span>})\n    );\n  });\n});\n<\/code><\/pre>\n<p>\u062f\u0631\u062c \u0631\u06a9\u0648\u0631\u062f URL:<\/p>\n<pre><code class=\"hljs\">db.Url.create({<span class=\"hljs-attr\">url<\/span>: <span class=\"hljs-string\">'https:\/\/rasanegar.com\/deploying-a-node-js-app-to-heroku'<\/span>, <span class=\"hljs-attr\">shortUrl<\/span>: <span class=\"hljs-string\">'https:\/\/is.gd\/56bEH3'<\/span>});\n<\/code><\/pre>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0631\u0627\u06cc \u06cc\u06a9 URL \u0628\u0627 \u0634\u0646\u0627\u0633\u0647 \u0648 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0622\u0646:<\/p>\n<pre><code class=\"hljs\">db.Url.findByPk(<span class=\"hljs-number\">1<\/span>).then(<span class=\"hljs-function\"><span class=\"hljs-params\">url<\/span> =&gt;<\/span> {\n  url.shortUrl = <span class=\"hljs-string\">'example.com'<\/span>;\n  url.save();\n});\n<\/code><\/pre>\n<p>\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0631\u0627\u06cc \u06cc\u06a9 URL \u0628\u0627 \u0634\u0646\u0627\u0633\u0647 \u0648 \u062d\u0630\u0641 \u0622\u0646:<\/p>\n<pre><code class=\"hljs\">db.Url.findByPk(<span class=\"hljs-number\">1<\/span>).then(<span class=\"hljs-function\"><span class=\"hljs-params\">url<\/span> =&gt;<\/span> {\n  url.destroy();\n});\n<\/code><\/pre>\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>\u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627\u06cc \u0645\u062a\u0639\u062f\u062f\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u06af\u0633\u062a\u0631\u0634 Heroku \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f.  \u06cc\u06a9\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627 Heroku Postgres \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0645\u0627 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0633\u0627\u062f\u0647 Node \u0648 Express \u0631\u0627 \u06af\u0633\u062a\u0631\u0634 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u062a\u0627 url \u0647\u0627 \u0631\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 Postgres \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u062f. \u0631\u0648\u06cc \u0647\u06cc\u0631\u0648\u06a9\u0648.<\/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-22 05:52:04<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;16216&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\u0641\u0632\u0648\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 Node.js \u0631\u0648\u06cc HerokuHeroku \u06cc\u06a9 \u0633\u0631\u0648\u06cc\u0633 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc Node.js \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a \u0648 \u0639\u0645\u0644\u06a9\u0631\u062f \u0622\u0646 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0627\u062f.  \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0686\u06cc\u0632\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u067e\u06cc\u0627\u0645\u200c\u0631\u0633\u0627\u0646\u06cc\\\/\u0635\u0641\u200c\u0647\u0627\u060c \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645\u060c \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u0648 \u0627\u0644\u0628\u062a\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.  \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062d\u0628\u0648\u0628 \u0645\u0627\u0646\u0646\u062f PostgreSQL\u060c Redis \u0648 ... \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f.&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\"> 8<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span>\u0645\u0639\u0631\u0641\u06cc Heroku \u06cc\u06a9 \u0633\u0631\u0648\u06cc\u0633 \u0645\u06cc\u0632\u0628\u0627\u0646\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc Node.js \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0622\u0633\u0627\u0646 \u0627\u0633\u062a \u0648 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0622\u0646 \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0627\u062f \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627. \u0627\u0641\u0632\u0648\u0646\u0647\u200c\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0686\u06cc\u0632\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u067e\u06cc\u0627\u0645\u200c\u0631\u0633\u0627\u0646\u06cc\/\u0635\u0641\u200c\u0647\u0627\u060c \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645\u060c \u0645\u0639\u06cc\u0627\u0631\u0647\u0627 \u0648 \u0627\u0644\u0628\u062a\u0647 \u0630\u062e\u06cc\u0631\u0647\u200c\u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f. \u0627\u0641\u0632\u0648\u0646\u0647 \u0647\u0627\u06cc \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062d\u0628\u0648\u0628 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":16217,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1772,620],"tags":[],"class_list":["post-16216","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\/16216","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=16216"}],"version-history":[{"count":0,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/16216\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media\/16217"}],"wp:attachment":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media?parent=16216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/categories?post=16216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/tags?post=16216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}