app.models.multipleObject返回：get（）返回了多个用户它返回了17

Question

我有个错误，app.models.multipleObject返回：get（）返回了多个用户--它返回了17。 我想解析excel并把它放到模型中（城市和地区&用户）。我写的

  fourrows_transpose = list(map(list, zip(*fourrows)))
  val3 = sheet3.cell_value(rowx=0, colx=9)
  user3 = User.objects.get(corporation_id=val3)
  print(user3)
  if user3:
   area = Area.objects.filter(name="America")
   pref = Prefecture.objects.create(name="prefecture", area=user3.area)
   city = City.objects.create(name="city", prefecture=pref)
   price_u1000 = Price.upper1000.objects.get(city=city)
   price_500_1000 = Price.from500to1000.objects.get(city=city)
   price_u500 = Price.under500.objects.get(city=city)

   pref.name = "NY"
   pref.save()

   for i in range(len(fourrows_transpose)):
       city.name = fourrows_transpose[i][1]
       city.save()
       print(fourrows_transpose[i][1])

       price_u1000.name = fourrows_transpose[i][2]
       price_u1000.save()
       print(fourrows_transpose[i][2])

       price_500_1000.name = fourrows_transpose[i][3]
       price_500_1000.save()
       print(fourrows_transpose[i][3])

       price_u500.name = fourrows_transpose[i][4]
       price_u500.save()
       print(fourrows_transpose[i][4])

我想把这些数据 [['America', '', '', '', ''], ['', '', 'u1000', '500～1000', 'd500'], ['NY', 'City A', '×', '×', '×'], ['', 'City B', '×', '×', '×'], ['', 'City C', '×', '×', '×'], ['', 'City D', '×', '×', '×'], ['', 'City E', '×', '×', '×']] 像“美国”到地区，城市A到城市名称和价格。我该怎么解决这个问题？我应该写什么？在

Answer 1

尝试使用此方法捕获实例的第一条记录first（）

user3 = User.objects.filter(corporation_id=val3).first()

它有助于获取特定对象实例的第一条记录，这些可以对您有所帮助