首页 > 解决方案 > 每次运行代码时我都会收到以下错误,但我不知道出了什么问题

问题描述

我收到以下错误。任何帮助表示赞赏。我可能从文档中遗漏了一些非常重要的东西。

如果你看到它,请指出我的错误,并告诉我来自 Django 的多对多关系。从出现的错误来看,这是否意味着 .add() 函数不能在查询集上使用?

追溯

Internal Server Error: /7/
Traceback (most recent call last):
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\exception.py", line 34, in inner
    response = get_response(request)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.py", line 126, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\core\handlers\base.py", line 124, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "C:\music\songs\views.py", line 141, in Playlist_Add
    playlist.song.add(song)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\related_descriptors.py", line 926, in add
    self._add_items(self.source_field_name, self.target_field_name, *objs)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\related_descriptors.py", line 1073, in _add_items
    '%s__in' % target_field_name: new_ids,
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.py", line 844, in filter
    return self._filter_or_exclude(False, *args, **kwargs)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\query.py", line 862, in _filter_or_exclude
    clone.query.add_q(Q(*args, **kwargs))
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\sql\query.py", line 1263, in add_q
    clause, _ = self._add_q(q_object, self.used_aliases)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\sql\query.py", line 1287, in _add_q
    split_subq=split_subq,
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\sql\query.py", line 1225, in build_filter
    condition = self.build_lookup(lookups, col, value)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\sql\query.py", line 1096, in build_lookup
    lookup = lookup_class(lhs, rhs)
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\lookups.py", line 20, in __init__
    self.rhs = self.get_prep_lookup()
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\related_lookups.py", line 59, in get_prep_lookup
    self.rhs = [target_field.get_prep_value(v) for v in self.rhs]
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\related_lookups.py", line 59, in <listcomp>
    self.rhs = [target_field.get_prep_value(v) for v in self.rhs]
  File "C:\Users\hanya\AppData\Local\Programs\Python\Python37\lib\site-packages\django\db\models\fields\__init__.py", line 965, in get_prep_value
    return int(value)
TypeError: int() argument must be a string, a bytes-like object or a number, not 'QuerySet'
[16/Apr/2020 23:06:55] "GET /7/ HTTP/1.1" 500 127314

模型.py

class Playlist (models.Model):
    user = models.ForeignKey(settings.AUTH_USER_MODEL, on_delete=models.CASCADE, default=1)
    song = models.ManyToManyField(Song)

视图.py

def Playlist_Add(request, id):
    song = Song.objects.filter(id=id)
    playlist, created = Playlist.objects.get_or_create(user=request.user)
    #playlist.save()
    playlist.song.add(song)
    return redirect('home:home')

网址.py

path('<int:id>/', views.Playlist_Add, name='playlist_add'),

模板

<footer class="w3-container w3-blue">
    <a href="{% url 'playlist_add' id=obj.id %}">
    <button type="button" class="btn btn-info">+ To Playlist</button>
    </a>
    <h5>last edited:&nbsp {{objects.timestamp}}</h5>
  </footer>

标签: djangomanytomanyfield

解决方案


song不是一首歌曲,它是一QuerySet首歌曲,因此它可以包含零、一首或多首歌曲。因为你在一个主键上过滤,它只能包含零或一个Song,但无论如何,它仍然是一个集合。

您可以使用 . get(..)在 a.filter()或更好的 a 上get_object_or_404(..)

from django.shortcuts import get_object_or_404

def Playlist_Add(request, id):
    song = get_object_or_404(Song, id=id)
    playlist, created = Playlist.objects.get_or_create(user=request.user)
    #playlist.save()
    playlist.song.add(song)
    return redirect('home:home')

注意:GET 请求应该有副作用,因此在用户发出 GET 请求时构造对象不符合 HTTP 标准。因此,最好将其转换为 POST 请求。


推荐阅读