changeset 297c5dd2261a in modules/project_invoice:6.0
details:
https://hg.tryton.org/modules/project_invoice?cmd=changeset&node=297c5dd2261a
description:
Prevent division by zero when migrating effort into progress
issue10990
review370341002
(grafted from a7422b368042e9ce7666b55428cce24d8cb8826e)
diffstat:
project.py | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diffs (20 lines):
diff -r 63571a6b9d5d -r 297c5dd2261a project.py
--- a/project.py Fri Dec 03 21:53:13 2021 +0100
+++ b/project.py Mon Dec 06 23:21:49 2021 +0100
@@ -11,6 +11,7 @@
from sql.aggregate import Sum
from sql.functions import Extract
from sql.operators import Concat
+from sql.conditionals import NullIf
from trytond.i18n import gettext
from trytond.model import ModelSQL, ModelView, fields
@@ -684,7 +685,7 @@
# Don't use UPDATE FROM because SQLite does not support it.
value = work.select(
(Extract('EPOCH', sql_table.effort_duration)
- / Extract('EPOCH', work.effort_duration)),
+ / NullIf(Extract('EPOCH', work.effort_duration), 0)),
where=work.id == sql_table.work)
cursor.execute(*sql_table.update([sql_table.progress], [value]))
