changeset 18260db697cd in modules/project_invoice:6.2
details:
https://hg.tryton.org/modules/project_invoice?cmd=changeset&node=18260db697cd
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 ad868b3ee2eb -r 18260db697cd project.py
--- a/project.py Fri Dec 03 21:52:54 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
@@ -663,7 +664,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]))
