CSV generate

csv-generate.py

def profile(request):
    response_model = generate_response(request)

    # Generate CSV
    from django.http import HttpResponse
    import csv


    users = User.objects.all()
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="User_List_TheSunCoin.csv"'

    writer = csv.writer(response, quotechar='"')
    headers = ['Username', 'Registration Date', 'Sponsor', 'User Left','User Right', 'Position']
    writer.writerow(headers)

    tmp = []
    n = 0
    for person in users:
        tmp.append(person.username)
        tmp.append(person.date_joined)

        if person.profile:
            s = person.profile.sponsor
            if s is not None:
                s = s.lower()
            tmp.append(s)
            left = AffiliateService.superuser_left(person)
            right = AffiliateService.superuser_right(person)

            if left is not None:
                tmp.append(left.user.username)
            else:
                tmp.append(' ')

            if right is not None:
                tmp.append(right.user.username)
            else:
                tmp.append(' ')

            tmp.append(person.profile.set_position)
        else:
            tmp.append('thesuncoin')
            tmp.append(' ')
            tmp.append(' ')
            tmp.append('RIGHT')

        writer.writerow(tmp)
        tmp = []
        n = len(tmp)

    return render(request, 'dashboard/user/profile.html', response_model)
    #return response