# -*- coding: utf-8 -*-

from mongoengine import *


class Report(Document):
    name = StringField()
    email = StringField()
    num_orders = StringField()
    num_products = StringField()
    total = StringField()

import csv
with open('report_result.csv', 'w') as csvfile:
    connect('order_report_base')
    spamwriter = csv.writer(csvfile)
    for report in Report.objects:
        spamwriter.writerow([report.name] + [report.email] + [report.num_orders] + [report.num_products] + [report.total])