问用Django StreamingHttpResponse流Excel文件

EN

def get_stuff():
def fetch_from_server_cursor(cursor, cursor_name, fetch_size=10000):
    while True:
        cursor.execute("FETCH {fetch_size} FROM {cursor_name}".format(fetch_size = fetch_size, cursor_name = cursor_name))
        chunk = cursor.fetchall()
        if not chunk:
            return
        yield from chunk

with transaction.atomic(), connection.cursor() as cursor:
    cursor_name = "my_cursor"
    cursor.execute(
        """
        DECLARE {cursor_name} CURSOR FOR
        SELECT field1,field2
        FROM {table_name}
        WHERE field3 = XX
        """.format(cursor_name = cursor_name,table_name = MyModel.objects.model._meta.db_table)
    )
    yield from fetch_from_server_cursor(cursor, cursor_name)

def stream_csv_view(request):
"""A view that streams a large CSV file."""
# Generate a sequence of rows. The range is based on the maximum number of
# rows that can be handled by a single sheet in most spreadsheet
# applications.
pseudo_buffer = Echo()
writer = csv.writer(pseudo_buffer)
response = StreamingHttpResponse((writer.writerow(row) for row in get_stuff()),
                                 content_type="text/csv")
response['Content-Disposition'] = 'attachment; filename="test.csv"'
return response