[模型.py]
class History(models.Model):
user = models.ForeignKey(User, on_delete=models.SET_NULL, blank=True)
study = models.ForeignKey(Study, on_delete=models.SET_NULL, blank=True)
summary = models.TextField(blank=True, null=True)
create_date = models.DateTimeField(auto_now_add=True)
[视图.py]
def add_history(request):
history = History(user=request.user,
study=new_study,
summary=json.dumps({
'field_summary': field_summary,
'file_summary': file_summary
}))
history.save()
def chart(request):
histories = History.objects.filter(summary__icontains='teacher', create_date__gte='2022-01-01', create_date__lte='2022-04-10')\
.annotate(teacher=json.loads('summary')['field_summary']['teacher'])\
.values('study_name', 'teacher', 'create_date')
return render(request, 'chart.html', {'histories': histories})
[图表.html]
{% for h in histories %} {{ h.study_name }},{{ h.teacher }}, {{ h.create_date }} {% endfor %}
错误为:JSONDecodeError at /chart/ 期望值:第 1 行第 1 列(字符 0)。
我只想提取摘要字段中的教师值。但注释部分出现错误。