Cannot resolve keyword... | Forum | Django на русском

28 Oct. 2011, 1:08

razrabotkaphp

Posts: 23

28 Oct. 2011, 1:08

razrabotkaphp

Posts: 23

У меня есть модель:

class Message(models.Model):
    datetime = models.DateTimeField()
    taker = models.ForeignKey(User, related_name='taker')
    sender = models.ForeignKey(User, related_name='sender')
    message = models.TextField()

    def __unicode__(self):
        return self.message

и вьюшка:

def detail(request,pk):
    user = get_object_or_404(User,pk=pk)
    wall_messages_list = Message.objects.filter(taker=user).order_by('-datetime')[:5]
    return render(request,'detail.html',{'user':user, 'wall_messages_list':wall_messages_list})

вылетает ошибка Cannot resolve keyword 'taker' into field. Choices are: id, message, user

пробовал даже менять вьюшку на

def detail(request,pk):
    user = get_object_or_404(User,pk=pk)
    wall_messages_list = Message.objects.filter(taker__id=pk).order_by('-datetime')[:5]
    return render(request,'detail.html',{'user':user, 'wall_messages_list':wall_messages_list})

но таже фигня, помогите разобраться

Answer | 0

28 Oct. 2011, 3:20 RaD Posts: 2826 Location: Снегири, МО	28 Oct. 2011, 3:20 RaD Posts: 2826 Location: Снегири, МО Скорее всего, не та модель. Если ничего не помогает, прочтите документацию, наконец!
	Answer \| 0

28 Oct. 2011, 3:21 FoRever_Zambia Posts: 6	28 Oct. 2011, 3:21 FoRever_Zambia Posts: 6 а в базе данных все таблички правильные?
	Answer \| 0

28 Oct. 2011, 3:50 alerion Posts: 5750 Location: Львов	28 Oct. 2011, 3:50 alerion Posts: 5750 Location: Львов Выложите полный трейсбек. Фиксю баги по трейсбеку.
	Answer \| 0

28 Oct. 2011, 19:05

razrabotkaphp

Posts: 23

28 Oct. 2011, 19:05

razrabotkaphp

Posts: 23

Environment:

Request Method: GET Request URL: http://localhost:8000/1/

Django Version: 1.3.1 Python Version: 2.6.5 Installed Applications: ['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'django.contrib.admin', 'wall'] Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware')

Traceback: File "/usr/lib/python2.6/site-packages/django/core/handlers/base.py" in get_response 111. response = callback(request, callback_args, callback_kwargs) File "/home/Admin/Django/mysite/../mysite/wall/views.py" in detail 7. wall_messages_list = Message.objects.filter(taker=user).order_by('-datetime')[:5] File "/usr/lib/python2.6/site-packages/django/db/models/manager.py" in filter 141. return self.get_query_set().filter(*args, kwargs) File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in filter 550. return self._filter_or_exclude(False, args, kwargs) File "/usr/lib/python2.6/site-packages/django/db/models/query.py" in _filter_or_exclude 568. clone.query.add_q(Q(*args, kwargs)) File "/usr/lib/python2.6/site-packages/django/db/models/sql/query.py" in add_q 1194. can_reuse=used_aliases, force_having=force_having) File "/usr/lib/python2.6/site-packages/django/db/models/sql/query.py" in add_filter 1069. negate=negate, process_extras=process_extras) File "/usr/lib/python2.6/site-packages/django/db/models/sql/query.py" in setup_joins 1260. "Choices are: %s" % (name, ", ".join(names)))

Exception Type: FieldError at /1/ Exception Value: Cannot resolve keyword 'taker' into field. Choices are: id, message, user

Answer | 0

28 Oct. 2011, 22:01 alerion Posts: 5750 Location: Львов	28 Oct. 2011, 22:01 alerion Posts: 5750 Location: Львов Муть какая-то. Сделайте `print type(Message)` и убедитесь что модель именно та, которая нужна. Фиксю баги по трейсбеку.
	Answer \| 0

28 Oct. 2011, 22:14 reebokey Posts: 4	28 Oct. 2011, 22:14 reebokey Posts: 4 https://github.com/fletcher35/Django
	Answer \| 0

28 Oct. 2011, 23:03

FoRever_Zambia

Posts: 6

28 Oct. 2011, 23:03

FoRever_Zambia

Posts: 6

в django.contrib.auth.models уже есть модель Message, поэтому чтобы избавиться от ошибки - делайте не from django.contrib.auth.models import * a from django.contrib.auth.models import User

# django,contrib.auth.models.Message
class Message(models.Model):
    """
    The message system is a lightweight way to queue messages for given
    users. A message is associated with a User instance (so it is only
    applicable for registered users). There's no concept of expiration or
    timestamps. Messages are created by the Django admin after successful
    actions. For example, "The poll Foo was created successfully." is a
    message.
    """
    user = models.ForeignKey(User, related_name='_message_set')
    message = models.TextField(_('message'))

    def __unicode__(self):
        return self.message

Updated 28 Oct. 2011, 23:08 by FoRever_Zambia.

Answer | 0

28 Oct. 2011, 23:06 razrabotkaphp Posts: 23	28 Oct. 2011, 23:06 razrabotkaphp Posts: 23 а разницы
	Answer \| 0

28 Oct. 2011, 23:11 FoRever_Zambia Posts: 6	28 Oct. 2011, 23:11 FoRever_Zambia Posts: 6 что разницЫ? по-моему, всё понятно - другая модель Updated 28 Oct. 2011, 23:12 by FoRever_Zambia.
	Answer \| 0

28 Oct. 2011, 23:12 razrabotkaphp Posts: 23	28 Oct. 2011, 23:12 razrabotkaphp Posts: 23 Всё заработало, методом тыка)
	Answer \| 0

8 July 2019, 9:15

gugleadik

Posts: 2

8 July 2019, 9:15

gugleadik

Posts: 2

Всем привет! Получаю ошибку related Field got invalid lookup: icontains

admin.py

class CartsAdmin(admin.ModelAdmin):

list_display = ('id' ,'FIO','SN','HidNum','Model','Priznak','BData')
search_fields = ['FIO']

model.py

class Person (models.Model):

FIO = models.CharField(verbose_name=u"ФИО", max_length=60)

class Carts(models.Model):

SN = models.CharField(max_length=40)
HidNum = models.CharField(max_length=12)
Model = models.ForeignKey(ModelCarts, on_delete=None, null=True)
Priznak= models.ForeignKey(Priznak, on_delete=None)
FIO = models.ForeignKey(Person, on_delete=None)

Подскажите, как сделать, чтоб по ForeignKey искало на странице Carts ?

Updated 8 July 2019, 9:19 by gugleadik.

Answer | 0

8 July 2019, 17:46 memantulov Posts: 359 Location: Кодинск	8 July 2019, 17:46 memantulov Posts: 359 Location: Кодинск `search_fields = ['FIO__FIO']`
	Answer \| 0

9 July 2019, 6:39

gugleadik

Posts: 2

9 July 2019, 6:39

gugleadik

Posts: 2

Спасибо!!! Это работает! admin.py

class CartsAdmin(admin.ModelAdmin):

list_display = ('id' ,'FIO','SN','HidNum','Model','Priznak','BData')

search_fields = ['FIO__FIO']

model.py class Person (models.Model):

FIO = models.CharField(verbose_name=u"ФИО", max_length=60) class Carts(models.Model):

SN = models.CharField(max_length=40) HidNum = models.CharField(max_length=12) Model = models.ForeignKey(ModelCarts, on_delete=None, null=True) Priznak= models.ForeignKey(Priznak, on_delete=None) FIO = models.ForeignKey(Person, on_delete=None)

Толку мало от документации https://docs.djangoproject.com/en/2.2/ref/contrib/admin/ без работающего примера, чтоб понять механизм Написано search_fields = ['foreign_key__related_fieldname'].. .....

Updated 9 July 2019, 6:50 by gugleadik.

Answer | 0

9 July 2019, 9:41

memantulov

Posts: 359
Location: Кодинск

9 July 2019, 9:41

memantulov

Posts: 359
Location: Кодинск

Всё правильно написано. Внешний ключ__имя поля, по которому фильтровать. Если немного понимать СУБД, то всё понятно. Внешний ключ - это, по умолчанию id в связанной таблице - целое число. Какой смысл по нему поиск производить. Тем более в админке поиск icontains - поиск подстроки.

да и полей в главной таблице может быть не одно.

Updated 9 July 2019, 10:12 by memantulov.

Answer | 0