[tryton-commits] changeset in modules/account_dunning:default Replace cursor fetc...

[Cédric Krier]

changeset cce84836da4f in modules/account_dunning:default
details: 
https://hg.tryton.org/modules/account_dunning?cmd=changeset&node=cce84836da4f
description:
        Replace cursor fetchall by iteration over cursor

        issue5817
        review335831003
diffstat:

 dunning.py |  8 +++++---
 1 files changed, 5 insertions(+), 3 deletions(-)

diffs (26 lines):

diff -r ba4f0f95aaad -r cce84836da4f dunning.py
--- a/dunning.py        Fri Mar 05 15:49:19 2021 +0100
+++ b/dunning.py        Sun Mar 21 16:09:13 2021 +0100
@@ -37,7 +37,9 @@
 
     @classmethod
     def __register__(cls, module_name):
-        cursor = Transaction().connection.cursor()
+        transaction = Transaction()
+        cursor = transaction.connection.cursor()
+        update = transaction.connection.cursor()
         table = cls.__table_handler__(module_name)
         sql_table = cls.__table__()
 
@@ -47,9 +49,9 @@
         if table.column_exist('days'):
             cursor.execute(*sql_table.select(sql_table.id, sql_table.days,
                     where=sql_table.days != Null))
-            for id_, days in cursor.fetchall():
+            for id_, days in cursor:
                 overdue = datetime.timedelta(days)
-                cursor.execute(*sql_table.update(
+                update.execute(*sql_table.update(
                         [sql_table.overdue],
                         [overdue],
                         where=sql_table.id == id_))