Создание модели трансформации данных
После оценки критичности изменений модели данных вы можете создать модель трансформации данных, которая позволяет минимизировать потерю данных в базе данных приложения. По вашему запросу будет сгенерирован файл Transform.mdtr формата JSON, который описывает действия по трансформации данных согласно внутренним алгоритмам Платформы. Действия по трансформации выполняются с помощью SQL-скриптов.
Что бы создать файл трансформации модели данных, при оценке критичности изменений модели данных в окне Изменения нажмите Получить модель трансформации.
Файл Transform.mdtr создается в папке models проекта.
Файл модели трансформации имеет следующую структуру:
-
Заголовок. Содержит информацию, описываемую следующими полями:
dateCreated: дата создания файла с точностью до миллисекунд.versionFrom: идентификатор текущей версии модели данных в текущем экземпляре Платформы.versionTo: идентификатор версии модели данных, которая будет получена в результате успешной публикации модели трансформации.
-
Массив транзакций
transactionContainers, описывающий трансформацию данных. Каждый элемент массива описывается объектом со следующими полями:-
owner: инициатор транзакции по трансформации данных. Может иметь одно из значенийsystemдля транзакций, автоматически сгенерированных Платформой, илиuserдля транзакций, созданных пользователем. При генерации файла модели трансформации данных создается массив транзакций с единственным объектом, который имеет значениеsystemполяowner. -
onError: тип дальнейшего действия при ошибке в процессе трансформации данных. ЗначениеCONTINUEуказывает на продолжение процесса, значениеSTOPуказывает на прерывание процесса. -
alias: уникальное имя транзакции, ассоциированное с выполняемым действием по трансформации данных. Используется при автоматическом создании переменной (согласно шаблонуresult_<alias>), хранящей результат выполнения транзакции. -
description: описание транзакции. -
targetService: имя сервиса, выполняющего трансформацию данных. В текущей версии трансформацию данных выполняет сервис доступа к хранилищу данных storagedata. -
items: массив действий в пределах транзакции. Каждое действие описывается объектом со следующими полями:actionType: описывает тип действия по трансформации данных. В текущей версии доступен единственный тип со значениемSQL_SCRIPT, что означает трансформацию с помощью SQL-скрипта.owner: инициатор изменения. Может иметь значениеsystemдля изменений, автоматически сгенерированных Платформой, илиuserдля изменений, описанных пользователем.description: описание выполняемого действия по трансформации.sql: тело SQL-скрипта трансформации данных.
-
Вы можете изменять содержимое файла Transform.mdtr следующими способами:
- Если вы хотите описать дополнительные транзакции, добавьте элементы в массив
transactionContainers. Добавляемые элементы должны иметь значениеuserполяowner. - Если вы хотите описать дополнительные действия в пределах транзакции, добавьте элементы в массив
items. Если элементы массиваitemsдобавляются в транзакцию, которая имеет значениеuserполяowner, значение поляownerв этом действиии может быть толькоuser.
примечание
В массиве transactionContainers может содержаться только один объект, у которого поле owner имеет значение system и произвольное количество объектов у которых поле owner имеет значение user. Порядок следования объектов (в массиве transactionContainers) с разными значениями в поле owner может быть произвольным.
При публикации модели данных модель трансформации данных будет применена. После публикации модели данных вы можете удалить файл Transform.mdtr, однако, это действие не является обязательным. Если вы решите сформировать модель трансформации еще раз, содержимое файла Transform.mdtr будет перезаписано.
Пример содержимого файла Transform.mdtr с системной и пользов ательской транзакциями
{
"dateCreated": "2025-04-13T17:36:28.9997463Z",
"versionFrom": "0b341fd4-4595-48e5-b5f5-8faedea0bb4f",
"versionTo": "200002b2-c603-4959-bdd2-ba0e7e552453",
"transactionContainers": [
{
"owner":"user",
"onError":"STOP",
"alias":"post_action",
"description":"примеры пользовательских действий",
"targetService": "storagedata",
"items":[
{
"actionType": "SQL_SCRIPT",
"owner":"user",
"description":"создание пустой таблицы",
"sql":"CREATE TABLE transformation.\"testclassA\" (\n_type_discr character varying (8) NOT NULL default $wBMy$36343892$wBMy$,\r\nid serial NOT NULL,\r\nPRIMARY KEY (id)\n);\n"
},
{
"actionType": "SQL_SCRIPT",
"owner": "user",
"description": "добавление трех атрибутов в созданную таблицу",
"sql": "ALTER TABLE transformation.\"testclassA\" ADD column columnA text,\r\nADD column columnB text,\r\nADD column columnC text;\n"
},
{
"actionType": "SQL_SCRIPT",
"owner": "user",
"description": "создание таблицы с двумя атрибутами",
"sql": "CREATE TABLE transformation.\"testclassD\" (\nnewatribA character varying (255),\r\nnewatribB text,\r\n_type_discr character varying (8) NOT NULL default $wBMy$1506e9f0$wBMy$,\r\nid serial NOT NULL,\r\nPRIMARY KEY (id)\n);\n"
},
{
"actionType": "SQL_SCRIPT",
"owner": "user",
"description": "наполнение созданной таблицы двумя кортежами",
"sql": "INSERT INTO transformation.\"testclassD\" (\nnewatribA, newatribB) VALUES\r\n('Значение 1', 'Текст для записи 1'),\r\n('Значение 2', 'Текст для записи 2');\n"
}
]
},
{
"owner": "System",
"onError": "Stop",
"alias": "system",
"description": "Системный блок трансформации модели",
"targetService": "storagedata",
"items": [
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists transformation_orders_mod_trigger on transformation.\"orders\";\r\ndrop trigger if exists transformation_orders_mod_trigger on transformation.v_orders;\n",
"changeSetId": "33b970a1-2d20-36a9-6be3-bc0bd0733fc3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists test3_testclass_mod_trigger on test3.\"testclass\";\r\ndrop trigger if exists test3_testclass_mod_trigger on test3.v_testclass;\n",
"changeSetId": "c8839860-6ef4-b8e8-92a1-310b0e0af59f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists dev1_devcls1_mod_trigger on dev1.\"devcls1\";\r\ndrop trigger if exists dev1_devcls1_mod_trigger on dev1.v_devcls1;\n",
"changeSetId": "04de14c0-f9ec-76b1-6ef9-ec034918730d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "60bf84b8-41ba-2b01-16b2-21696dc38307"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists pipeline1_pipelinecls1_mod_trigger on pipeline1.\"pipelinecls1\";\r\ndrop trigger if exists pipeline1_pipelinecls1_mod_trigger on pipeline1.v_pipelinecls1;\n",
"changeSetId": "d4f6f6d8-c9e2-09e7-9151-0ccb4be07d58"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists aproject_document_mod_trigger on aproject.\"document\";\r\ndrop trigger if exists aproject_document_mod_trigger on aproject.v_document;\r\ndrop trigger if exists aproject_file_mod_trigger on aproject.\"file\";\r\ndrop trigger if exists aproject_file_mod_trigger on aproject.v_file;\r\ndrop trigger if exists aproject_kafka_class_mod_trigger on aproject.\"kafka_class\";\r\ndrop trigger if exists aproject_kafka_class_mod_trigger on aproject.v_kafka_class;\n",
"changeSetId": "c9d293e0-8b0a-1de0-f343-cb4d468bee6f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists new1_newclass1_mod_trigger on new1.\"newclass1\";\r\ndrop trigger if exists new1_newclass1_mod_trigger on new1.v_newclass1;\n",
"changeSetId": "2b894e5f-8e8a-7c22-eba7-29916582ea8b"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists testtr1_qwerty1_mod_trigger on testtr1.\"qwerty1\";\r\ndrop trigger if exists testtr1_qwerty1_mod_trigger on testtr1.v_qwerty1;\n",
"changeSetId": "9c4e4d9d-9bfc-7b96-e468-6a846e5fef82"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists testtransformation111_cls1_mod_trigger on testtransformation111.\"cls1\";\r\ndrop trigger if exists testtransformation111_cls1_mod_trigger on testtransformation111.v_cls1;\n",
"changeSetId": "ce4addf1-a159-4c90-cdc3-1d54f7f6cc19"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "2036154d-cc7e-d998-b2e1-cc989584215d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "84bf9db4-c351-45c8-f86d-82d53005c3af"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "9708f25c-042e-e4bb-464c-3e2253d7b6a1"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "27328bb9-1521-dad0-80b2-823c16f8acf9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists library_author_mod_trigger on library.\"author\";\r\ndrop trigger if exists library_author_mod_trigger on library.v_author;\r\ndrop trigger if exists library_authorbook_mod_trigger on library.\"authorbook\";\r\ndrop trigger if exists library_authorbook_mod_trigger on library.v_authorbook;\r\ndrop trigger if exists library_book_mod_trigger on library.\"book\";\r\ndrop trigger if exists library_book_mod_trigger on library.v_book;\r\ndrop trigger if exists library_comment_mod_trigger on library.\"comment\";\r\ndrop trigger if exists library_comment_mod_trigger on library.v_comment;\r\ndrop trigger if exists library_subscription_mod_trigger on library.\"subscription\";\r\ndrop trigger if exists library_subscription_mod_trigger on library.v_subscription;\r\ndrop trigger if exists library_user_mod_trigger on library.\"user\";\r\ndrop trigger if exists library_user_mod_trigger on library.v_user;\n",
"changeSetId": "d2eea9a1-8af0-557f-280f-09c64081c0c7"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "25547bd5-7117-61f1-c610-e5e0d771bc20"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "eda234b8-088e-09da-0564-7c86d2787bc4"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "347d4b58-e798-91ed-122f-ff704a2ac502"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "6b0b88a3-03cb-06d8-21e9-dfc72268eb7a"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "c7958029-41fe-618d-66ca-788c9cfa8ea9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "ef397598-b02e-a78f-eb85-81bf567c2023"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "drop trigger if exists projectsanddocs_docset_mod_trigger on projectsanddocs.\"docset\";\r\ndrop trigger if exists projectsanddocs_docset_mod_trigger on projectsanddocs.v_docset;\r\ndrop trigger if exists projectsanddocs_organization_mod_trigger on projectsanddocs.\"organization\";\r\ndrop trigger if exists projectsanddocs_organization_mod_trigger on projectsanddocs.v_organization;\r\ndrop trigger if exists projectsanddocs_project_mod_trigger on projectsanddocs.\"project\";\r\ndrop trigger if exists projectsanddocs_project_mod_trigger on projectsanddocs.v_project;\r\ndrop trigger if exists projectsanddocs_file_mod_trigger on projectsanddocs.\"file\";\r\ndrop trigger if exists projectsanddocs_file_mod_trigger on projectsanddocs.v_file;\r\ndrop trigger if exists projectsanddocs_projectdocset_mod_trigger on projectsanddocs.\"projectdocset\";\r\ndrop trigger if exists projectsanddocs_projectdocset_mod_trigger on projectsanddocs.v_projectdocset;\n",
"changeSetId": "add59ce4-7ff8-a698-2bab-179edf36a3ef"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "b9827a75-b356-21fa-b802-9297e5039f99"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "7fcfc8f0-05a2-966c-5bde-4a6dc478bbf3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление триггера",
"sql": "\n",
"changeSetId": "42f0a92a-546d-6420-17bc-70f17d0ffcd9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists transformation.orders_mod_trigger_fun;\n",
"changeSetId": "33b970a1-2d20-36a9-6be3-bc0bd0733fc3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists test3.testclass_mod_trigger_fun;\n",
"changeSetId": "c8839860-6ef4-b8e8-92a1-310b0e0af59f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists dev1.devcls1_mod_trigger_fun;\n",
"changeSetId": "04de14c0-f9ec-76b1-6ef9-ec034918730d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "60bf84b8-41ba-2b01-16b2-21696dc38307"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists pipeline1.pipelinecls1_mod_trigger_fun;\n",
"changeSetId": "d4f6f6d8-c9e2-09e7-9151-0ccb4be07d58"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists aproject.document_mod_trigger_fun;\r\ndrop function if exists aproject.file_mod_trigger_fun;\r\ndrop function if exists aproject.kafka_class_mod_trigger_fun;\n",
"changeSetId": "c9d293e0-8b0a-1de0-f343-cb4d468bee6f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists new1.newclass1_mod_trigger_fun;\n",
"changeSetId": "2b894e5f-8e8a-7c22-eba7-29916582ea8b"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists testtr1.qwerty1_mod_trigger_fun;\n",
"changeSetId": "9c4e4d9d-9bfc-7b96-e468-6a846e5fef82"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists testtransformation111.cls1_mod_trigger_fun;\n",
"changeSetId": "ce4addf1-a159-4c90-cdc3-1d54f7f6cc19"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "2036154d-cc7e-d998-b2e1-cc989584215d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "84bf9db4-c351-45c8-f86d-82d53005c3af"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "9708f25c-042e-e4bb-464c-3e2253d7b6a1"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "27328bb9-1521-dad0-80b2-823c16f8acf9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists library.author_mod_trigger_fun;\r\ndrop function if exists library.authorbook_mod_trigger_fun;\r\ndrop function if exists library.book_mod_trigger_fun;\r\ndrop function if exists library.comment_mod_trigger_fun;\r\ndrop function if exists library.subscription_mod_trigger_fun;\r\ndrop function if exists library.user_mod_trigger_fun;\n",
"changeSetId": "d2eea9a1-8af0-557f-280f-09c64081c0c7"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "25547bd5-7117-61f1-c610-e5e0d771bc20"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "eda234b8-088e-09da-0564-7c86d2787bc4"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "347d4b58-e798-91ed-122f-ff704a2ac502"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "6b0b88a3-03cb-06d8-21e9-dfc72268eb7a"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "c7958029-41fe-618d-66ca-788c9cfa8ea9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "ef397598-b02e-a78f-eb85-81bf567c2023"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "drop function if exists projectsanddocs.docset_mod_trigger_fun;\r\ndrop function if exists projectsanddocs.organization_mod_trigger_fun;\r\ndrop function if exists projectsanddocs.project_mod_trigger_fun;\r\ndrop function if exists projectsanddocs.file_mod_trigger_fun;\r\ndrop function if exists projectsanddocs.projectdocset_mod_trigger_fun;\n",
"changeSetId": "add59ce4-7ff8-a698-2bab-179edf36a3ef"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "b9827a75-b356-21fa-b802-9297e5039f99"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "7fcfc8f0-05a2-966c-5bde-4a6dc478bbf3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление функции",
"sql": "\n",
"changeSetId": "42f0a92a-546d-6420-17bc-70f17d0ffcd9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "33b970a1-2d20-36a9-6be3-bc0bd0733fc3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "c8839860-6ef4-b8e8-92a1-310b0e0af59f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "04de14c0-f9ec-76b1-6ef9-ec034918730d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "60bf84b8-41ba-2b01-16b2-21696dc38307"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "d4f6f6d8-c9e2-09e7-9151-0ccb4be07d58"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "c9d293e0-8b0a-1de0-f343-cb4d468bee6f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "2b894e5f-8e8a-7c22-eba7-29916582ea8b"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "9c4e4d9d-9bfc-7b96-e468-6a846e5fef82"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "ce4addf1-a159-4c90-cdc3-1d54f7f6cc19"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "2036154d-cc7e-d998-b2e1-cc989584215d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "84bf9db4-c351-45c8-f86d-82d53005c3af"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "9708f25c-042e-e4bb-464c-3e2253d7b6a1"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "27328bb9-1521-dad0-80b2-823c16f8acf9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "d2eea9a1-8af0-557f-280f-09c64081c0c7"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "25547bd5-7117-61f1-c610-e5e0d771bc20"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "eda234b8-088e-09da-0564-7c86d2787bc4"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "347d4b58-e798-91ed-122f-ff704a2ac502"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "6b0b88a3-03cb-06d8-21e9-dfc72268eb7a"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "c7958029-41fe-618d-66ca-788c9cfa8ea9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "ef397598-b02e-a78f-eb85-81bf567c2023"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "add59ce4-7ff8-a698-2bab-179edf36a3ef"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "b9827a75-b356-21fa-b802-9297e5039f99"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "7fcfc8f0-05a2-966c-5bde-4a6dc478bbf3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "удаление view",
"sql": "\n",
"changeSetId": "42f0a92a-546d-6420-17bc-70f17d0ffcd9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "создание схемы, если необходимо",
"sql": "CREATE SCHEMA IF NOT EXISTS test;\n",
"changeSetId": "cbb69798-2bf1-e049-22bf-bfd4e077ff4d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "c674fecf-3a21-0b66-b182-2c8c9d28cc7c"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "df97acc0-69f8-6083-581c-a50a63d7153d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "c802fe6d-37e2-7ef7-dcd4-c89cc911e91f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "b6813e9f-cd1f-fe58-e931-49356776a6ee"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "b559fc67-db7c-a311-b55d-987e4077ad35"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "110ed540-719f-3241-ec68-eec1666208a3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "0189765a-1606-38b6-72bc-38b6743afe72"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "a36ee41e-b88b-88f7-f4b3-a44d075f41e8"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "1521aa99-5ca8-4198-0b04-fcacce04731b"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "b913a446-6e58-2350-bddf-7c5f781c4cec"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "083a3f75-cf62-5680-a99a-97842c7f754f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "2fc00b26-8333-afed-7d86-96a0cf0d607d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "a633f51e-a375-8741-aa06-9279539e55a5"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "b304ea25-5487-c085-1c2f-e15625b1a3b2"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "c69b4eac-b97c-6daf-9174-961cb8e7bbdc"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "1bb26475-4ea1-4476-6a66-0686299229af"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "3b2539a4-ef56-b9d8-f1a8-bf8448cdf6d9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "e13c5aeb-0c3a-b436-a3a4-8cb13cfb2ebb"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "b5e0cc88-487c-62bb-cfd5-cdaf83624dcc"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "6cc15deb-c338-4fb6-31c2-cee724218d9f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "b42d3331-1be8-3cd9-e185-7a203fcb38be"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "94d74d33-6828-47f5-6af4-04f1943f9e53"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "911a4697-e02f-0942-fed2-d05dedda19e5"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "4fe12c2c-3359-4864-2f5f-2c5efd192f4a"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление представлений",
"sql": "\n",
"changeSetId": "7bc3a434-55d1-946b-6a8a-748cc8f41707"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION test.testclass1_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "c674fecf-3a21-0b66-b182-2c8c9d28cc7c"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION transformation.orders_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "df97acc0-69f8-6083-581c-a50a63d7153d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION test3.testclass_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "c802fe6d-37e2-7ef7-dcd4-c89cc911e91f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION dev1.devcls1_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "b6813e9f-cd1f-fe58-e931-49356776a6ee"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "b559fc67-db7c-a311-b55d-987e4077ad35"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION pipeline1.pipelinecls1_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "110ed540-719f-3241-ec68-eec1666208a3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION aproject.document_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION aproject.file_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION aproject.kafka_class_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nif (OLD._type_discr = 'df147f32') then insert into system.sync_new (id, changeset, index_opensearch, operation) values ( uuid_generate_v1(), (select jsonb_build_object('data',jsonb_agg(jsonb_build_object('name', fields.name, 'value', fields.value, 'type', fields.field_type))) from (values ('id', CAST (OLD.id AS text), 'Int32'),('_type_discr', CAST (OLD._type_discr AS text), 'String')) as fields(name, value, field_type)), 's132616.dev.cifrum.local__df147f32_ff560828edf50fda', 0 ); end if;\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nif (NEW._type_discr = 'df147f32' and (OLD.forth_attribute_f655b03c <> NEW.forth_attribute_f655b03c)) then insert into system.sync_new (id, changeset, index_opensearch, operation) values ( uuid_generate_v1(), (select jsonb_build_object('data',jsonb_agg(jsonb_build_object('name', fields.name, 'value', fields.value, 'type', fields.field_type))) from (values ('id', CAST (NEW.id AS text), 'Int32'),('_type_discr', CAST (NEW._type_discr AS text), 'String'),('forth_attribute_f655b03c', CAST (NEW.forth_attribute_f655b03c AS text), 'String')) as fields(name, value, field_type)), 's132616.dev.cifrum.local__df147f32_ff560828edf50fda', 2 ); end if;\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nif (NEW._type_discr = 'df147f32') then insert into system.sync_new (id, changeset, index_opensearch, operation) values ( uuid_generate_v1(), (select jsonb_build_object('data',jsonb_agg(jsonb_build_object('name', fields.name, 'value', fields.value, 'type', fields.field_type))) from (values ('id', CAST (NEW.id AS text), 'Int32'),('_type_discr', CAST (NEW._type_discr AS text), 'String'),('forth_attribute_f655b03c', CAST (NEW.forth_attribute_f655b03c AS text), 'String')) as fields(name, value, field_type)), 's132616.dev.cifrum.local__df147f32_ff560828edf50fda', 1 ); end if;\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "0189765a-1606-38b6-72bc-38b6743afe72"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION new1.newclass1_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "a36ee41e-b88b-88f7-f4b3-a44d075f41e8"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION testtr1.qwerty1_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "1521aa99-5ca8-4198-0b04-fcacce04731b"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION testtransformation111.cls1_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "b913a446-6e58-2350-bddf-7c5f781c4cec"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "083a3f75-cf62-5680-a99a-97842c7f754f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "2fc00b26-8333-afed-7d86-96a0cf0d607d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "a633f51e-a375-8741-aa06-9279539e55a5"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "b304ea25-5487-c085-1c2f-e15625b1a3b2"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION library.author_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION library.authorbook_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION library.book_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION library.comment_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION library.subscription_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION library.user_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "c69b4eac-b97c-6daf-9174-961cb8e7bbdc"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "1bb26475-4ea1-4476-6a66-0686299229af"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "3b2539a4-ef56-b9d8-f1a8-bf8448cdf6d9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "e13c5aeb-0c3a-b436-a3a4-8cb13cfb2ebb"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "b5e0cc88-487c-62bb-cfd5-cdaf83624dcc"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "6cc15deb-c338-4fb6-31c2-cee724218d9f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "b42d3331-1be8-3cd9-e185-7a203fcb38be"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "CREATE OR REPLACE FUNCTION projectsanddocs.docset_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION projectsanddocs.organization_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION projectsanddocs.project_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION projectsanddocs.file_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\r\nCREATE OR REPLACE FUNCTION projectsanddocs.projectdocset_mod_trigger_fun() RETURNS trigger LANGUAGE 'plpgsql' AS $BODY$ DECLARE ins RECORD;\r\nBEGIN\r\nIF (TG_OP = 'DELETE') THEN\r\nRETURN OLD;\r\nELSIF (TG_OP = 'UPDATE') THEN\r\nRETURN NEW;\r\nELSIF (TG_OP = 'INSERT') THEN\r\nRETURN NEW;\r\nEND IF; END; $BODY$;\n",
"changeSetId": "94d74d33-6828-47f5-6af4-04f1943f9e53"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "911a4697-e02f-0942-fed2-d05dedda19e5"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "4fe12c2c-3359-4864-2f5f-2c5efd192f4a"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление функций",
"sql": "\n",
"changeSetId": "7bc3a434-55d1-946b-6a8a-748cc8f41707"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER test_testclass1_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON test.\"testclass1\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION test.testclass1_mod_trigger_fun()\r\n;\n",
"changeSetId": "c674fecf-3a21-0b66-b182-2c8c9d28cc7c"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER transformation_orders_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON transformation.\"orders\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION transformation.orders_mod_trigger_fun()\r\n;\n",
"changeSetId": "df97acc0-69f8-6083-581c-a50a63d7153d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER test3_testclass_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON test3.\"testclass\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION test3.testclass_mod_trigger_fun()\r\n;\n",
"changeSetId": "c802fe6d-37e2-7ef7-dcd4-c89cc911e91f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER dev1_devcls1_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON dev1.\"devcls1\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION dev1.devcls1_mod_trigger_fun()\r\n;\n",
"changeSetId": "b6813e9f-cd1f-fe58-e931-49356776a6ee"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "b559fc67-db7c-a311-b55d-987e4077ad35"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER pipeline1_pipelinecls1_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON pipeline1.\"pipelinecls1\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION pipeline1.pipelinecls1_mod_trigger_fun()\r\n;\n",
"changeSetId": "110ed540-719f-3241-ec68-eec1666208a3"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER aproject_document_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON aproject.\"document\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION aproject.document_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER aproject_file_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON aproject.\"file\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION aproject.file_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER aproject_kafka_class_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON aproject.\"kafka_class\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION aproject.kafka_class_mod_trigger_fun()\r\n;\n",
"changeSetId": "0189765a-1606-38b6-72bc-38b6743afe72"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER new1_newclass1_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON new1.\"newclass1\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION new1.newclass1_mod_trigger_fun()\r\n;\n",
"changeSetId": "a36ee41e-b88b-88f7-f4b3-a44d075f41e8"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER testtr1_qwerty1_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON testtr1.\"qwerty1\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION testtr1.qwerty1_mod_trigger_fun()\r\n;\n",
"changeSetId": "1521aa99-5ca8-4198-0b04-fcacce04731b"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER testtransformation111_cls1_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON testtransformation111.\"cls1\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION testtransformation111.cls1_mod_trigger_fun()\r\n;\n",
"changeSetId": "b913a446-6e58-2350-bddf-7c5f781c4cec"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "083a3f75-cf62-5680-a99a-97842c7f754f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "2fc00b26-8333-afed-7d86-96a0cf0d607d"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "a633f51e-a375-8741-aa06-9279539e55a5"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "b304ea25-5487-c085-1c2f-e15625b1a3b2"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER library_author_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON library.\"author\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION library.author_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER library_authorbook_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON library.\"authorbook\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION library.authorbook_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER library_book_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON library.\"book\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION library.book_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER library_comment_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON library.\"comment\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION library.comment_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER library_subscription_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON library.\"subscription\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION library.subscription_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER library_user_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON library.\"user\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION library.user_mod_trigger_fun()\r\n;\n",
"changeSetId": "c69b4eac-b97c-6daf-9174-961cb8e7bbdc"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "1bb26475-4ea1-4476-6a66-0686299229af"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "3b2539a4-ef56-b9d8-f1a8-bf8448cdf6d9"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "e13c5aeb-0c3a-b436-a3a4-8cb13cfb2ebb"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "b5e0cc88-487c-62bb-cfd5-cdaf83624dcc"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "6cc15deb-c338-4fb6-31c2-cee724218d9f"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "b42d3331-1be8-3cd9-e185-7a203fcb38be"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "CREATE TRIGGER projectsanddocs_docset_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON projectsanddocs.\"docset\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION projectsanddocs.docset_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER projectsanddocs_organization_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON projectsanddocs.\"organization\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION projectsanddocs.organization_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER projectsanddocs_project_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON projectsanddocs.\"project\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION projectsanddocs.project_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER projectsanddocs_file_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON projectsanddocs.\"file\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION projectsanddocs.file_mod_trigger_fun()\r\n;\r\nCREATE TRIGGER projectsanddocs_projectdocset_mod_trigger\r\nAFTER INSERT OR DELETE OR UPDATE\r\nON projectsanddocs.\"projectdocset\"\r\nFOR EACH ROW\r\nEXECUTE FUNCTION projectsanddocs.projectdocset_mod_trigger_fun()\r\n;\n",
"changeSetId": "94d74d33-6828-47f5-6af4-04f1943f9e53"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "911a4697-e02f-0942-fed2-d05dedda19e5"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "4fe12c2c-3359-4864-2f5f-2c5efd192f4a"
},
{
"actionType": "SQL_SCRIPT",
"owner": "System",
"description": "добавление триггеров",
"sql": "\n",
"changeSetId": "7bc3a434-55d1-946b-6a8a-748cc8f41707"
}
]
}
]
}