时间戳

首页 > 解决方案 > MainList 缺少 QuerySet。定义 MainList.model、MainList.queryset 或覆盖 MainList.get_queryset()

python - MainList 缺少 QuerySet。定义 MainList.model、MainList.queryset 或覆盖 MainList.get_queryset()

问题描述

您好我正在尝试有一个主页，我可以从一个名为 Lecturer 的模型中列出，并从一个名为 DistributionForm 的模型中创建表单。我用 CreateView 尝试过，但我得到错误MainList is missing a QuerySet。定义 MainList.model、MainList.queryset 或覆盖 MainList.get_queryset()。 在查询集丢失的情况下。你能帮我么。

视图.py

class MainList(generic.CreateView):
    template_name='home.html'
    form=DistributionForm
    models=Lecturer
    fields=['distribution','semester','lecture','lecturer']
    success_url = "/home"


    def form_valid(self,form):
        form.instance.author=self.request.user
        return super().form_valid(form)

    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        context ['lecturer_list'] = Lecturer.objects.order_by('lecturer')
        return context

网址.py

from django.urls import path
from . import views
from django.conf.urls.static import static
from django.conf import settings
from django.contrib.staticfiles.urls import staticfiles_urlpatterns


app_name='distribution'

urlpatterns=[
    path('home/',views.MainList.as_view(),name='home'),
    path('hocalar/<slug:slug>/',views.LecturerDistribution.as_view(),name='lecturer_distribution'),
    path('dersler/<slug:slug>/',views.LectureDistribution.as_view(),name='lecture_distribution'),
]



urlpatterns += staticfiles_urlpatterns()
urlpatterns += static(settings.MEDIA_URL, document_root=settings.MEDIA_ROOT)

和我的 home.html

{% extends "base.html" %}
{%block content%}
{% load crispy_forms_tags %}


<div class="container">
        <div class="form-group pull-right">
    <input type="text" class="search form-control" placeholder="Ara">
        </div>
        <span class="counter pull-right"></span>
        <table class="table table-hover results">
    <thead>
        <tr>
        <th >Hoca</th>
        <th >Ders</th>
        </tr>
        <tr class="warning no-result">
        <td><i class="fa fa-warning"></i> Sonuç Yok</td>
        </tr>
    </thead>
    <tbody>
            {%for lec in lecturer_list%}
        <tr>
        <td>
                    <p ><a style="text-decoration:none" href="{% url 'distribution:lecturer_distribution' slug=lec.slug%}">{{lec.lecturer}}</a></p>
        </td>
        <td>
                    {%for ders in lec.lecture.all%}
                        <a style="text-decoration:none" href="{% url 'distribution:lecture_distribution' slug=ders.slug%}">{{ders.lecture}}</a>,
                    {% endfor%}
                </td>
        </tr>
            {%endfor%}
    </tbody>
</table>

</div>



<div class="col-md-2 float-right ">
  <button style= "position: fixed; top:175px; " type="button" class="btn btn-primary" data-toggle="modal" data-target="#exampleModal" data-whatever="@mdo">Add New Distribution</button>
</div>


<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
 <div class="modal-dialog" role="document">
   <div class="modal-content">
     <div class="modal-header">
       <h5 class="modal-title" id="exampleModalLabel">New Distribution</h5>
     </div>
     <div class="modal-body">
       <form method="post" style="margin-top: 1.3em;">
         {% csrf_token %}
         {{ form|crispy }}
         <div class="modal-footer">
           <button type="submit" class="btn btn-primary">Submit</button>
           <button type="submit" class="btn btn-secondary" data-dismiss="modal">Close</button>
         </div>
             </form>
     </div>
   </div>
 </div>
</div>

<style >
        body{
  padding:20px 20px;
}

.results tr[visible='false'],
.no-result{
  display:none;
}

.results tr[visible='true']{
  display:table-row;
}

.counter{
  padding:8px;
  color:#ccc;
}
    </style>

<script>
    $(document).ready(function() {
  $(".search").keyup(function () {
    var searchTerm = $(".search").val();
    var listItem = $('.results tbody').children('tr');
    var searchSplit = searchTerm.replace(/ /g, "'):containsi('")

  $.extend($.expr[':'], {'containsi': function(elem, i, match, array){
        return (elem.textContent || elem.innerText || '').toLowerCase().indexOf((match[3] || "").toLowerCase()) >= 0;
    }
  });

  $(".results tbody tr").not(":containsi('" + searchSplit + "')").each(function(e){
    $(this).attr('visible','false');
  });

  $(".results tbody tr:containsi('" + searchSplit + "')").each(function(e){
    $(this).attr('visible','true');
  });

  var jobCount = $('.results tbody tr[visible="true"]').length;

  if(jobCount == '0') {$('.no-result').show();}
    else {$('.no-result').hide();}
          });
});
</script>



{% endblock content%}

编辑

class MainList(generic.CreateView):
    template_name='home.html'
    model=Distribution
    fields=['distribution','semester','lecture','lecturer']
    success_url = "/home"


    def form_valid(self,form):
        form.instance.author=self.request.user
        return super().form_valid(form)

    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        context ['lecturer_list'] = Lecturer.objects.order_by('lecturer')
        return context

标签： pythondjangodjango-viewsdjango-urls

解决方案

我认为添加一个类属性（或您queryset = Lecturer.objects.all()想要MainList基于Lecturer模型的任何查询集）或定义get_queryset如下代码的方法：

class MainList(generic.CreateView):
    template_name='home.html'
    form=DistributionForm
    models=Lecturer
    fields=['distribution','semester','lecture','lecturer']
    success_url = "/home"

    def get_queryset(self):
        return Lecturer.objects.all()

    def form_valid(self,form):
        form.instance.author=self.request.user
        return super().form_valid(form)

    def get_context_data(self, **kwargs):
        context = super().get_context_data(**kwargs)
        context ['lecturer_list'] = Lecturer.objects.order_by('lecturer')
        return context

将解决您的问题。另一种方法是更改models=Lecturer​​您model=Lecturer的类属性（如果您没有在其他地方使用它），并且只有在这种情况下您才不需要为您的类定义查询集。

推荐阅读