我想在django中显示两个连接表的外键数据，我已经设置好了，但它没有显示任何东西，这是我的文件:
models.py:
from django.db import models
from django.utils.encoding import smart_unicode
class Course (models.Model):
Course_name=models.CharField(max_length=120,null=False,blank=False)
course_id=models.AutoField(primary_key=True)
course_idtomatch=models.IntegerField(max_length=2)
def __unicode__(self):
return smart_unicode(self.Course_name)
class Subjectsnames(models.Model):
subject_name=models.CharField(max_length=50)
course=models.ForeignKey(Course)
def List item__unicode__(self):
return smart_unicode(self.subject_name)
views.py:
from django.shortcuts import render
from django.shortcuts import render_to_response
from django.template import RequestContext
from .models import Subjectsnames
from .models import Course
def Subjects(request):
Subject = Subjectsnames.objects.get(id=id)
subjects_data = {
"subjects_names":Subject
}
print subjects_data
return render_to_response("code.html",subjects_data,context_instance=RequestContext(request))
code.html:
<html>
{% for name in Subjectsnames %}
Name:{{name.subject_name}}
Id:{{name.id}}
{% endfor %}
</html>
我的数据库中有这些数据:
Subjectsnames:
+----+-----------------+-----------+
| id | subject_name | course_id |
+----+-----------------+-----------+
| 2 | Organic | 1 |
| 3 | inorganic | 1 |
| 4 | thermodynacmics | 2 |
| 5 | vectors | 2 |
| 6 | trigo | 3 |
| 7 | algebra | 3 |
| 8 | relational | 3 |
| 9 | c++ | 4 |
| 10 | c# | 4 |
+----+-----------------+-----------+
:
+-------------+-----------+------------------+
| Course_name | course_id | course_idtomatch |
+-------------+-----------+------------------+
| chemistry | 1 | 1 |
| pyhics | 2 | 2 |
| maths | 3 | 3 |
| computers | 4 | 4 |
+-------------+-----------+------------------+
忽略course_idtomatch
据我所知，我可能在code.html中的for循环中做错了什么。如果有人知道，请帮助我解决这个问题，提前谢谢。
我已经更新了views.py如下:
from django.conf import settings
settings.configure()
from django.shortcuts import render, render_to_response, RequestContext
from django.db import models
from .models import Course
from .models import Subjectsnames
def Subjects(request):
Subject = Subjectsnames.objects.get(id=id)
subjects_data = {
"subjects_names":Subject
}
print subjects_data
return render_to_response("code.html",subjects_data,context_instance=RequestContext(request))
print Subject
但是现在当我在终端上运行python views.py时，我得到一个错误:
Traceback (most recent call last):
File "views.py", line 7, in <module>
from .models import Course
ValueError: Attempted relative import in non-package
试试这个
Name:{{subjects_names.subject_name}}
Id:{{subjects_names.id}}
因为你只呈现一个对象而不是一个查询集，所以你不需要forloop
我希望，这行中的id是在某处定义的:
Subject = Subjectsnames.objects.get(id=id)