Django 1.6: ValueError 无法将字符串转换为整数

Question

我正在尝试根据从上一页获取的专业输入来筛选医生对象，但我一直遇到这个错误。

Traceback:
File "/Library/Python/2.7/site-packages/django/core/handlers/base.py" in get_response
  114.                     response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/Library/Python/2.7/site-packages/django/views/decorators/csrf.py" in wrapped_view
  57.         return view_func(*args, **kwargs)
File "views.py" in doclistings
  87.     doctors = Doctor.objects.filter(specialization = s).order_by('-likes')


Exception Type: ValueError at /doclistings/
Exception Value: invalid literal for int() with base 10: 'Dentist'

这是我尝试筛选的视图。

def doclistings(request):
    d = getVariables(request)
    s = request.session.get('selection')
    d['userselection'] = s
    doctors = Doctor.objects.filter(specialization = s).order_by('-likes')
    paginator = Paginator(doctors, 20) #Show 20 doctors per page
    page =  page = request.GET.get('page')

 try:
        doctors = paginator.page(page)
    except PageNotAnInteger:
        doctors = paginator.page(1)
    except EmptyPage:
        doctors = paginator.page(paginator.num_pages)
    d['doctors'] = doctors
    d['paginator'] = paginator

    return render_to_response('meddy1/doclistings.html',d)

这是医生模型。

class Doctor(models.Model):
    name = models.CharField(max_length=100)
    specialization = models.ForeignKey(Specialization)
    clinic = models.ForeignKey(Clinic)
    seekers = models.ManyToManyField(User, through='UserContent')
    likes = models.IntegerField(default=0)

这是专业模型。

class Specialization(models.Model):
    name = models.CharField(max_length=30)

这是我放置表单的索引模板。

<div class="signup">
          <div class="form-group">
            <form action="" method="post" >
            <select class="form-control" id="selection" name="selection">
              <option><b>Find a Doctor...</b></option>
              {% for value, text in form.selection.field.choices %}
                <option value="{{ value }}">{{ text }}</option>
              {% endfor %}
              {% csrf_token %}
            </select>
<span class="input-group-btn">
              <button class="btn btn-primary" type="submit"  name="submit" id="ss-submit">Find Doctors</button>
            </span>
          </div>
        </div>

我在doclisting.html中打印出来，以检查我得到的选择值。

  <h2>{{userselection}}</h2> 

我只是想根据专业来筛选医生对象，并按点赞数从高到低排序。

Answer 1

我觉得你应该在你的views.py文件里这样做：

def doclistings(request):
    d = getVariables(request)
    s_name = request.session.get('selection')  # Change variable name
    d['userselection'] = s_name  # Update this for new variable name s_name
    spec = Specialization.objects.get(name=s_name)  # Get spec object
    # Now this should work:
    doctors = Doctor.objects.filter(specialization = spec).order_by('-likes')  
    paginator = Paginator(doctors, 20) #Show 20 doctors per page
    page =  page = request.GET.get('page')

 try:....

---

正如@Rohan所说，你也可以这样做：

def doclistings(request):
    d = getVariables(request)
    s_name = request.session.get('selection')  # Change variable name
    d['userselection'] = s_name  # Update this for new variable name s_name
    # Now this should work:
    doctors = Doctor.objects.filter(specialization__name = s_name).order_by('-likes')  
    paginator = Paginator(doctors, 20) #Show 20 doctors per page
    page =  page = request.GET.get('page')

 try:....

在第二种方法中，你不需要获取专业对象，而是使用 specialization__name 来告诉Django，找出那些与 specialization 相关联的医生，并且他们的 name 等于 s_name。