{"id":31724,"date":"2023-07-23T21:16:32","date_gmt":"2023-07-23T17:46:32","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/"},"modified":"2023-07-23T21:16:32","modified_gmt":"2023-07-23T17:46:32","slug":"query-materialized-views-with-java-spring-and-streaming-database-2bd1","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/","title":{"rendered":"\u0646\u0645\u0627\u0647\u0627 \u0631\u0627 \u0628\u0627 \u062c\u0627\u0648\u0627\u060c Spring \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0631\u06cc\u0645 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f"},"content":{"rendered":"<div data-article-id=\"1493538\" id=\"article-body\">\n<p>\u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u0627\u0628\u0632\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0646\u062a\u0627\u06cc\u062c \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0627\u0632 \u0642\u0628\u0644 \u0645\u062d\u0627\u0633\u0628\u0647 \u0648 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u0646\u062f\u060c \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0645\u06cc \u0628\u062e\u0634\u062f \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u06af\u0631\u0627\u0646 \u0642\u06cc\u0645\u062a \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0645\u062f\u0631\u0646 \u0648 \u0633\u0631\u06cc\u0639\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0647 \u0637\u0648\u0631 \u0645\u06a9\u0631\u0631 \u062a\u063a\u06cc\u06cc\u0631 \u06a9\u0646\u0646\u062f\u060c \u06a9\u0647 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc\u200c\u0647\u0627\u06cc \u0645\u06a9\u0631\u0631 \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u062f\u0627\u0631\u062f.  \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u0631\u06cc\u0627\u0646\u06cc \u0645\u0627 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0645\u06cc \u0633\u0627\u0632\u062f <strong>\u0628\u0647 \u0637\u0648\u0631 \u0645\u062f\u0627\u0648\u0645 \u0628\u0644\u0639\u06cc\u062f\u0646<\/strong> \u0648 \u062d\u062c\u0645 \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u06a9\u0646\u062f.  \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0647 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u067e\u0631\u062f\u0627\u062e\u062a <strong>\u0646\u062d\u0648\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0628\u0627 \u062c\u0627\u0648\u0627\u060c Spring \u0648 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0631\u06cc\u0645<\/strong> \u0645\u0627\u0646\u0646\u062f RisingWave.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<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:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D8%A7%D9%87%D8%AF%D8%A7%D9%81_%DB%8C%D8%A7%D8%AF%DA%AF%DB%8C%D8%B1%DB%8C\" >\u0627\u0647\u062f\u0627\u0641 \u06cc\u0627\u062f\u06af\u06cc\u0631\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:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%85%D8%AD%D8%AA%D9%88%D8%A7%DB%8C_%D9%BE%DB%8C%D8%B4%D9%86%D9%87%D8%A7%D8%AF%DB%8C\" >\u0645\u062d\u062a\u0648\u0627\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D8%B3%D9%86%D8%A7%D8%B1%DB%8C%D9%88%DB%8C_%D9%86%D9%85%D9%88%D9%86%D9%87_%D8%AA%D8%AC%D8%B2%DB%8C%D9%87_%D9%88_%D8%AA%D8%AD%D9%84%DB%8C%D9%84_%D8%B9%D9%85%D9%84%DA%A9%D8%B1%D8%AF_%D8%AA%D8%AD%D9%88%DB%8C%D9%84_%D8%B3%D9%81%D8%A7%D8%B1%D8%B4\" >\u0633\u0646\u0627\u0631\u06cc\u0648\u06cc \u0646\u0645\u0648\u0646\u0647: \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%86%D9%85%D8%A7%DB%8C%D8%B4_%D9%86%D9%85%D8%A7%DB%8C%D8%B4%DB%8C_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D8%AA%D8%AD%D9%82%D9%82_%DB%8C%D8%A7%D9%81%D8%AA%D9%87_%D8%B1%D8%A7_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0646\u0645\u0627\u06cc\u0634 \u0646\u0645\u0627\u06cc\u0634\u06cc \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%82%D8%A8%D9%84_%D8%A7%D8%B2_%D8%A7%DB%8C%D9%86%DA%A9%D9%87_%D8%B4%D8%B1%D9%88%D8%B9_%DA%A9%D9%86%DB%8C\" >\u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_1_%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%D8%AF%D9%85%D9%88_%DA%A9%D9%84%D8%A7%D8%B3%D8%AA%D8%B1\" >\u0645\u0631\u062d\u0644\u0647 1: \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u062f\u0645\u0648 \u06a9\u0644\u0627\u0633\u062a\u0631<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_2_%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87_Spring_Boot_%D8%B1%D8%A7_%DA%A9%D9%BE%DB%8C_%DA%A9%D8%B1%D8%AF%D9%87_%D9%88_%D8%A8%D8%A7%D8%B2_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 2: \u0628\u0631\u0646\u0627\u0645\u0647 Spring Boot \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_3_%D9%BE%D8%B1%D9%88%DA%98%D9%87_%D8%B1%D8%A7_%D9%86%D8%B5%D8%A8_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 3: \u067e\u0631\u0648\u0698\u0647 \u0631\u0627 \u0646\u0635\u0628 \u06a9\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:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D9%85%D8%B1%D8%AD%D9%84%D9%87_4_%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87_%D8%AF%D9%85%D9%88_RisingWave_%D8%B1%D8%A7_%D8%A7%D8%AC%D8%B1%D8%A7_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0645\u0631\u062d\u0644\u0647 4: \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0645\u0648 RisingWave \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\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:\/\/nabfollower.com\/blog\/query-materialized-views-with-java-spring-and-streaming-database-2bd1\/#%D8%AA%D9%81%DA%A9%DB%8C%DA%A9_%D9%81%D8%A7%DB%8C%D9%84_%D9%87%D8%A7%DB%8C_%D9%BE%D8%B1%D9%88%DA%98%D9%87\" >\u062a\u0641\u06a9\u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u067e\u0631\u0648\u0698\u0647<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%A7%D9%87%D8%AF%D8%A7%D9%81_%DB%8C%D8%A7%D8%AF%DA%AF%DB%8C%D8%B1%DB%8C\"><\/span>\n<p>  \u0627\u0647\u062f\u0627\u0641 \u06cc\u0627\u062f\u06af\u06cc\u0631\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0637\u0648\u0644 \u0645\u0642\u0627\u0644\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u062f \u0622\u0645\u0648\u062e\u062a:<\/p>\n<ul>\n<li>\u0646\u062d\u0648\u0647 \u062c\u0630\u0628 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627 \u0648 \u0627\u062c\u0631\u0627\u06cc \u062c\u0633\u062a\u0627\u0631\u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af.<\/li>\n<li>\u0646\u062d\u0648\u0647 \u0627\u06cc\u062c\u0627\u062f \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0631\u06cc\u0645<\/li>\n<li>\u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u062c\u0627\u0648\u0627 \u0628\u0633\u0627\u0632\u06cc\u062f \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0645\u06cc \u062e\u0648\u0627\u0646\u062f \u0648 \u062f\u0631 \u0645\u0639\u0631\u0636 \u062f\u06cc\u062f \u0642\u0631\u0627\u0631 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D8%AD%D8%AA%D9%88%D8%A7%DB%8C_%D9%BE%DB%8C%D8%B4%D9%86%D9%87%D8%A7%D8%AF%DB%8C\"><\/span>\n<p>  \u0645\u062d\u062a\u0648\u0627\u06cc \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u062f\u0627\u0645\u0647 \u0627\u06cc\u0646 \u067e\u0633\u062a\u060c \u0627\u06a9\u06cc\u062f\u0627\u064b \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc\u200c\u06a9\u0646\u0645 \u067e\u0633\u062a\u200c\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u0645 \u0631\u0627 \u0646\u06cc\u0632 \u0628\u062e\u0648\u0627\u0646\u06cc\u062f \u062a\u0627 \u0645\u062a\u0648\u062c\u0647 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647\u200c\u0627\u06cc \u062c\u0631\u06cc\u0627\u0646\u06cc \u0628\u0627 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0646\u062a\u06cc \u0686\u0647 \u062a\u0641\u0627\u0648\u062a\u06cc \u062f\u0627\u0631\u062f\u060c \u0686\u0631\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u0627\u062f\u06cc\u062a\u200c\u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633\u200c\u0648\u062c\u0648 \u0627\u0632 \u0645\u06cc\u06a9\u0631\u0648\u0633\u0631\u0648\u06cc\u0633\u200c\u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645\u060c \u0648 \u0686\u06af\u0648\u0646\u0647 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0631\u0627 \u062f\u0631 \u06a9\u0627\u0641\u06a9\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u0645.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B3%D9%86%D8%A7%D8%B1%DB%8C%D9%88%DB%8C_%D9%86%D9%85%D9%88%D9%86%D9%87_%D8%AA%D8%AC%D8%B2%DB%8C%D9%87_%D9%88_%D8%AA%D8%AD%D9%84%DB%8C%D9%84_%D8%B9%D9%85%D9%84%DA%A9%D8%B1%D8%AF_%D8%AA%D8%AD%D9%88%DB%8C%D9%84_%D8%B3%D9%81%D8%A7%D8%B1%D8%B4\"><\/span>\n<p>  \u0633\u0646\u0627\u0631\u06cc\u0648\u06cc \u0646\u0645\u0648\u0646\u0647: \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0639\u0645\u0644\u06a9\u0631\u062f \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634 \u06cc\u06a9 \u0645\u0639\u06cc\u0627\u0631 \u0628\u0633\u06cc\u0627\u0631 \u0645\u0647\u0645 \u0628\u0631\u0627\u06cc \u0647\u0631 \u06a9\u0633\u0628 \u0648 \u06a9\u0627\u0631\u06cc \u0627\u0633\u062a \u06a9\u0647 \u0645\u062d\u0635\u0648\u0644\u0627\u062a \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0622\u0646\u0644\u0627\u06cc\u0646 \u0645\u06cc \u0641\u0631\u0648\u0634\u062f.  \u0627\u06cc\u0646 \u0646\u0634\u0627\u0646 \u062f\u0647\u0646\u062f\u0647 \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0648 \u0627\u062b\u0631\u0628\u062e\u0634\u06cc \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u0646\u062c\u0627\u0645 \u0633\u0641\u0627\u0631\u0634 \u0627\u0633\u062a \u0648 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0633\u062a\u0642\u06cc\u0645 \u0628\u0631 \u0631\u0636\u0627\u06cc\u062a \u0645\u0634\u062a\u0631\u06cc \u062a\u0623\u062b\u06cc\u0631 \u0645\u06cc \u06af\u0630\u0627\u0631\u062f.  \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634\u060c \u06a9\u0633\u0628\u200c\u0648\u06a9\u0627\u0631\u0647\u0627 \u0628\u0627\u06cc\u062f \u0634\u0627\u062e\u0635\u200c\u0647\u0627\u06cc \u06a9\u0644\u06cc\u062f\u06cc \u0639\u0645\u0644\u06a9\u0631\u062f (KPI) \u0645\u0627\u0646\u0646\u062f \u0632\u0645\u0627\u0646 \u062a\u062d\u0648\u06cc\u0644\u060c \u062f\u0642\u062a \u0633\u0641\u0627\u0631\u0634 \u0648 \u0647\u0632\u06cc\u0646\u0647 \u062a\u062d\u0648\u06cc\u0644 \u0631\u0627 \u0631\u062f\u06cc\u0627\u0628\u06cc \u06a9\u0646\u0646\u062f.  \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647\u060c \u0645\u0627 \u06cc\u06a9 \u0646\u0645\u0648\u0646\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634 (\u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u062f \u0645\u0646\u0628\u0639 \u0631\u0627 \u062f\u0631 GitHub \u0628\u06cc\u0627\u0628\u06cc\u062f) \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062c\u0627\u0648\u0627 \u0648 Spring Boot \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u0631\u06cc\u0627\u0646 \u0648 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0639\u0645\u0644\u06a9\u0631\u062f \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634 \u063a\u0630\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u06cc\u0627\u062f \u0645\u06cc\u200c\u06af\u06cc\u0631\u06cc\u0645.<\/p>\n<p>\u0646\u0645\u0648\u062f\u0627\u0631 \u0645\u0639\u0645\u0627\u0631\u06cc \u0632\u06cc\u0631 \u06a9\u0647 \u062c\u0631\u06cc\u0627\u0646 \u06a9\u0644\u06cc \u062f\u0627\u062f\u0647 \u0631\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n<p><\/p>\n<ol>\n<li>\u0645\u0627 \u06cc\u06a9 \u0645\u0648\u0636\u0648\u0639 \u06a9\u0627\u0641\u06a9\u0627 \u062f\u0627\u0631\u06cc\u0645 \u0628\u0647 \u0646\u0627\u0645 <code>delivery_orders<\/code> \u06a9\u0647 \u0634\u0627\u0645\u0644 \u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc\u06cc \u0628\u0631\u0627\u06cc \u0647\u0631 \u0633\u0641\u0627\u0631\u0634\u06cc \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u06cc\u06a9 \u0648\u0628 \u0633\u0627\u06cc\u062a \u062a\u062d\u0648\u06cc\u0644 \u063a\u0630\u0627 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f.  \u0647\u0631 \u0631\u0648\u06cc\u062f\u0627\u062f \u0634\u0627\u0645\u0644 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0633\u0641\u0627\u0631\u0634\u060c \u0645\u0627\u0646\u0646\u062f <code>order ID<\/code>\u060c <code>restaurant ID<\/code>\u060c \u0648 <code>delivery status<\/code>.  \u0645\u0648\u0644\u062f \u0628\u0627\u0631 \u06a9\u0627\u0631\u06cc (\u0627\u0633\u06a9\u0631\u06cc\u067e\u062a \u067e\u0627\u06cc\u062a\u0648\u0646 \u0628\u0647 \u0646\u0627\u0645 Datagen) \u062a\u0648\u0644\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u06af\u06cc \u062a\u0635\u0627\u062f\u0641\u06cc \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u062f\u0627\u0648\u0645 \u0634\u0628\u06cc\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0622\u0646\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627 \u067e\u062e\u0634 \u0645\u06cc\u200c\u06a9\u0646\u062f.  \u062f\u0631 \u0648\u0627\u0642\u0639\u060c \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u06af\u06cc \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0627 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062f\u0631\u06cc\u0627\u0641\u062a\u06cc \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0631\u062f.<\/li>\n<li>\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u06cc\u0645\u06cc\u0646\u06af RisingWave \u0628\u0647 \u06cc\u06a9 \u06a9\u0627\u0631\u06af\u0632\u0627\u0631 \u06a9\u0627\u0641\u06a9\u0627 \u0645\u062a\u0635\u0644 \u0645\u06cc \u0634\u0648\u062f \u0648 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0627\u0628\u0637 \u06a9\u0627\u0641\u06a9\u0627 \u0645\u06cc \u062e\u0648\u0627\u0646\u062f.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0645\u0646\u0628\u0639 \u062f\u0631 \u062c\u062f\u0648\u0644 RisingWave \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>RisingWave \u0628\u0647 \u0645\u0627 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0631\u0627 \u0645\u06cc \u062f\u0647\u062f <strong>\u062c\u0633\u062a\u062c\u0648\u06cc \u062c\u0631\u06cc\u0627\u0646 \u062f\u0627\u062f\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL<\/strong> \u0648 \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 <strong>\u0627\u06cc\u062c\u0627\u062f \u062f\u06cc\u062f\u06af\u0627\u0647 \u0647\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647<\/strong> \u06a9\u0647 \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0628\u0627 \u06a9\u0627\u0647\u0634 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0627\u062a\u0635\u0627\u0644 \u0648 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u06af\u0631\u0627\u0646 \u0642\u06cc\u0645\u062a \u0628\u0647\u06cc\u0646\u0647 \u0634\u062f\u0647 \u0627\u0646\u062f.  \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0634\u062f\u0647 \u062f\u0631 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f <strong>\u0628\u0627 \u0631\u0633\u06cc\u062f\u0646 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062c\u062f\u06cc\u062f \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0628\u0647 \u0631\u0648\u0632 \u0645\u06cc \u0634\u0648\u062f<\/strong>.\n<\/li>\n<li>\u0633\u067e\u0633\u060c \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u0627\u0632 \u0646\u0645\u0648\u0646\u0647 Spring boot Web API \u062c\u0633\u062a\u062c\u0648 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/li>\n<\/ol>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C%D8%B4_%D9%86%D9%85%D8%A7%DB%8C%D8%B4%DB%8C_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D8%AA%D8%AD%D9%82%D9%82_%DB%8C%D8%A7%D9%81%D8%AA%D9%87_%D8%B1%D8%A7_%D9%BE%D8%B1%D8%B3_%D9%88_%D8%AC%D9%88_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc\u0634 \u0646\u0645\u0627\u06cc\u0634\u06cc \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0641\u0631\u0636 \u06a9\u0646\u06cc\u0645 \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0628\u0647 \u0646\u0627\u0645 restaurant_orders_view \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u062a\u0639\u062f\u0627\u062f \u06a9\u0644 \u0633\u0641\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0632 \u0631\u0633\u062a\u0648\u0631\u0627\u0646\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062f\u0631 15 \u062f\u0642\u06cc\u0642\u0647 \u06af\u0630\u0634\u062a\u0647 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0645\u062d\u0627\u0633\u0628\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f.  \u0627\u06a9\u0646\u0648\u0646 \u0648\u0638\u06cc\u0641\u0647 \u0645\u0627 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0627\u06cc\u0646 \u0646\u062a\u06cc\u062c\u0647 \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc API \u062f\u0631 \u06cc\u06a9 \u0633\u0631\u0648\u06cc\u0633 \u0633\u0641\u0627\u0631\u0634 \u062f\u0631 \u0645\u0639\u0631\u0636 \u062f\u06cc\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645 <code>\/orders\/count-total-restaurant-orders<\/code>.  \u062f\u0631 \u062c\u0627\u0648\u0627\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 JDBC\u060c \u06a9\u0647 \u06cc\u06a9 API \u062c\u0627\u0648\u0627 \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u060c \u0646\u0645\u0627\u0647\u0627\u06cc \u062a\u062d\u0642\u0642\u200c\u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f.  \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0627\u06cc\u0646\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 Spring Framework \u0628\u0631\u0627\u06cc \u0633\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0641\u0631\u0622\u06cc\u0646\u062f \u06a9\u0627\u0631 \u0628\u0627 JDBC \u0648 \u0627\u06cc\u062c\u0627\u062f \u06cc\u06a9 REST API \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<blockquote>\n<p>\u0627\u0632 \u0622\u0646\u062c\u0627\u06cc\u06cc \u06a9\u0647 RisingWave \u0628\u0627 PostgreSQL \u0633\u0627\u0632\u06af\u0627\u0631 \u0627\u0633\u062a\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062f\u0631\u0627\u06cc\u0648\u0631 PostgreSQL JDBC \u0628\u0631\u0627\u06cc \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 RisingWave \u0648 \u062a\u0639\u0627\u0645\u0644 \u0628\u0627 RisingWave \u0627\u0632 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u062c\u0627\u0648\u0627 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.  \u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u06a9\u062a\u0627\u0628\u062e\u0627\u0646\u0647 \u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u06a9\u0644\u0627\u06cc\u0646\u062a \u0647\u0627 \u0628\u0631\u0627\u06cc \u0632\u0628\u0627\u0646 \u0647\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u0645\u062e\u062a\u0644\u0641 (NodeJS\u060c Python \u0648 Go) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/blockquote>\n<p>\u0628\u062e\u0634 \u0647\u0627\u06cc \u0628\u0639\u062f\u06cc \u06cc\u06a9 \u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u06af\u0627\u0645 \u0628\u0647 \u06af\u0627\u0645 \u0628\u0631\u0627\u06cc \u062c\u0633\u062a\u062c\u0648\u06cc \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u062f\u0631 \u062c\u0627\u0648\u0627 \u0648 Spring \u0628\u0647 \u0634\u0645\u0627 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%82%D8%A8%D9%84_%D8%A7%D8%B2_%D8%A7%DB%8C%D9%86%DA%A9%D9%87_%D8%B4%D8%B1%D9%88%D8%B9_%DA%A9%D9%86%DB%8C\"><\/span>\n<p>  <strong>\u0642\u0628\u0644 \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc<\/strong><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0634\u0627\u0645\u0644 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u062f\u0648 \u067e\u0631\u0648\u0698\u0647 \u0627\u0633\u062a:<\/p>\n<ul>\n<li>\u0645\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u0645\u062d\u0644\u06cc \u062e\u0648\u062f\u060c \u062e\u0648\u0634\u0647 \u0646\u0645\u0627\u06cc\u0634\u06cc \u0628\u0627 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u06a9\u0627\u0645\u0644 RisingWave \u0645\u0648\u062c\u0648\u062f \u062f\u0631 GitHub \u0631\u0627 \u06a9\u0647 \u0627\u0632 \u0686\u0646\u062f\u06cc\u0646 \u0645\u0624\u0644\u0641\u0647 RisingWave \u062a\u0634\u06a9\u06cc\u0644 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0628\u0627\u0632 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.  \u0628\u0631\u0627\u06cc \u0633\u0627\u062f\u0647 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u06a9\u0627\u0631\u060c \u0627\u0632 \u0641\u0627\u06cc\u0644 docker-compose.yaml \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u06a9\u0647 \u0634\u0627\u0645\u0644 \u06a9\u0627\u0646\u062a\u06cc\u0646\u0631\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631\u06af\u0632\u0627\u0631 \u067e\u06cc\u0627\u0645 \u06a9\u0627\u0641\u06a9\u0627 \u0648 \u0633\u0631\u0648\u06cc\u0633 \u062a\u0648\u0644\u06cc\u062f \u062f\u0627\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u0627\u067e\u0644\u06cc\u06a9\u06cc\u0634\u0646 Spring boot\u060c \u06cc\u06a9 \u067e\u0631\u0648\u0698\u0647 Maven \u0628\u0627 \u0648\u0627\u0628\u0633\u062a\u06af\u06cc \u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u0648 \u0645\u0627 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0645\u062d\u0644\u06cc \u0646\u06cc\u0632 \u0627\u062c\u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/li>\n<\/ul>\n<p>\u0628\u0631\u0627\u06cc \u062a\u06a9\u0645\u06cc\u0644 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_1_%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%D8%AF%D9%85%D9%88_%DA%A9%D9%84%D8%A7%D8%B3%D8%AA%D8%B1\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 1: \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u062f\u0645\u0648 \u06a9\u0644\u0627\u0633\u062a\u0631<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0628\u062a\u062f\u0627 \u0645\u062e\u0632\u0646 RisingWave \u0631\u0627 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u0645\u062d\u0644\u06cc \u062e\u0648\u062f \u06a9\u0644\u0648\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>git clone https:\/\/github.com\/risingwavelabs\/risingwave.git\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u067e\u0633\u060c \u0628\u0647 \u0645\u0633\u06cc\u0631 \u0628\u0631\u0648\u06cc\u062f <code>integration_tests\/delivery<\/code> \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0648 \u06a9\u0644\u0627\u0633\u062a\u0631 \u062f\u0645\u0648 \u0631\u0627 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0646\u0648\u0634\u062a\u0646 docker \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code><span class=\"nb\">cd <\/span>risingwave\/integration_tests\/delivery\ndocker compose up <span class=\"nt\">-d<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0647\u0645\u0647 \u06a9\u0627\u0646\u062a\u06cc\u0646\u0631\u0647\u0627 \u0622\u0645\u0627\u062f\u0647 \u0648 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u0646\u062f!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_2_%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87_Spring_Boot_%D8%B1%D8%A7_%DA%A9%D9%BE%DB%8C_%DA%A9%D8%B1%D8%AF%D9%87_%D9%88_%D8%A8%D8%A7%D8%B2_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 2: \u0628\u0631\u0646\u0627\u0645\u0647 Spring Boot \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0631\u06cc\u0645 \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u0634\u062f\u060c \u0628\u0631\u0646\u0627\u0645\u0647 Spring Boot \u062e\u0648\u062f \u0631\u0627 \u0627\u062c\u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.  \u0647\u0645\u0686\u0646\u06cc\u0646\u060c \u067e\u0631\u0648\u0698\u0647 \u0631\u0627 \u0641\u0648\u0631\u06a9\/\u06a9\u0644\u0648\u0646 \u06a9\u0646\u06cc\u062f \u0648 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u062c\u0627\u0648\u0627 \u062e\u0648\u062f \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>git clone https:\/\/github.com\/Boburmirzo\/risingwave-java-spring.git\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_3_%D9%BE%D8%B1%D9%88%DA%98%D9%87_%D8%B1%D8%A7_%D9%86%D8%B5%D8%A8_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 3: \u067e\u0631\u0648\u0698\u0647 \u0631\u0627 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f.<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0633\u067e\u0633 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f <code>mvn clean install<\/code> \u0627\u0632 \u067e\u0648\u0634\u0647 \u0631\u06cc\u0634\u0647 \u067e\u0631\u0648\u0698\u0647  \u062f\u0631 \u0645\u0627\u0648\u0646 <code>pom.xml<\/code> \u0641\u0627\u06cc\u0644 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u06cc\u0645 <code>postgresql<\/code> \u0648\u0627\u0628\u0633\u062a\u06af\u06cc \u0648 <code>spring-boot-starter-jdbc<\/code> \u0648\u0627\u0628\u0633\u062a\u06af\u06cc \u0631\u0627\u0646\u0646\u062f\u0647 \u0628\u0647 \u067e\u0631\u0648\u0698\u0647 \u0645\u0627  \u0627\u06cc\u0646 \u0648\u0627\u0628\u0633\u062a\u06af\u06cc \u0647\u0627 \u06a9\u0644\u0627\u0633 \u0647\u0627 \u0648 \u0631\u0627\u0628\u0637 \u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0627\u0631 \u0628\u0627 JDBC \u062f\u0631 \u0628\u0647\u0627\u0631 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D9%85%D8%B1%D8%AD%D9%84%D9%87_4_%D8%A8%D8%B1%D9%86%D8%A7%D9%85%D9%87_%D8%AF%D9%85%D9%88_RisingWave_%D8%B1%D8%A7_%D8%A7%D8%AC%D8%B1%D8%A7_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0645\u0631\u062d\u0644\u0647 4: \u0628\u0631\u0646\u0627\u0645\u0647 \u062f\u0645\u0648 RisingWave \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f.<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 DemoRisingWaveApplication.java \u0627\u0635\u0644\u06cc \u062e\u0648\u062f \u0631\u0627 \u0627\u0632 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u0645.  \u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627\u06cc \u0628\u0631\u0646\u0627\u0645\u0647\u060c \u0628\u0647 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc \u062f\u0631 \u067e\u0648\u0631\u062a \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u0645\u06cc \u06a9\u0646\u06cc\u062f <code>8080<\/code> \u06cc\u0627 \u0627\u06cc\u0646 URL \u0631\u0627 \u062f\u0631 \u0645\u0631\u0648\u0631\u06af\u0631 \u062e\u0648\u062f \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f.  http:\/\/localhost:8080\/orders\/count-total-restaurant-orders.  \u0634\u0645\u0627 \u067e\u0627\u0633\u062e \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0631\u0627 \u0627\u0632 RisingWave \u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code><span class=\"o\">[[<\/span><span class=\"s2\">\"2023-05-06T05:28:00.000+00:00\"<\/span>,1,1],[<span class=\"s2\">\"2023-05-06T05:33:00.000+00:00\"<\/span>,1,3...]]\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AA%D9%81%DA%A9%DB%8C%DA%A9_%D9%81%D8%A7%DB%8C%D9%84_%D9%87%D8%A7%DB%8C_%D9%BE%D8%B1%D9%88%DA%98%D9%87\"><\/span>\n<p>  \u062a\u0641\u06a9\u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u067e\u0631\u0648\u0698\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u0686\u0646\u062f \u0641\u0627\u06cc\u0644 \u0645\u0647\u0645 \u062f\u0631 \u067e\u0631\u0648\u0698\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u062f\u0631\u06a9 \u0647\u0631 \u0646\u0642\u0634 \u062a\u062c\u0632\u06cc\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n<p><strong>\u0628\u0647 RisingWave \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f<\/strong><\/p>\n<p>\u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0632 \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 Spring Boot\u060c \u0627\u0628\u062a\u062f\u0627 \u0628\u0627\u06cc\u062f \u0628\u0627 \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u0641\u0627\u06cc\u0644 Spring Boot application.yml \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u0631\u06cc\u0627\u0646 \u0628\u0631\u0642\u0631\u0627\u0631 \u06a9\u0646\u06cc\u062f.  \u0631\u0627 <strong><code>datasource<\/code><\/strong>  \u0628\u062e\u0634 \u06cc\u06a9 \u0627\u062a\u0635\u0627\u0644 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0628\u0627 URL \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 RisingWave \u062a\u0646\u0638\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f <code>jdbc:postgresql:\/\/localhost:4566\/dev<\/code> (\u0628\u0647 \u0627\u0644\u0641 \u0627\u0634\u0627\u0631\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>dev<\/code> \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062f\u0631 \u062d\u0627\u0644 \u0627\u062c\u0631\u0627 \u0628\u0631 \u0631\u0648\u06cc \u062e\u0648\u0634\u0647 \u0622\u0632\u0645\u0627\u06cc\u0634\u06cc RisingWave \u0645\u0627)\u060c \u06cc\u06a9 \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc &#8220;root&#8221; \u0648 \u06cc\u06a9 \u0631\u0645\u0632 \u0639\u0628\u0648\u0631 \u062e\u0627\u0644\u06cc.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight yaml\"><code><span class=\"na\">server<\/span><span class=\"pi\">:<\/span>\n  <span class=\"na\">port<\/span><span class=\"pi\">:<\/span> <span class=\"m\">8080<\/span>\n<span class=\"na\">spring<\/span><span class=\"pi\">:<\/span>\n  <span class=\"na\">profiles<\/span><span class=\"pi\">:<\/span>\n    <span class=\"na\">active<\/span><span class=\"pi\">:<\/span> <span class=\"s\">dev<\/span>\n  <span class=\"na\">application<\/span><span class=\"pi\">:<\/span>\n    <span class=\"na\">name<\/span><span class=\"pi\">:<\/span> <span class=\"s\">materialized-view-api<\/span>\n  <span class=\"na\">datasource<\/span><span class=\"pi\">:<\/span>\n    <span class=\"na\">url<\/span><span class=\"pi\">:<\/span> <span class=\"s\">jdbc:postgresql:\/\/localhost:4566\/dev<\/span>\n    <span class=\"na\">username<\/span><span class=\"pi\">:<\/span> <span class=\"s\">root<\/span>\n    <span class=\"na\">password<\/span><span class=\"pi\">:<\/span>\n<span class=\"nn\">...<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u06cc\u06a9 \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647 \u0648 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/strong><\/p>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0628\u0639\u062f\u060c \u062f\u0631 \u0641\u0627\u06cc\u0644 Startup.java\u060c \u0645\u0627 \u0633\u0647 \u062f\u0633\u062a\u0648\u0631 SQL \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u0647\u0646\u06af\u0627\u0645 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u0628\u0631\u0646\u0627\u0645\u0647 Spring Boot \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0645\u0646\u0628\u0639\u06cc \u0628\u0647\u200c\u0639\u0646\u0648\u0627\u0646 Kafka \u062f\u0631 RisingWave\u060c \u0631\u0647\u0627 \u06a9\u0631\u062f\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0645\u0648\u062c\u0648\u062f\u060c \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u0648 <strong>\u0645\u0648\u0627\u0631\u062f \u062c\u062f\u06cc\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/strong> \u0628\u0627 \u062e\u0648\u0627\u0646\u062f\u0646 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0641\u0627\u06cc\u0644 view.json \u062f\u0631 \u0641\u0647\u0631\u0633\u062a \u0645\u0646\u0627\u0628\u0639 \u0628\u0631\u0646\u0627\u0645\u0647 \u06a9\u0647 \u062d\u0627\u0648\u06cc \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u0646\u0645\u0627\u0647\u0627\u06cc \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0627\u0633\u062a.  \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u062f\u0631 \u0632\u06cc\u0631 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 SQL \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u062c\u062f\u0648\u0644\u06cc \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f <strong><code>delivery_orders_source<\/code><\/strong>  \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u0631\u06cc\u0627\u0646 RisingWave.  \u062c\u062f\u0648\u0644 \u062f\u0627\u0631\u0627\u06cc \u0686\u0647\u0627\u0631 \u0633\u062a\u0648\u0646 \u0627\u0633\u062a: <strong><code>order_id<\/code><\/strong>\u060c <strong><code>restaurant_id<\/code><\/strong>\u060c <strong><code>order_state<\/code><\/strong>\u060c \u0648 <strong><code>order_timestamp<\/code><\/strong>.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"kd\">public<\/span> <span class=\"kd\">static<\/span> <span class=\"kd\">final<\/span> <span class=\"nc\">String<\/span> <span class=\"no\">CREATE_RISINGWAVE_SOURCE_TABLE<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"CREATE TABLE IF NOT EXISTS delivery_orders_source (\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    order_id BIGINT,\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    restaurant_id BIGINT,\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    order_state VARCHAR,\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    order_timestamp TIMESTAMP\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\") WITH (\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    connector=\"kafka\",\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    topic=\"delivery_orders\",\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    properties.bootstrap.server=\"message_queue:29092\",\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\"    scan.startup.mode=\"earliest\"\\n\"<\/span> <span class=\"o\">+<\/span>\n        <span class=\"s\">\") ROW FORMAT JSON;\"<\/span><span class=\"o\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0647\u0645\u0686\u0646\u06cc\u0646 \u0634\u0627\u0645\u0644 \u0627\u0644\u0641 <strong><code>WITH<\/code><\/strong>  \u0628\u0646\u062f \u06a9\u0647 \u06af\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u0628\u0631\u0627\u06cc \u062c\u062f\u0648\u0644 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.  \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0648\u0631\u062f\u060c <strong><code>connector<\/code><\/strong>  \u06af\u0632\u06cc\u0646\u0647 \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a <strong><code>kafka<\/code><\/strong>\u060c \u06a9\u0647 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u062c\u062f\u0648\u0644 \u0628\u0647 \u0645\u0648\u0636\u0648\u0639 \u06a9\u0627\u0641\u06a9\u0627 \u0645\u062a\u0635\u0644 \u062e\u0648\u0627\u0647\u062f \u0634\u062f.  \u0631\u0627 <strong><code>topic<\/code><\/strong>  \u06af\u0632\u06cc\u0646\u0647 \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a <strong><code>delivery_orders<\/code><\/strong>\u060c \u06a9\u0647 \u0646\u0627\u0645 \u0645\u0648\u0636\u0648\u0639 \u06a9\u0627\u0641\u06a9\u0627 \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p><strong>\u0628\u0627 JdbcTemplate \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f<\/strong> <\/p>\n<p>Spring \u062a\u0639\u062f\u0627\u062f\u06cc \u0627\u0632 \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627 \u0631\u0627 \u0628\u0631\u0627\u06cc \u06a9\u0645\u06a9 \u0628\u0647 \u0634\u0645\u0627 \u062f\u0631 \u06a9\u0627\u0631 \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 <strong><code>JdbcTemplate<\/code><\/strong>  \u06a9\u0644\u0627\u0633\u060c \u06a9\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u062c\u0631\u0627\u06cc \u062f\u0633\u062a\u0648\u0631\u0627\u062a SQL \u0648 \u067e\u0631\u062f\u0627\u0632\u0634 \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0633\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f.  \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u06cc\u06a9 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u062f\u0631 \u0628\u0647\u0627\u0631\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 <strong><code>JdbcTemplate<\/code><\/strong>  \u06a9\u0644\u0627\u0633 \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc SQL \u06a9\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0646\u0645\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc \u06a9\u0646\u062f \u0648 \u0633\u067e\u0633 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nc\">String<\/span> <span class=\"n\">createSql<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">String<\/span>\n    <span class=\"o\">.<\/span><span class=\"na\">format<\/span><span class=\"o\">(<\/span><span class=\"no\">CREATE_MATERIALIZED_VIEW<\/span><span class=\"o\">,<\/span> <span class=\"n\">materializeView<\/span><span class=\"o\">.<\/span><span class=\"na\">getName<\/span><span class=\"o\">(),<\/span> <span class=\"n\">materializeView<\/span><span class=\"o\">.<\/span><span class=\"na\">getQuery<\/span><span class=\"o\">());<\/span>\n<span class=\"n\">jdbcTemplate<\/span><span class=\"o\">.<\/span><span class=\"na\">execute<\/span><span class=\"o\">(<\/span><span class=\"n\">createSql<\/span><span class=\"o\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><strong>\u06cc\u06a9 \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u0628\u0627 JPA \u062c\u0633\u062a\u062c\u0648 \u06a9\u0646\u06cc\u062f<\/strong><\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642 \u06cc\u0627\u0641\u062a\u0647 \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u062c\u0627\u0648\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u062e\u0632\u0646 Spring Data JPA \u0646\u06cc\u0632 \u062c\u0633\u062a\u062c\u0648 \u06a9\u0631\u062f.  \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 \u06a9\u0644\u0627\u0633 \u0645\u0648\u062c\u0648\u062f\u06cc\u062a \u062c\u062f\u06cc\u062f \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f <code>RestaurantOrdersView<\/code> \u06a9\u0647 \u0628\u0647 \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u0646\u0645\u0627\u06cc \u0645\u0627\u062f\u06cc \u0634\u062f\u0647 \u062f\u0631 RisingWave \u0646\u06af\u0627\u0634\u062a \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nd\">@Entity<\/span>\n<span class=\"nd\">@Getter<\/span>\n<span class=\"nd\">@Setter<\/span>\n<span class=\"nd\">@Table<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"restaurant_orders_view\"<\/span><span class=\"o\">)<\/span>\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">RestaurantOrdersView<\/span> <span class=\"kd\">implements<\/span> <span class=\"nc\">Serializable<\/span> <span class=\"o\">{<\/span>\n\n    <span class=\"nd\">@Id<\/span>\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"restaurant_id\"<\/span><span class=\"o\">)<\/span>\n    <span class=\"kd\">private<\/span> <span class=\"nc\">Long<\/span> <span class=\"n\">restaurantId<\/span><span class=\"o\">;<\/span>\n\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"window_start\"<\/span><span class=\"o\">)<\/span>\n    <span class=\"kd\">private<\/span> <span class=\"nc\">Timestamp<\/span> <span class=\"n\">windowStart<\/span><span class=\"o\">;<\/span>\n\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"total_order\"<\/span><span class=\"o\">)<\/span>\n    <span class=\"kd\">private<\/span> <span class=\"nc\">BigInteger<\/span> <span class=\"n\">totalOrder<\/span><span class=\"o\">;<\/span>\n<span class=\"o\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u0648\u062c\u0648\u062f \u06a9\u0644\u0627\u0633 \u0645\u0648\u062c\u0648\u062f\u06cc\u062a\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u0645 \u06cc\u06a9 \u0645\u062e\u0632\u0646 Spring Data JPA \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0647 \u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc\u200c\u062f\u0647\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u067e\u0631\u0633\u200c\u0648\u062c\u0648 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f JPA \u06cc\u0627 \u0634\u0645\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc SQL \u0628\u0648\u0645\u06cc\u060c \u0646\u0645\u0627\u06cc \u062a\u062d\u0642\u0642\u200c\u06cc\u0627\u0641\u062a\u0647 \u0631\u0627 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0646\u06cc\u0645.  \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644\u060c \u06a9\u062f \u0632\u06cc\u0631 \u06a9\u0644 \u0633\u0641\u0627\u0631\u0634 \u0647\u0627\u06cc \u0631\u0633\u062a\u0648\u0631\u0627\u0646 \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nd\">@Component<\/span>\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">OrderDeliveryRepositoryImpl<\/span> <span class=\"kd\">implements<\/span> <span class=\"nc\">OrderDeliveryRepository<\/span> <span class=\"o\">{<\/span>\n\n    <span class=\"nd\">@PersistenceContext<\/span>\n    <span class=\"kd\">private<\/span> <span class=\"nc\">EntityManager<\/span> <span class=\"n\">entityManager<\/span><span class=\"o\">;<\/span>\n\n    <span class=\"nd\">@Override<\/span>\n    <span class=\"kd\">public<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">RestaurantOrdersView<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">countTotalRestaurantOrders<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\n        <span class=\"nc\">Query<\/span> <span class=\"n\">query<\/span> <span class=\"o\">=<\/span> <span class=\"n\">entityManager<\/span><span class=\"o\">.<\/span><span class=\"na\">createNativeQuery<\/span><span class=\"o\">(<\/span><span class=\"s\">\"SELECT * FROM restaurant_orders_view WHERE restaurant_id = 1\"<\/span><span class=\"o\">);<\/span>\n        <span class=\"k\">return<\/span> <span class=\"n\">query<\/span><span class=\"o\">.<\/span><span class=\"na\">getResultList<\/span><span class=\"o\">();<\/span>\n    <span class=\"o\">}<\/span>\n<span class=\"o\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0631\u0648\u0634 <code>countTotalRestaurantOrders<\/code> \u0633\u067e\u0633 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 \u0645\u0627 \u062a\u0645\u0627\u0633 \u06af\u0631\u0641\u062a <code>OrderDeliveryService<\/code> \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0645\u0646\u0637\u0642 \u062a\u062c\u0627\u0631\u06cc \u0627\u0636\u0627\u0641\u06cc \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0647 \u0648 \u0622\u0646 \u0631\u0627 \u0628\u0647 \u0622\u0646 \u0645\u0646\u062a\u0642\u0644 \u06a9\u0646\u06cc\u0645 <code>OrderDeliveryController<\/code> \u0628\u0631\u0627\u06cc \u062f\u0631 \u062f\u0633\u062a\u0631\u0633 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 \u0627\u06cc\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 \u0646\u0642\u0637\u0647 \u067e\u0627\u06cc\u0627\u0646\u06cc REST.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight java\"><code><span class=\"nd\">@RestController<\/span>\n<span class=\"nd\">@RequiredArgsConstructor<\/span>\n<span class=\"nd\">@RequestMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/orders\"<\/span><span class=\"o\">)<\/span>\n<span class=\"nd\">@CrossOrigin<\/span><span class=\"o\">(<\/span><span class=\"n\">value<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"*\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">allowedHeaders<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"*\"<\/span><span class=\"o\">)<\/span>\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">OrderDeliveryController<\/span> <span class=\"o\">{<\/span>\n\n    <span class=\"kd\">private<\/span> <span class=\"kd\">final<\/span> <span class=\"nc\">OrderDeliveryService<\/span> <span class=\"n\">orderDeliveryService<\/span><span class=\"o\">;<\/span>\n\n    <span class=\"nd\">@GetMapping<\/span><span class=\"o\">(<\/span><span class=\"s\">\"\/count-total-restaurant-orders\"<\/span><span class=\"o\">)<\/span>\n    <span class=\"nd\">@CrossOrigin<\/span><span class=\"o\">(<\/span><span class=\"n\">value<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"*\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">allowedHeaders<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"*\"<\/span><span class=\"o\">)<\/span>\n    <span class=\"kd\">public<\/span> <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">RestaurantOrdersView<\/span><span class=\"o\">&gt;<\/span> <span class=\"nf\">getCountTotalRestaurantOrders<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\n        <span class=\"k\">return<\/span> <span class=\"n\">orderDeliveryService<\/span><span class=\"o\">.<\/span><span class=\"na\">countTotalRestaurantOrders<\/span><span class=\"o\">();<\/span>\n    <span class=\"o\">}<\/span>\n<span class=\"o\">}<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u062f\u0631 \u0646\u062a\u06cc\u062c\u0647\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062c\u0631\u06cc\u0627\u0646 \u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 <strong>\u062f\u0631\u06cc\u0627\u0641\u062a \u062c\u0631\u06cc\u0627\u0646 \u062f\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0645\u0646\u0628\u0639 \u062f\u0627\u062f\u0647<\/strong> \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0686\u0646\u062f\u06cc\u0646 \u062c\u0631\u06cc\u0627\u0646 \u0631\u0627 \u0627\u062f\u063a\u0627\u0645 \u06a9\u0646\u06cc\u062f \u0648 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.  Spring Boot \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u062f\u0627\u062e\u0644\u06cc \u0628\u0631\u0627\u06cc <strong>\u0627\u062f\u063a\u0627\u0645 \u0628\u0627 \u0645\u0646\u0627\u0628\u0639 \u062f\u0627\u062f\u0647 \u0645\u062d\u0628\u0648\u0628<\/strong>\u0645\u0627\u0646\u0646\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u0631\u06cc\u0627\u0646.  \u062f\u06cc\u062f\u0647\u200c\u0627\u06cc\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u06a9\u0633\u0628\u200c\u0648\u06a9\u0627\u0631\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u062a\u062d\u0648\u06cc\u0644 \u0633\u0641\u0627\u0631\u0634 \u0631\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647\u200c\u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0631\u06cc\u0645\u060c \u062c\u0627\u0648\u0627 \u0648 Spring \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u06a9\u0646\u0646\u062f \u0648 \u0622\u0646\u0647\u0627 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0628\u0647 \u0634\u0646\u0627\u0633\u0627\u06cc\u06cc \u062a\u0646\u06af\u0646\u0627\u0647\u0627 \u0648 \u0628\u0647\u0628\u0648\u062f \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0648 \u0627\u062b\u0631\u0628\u062e\u0634\u06cc \u0641\u0631\u0622\u06cc\u0646\u062f \u0627\u0646\u062c\u0627\u0645 \u0633\u0641\u0627\u0631\u0634 \u062e\u0648\u062f \u06a9\u0646\u0646\u062f. <\/p>\n<p>\ud83d\ude4b \u0628\u0647 \u0627\u0646\u062c\u0645\u0646 Risingwave \u0628\u067e\u06cc\u0648\u0646\u062f\u06cc\u062f<\/p>\n<p>\u0627\u0632 \u0648\u0628\u0644\u0627\u06af \u0645\u0646 \u062f\u06cc\u062f\u0646 \u06a9\u0646\u06cc\u062f: www.iambobur.com<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0646\u0645\u0627\u0647\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u0627\u0628\u0632\u0627\u0631 \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u062f\u0631 \u0633\u06cc\u0633\u062a\u0645 \u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0646\u062a\u0627\u06cc\u062c \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0631\u0627 \u0627\u0632 \u0642\u0628\u0644 \u0645\u062d\u0627\u0633\u0628\u0647 \u0648 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u0646\u062f\u060c \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0645\u06cc \u0628\u062e\u0634\u062f \u0648 \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u06af\u0631\u0627\u0646 \u0642\u06cc\u0645\u062a \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f. \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u062f\u0631 \u0645\u062d\u06cc\u0637\u200c\u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0645\u062f\u0631\u0646 \u0648 \u0633\u0631\u06cc\u0639\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":31725,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-31724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/31724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=31724"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/31724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/31725"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=31724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=31724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=31724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}