merchant

commit 440230a3c4d16f1e1e7668a5ea57520e380a2cd9
parent b4a24cbc1e54d035572eb7ff910d361d7b638c07
Author: bohdan-potuzhnyi <bohdan.potuzhnyi@gmail.com>
Date:   Sat, 30 Nov 2024 16:47:37 +0100

few updates of the webhook trigger

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

1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/backenddb/merchant-0013.sql b/src/backenddb/merchant-0013.sql
@@ -197,7 +197,7 @@ BEGIN
         resolved_body := replace_placeholder(resolved_body, 'description', NEW.description);
         resolved_body := replace_placeholder(resolved_body, 'description_i18n', encode(NEW.description_i18n, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'unit', NEW.unit);
-        resolved_body := replace_placeholder(resolved_body, 'image', encode(NEW.image, 'escape'));
+        resolved_body := replace_placeholder(resolved_body, 'image', NEW.image);
         resolved_body := replace_placeholder(resolved_body, 'taxes', encode(NEW.taxes, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'price', NEW.price::TEXT);
         resolved_body := replace_placeholder(resolved_body, 'total_stock', NEW.total_stock::TEXT);
@@ -240,8 +240,8 @@ BEGIN
         resolved_body := replace_placeholder(resolved_body, 'description_i18n', encode(NEW.description_i18n, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'old_unit', OLD.unit);
         resolved_body := replace_placeholder(resolved_body, 'unit', NEW.unit);
-        resolved_body := replace_placeholder(resolved_body, 'old_image', encode(OLD.image, 'escape'));
-        resolved_body := replace_placeholder(resolved_body, 'image', encode(NEW.image, 'escape'));
+        resolved_body := replace_placeholder(resolved_body, 'old_image', OLD.image);
+        resolved_body := replace_placeholder(resolved_body, 'image', NEW.image);
         resolved_body := replace_placeholder(resolved_body, 'old_taxes', encode(OLD.taxes, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'taxes', encode(NEW.taxes, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'old_price', OLD.price::TEXT);
@@ -289,7 +289,7 @@ BEGIN
         resolved_body := replace_placeholder(resolved_body, 'description', OLD.description);
         resolved_body := replace_placeholder(resolved_body, 'description_i18n', encode(OLD.description_i18n, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'unit', OLD.unit);
-        resolved_body := replace_placeholder(resolved_body, 'image', encode(OLD.image, 'escape'));
+        resolved_body := replace_placeholder(resolved_body, 'image', OLD.image);
         resolved_body := replace_placeholder(resolved_body, 'taxes', encode(OLD.taxes, 'escape'));
         resolved_body := replace_placeholder(resolved_body, 'price', OLD.price::TEXT);
         resolved_body := replace_placeholder(resolved_body, 'total_stock', OLD.total_stock::TEXT);