merchant

commit d1c267b6f4d3306f32a64dc56b8be910895d4611
parent 75c8023ca740511425fc34b5b75bd1f91b1df22e
Author: bohdan-potuzhnyi <bohdan.potuzhnyi@gmail.com>
Date:   Thu, 21 Nov 2024 10:52:43 +0100

small update of the categories webhook calls

Diffstat:
M
src/backenddb/merchant-0013.sql
 | 
24
++++++++++++++----------

1 file changed, 14 insertions(+), 10 deletions(-)
diff --git a/src/backenddb/merchant-0013.sql b/src/backenddb/merchant-0013.sql
@@ -52,9 +52,10 @@ BEGIN
              mw.url,
              mw.http_method,
              json_build_object(
-               'webhook_type', 'category_added',
-               'category_serial', NEW.category_serial,
-               'category_name', NEW.category_name
+                'webhook_type', 'category_added',
+                'category_serial', NEW.category_serial,
+                'category_name', NEW.category_name,
+                'category_name_i18n', NEW.category_name_i18n
              )::TEXT
       FROM merchant_webhook mw
       WHERE mw.event_type = 'category_added'
@@ -70,10 +71,12 @@ BEGIN
              mw.url,
              mw.http_method,
              json_build_object(
-               'webhook_type', 'category_updated',
-               'category_serial', NEW.category_serial,
-               'old_category_name', OLD.category_name,
-               'new_category_name', NEW.category_name
+                'webhook_type', 'category_updated',
+                'category_serial', NEW.category_serial,
+                'old_category_name', OLD.category_name,
+                'new_category_name', NEW.category_name,
+                'old_category_name_i18n', OLD.category_name_i18n,
+                'new_category_name_i18n', NEW.category_name_i18n
              )::TEXT
       FROM merchant_webhook mw
       WHERE mw.event_type = 'category_updated'
@@ -89,9 +92,10 @@ BEGIN
              mw.url,
              mw.http_method,
              json_build_object(
-               'webhook_type', 'category_deleted',
-               'category_serial', OLD.category_serial,
-               'category_name', OLD.category_name
+                'webhook_type', 'category_deleted',
+                'category_serial', OLD.category_serial,
+                'category_name', OLD.category_name,
+                'category_name_i18n', OLD.category_name_i18n
              )::TEXT
       FROM merchant_webhook mw
       WHERE mw.event_type = 'category_deleted'