add a new method iter_process_result which does the same as proces_result but is a generator (closes #1625374) process_result is reimplemented using the new method, and the two helper methods are turned into generators. These generators use cursor.fetchmany instead of cursor.fetchall after setting cursor.arraysize to 100. This means that the whole result set should never loaded in memory when using the iter_process_result method. This is used in the "portable" database dump implementation when we typically to 'SELECT * FROM table', but could probably be used too in other parts of cubicweb.

     1

@echo off

     2

rem = """-*-Python-*- script

     3

rem -------------------- DOS section --------------------

     4

rem You could set PYTHONPATH or TK environment variables here

     5

python -x "%~f0" %*

     6

goto exit

     7

     8

"""

     9

# -------------------- Python section --------------------

    10

import sys

    11

from os.path import join, dirname, normpath

    12

sys.path.insert(0, normpath(join(dirname(__file__), '..', '..')))

    13

from cubicweb.cwctl import run

    14

run(sys.argv[1:])

    15

    16

DosExitLabel = """

    17

:exit

    18

rem """

    19

    20