python - "Prefecture.area" must be a "Area" instance -


i got error,

valueerror: cannot assign "<queryset [<area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, <area: area object>, '...(remaining elements truncated)...']>": "prefecture.area" must "area" instance. 

i wanna parse excel , put model(city&prefecture&area&user) . wrote

fourrows_transpose = list(map(list, zip(*fourrows)))   val3 = sheet3.cell_value(rowx=0, colx=9)   user3 = user.objects.filter(corporation_id=val3).first()   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()     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]) 

i wanna put these data : [['america', '', '', '', ''], ['', '', 'u1000', '500~1000', 'd500'], ['ny', 'city a', '×', '×', '×'], ['', 'city b', '×', '×', '×'], ['', 'city c', '×', '×', '×'], ['', 'city d', '×', '×', '×'], ['', 'city e', '×', '×', '×']] models 'america' prefecture's area , city a city's name , × to price's name.

models.py :

class area(models.model):     name = models.charfield(max_length=20, verbose_name='area', null=true) class user(models.model):     user_id = models.charfield(max_length=200,null=true)     area = models.foreignkey('area',null=true, blank=true)  class prefecture(models.model):     name = models.charfield(max_length=20, verbose_name='prefecture')     area = models.foreignkey('area', null=true, blank=true)  class city(models.model):     name = models.charfield(max_length=20, verbose_name='city')     prefecture = models.foreignkey('prefecture', null=true, blank=true)  class price(models.model):     name = models.charfield(max_length=20, verbose_name='price')     city = models.foreignkey('city', null=true, blank=true) 

i cannot understand why happens many times. how can fix this?what should write it?


Comments

Popular posts from this blog

neo4j - finding mutual friends in a cypher statement starting with three or more persons -

php - How to remove letter in front of the word laravel -

minify - Minimizing css files -