如何迭代 django 模型的查询列表

Question

我正在从网站读取 json 文件，如果该记录不在我的客户查询集中，我想为该记录创建一个新客户。发生的事情是当我遍历查询集时，Django 试图创建一个新的 Customer，即使它已经在查询集中。

请看我下面的代码：

from rest_framework import generics

from customer.models import Customers

from .serializers import CustomersSerializer

import json

import urllib.request

class CustomerAPIView(generics.ListAPIView):

    j = urllib.request.urlopen("https://web.njit.edu/~jsd38/json/customer.json")

    customer_data = json.load(j)

    queryset1 = Customers.objects.values_list('CustomerId', flat=True)

    for customer in customer_data:

        if customer["@Id"] not in queryset1.iterator():

            CustomerId = customer["@Id"]

            Name = customer["Name"]

            PhoneNumber = customer["PhoneNumber"]

            EmailAddress = customer["EmailAddress"]

            StreetLine = customer["Address"]["StreetLine1"]

            City = customer["Address"]["City"]

            StateCode = customer["Address"]["StateCode"]

            PostalCode = customer["Address"]["PostalCode"]

            cus = Customers()

            cus.CustomerId = CustomerId

            cus.Name = Name

            cus.PhoneNumber = PhoneNumber

            cus.EmailAddress = EmailAddress

            cus.StreetLine = StreetLine

            cus.City = City

            cus.StateCode = StateCode

            cus.PostalCode = PostalCode

            cus.save()

    queryset = Customers.objects.all()

    serializer_class = CustomersSerializer

Answer 1

您的 JSON 正在返回“@Id”键的字符串，我假设您的模型Customers将整数作为CustomerId字段。您应该将它们转换为stror int：if int(customer["@Id"]) not in queryset1:     ...