changeset 1b99cee3a0fd in modules/notification_email:default
details: 
https://hg.tryton.org/modules/notification_email?cmd=changeset&node=1b99cee3a0fd
description:
        Do not migrate log without trigger

        The notification and resource columns are required so they can not be 
updated
        with NULL value when there is no trigger linked.

        issue10622
        review369341002
diffstat:

 notification.py |  4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diffs (21 lines):

diff -r f8724016634c -r 1b99cee3a0fd notification.py
--- a/notification.py   Mon Jul 12 23:12:23 2021 +0200
+++ b/notification.py   Thu Aug 12 18:36:32 2021 +0200
@@ -8,6 +8,7 @@
 from email.mime.nonmultipart import MIMENonMultipart
 from email.utils import getaddresses
 
+from sql import Null
 from sql.operators import Concat
 from genshi.template import TextTemplate
 
@@ -399,7 +400,8 @@
                 where=trigger.id == table.trigger))
         cursor.execute(*table.update(
                 [table.notification, table.resource],
-                [notification, resource]))
+                [notification, resource],
+                where=table.trigger != Null))
         table_h.not_null_action('trigger', 'remove')
 
     def get_date(self, name):

Reply via email to