python - 如何将视图中的变量值存储到 Django 模型中?
问题描述
在我的终端中,名称和分数的值正在显示,但是如何将这两个变量值存储到特定的模型(结果)中。
模型.py:
class Results(models.Model):
username = models.CharField(max_length=50,default='')
score = models.IntegerField(null=True,blank=True)
视图.py:
@login_required
def html2(request):
name = request.GET.get('name')
scores = request.GET.get('scores')
print(name, scores)
save_data = Results.objects.create(username=name, score=scores)
context = {
'data': save_data
}
return render(request,'quiz/html/html2.html',context)
终端:
[29/May/2020 13:15:22] "GET /api2/?format=json HTTP/1.1" 200 1467
Pavana 40
我尝试了此语句,但它显示非空约束错误,因此我删除了该语句 错误:
Traceback:
File "C:\Python38-32\lib\site-packages\django\db\backends\utils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:\Python38-32\lib\site-packages\django\db\backends\sqlite3\base.py" in execute
296. return Database.Cursor.execute(self, query, params)
The above exception (NOT NULL constraint failed: quiz_results.username) was the direct cause of the following exception:
File "C:\Python38-32\lib\site-packages\django\core\handlers\exception.py" in inner
34. response = get_response(request)
File "C:\Python38-32\lib\site-packages\django\core\handlers\base.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "C:\Python38-32\lib\site-packages\django\core\handlers\base.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:\Python38-32\lib\site-packages\django\contrib\auth\decorators.py" in _wrapped_view
21. return view_func(request, *args, **kwargs)
File "C:\Users\user\dev\samplequiz\quiz\views.py" in html2
58. save_data = Results.objects.create(username=name, score=scores)
File "C:\Python38-32\lib\site-packages\django\db\models\manager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:\Python38-32\lib\site-packages\django\db\models\query.py" in create
413. obj.save(force_insert=True, using=self.db)
File "C:\Python38-32\lib\site-packages\django\db\models\base.py" in save
717. self.save_base(using=using, force_insert=force_insert,
File "C:\Python38-32\lib\site-packages\django\db\models\base.py" in save_base
748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "C:\Python38-32\lib\site-packages\django\db\models\base.py" in _save_table
831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "C:\Python38-32\lib\site-packages\django\db\models\base.py" in _do_insert
868. return manager._insert([self], fields=fields, return_id=update_pk,
File "C:\Python38-32\lib\site-packages\django\db\models\manager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:\Python38-32\lib\site-packages\django\db\models\query.py" in _insert
1136. return query.get_compiler(using=using).execute_sql(return_id)
File "C:\Python38-32\lib\site-packages\django\db\models\sql\compiler.py" in execute_sql
1289. cursor.execute(sql, params)
File "C:\Python38-32\lib\site-packages\django\db\backends\utils.py" in execute
100. return super().execute(sql, params)
File "C:\Python38-32\lib\site-packages\django\db\backends\utils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:\Python38-32\lib\site-packages\django\db\backends\utils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "C:\Python38-32\lib\site-packages\django\db\backends\utils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:\Python38-32\lib\site-packages\django\db\utils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:\Python38-32\lib\site-packages\django\db\backends\utils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:\Python38-32\lib\site-packages\django\db\backends\sqlite3\base.py" in execute
296. return Database.Cursor.execute(self, query, params)
Exception Type: IntegrityError at /
Exception Value: NOT NULL constraint failed: quiz_results.username
save_data = Results.objects.create(username=name, score=scores)
如何将名称和分数存储到结果模型中。
解决方案
这是因为数据库表中列的所有字段都是空的,这不好。您必须至少有一个字段不为空,因此请删除用户名中的 default=''。即它应该看起来像这样username = models.CharField(max_length=50 )
运行makemigrations 并迁移命令以与数据库同步。
推荐阅读
- python - Spark使用mappartitions将rdd文本文件转换为列,同时保留空值
- flutter - 如何让 RotateTransition 将我的小部件旋转一半(180 度)
- c# - 使用启动窗口运行 Windows 窗体应用程序
- javascript - 如何在javascript中设置数组对象的键值?
- python - 根据列值复制数据框的特定行
- c# - 将长数据分成最多16个二维码并在C#中读取时将它们组合起来的“连接功能”
- arduino - 带伺服电机的arduino加速度计
- bash - 通过 bash 脚本打开文件并将一个字符串替换为另一个字符串
- lua - 车辆生成菜单在lua中无限循环
- python - 将文本区域输入从 html 传递到烧瓶