django - 每次运行代码时我都会收到以下错误,但我不知道出了什么问题
问题描述
我收到以下错误。任何帮助表示赞赏。我可能从文档中遗漏了一些非常重要的东西。
如果你看到它,请指出我的错误,并告诉我来自 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:  {{objects.timestamp}}</h5>
</footer>
解决方案
你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 请求。
推荐阅读
- azure-active-directory - 与另一个租户中的应用注册交谈时 Azure Databricks 抛出错误
- html - 在工具按钮后启用悬停颜色
- python - 查找两条 3D 折线的交点
- flutter - 来自 QueryDocumentSnapshot 的访问列表字段
- php - : 和 ?? 之间有什么区别?PHP 运算符?
- python-3.x - DeprecationWarning: executable_path has been deprecated, please pass in a Service object
- django - 在 Django 中处理重复的引导模式
- web-component - 我应该如何将 Web 组件添加到页面?
- php - PHP shell_exec:PHP 总是等待完成
- node.js - 如何从 s3 存储桶中的 tar.gz 读取文件