饼图查询集

Question

我想我只是在这里犯了一个简单的错误，但我似乎无法解决它。我试图创建一些假数据，并通过不同类型的用户分析，然后我会放入饼图。下面是我的models.py：

from django.db import models

import factory
import factory.django
import factory.fuzzy
from datetime import datetime
from django.core.validators import MinValueValidator, MaxValueValidator
from faker import Faker
from faker.providers import BaseProvider
import random


class User(models.Model):
    name = models.CharField(max_length=64)
    address = models.CharField(max_length=128)
    phone_number = models.CharField(max_length=32)
    access_date = models.DateTimeField(default=datetime.now(), blank=True)
    session_duration = models.IntegerField(default = 0, validators=[MinValueValidator(0),
                               MaxValueValidator(5)])
    traffic_source = models.CharField(max_length=32)
    created_account = models.BooleanField(default=True)
    paid_customer = models.BooleanField(default=True)
    user_type = models.CharField(max_length=128, default = 'all_others')


class UserFactory(factory.django.DjangoModelFactory):
    class Meta:
        model = User

    name = factory.Faker('name')
    address = factory.Faker('address')
    phone_number = factory.Faker('phone_number')
    access_date = factory.Faker('date')
    session_duration = factory.Faker('random_int')
    traffic_source = factory.fuzzy.FuzzyChoice(['Google', 'Facebook'])
    created_account = factory.Faker('pybool')
    paid_customer = factory.Faker('pybool')
    user_type = factory.fuzzy.FuzzyChoice(['registered', 'paid', 'all_others'])

和我的views.py:

from django.shortcuts import render

from django.db.models import Sum
from django.http import JsonResponse

from mysite.models import User


def home(request):
    return render(request, 'home.html')


def pie_chart(request):
    labels = [User.user_type]
    registered_user = User.objects.filter('registered')
    paid_user = User.objects.count('paid')
    all_others = User.objects.count('all_others')
    data = [registered_user, paid_user, all_others]

    #queryset = User.objects.order_by('-access_date')
    #for user in queryset:
        #labels.append(user.user_type)
        #data.append(user.user_count)

    return render(request, 'pie_chart.html', {
        'labels': labels,
        'data': data,
    })

Answer 1

谢谢大家的意见。我可以通过对views.py进行以下更改来解决这个问题。请随意留下其他评论，但我现在将关闭它。

from django.shortcuts import render

from django.db.models import Sum
from django.http import JsonResponse

from mysite.models import User


def home(request):
    return render(request, 'home.html')


def pie_chart(request):

    queryset = User.objects.order_by('-access_date')

    total_registered = 0
    total_paid = 0
    total_others = 0

    labels = ['total_registered', 'total_paid', 'total_others']

    for user in queryset:

        if user.created_account == 1:
            total_registered = total_registered + 1

        elif user.paid_customer == 1:
            total_paid = total_paid + 1

        elif user.created_account == 0 and user.paid_customer == 0:
            total_others = total_others + 1


    data = [total_registered, total_paid, total_others]

    return render(request, 'pie_chart.html', {
        'labels': labels,
        'data': data,
    })