{"id":92105,"date":"2020-08-23T07:42:12","date_gmt":"2020-08-23T05:42:12","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/etyud-po-realizacziya-biznes-logiki-na-urovne-hranimyh-funkczij-postgresql"},"modified":"2020-08-23T07:42:12","modified_gmt":"2020-08-23T05:42:12","slug":"etyud-po-realizacziya-biznes-logiki-na-urovne-hranimyh-funkczij-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/etyud-po-realizacziya-biznes-logiki-na-urovne-hranimyh-funkczij-postgresql","title":{"rendered":"Studie zur Implementierung von Gesch\u00e4ftslogik auf der Ebene von PostgreSQL-Stored Functions","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\u041f\u043e\u0431\u0443\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u043c\u043e\u0442\u0438\u0432\u043e\u043c \u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u044e \u044d\u0442\u044e\u0434\u0430 \u043f\u043e\u0441\u043b\u0443\u0436\u0438\u043b\u0430 \u0441\u0442\u0430\u0442\u044c\u044f \u00ab\u0412 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u0432\u044b\u0440\u043e\u0441\u043b\u0430 \u0432 5 \u0440\u0430\u0437, \u043d\u043e \u043c\u044b \u0431\u044b\u043b\u0438 \u0433\u043e\u0442\u043e\u0432\u044b\u00bb. \u041a\u0430\u043a Lingualeo \u043f\u0435\u0440\u0435\u0435\u0445\u0430\u043b \u043d\u0430 PostgreSQL \u0441 23 \u043c\u043b\u043d \u044e\u0437\u0435\u0440\u043e\u0432<\/a><\/noindex>. \u0422\u0430\u043a \u0436\u0435 \u043f\u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u044f \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u0430\u044f 4 \u0433\u043e\u0434\u0430 \u043d\u0430\u0437\u0430\u0434 \u2014 \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u0432 MySQL<\/a><\/noindex>.<\/p>\n

\u041f\u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u044b\u043c \u0442\u043e, \u0447\u0442\u043e \u043e\u0434\u043d\u0430 \u0438 \u0442\u0430 \u0436\u0435 \u043c\u044b\u0441\u043b\u044c-"\u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u0442\u044c \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0443 \u0432 \u0411\u0414<\/b><\/i>".<\/p>\n

\"\u042d\u0442\u044e\u0434
\n
\n\u043f\u0440\u0438\u0448\u043b\u0430 \u0432 \u0433\u043e\u043b\u043e\u0432\u0443 \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u043c\u043d\u0435 \u043e\u0434\u043d\u043e\u043c\u0443.<\/p>\n

\u0422\u0430\u043a\u0436\u0435 \u043d\u0430 \u0431\u0443\u0434\u0443\u0449\u0435\u0435 \u0445\u043e\u0442\u0435\u043b\u043e\u0441\u044c \u0441\u043e\u0445\u0440\u0430\u043d\u0438\u0442\u044c, \u0434\u043b\u044f \u0441\u0435\u0431\u044f \u0432 \u043f\u0435\u0440\u0432\u0443\u044e \u043e\u0447\u0435\u0440\u0435\u0434\u044c, \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u044b\u0435 \u043d\u0430\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u0432\u043e\u0437\u043d\u0438\u043a\u0448\u0438\u0435 \u043f\u043e \u0445\u043e\u0434\u0443 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438. \u041e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u044f \u0442\u043e, \u0447\u0442\u043e \u043e\u0442\u043d\u043e\u0441\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0435\u0434\u0430\u0432\u043d\u043e \u0431\u044b\u043b\u043e \u043f\u0440\u0438\u043d\u044f\u0442\u043e \u0441\u0442\u0440\u0430\u0442\u0435\u0433\u0438\u0447\u0435\u0441\u043a\u043e\u0435 \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u043e \u0441\u043c\u0435\u043d\u0435 \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u044b \u0438 \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0435 \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u043d\u0430 \u0443\u0440\u043e\u0432\u0435\u043d\u044c backend. \u0422\u0430\u043a, \u0447\u0442\u043e \u0432\u0441\u0435, \u0447\u0442\u043e \u0431\u044b\u043b\u043e \u043d\u0430\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u043e, \u0441\u043a\u043e\u0440\u043e \u043d\u0438\u043a\u043e\u043c\u0443 \u043d\u0435 \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u0441\u044f \u0438 \u043d\u0438\u043a\u043e\u043c\u0443 \u0431\u0443\u0434\u0435\u0442 \u043d\u0435 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e.<\/p>\n

\u041e\u043f\u0438\u0441\u0430\u043d\u043d\u044b\u0435 \u043c\u0435\u0442\u043e\u0434\u044b \u043d\u0435 \u044f\u0432\u043b\u044f\u044e\u0442\u0441\u044f \u043a\u0430\u043a\u0438\u043c \u0442\u043e \u043e\u0442\u043a\u0440\u044b\u0442\u0438\u0435\u043c \u0438 \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c know how<\/i>, \u0432\u0441\u0435 \u043f\u043e \u043a\u043b\u0430\u0441\u0441\u0438\u043a\u0435 \u0438 \u0431\u044b\u043b\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043e \u043d\u0435\u043e\u0434\u043d\u043e\u043a\u0440\u0430\u0442\u043d\u043e (\u044f \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u043f\u043e\u0434\u043e\u0431\u043d\u044b\u0439 \u043f\u043e\u0434\u0445\u043e\u0434 \u043f\u0440\u0438\u043c\u0435\u043d\u0438\u043b 20 \u043b\u0435\u0442 \u043d\u0430\u0437\u0430\u0434 \u043d\u0430 Oracle).\u041f\u0440\u043e\u0441\u0442\u043e \u0440\u0435\u0448\u0438\u043b \u0441\u043e\u0431\u0440\u0430\u043b \u0432\u0441\u0435 \u0432 \u043e\u0434\u043d\u043e\u043c \u043c\u0435\u0441\u0442\u0435. \u0412\u0434\u0440\u0443\u0433 \u043a\u043e\u043c\u0443 \u043f\u0440\u0438\u0433\u043e\u0434\u0438\u0442\u0441\u044f. \u041a\u0430\u043a \u043f\u043e\u043a\u0430\u0437\u0430\u043b\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0430 \u2014 \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u0447\u0430\u0441\u0442\u043e \u043e\u0434\u043d\u0430 \u0438 \u0442\u0430 \u0436\u0435 \u0438\u0434\u0435\u044f \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u0442 \u043d\u0435\u0437\u0430\u0432\u0438\u0441\u0438\u043c\u043e \u0440\u0430\u0437\u043d\u044b\u043c \u043b\u044e\u0434\u044f\u043c. \u0414\u0430 \u0438 \u0434\u043b\u044f \u0441\u0435\u0431\u044f \u043e\u0441\u0442\u0430\u0432\u0438\u0442\u044c \u043d\u0430 \u043f\u0430\u043c\u044f\u0442\u044c, \u043f\u043e\u043b\u0435\u0437\u043d\u043e.<\/p>\n

\u041a\u043e\u043d\u0435\u0447\u043d\u043e, \u0436\u0435 \u043d\u0438\u0447\u0442\u043e \u0432 \u044d\u0442\u043e\u043c \u043c\u0438\u0440\u0435 \u043d\u0435 \u0441\u043e\u0432\u0435\u0440\u0448\u0435\u043d\u043d\u043e, \u043e\u0448\u0438\u0431\u043a\u0438 \u0438 \u043e\u043f\u0435\u0447\u0430\u0442\u043a\u0438 \u043a \u0441\u043e\u0436\u0430\u043b\u0435\u043d\u0438\u044e \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u044b. \u041a\u0440\u0438\u0442\u0438\u043a\u0430 \u0438 \u0437\u0430\u043c\u0435\u0447\u0430\u043d\u0438\u044f \u0432\u0441\u044f\u0447\u0435\u0441\u043a\u0438 \u043f\u0440\u0438\u0432\u0435\u0442\u0441\u0442\u0432\u0443\u044e\u0442\u0441\u044f \u0438 \u043e\u0436\u0438\u0434\u0430\u044e\u0442\u0441\u044f.\u0418 \u0435\u0449\u0435 \u043e\u0434\u043d\u0430 \u043c\u0430\u043b\u0435\u043d\u044c\u043a\u0430\u044f \u0434\u0435\u0442\u0430\u043b\u044c \u2014 \u043a\u043e\u043d\u043a\u0440\u0435\u0442\u043d\u044b\u0435 \u0434\u0435\u0442\u0430\u043b\u0438 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u043e\u043f\u0443\u0449\u0435\u043d\u044b. \u0412\u0441\u0435 \u0442\u0430\u043a\u0438 \u0432\u0441\u0451 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u043f\u043e\u043a\u0430 \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0435\u043c \u043f\u0440\u043e\u0435\u043a\u0442\u0435. \u0422\u0430\u043a, \u0447\u0442\u043e \u0441\u0442\u0430\u0442\u044c\u044f \u043a\u0430\u043a \u044d\u0442\u044e\u0434 \u0438 \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435 \u043e\u0431\u0449\u0435\u0439 \u043a\u043e\u043d\u0446\u0435\u043f\u0446\u0438\u0438, \u043d\u0435 \u0431\u043e\u043b\u0435\u0435 \u0442\u043e\u0433\u043e. \u041d\u0430\u0434\u0435\u044e\u0441\u044c \u0434\u043b\u044f \u043f\u043e\u043d\u044f\u0442\u0438\u044f \u043e\u0431\u0449\u0435\u0439 \u043a\u0430\u0440\u0442\u0438\u043d\u044b, \u0434\u0435\u0442\u0430\u043b\u0435\u0439 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e.<\/p><\/blockquote>\n

<\/a><\/noindex><\/p>\n

\u041e\u0431\u0449\u0430\u044f \u0438\u0434\u0435\u044f \u2014 \u00ab\u0440\u0430\u0437\u0434\u0435\u043b\u044f\u0439 \u0438 \u0432\u043b\u0430\u0441\u0442\u0432\u0443\u0439, \u0441\u043a\u0440\u044b\u0432\u0430\u0439 \u0438 \u0432\u043b\u0430\u0434\u0435\u0439\u00bb<\/h2>\n

\n\u0418\u0434\u0435\u044f \u043a\u043b\u0430\u0441\u0441\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u2014 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0430\u044f \u0441\u0445\u0435\u043c\u0430 \u0434\u043b\u044f \u0442\u0430\u0431\u043b\u0438\u0446, \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0430\u044f \u0441\u0445\u0435\u043c\u0430 \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439.
\n\u041a\u043b\u0438\u0435\u043d\u0442 \u043d\u0435 \u0438\u043c\u0435\u0435\u0442 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0434\u0430\u043d\u043d\u044b\u043c \u043d\u0430\u043f\u0440\u044f\u043c\u0443\u044e. \u0412\u0441\u0435, \u0447\u0442\u043e \u043a\u043b\u0438\u0435\u043d\u0442 \u043c\u043e\u0436\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c \u2014 \u0442\u043e\u043b\u044c\u043a\u043e \u0432\u044b\u0437\u0432\u0430\u0442\u044c \u0445\u0440\u0430\u043d\u0438\u043c\u0443\u044e \u0444\u0443\u043d\u043a\u0446\u0438\u044e \u0438 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u0439 \u043e\u0442\u0432\u0435\u0442.<\/i><\/p>\n

\u0420\u043e\u043b\u0438<\/h4>\n

<\/p>\n

CREATE ROLE store;\n<\/code><\/pre>\n
<\/p>\n
CREATE ROLE sys_functions;\n<\/code><\/pre>\n
<\/p>\n
CREATE ROLE loc_audit_functions;\n<\/code><\/pre>\n
<\/p>\n
CREATE ROLE service_functions;\n<\/code><\/pre>\n
<\/p>\n
CREATE ROLE business_functions;\n<\/code><\/pre>\n
<\/p>\n
\u0421\u0445\u0435\u043c\u044b<\/h4>\n
\n\u0421\u0445\u0435\u043c\u0430 \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446<\/b><\/p>\n
\u0426\u0435\u043b\u0435\u0432\u044b\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u0440\u0435\u0430\u043b\u0438\u0437\u0443\u044e\u0449\u0438\u0435 \u043f\u0440\u0435\u0434\u043c\u0435\u0442\u043d\u044b\u0435 \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0438.<\/p>\n
CREATE SCHEMA store AUTHORIZATION store ;\n<\/code><\/pre>\n
\n\u0421\u0445\u0435\u043c\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439<\/b><\/p>\n
\u0421\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438, \u0432 \u0447\u0430\u0441\u0442\u043d\u043e\u0441\u0442\u0438 \u0434\u043b\u044f \u043b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446.<\/p>\n
CREATE SCHEMA sys_functions AUTHORIZATION sys_functions ;\n<\/code><\/pre>\n
\n\u0421\u0445\u0435\u043c\u0430 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0430\u0443\u0434\u0438\u0442\u0430<\/b><\/p>\n
\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0434\u043b\u044f \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0430\u0443\u0434\u0438\u0442\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0446\u0435\u043b\u0435\u0432\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446.<\/p>\n
CREATE SCHEMA loc_audit_functions AUTHORIZATION loc_audit_functions;\n<\/code><\/pre>\n
\n\u0421\u0445\u0435\u043c\u0430 \u0441\u0435\u0440\u0432\u0438\u0441\u043d\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439<\/b><\/p>\n
\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u0441\u0435\u0440\u0432\u0438\u0441\u043d\u044b\u0445 \u0438 DML \u0444\u0443\u043d\u043a\u0446\u0438\u0439.<\/p>\n
CREATE SCHEMA service_functions AUTHORIZATION service_functions;\n<\/code><\/pre>\n
\n\u0421\u0445\u0435\u043c\u0430 \u0431\u0438\u0437\u043d\u0435\u0441 \u0444\u0443\u043d\u043a\u0446\u0438\u0439<\/b><\/p>\n
\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0434\u043b\u044f \u043a\u043e\u043d\u0435\u0447\u043d\u044b\u0445 \u0431\u0438\u0437\u043d\u0435\u0441 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u043c\u044b\u0445 \u043a\u043b\u0438\u0435\u043d\u0442\u043e\u043c.<\/p>\n
CREATE SCHEMA business_functions AUTHORIZATION business_functions;\n<\/code><\/pre>\n
<\/p>\n
\u041f\u0440\u0430\u0432\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430<\/h4>\n
\n\u0420\u043e\u043b\u044c \u2014 DBA<\/b> \u0438\u043c\u0435\u0435\u0442 \u043f\u043e\u043b\u043d\u044b\u0439 \u0434\u043e\u0441\u0442\u0443\u043f \u043a\u043e \u0432\u0441\u0435\u043c \u0441\u0445\u0435\u043c\u0430\u043c (\u043e\u0442\u0434\u0435\u043b\u0435\u043d\u0430 \u043e\u0442 \u0440\u043e\u043b\u0438 DB Owner).<\/p>\n
CREATE ROLE dba_role;\nGRANT store TO dba_role;\nGRANT sys_functions TO dba_role;\nGRANT loc_audit_functions TO dba_role;\nGRANT service_functions TO dba_role;\nGRANT business_functions TO dba_role;\n<\/code><\/pre>\n
\n\u0420\u043e\u043b\u044c \u2014 USER<\/b> \u0438\u043c\u0435\u0435\u0442 \u043f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u044e EXECUTE<\/b> \u0432 \u0441\u0445\u0435\u043c\u0435 business_functions<\/b>.<\/p>\n
CREATE ROLE user_role;\n<\/code><\/pre>\n
<\/p>\n
\u041f\u0440\u0438\u0432\u0438\u043b\u0435\u0433\u0438\u0438 \u043c\u0435\u0436\u0434\u0443 \u0441\u0445\u0435\u043c\u0430\u043c\u0438<\/h4>\n
<\/p>\n
                        GRANT<\/b>
\n                        \u041f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 \u0432\u0441\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0441\u043e\u0437\u0434\u0430\u044e\u0442\u0441\u044f \u0441 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u043c SECURITY DEFINER<\/i> \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u0430 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u044f REVOKE EXECUTE ON ALL FUNCTION\u2026 FROM public;<\/i> <\/p>\n
REVOKE EXECUTE ON ALL FUNCTION IN SCHEMA sys_functions FROM public ; \nREVOKE EXECUTE ON ALL FUNCTION IN SCHEMA  loc_audit_functions  FROM public ; \nREVOKE EXECUTE ON ALL FUNCTION IN SCHEMA  service_functions FROM public ; \nREVOKE EXECUTE ON ALL FUNCTION IN SCHEMA  business_functions FROM public ; \n\nGRANT USAGE ON SCHEMA sys_functions TO dba_role ; \nGRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA sys_functions TO dba_role ;\nGRANT USAGE ON SCHEMA loc_audit_functions  TO dba_role ; \nGRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA loc_audit_functions  TO dba_role ;\nGRANT USAGE ON SCHEMA service_functions TO dba_role ; \nGRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA service_functions TO dba_role ;\nGRANT USAGE ON SCHEMA business_functions TO dba_role ; \nGRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA business_functions TO dba_role ;\nGRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA business_functions TO user_role ;\n\nGRANT ALL PRIVILEGES ON SCHEMA store TO GROUP business_functions ;\nGRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA store TO business_functions ;\nGRANT USAGE ON ALL SEQUENCES IN SCHEMA store TO business_functions ;\n<\/code><\/pre>\n
\n\u0418\u0442\u0430\u043a \u0441\u0445\u0435\u043c\u0430 \u0411\u0414 \u2014 \u0433\u043e\u0442\u043e\u0432\u0430. \u041c\u043e\u0436\u043d\u043e \u043f\u0440\u0438\u0441\u0442\u0443\u043f\u0430\u0442\u044c \u043a \u043d\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044e \u0434\u0430\u043d\u043d\u044b\u043c\u0438.<\/p>\n
\u0426\u0435\u043b\u0435\u0432\u044b\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/h3>\n
\n\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0442\u0440\u0438\u0432\u0438\u0430\u043b\u044c\u043d\u043e. \u041d\u0438\u043a\u0430\u043a\u0438\u0445 \u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e\u0441\u0442\u0435\u0439, \u0437\u0430 \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0435\u043c \u0442\u043e\u0433\u043e, \u0447\u0442\u043e \u0431\u044b\u043b\u043e \u0440\u0435\u0448\u0435\u043d\u043e \u043e\u0442\u043a\u0430\u0437\u0430\u0442\u044c\u0441\u044f \u043e\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f SERIAL<\/i> \u0438 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u044f\u0432\u043d\u043e. \u041f\u043b\u044e\u0441, \u0440\u0430\u0437\u0443\u043c\u0435\u0435\u0442\u0441\u044f \u043c\u0430\u043a\u0441\u0438\u043c\u0430\u043b\u044c\u043d\u043e\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438 <\/p>\n
COMMENT ON ...<\/code><\/pre>\n
\n\u041a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0438 \u0434\u043b\u044f \u0432\u0441\u0435\u0445<\/b> \u043e\u0431\u044a\u0435\u043a\u0442\u043e\u0432, \u0431\u0435\u0437 \u0438\u0441\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u0439.<\/p>\n
\u041b\u043e\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u0430\u0443\u0434\u0438\u0442<\/h3>\n
\n\u0414\u043b\u044f \u0432\u0435\u0434\u0435\u043d\u0438\u044f \u0436\u0443\u0440\u043d\u0430\u043b\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0438 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u0446\u0435\u043b\u0435\u0432\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0430\u0443\u0434\u0438\u0442\u0430, \u0432\u043a\u043b\u044e\u0447\u0430\u044e\u0449\u0430\u044f \u0432 \u0441\u0435\u0431\u044f \u0432 \u0442\u043e\u043c \u0447\u0438\u0441\u043b\u0435 \u0434\u0435\u0442\u0430\u043b\u0438 \u043a\u043b\u0438\u0435\u043d\u0442\u0441\u043a\u043e\u0433\u043e \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f, \u043c\u0435\u0442\u043a\u0443 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u043c\u043e\u0433\u043e \u043c\u043e\u0434\u0443\u043b\u044f, \u0444\u0430\u043a\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432\u0445\u043e\u0434\u043d\u044b\u0445 \u0438 \u0432\u044b\u0445\u043e\u0434\u043d\u044b\u0445 \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u043e\u0432 \u0432 \u0432\u0438\u0434\u0435 JSON.<\/p>\n
\u0421\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438<\/h3>\n
\n\u041f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u044b \u0434\u043b\u044f \u043b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0439 \u0432 \u0446\u0435\u043b\u0435\u0432\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445. \u041f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0442 \u0441\u043e\u0431\u043e\u0439 \u0442\u0440\u0438\u0433\u0433\u0435\u0440\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438.<\/p>\n
                        \u0428\u0430\u0431\u043b\u043e\u043d — \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f<\/b><\/p>\n
---------------------------------------------------------\n-- INSERT\nCREATE OR REPLACE FUNCTION sys_functions.table_insert_log ()\nRETURNS TRIGGER AS $$\nBEGIN\n  PERFORM loc_audit_functions.make_log( ' '||'table' , 'insert' , json_build_object('id', NEW.id)  );\n  RETURN NULL ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;\n\nCREATE TRIGGER table_after_insert AFTER INSERT ON storage.table FOR EACH ROW EXECUTE PROCEDURE sys_functions.table_insert_log();\n\n---------------------------------------------------------\n-- UPDATE\nCREATE OR REPLACE FUNCTION sys_functions.table_update_log ()\nRETURNS TRIGGER AS $$\nBEGIN\n  IF OLD.column != NEW.column\n  THEN\n    PERFORM loc_audit_functions.make_log( ' '||'table' , 'update' , json_build_object('OLD.column', OLD.column , 'NEW.column' , NEW.column )  );\n  END IF ;\n  RETURN NULL ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;\n\nCREATE TRIGGER table_after_update AFTER UPDATE ON storage.table FOR EACH ROW EXECUTE PROCEDURE sys_functions.table_update_log ();\n\n---------------------------------------------------------\n-- DELETE\nCREATE OR REPLACE FUNCTION sys_functions.table_delete_log ()\nRETURNS TRIGGER AS $$\nBEGIN\n  PERFORM loc_audit_functions.make_log( ' '||'table' , 'delete' , json_build_object('id', OLD.id )  );\n  RETURN NULL ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;\n\nCREATE TRIGGER table_after_delete AFTER DELETE ON storage.table FOR EACH ROW EXECUTE PROCEDURE sys_functions.table_delete_log ();<\/code><\/pre>\n
<\/p>\n
\u0421\u0435\u0440\u0432\u0438\u0441\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438<\/h3>\n
\n\u041f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u044b \u0434\u043b\u044f \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0438 \u0441\u0435\u0440\u0432\u0438\u0441\u043d\u044b\u0445 \u0438 DML \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0439 \u043d\u0430\u0434 \u0446\u0435\u043b\u0435\u0432\u044b\u043c\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438.<\/p>\n
                        \u0428\u0430\u0431\u043b\u043e\u043d — \u0441\u0435\u0440\u0432\u0438\u0441\u043d\u0430\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u044f<\/b><\/p>\n
--INSERT\n--RETURN id OF NEW ROW\nCREATE OR REPLACE FUNCTION service_functions.table_insert ( new_column store.table.column%TYPE )\nRETURNS integer AS $$\nDECLARE\n  new_id integer ;\nBEGIN\n  -- Generate new id\n  new_id = nextval('store.table.seq');\n\n  -- Insert into table\n  INSERT INTO store.table\n  ( \n    id ,\n    column\n   )\n  VALUES\n  (\n   new_id ,\n   new_column\n   );\n\nRETURN new_id ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;\n\n--DELETE\n--RETURN ROW NUMBERS DELETED\nCREATE OR REPLACE FUNCTION service_functions.table_delete ( current_id integer ) \nRETURNS integer AS $$\nDECLARE\n  rows_count integer  ;    \nBEGIN\n  DELETE FROM store.table WHERE id = current_id; \n\n  GET DIAGNOSTICS rows_count = ROW_COUNT;                                                                           \n\n  RETURN rows_count ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;\n \n-- UPDATE DETAILS\n-- RETURN ROW NUMBERS UPDATED\nCREATE OR REPLACE FUNCTION service_functions.table_update_column \n(\n  current_id integer \n  ,new_column store.table.column%TYPE\n) \nRETURNS integer AS $$\nDECLARE\n  rows_count integer  ; \nBEGIN\n  UPDATE  store.table\n  SET\n    column = new_column\n  WHERE id = current_id;\n\n  GET DIAGNOSTICS rows_count = ROW_COUNT;                                                                           \n\n  RETURN rows_count ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;<\/code><\/pre>\n
<\/p>\n
\u0411\u0438\u0437\u043d\u0435\u0441 \u0444\u0443\u043d\u043a\u0446\u0438\u0438<\/h3>\n
\n\u041f\u0440\u0435\u0434\u043d\u0430\u0437\u043d\u0430\u0447\u0435\u043d\u044b \u0434\u043b\u044f \u043a\u043e\u043d\u0435\u0447\u043d\u044b\u0445 \u0431\u0438\u0437\u043d\u0435\u0441 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 \u0432\u044b\u0437\u044b\u0432\u0430\u0435\u043c\u044b\u0439 \u043a\u043b\u0438\u0435\u043d\u0442\u043e\u043c. \u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u0432\u0441\u0435\u0433\u0434\u0430 \u2014 JSON<\/b>. \u0414\u043b\u044f \u043f\u0435\u0440\u0435\u0445\u0432\u0430\u0442\u0430 \u0438 \u043b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043e\u0448\u0438\u0431\u043e\u043a \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0431\u043b\u043e\u043a EXCEPTION<\/b>.<\/p>\n
                        \u0428\u0430\u0431\u043b\u043e\u043d — \u0431\u0438\u0437\u043d\u0435\u0441 \u0444\u0443\u043d\u043a\u0446\u0438\u044f<\/b><\/p>\n
CREATE OR REPLACE FUNCTION business_functions.business_function_template(\n--Input parameters        \n )\nRETURNS JSON AS $$\nDECLARE\n  ------------------------\n  --for exception catching\n  error_message text ;\n  error_json json ;\n  result json ;\n  ------------------------ \nBEGIN\n--LOGGING\n  PERFORM loc_audit_functions.make_log\n  (\n    'business_function_template',\n    'STARTED',\n    json_build_object\n    (\n\t--IN Parameters\n    ) \n   );\n\n  PERFORM business_functions.notice('business_function_template');            \n\n  --START BUSINESS PART\n  --END BUSINESS PART\n\n  -- SUCCESFULLY RESULT\n  PERFORM business_functions.notice('result');\n  PERFORM business_functions.notice(result);\n\n  PERFORM loc_audit_functions.make_log\n  (\n    'business_function_template',\n    'FINISHED', \n    json_build_object( 'result',result )\n  );\n\n  RETURN result ;\n----------------------------------------------------------------------------------------------------------\n-- EXCEPTION CATCHING\nEXCEPTION                        \n  WHEN OTHERS THEN    \n    PERFORM loc_audit_functions.make_log\n    (\n      'business_function_template',\n      'STARTED',\n      json_build_object\n      (\n\t--IN Parameters\t\n      ) , TRUE );\n\n     PERFORM loc_audit_functions.make_log\n     (\n       'business_function_template',\n       ' ERROR',\n       json_build_object('SQLSTATE',SQLSTATE ), TRUE \n     );\n\n     PERFORM loc_audit_functions.make_log\n     (\n       'business_function_template',\n       ' ERROR',\n       json_build_object('SQLERRM',SQLERRM  ), TRUE \n      );\n\n     GET STACKED DIAGNOSTICS error_message = RETURNED_SQLSTATE ;\n     PERFORM loc_audit_functions.make_log\n     (\n      'business_function_template',\n      ' ERROR-RETURNED_SQLSTATE',json_build_object('RETURNED_SQLSTATE',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = COLUMN_NAME ;\n     PERFORM loc_audit_functions.make_log\n     (\n       'business_function_template',\n       ' ERROR-COLUMN_NAME',\n       json_build_object('COLUMN_NAME',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = CONSTRAINT_NAME ;\n     PERFORM loc_audit_functions.make_log\n     (\n      'business_function_template',\n      ' ERROR-CONSTRAINT_NAME',\n      json_build_object('CONSTRAINT_NAME',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = PG_DATATYPE_NAME ;\n     PERFORM loc_audit_functions.make_log\n     (\n       'business_function_template',\n       ' ERROR-PG_DATATYPE_NAME',\n       json_build_object('PG_DATATYPE_NAME',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = MESSAGE_TEXT ;\n     PERFORM loc_audit_functions.make_log\n     (\n       'business_function_template',\n       ' ERROR-MESSAGE_TEXT',json_build_object('MESSAGE_TEXT',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = SCHEMA_NAME ;\n     PERFORM loc_audit_functions.make_log\n     (s\n       'business_function_template',\n       ' ERROR-SCHEMA_NAME',json_build_object('SCHEMA_NAME',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = PG_EXCEPTION_DETAIL ;\n     PERFORM loc_audit_functions.make_log\n     (\n      'business_function_template',\n      ' ERROR-PG_EXCEPTION_DETAIL',\n      json_build_object('PG_EXCEPTION_DETAIL',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = PG_EXCEPTION_HINT ;\n     PERFORM loc_audit_functions.make_log\n     (\n       'business_function_template',\n       ' ERROR-PG_EXCEPTION_HINT',json_build_object('PG_EXCEPTION_HINT',error_message  ), TRUE );\n\n     GET STACKED DIAGNOSTICS error_message = PG_EXCEPTION_CONTEXT ;\n     PERFORM loc_audit_functions.make_log\n     (\n      'business_function_template',\n      ' ERROR-PG_EXCEPTION_CONTEXT',json_build_object('PG_EXCEPTION_CONTEXT',error_message  ), TRUE );                                      \n\n    RAISE WARNING 'ALARM: %' , SQLERRM ;\n\n    SELECT json_build_object\n    (\n      'isError' , TRUE ,\n      'errorMsg' , SQLERRM\n     ) INTO error_json ;\n\n  RETURN  error_json ;\nEND\n$$ LANGUAGE plpgsql SECURITY DEFINER;<\/code><\/pre>\n
<\/p>\n
\u0418\u0442\u043e\u0433<\/h2>\n
\n\u0414\u043b\u044f \u043e\u043f\u0438\u0441\u0430\u043d\u0438\u044f \u043e\u0431\u0449\u0435\u0439 \u043a\u0430\u0440\u0442\u0438\u043d\u044b, \u0434\u0443\u043c\u0430\u044e \u0432\u043f\u043e\u043b\u043d\u0435 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e. \u0415\u0441\u043b\u0438 \u043a\u043e\u0433\u043e \u0437\u0430\u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043e\u0432\u0430\u043b\u0438 \u0434\u0435\u0442\u0430\u043b\u0438 \u0438 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b-\u043f\u0438\u0448\u0438\u0442\u0435 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0438, \u0441 \u0443\u0434\u043e\u0432\u043e\u043b\u044c\u0441\u0442\u0432\u0438\u0435\u043c \u0434\u043e\u043f\u043e\u043b\u043d\u044e \u043a\u0430\u0440\u0442\u0438\u043d\u0443 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c\u0438 \u0448\u0442\u0440\u0438\u0445\u0430\u043c\u0438.<\/p>\n
P.S.<\/h2>\n
                        \u041b\u043e\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u043e\u0448\u0438\u0431\u043a\u0438 — \u0442\u0438\u043f \u0432\u0445\u043e\u0434\u043d\u043e\u0433\u043e \u043f\u0430\u0440\u0430\u043c\u0435\u0442\u0440\u0430<\/b><\/p>\n
-[ RECORD 1 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1072\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          | STARTED\njsonb_pretty    | {\n                |     "dko": {\n                |         "id": 4,\n                |         "type": "Type1",                                                                                                                                                                                            \n                |         "title": "CREATED BY addKD",\n                |         "Weight": 10,\n                |         "Tr": "300",\n                |         "reduction": 10,\n                |         "isTrud": "TRUE",\n                |         "description": "decription",\n                |         "lowerTr": "100",\n                |         "measurement": "measurement1",\n                |         "methodology": "m1",                                                                                                                                                                                           \n                |         "passportUrl": "files",\n                |         "upperTr": "200",\n                |         "weightingFactor": 100.123,\n                |         "actualTrValue": null,\n                |         "upperTrCalcNumber": "120"\n                |     },\n                |     "CardId": 3\n                | }\n-[ RECORD 2 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1073\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR\njsonb_pretty    | {\n                |     "SQLSTATE": "22P02"\n                | }\n-[ RECORD 3 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1074\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR\njsonb_pretty    | {\n                |     "SQLERRM": "invalid input syntax for type numeric: "null""\n                | }\n-[ RECORD 4 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1075\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-RETURNED_SQLSTATE\njsonb_pretty    | {\n                |     "RETURNED_SQLSTATE": "22P02"\n                | }\n-[ RECORD 5 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1076\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-COLUMN_NAME\njsonb_pretty    | {\n                |     "COLUMN_NAME": ""\n                | }\n\n-[ RECORD 6 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1077\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-CONSTRAINT_NAME\njsonb_pretty    | {\n                |     "CONSTRAINT_NAME": ""\n                | }\n-[ RECORD 7 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1078\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-PG_DATATYPE_NAME\njsonb_pretty    | {\n                |     "PG_DATATYPE_NAME": ""\n                | }\n-[ RECORD 8 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1079\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-MESSAGE_TEXT\njsonb_pretty    | {\n                |     "MESSAGE_TEXT": "invalid input syntax for type numeric: "null""\n                | }\n-[ RECORD 9 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1080\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-SCHEMA_NAME\njsonb_pretty    | {\n                |     "SCHEMA_NAME": ""\n                | }\n-[ RECORD 10 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1081\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-PG_EXCEPTION_DETAIL\njsonb_pretty    | {\n                |     "PG_EXCEPTION_DETAIL": ""\n                | }\n-[ RECORD 11 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1082\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-PG_EXCEPTION_HINT\njsonb_pretty    | {\n                |     "PG_EXCEPTION_HINT": ""\n                | }\n-[ RECORD 12 ]-\ndate_trunc      | 2020-08-19 13:15:46\nid              | 1083\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-PG_EXCEPTION_CONTEXT\njsonb_pretty    | {\nusename         | emp1\nlog_module      | addKD\nlog_module_hash | 0b4c1529a89af3ddf6af3821dc790e8a\nstatus          |  ERROR-MESSAGE_TEXT\njsonb_pretty    | {\n                |     "MESSAGE_TEXT": "invalid input syntax for type numeric: "null""\n                | }<\/pre>\n
\u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a: habr.com<\/a> <\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
\u041f\u043e\u0431\u0443\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u043c\u043e\u0442\u0438\u0432\u043e\u043c \u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u044e \u044d\u0442\u044e\u0434\u0430 \u043f\u043e\u0441\u043b\u0443\u0436\u0438\u043b\u0430 \u0441\u0442\u0430\u0442\u044c\u044f \u00ab\u0412 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u0432\u044b\u0440\u043e\u0441\u043b\u0430 \u0432 5 \u0440\u0430\u0437, \u043d\u043e \u043c\u044b \u0431\u044b\u043b\u0438 \u0433\u043e\u0442\u043e\u0432\u044b\u00bb. \u041a\u0430\u043a Lingualeo \u043f\u0435\u0440\u0435\u0435\u0445\u0430\u043b \u043d\u0430 PostgreSQL \u0441 23 \u043c\u043b\u043d \u044e\u0437\u0435\u0440\u043e\u0432. \u0422\u0430\u043a \u0436\u0435 \u043f\u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u044f \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u0430\u044f 4 \u0433\u043e\u0434\u0430 \u043d\u0430\u0437\u0430\u0434 \u2014 \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u0432 MySQL. \u041f\u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u044b\u043c \u0442\u043e, \u0447\u0442\u043e \u043e\u0434\u043d\u0430 \u0438 \u0442\u0430 \u0436\u0435 \u043c\u044b\u0441\u043b\u044c-"\u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u0442\u044c \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0443 \u0432 \u0411\u0414". \u043f\u0440\u0438\u0448\u043b\u0430 \u0432 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":92106,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-92105","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Studie zur Umsetzung von Gesch\u00e4ftslogik auf Ebene der gespeicherten Funktionen in PostgreSQL | ProHoster","description":"Der Ansto\u00df zur Verfassung dieser Studie war der Artikel \u201eIm Lockdown stieg die Auslastung um das F\u00fcnfzehnfache, aber wir waren vorbereitet\u201c. Wie Lingualeo mit 23 Millionen Nutzern auf PostgreSQL umstieg. Auch der vor vier Jahren ver\u00f6ffentlichte Artikel \u2014 Umsetzung von Gesch\u00e4ftslogik in MySQL \u2014 war interessant. Es fiel auf, dass derselbe Gedanke \u2014 \"Gesch\u00e4ftslogik in der Datenbank umsetzen\" \u2014 aufkam.","canonical_url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/etyud-po-realizacziya-biznes-logiki-na-urovne-hranimyh-funkczij-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"de_DE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u042d\u0442\u044e\u0434 \u043f\u043e \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0445\u0440\u0430\u043d\u0438\u043c\u044b\u0445 \u0444\u0443\u043d\u043a\u0446\u0438\u0439 PostgreSQL | ProHoster","og:description":"\u041f\u043e\u0431\u0443\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u043c \u043c\u043e\u0442\u0438\u0432\u043e\u043c \u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u0438\u044e \u044d\u0442\u044e\u0434\u0430 \u043f\u043e\u0441\u043b\u0443\u0436\u0438\u043b\u0430 \u0441\u0442\u0430\u0442\u044c\u044f \u00ab\u0412 \u043a\u0430\u0440\u0430\u043d\u0442\u0438\u043d \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0430 \u0432\u044b\u0440\u043e\u0441\u043b\u0430 \u0432 5 \u0440\u0430\u0437, \u043d\u043e \u043c\u044b \u0431\u044b\u043b\u0438 \u0433\u043e\u0442\u043e\u0432\u044b\u00bb. \u041a\u0430\u043a Lingualeo \u043f\u0435\u0440\u0435\u0435\u0445\u0430\u043b \u043d\u0430 PostgreSQL \u0441 23 \u043c\u043b\u043d \u044e\u0437\u0435\u0440\u043e\u0432. \u0422\u0430\u043a \u0436\u0435 \u043f\u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u043e\u0439 \u0441\u0442\u0430\u0442\u044c\u044f \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u043d\u0430\u044f 4 \u0433\u043e\u0434\u0430 \u043d\u0430\u0437\u0430\u0434 \u2014 \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0438 \u0432 MySQL. \u041f\u043e\u043a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u043d\u044b\u043c \u0442\u043e, \u0447\u0442\u043e \u043e\u0434\u043d\u0430 \u0438 \u0442\u0430 \u0436\u0435 \u043c\u044b\u0441\u043b\u044c-"\u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u0442\u044c \u0431\u0438\u0437\u043d\u0435\u0441-\u043b\u043e\u0433\u0438\u043a\u0443 \u0432 \u0411\u0414". \u043f\u0440\u0438\u0448\u043b\u0430 \u0432","og:url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/etyud-po-realizacziya-biznes-logiki-na-urovne-hranimyh-funkczij-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-08-23T05:42:12+00:00","article:modified_time":"2020-08-23T05:42:12+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"92105","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 12:14:24","updated":"2022-10-07 18:44:00"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/92105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/comments?post=92105"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/92105\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media\/92106"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media?parent=92105"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/categories?post=92105"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/tags?post=92105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}