def get_queryset(self, request): qs = super().get_queryset(request) result = [] if 'name' in request.GET and request.GET['name'] != 'none': # 条件查询 qs = warehousePeople.objects.filter(name=request.GET['name']) if 'subjectMatter' in self.list_display: self.list_display.remove('subjectMatter') if 'apply_prove' not in self.list_display: self.list_display.append('apply_prove') qs = qs.values('month', 'warehouse').annotate(apply_prove=Count('id')).distinct() for item in qs: warehouse = warehouseInformation.objects.get(id=item['warehouse']) obj = warehousePeople(month=item['month'], warehouse=warehouse) obj.apply_prove = item['apply_prove'] result.append(obj) 怎么将result转换为QuerySet，并且保留result列表中自定义字段apply_prove 代码应该怎么修改

from django.contrib import admin from django.urls import reverse from django.utils.html import format_html from django.shortcuts import redirect from .models import Drug @admin.register(Drug) class DrugAdmin(admin.ModelAdmin): change_list_template = 'admin/drug/change_list.html' def get_urls(self): urls = super().get_urls() custom_urls = [ path('import-csv/', self.import_csv), ] return custom_urls + urls def import_csv(self, request): if request.method == 'POST': # TODO: import CSV data self.message_user(request, 'CSV data imported successfully') return redirect('..') return render(request, 'admin/drug/import_csv.html') def changelist_view(self, request, extra_context=None): if not request.GET.get('ordering'): # set default ordering request.GET = request.GET.copy() request.GET['ordering'] = 'name' return super().changelist_view(request, extra_context=extra_context) def interaction_display(self, obj): return format_html('{}', obj.interaction) interaction_display.short_description = 'Interaction' def get_actions(self, request): actions = super().get_actions(request) del actions['delete_selected'] return actions def delete_model(self, request, obj): # TODO: delete model pass def delete_selected(self, request, queryset): # TODO: delete selected models pass def get_queryset(self, request): qs = super().get_queryset(request) qs = qs.order_by('name') return qs def add_view(self, request, form_url='', extra_context=None): self.change_list_template = None return super().add_view(request, form_url=form_url, extra_context=extra_context) def change_view(self, request, object_id, form_url='', extra_context=None): self.change_list_template = None return super().change_view(request, object_id, form_url=form_url, extra_context=extra_context) def delete_view(self, request, object_id, extra_context=None): self.change_list_template = None return super().delete_view(request, object_id, extra_context=extra_context) 怎么重写ModelAdmin中的特性

6. get_queryset()：返回一个查询集，该查询集包含ModelAdmin管理的模型对象。 7. get_actions()：返回一个字典，其中包含ModelAdmin提供的所有批量操作。 8. delete_model()：删除指定的模型对象。 9. delete_...

def get_queryset(self, request): qs = warehousePeople.objects.all() if 'name' in request.GET and request.GET['name'] != 'none': # 条件查询 qs = qs.filter(name=request.GET['name']) qs1 = qs.none() if 'subjectMatter' in self.list_display: self.list_display.remove('subjectMatter') if 'apply_prove' not in self.list_display: self.list_display.append('apply_prove') for obj in qs: if qs1.filter(month=obj.month, warehouse=obj.warehouse.id).exists(): break else: infoLi = qs.filter(month=obj.month, warehouse=obj.warehouse.id) first_obj = infoLi.first() infoLiOne = qs.filter(pk=first_obj.pk) qs1 |= infoLiOne else: if 'subjectMatter' not in self.list_display: self.list_display.append('subjectMatter') if "apply_prove" in self.list_display: self.list_display.remove('apply_prove') if 'name' in request.GET and request.GET['name'] != 'none': return qs1 else: return qs 代码中如何使用annotate方法动态的为qs1添加动态字段apply_prove？

可以使用annotate方法来为qs1添加动态字段apply_prove，具体代码如下： from django.db.models import Case, When, IntegerField qs1 = qs.none().annotate( apply_prove=Case( When(warehouse__isnull=True...

from django.views.generic import ListView class RankingList(ListView): context_object_name = 'dynamics' template_name = 'ranking.html' def get_queryset(self): t = self.request.GET.get('type', '') if t: dynamics = Dynamic.objects.select_related('video').filter(video__label=t).order_by('-plays').all()[:10] else: dynamics = Dynamic.objects.select_related('video').order_by('-plays').all()[:10] return dynamics def get_context_data(self, kwargs): context = super().get_context_data(kwargs) context['searchs'] = Dynamic.objects.select_related('video').order_by('-search').all()[:4] context['labels'] = Label.objects.all() return context

get_queryset 方法是 ListView 中用于获取查询结果集的方法，这里按照与 rankingView 中相同的逻辑进行查询，并返回查询结果。 get_context_data 方法是用于获取模板上下文数据的方法，这里通过调用父类的方法获取...

class warehousePeopleBase(ModelAdmin): model = warehousePeople menu_label = '库房人员出入库信息' # ditch this to use verbose_name_plural from model menu_icon = 'site' # change as required list_display = ['name', 'month', 'warehouse', 'subjectMatter'] list_filter = ('name', 'month', 'warehouse',) def apply_prove(self, obj): return format_html("认证完成") apply_prove.short_description = '入库次数' apply_prove.allow_tags = True def get_queryset(self, request): qs = super().get_queryset(request) if 'name' in request.GET and request.GET['name'] != 'none': # 条件查询 qs = qs.filter(name=request.GET['name']) if 'subjectMatter' in self.list_display: self.list_display.remove('subjectMatter') # qs = qs.values('month', 'warehouse').annotate(apply_prove=Count('id')).distinct() # self.list_display = ['name', 'month', 'warehouse', 'apply_prove'] if 'apply_prove' not in self.list_display: self.list_display.append('apply_prove') else: if 'subjectMatter' not in self.list_display: self.list_display.append('subjectMatter') if "apply_prove" in self.list_display: self.list_display.remove('apply_prove') return qs 代码中的qs = qs.filter(name=request.GET['name']),当前qs查询出来5个QuerySet实例，如何根据month和warehouse去重，并且将重复的条数定义为新字段添加在数据中，去重后结果不是字典，而是跟qs = qs.filter(name=request.GET['name'])结果类型一致

# qs = qs.filter(name=request.GET['name']).distinct() 替换为以下代码： qs = qs.filter(name=request.GET['name']).values('month', 'warehouse').annotate(apply_prove=Count('id')).distinct() ...

class GroupAdmin(admin.ModelAdmin): search_fields = ('name',) ordering = ('name',) filter_horizontal = ('permissions',) def formfield_for_manytomany(self, db_field, request=None, kwargs): if db_field.name == 'permissions': qs = kwargs.get('queryset', db_field.remote_field.model.objects) # Avoid a major performance hit resolving permission names which # triggers a content_type load: kwargs['queryset'] = qs.select_related('content_type') return super().formfield_for_manytomany(db_field, request=request, kwargs)

- search_fields = ('name',) 表示在管理后台的列表页中添加一个搜索框，可以搜索该模型的 name 字段。 - ordering = ('name',) 表示在管理后台的列表页中按照 name 字段进行排序。 - filter_horizontal = ('...

优化代码class FileManager_listview(ListView): """利用django的五大视图中的ListView来显示数据同时添加了排序功能 """ # 查询模型 model = FileManager # 指定模型为UserInfo # TODO 待完善 extra_context待实验 # 设置模型外的数据 # extra_context = {'title': '人员信息表'} # 获取并判断搜索条件 # 设置模版文件 template_name = 'zadmin/pages/File_Manager.html' # 指定模板 # 设置模板上下文，即为模板变量进行命名 context_object_name = 'files' # 指定在模板中使用的变量为customers # 每页的展示多少条数据 paginate_by = 10 # 注意下面一行, 获取智能页码范围，并传递给模板 # page_range = paginator.get_elided_page_range(page, on_each_side=3, on_ends=2) # 可以自定义查询集 # TODO 应该是可以指定一个数据库中的部分数据吧 # queryset = UserInfo.objects.all() # 重写get_queryset方法，对数据进行过滤排序 def get_queryset(self): """ 查询 :return: """ queryset = super().get_queryset() mywhere = [] order_by = self.request.GET.get('order_by', None) search_keyword = self.request.GET.get("search", None) # Q就是或 if search_keyword: # 构造查询条件 kwlist = Q(username__contains=search_keyword) | Q(realname__contains=search_keyword) | Q( phone__contains=search_keyword) # # 保持搜索条件 # mywhere.append('search=' + search_keyword) # 将搜索参数存储在Session中 self.request.session['search_keyword'] = search_keyword messages.success(self.request, '搜索结果') else: # 清除Session中的搜索参数 self.request.session.pop('search_query', None) # return queryset.filter(kwlist) return queryset

def get_queryset(self): queryset = super().get_queryset() order_by = self.request.GET.get('order_by') search_keyword = self.request.GET.get("search") if search_keyword: queryset = queryset....

Django有一个模型如下 class X86_log(models.Model): id = models.AutoField(primary_key=True) time = models.DateTimeField("时间", auto_now_add=True) user = models.CharField("用户", max_length=16) location = models.CharField("对象", max_length=50) describe = models.CharField("描述", max_length=50) 需要使用django_filters对user、location、describe字段或指定time范围进行过滤

filter = X86_logFilter(request.GET, queryset=X86_log.objects.all()) logs = filter.qs # 处理过滤后的结果 logs return render(request, 'log_list.html', {'filter': filter, 'logs': logs}) 在这个...

def delete_selected(modeladmin, request, queryset): """ Default action which deletes the selected objects. This action first displays a confirmation page which shows all the deletable objects, or, if the user has no permission one of the related childs (foreignkeys), a "permission denied" message. Next, it deletes all selected objects and redirects back to the change list. """ opts = modeladmin.model._meta app_label = opts.app_label # Check that the user has delete permission for the actual model if not modeladmin.has_delete_permission(request): raise PermissionDenied using = router.db_for_write(modeladmin.model) # Populate deletable_objects, a data structure of all related objects that # will also be deleted. deletable_objects, model_count, perms_needed, protected = get_deleted_objects( queryset, opts, request.user, modeladmin.admin_site, using) # The user has already confirmed the deletion. # Do the deletion and return a None to display the change list view again. if request.POST.get('post') and not protected: if perms_needed: raise PermissionDenied n = queryset.count() if n: for obj in queryset: obj_display = force_text(obj) modeladmin.log_deletion(request, obj, obj_display) queryset.delete() modeladmin.message_user(request, _("Successfully deleted %(count)d %(items)s.") % { "count": n, "items": model_ngettext(modeladmin.opts, n) }, messages.SUCCESS) # Return None to display the change list page again. return None if len(queryset) == 1: objects_name = force_text(opts.verbose_name) else: objects_name = force_text(opts.verbose_name_plural) if perms_needed or protected: title = _("Cannot delete %(name)s") % {"name": objects_name} else: title = _("Are you sure?") context = dict( modeladmin.admin_site.each_context(request), title=title, objects_name=objects_name, deletable_objects=[deletable_objects], model_count=dict(model_count).items(), queryset=queryset, perms_lacking=perms_needed, protected=protected, opts=opts, action_checkbox_name=helpers.ACTION_CHECKBOX_NAME, media=modeladmin.media, ) request.current_app = modeladmin.admin_site.name # Display the confirmation page return TemplateResponse(request, modeladmin.delete_selected_confirmation_template or [ "admin/%s/%s/delete_selected_confirmation.html" % (app_label, opts.model_name), "admin/%s/delete_selected_confirmation.html" % app_label, "admin/delete_selected_confirmation.html" ], context) delete_selected.short_description = ugettext_lazy("Delete selected %(verbose_name_plural)s")

在代码中，delete_selected() 函数接受三个参数：modeladmin 表示 Django admin 后台的管理器对象，request 表示当前的 HTTP 请求对象，queryset 表示选中的对象的 QuerySet。函数首先获取模型的元数据信息...

if search: queryset = queryset.filter( Q(user_idusernamecontains=search) | Q(competition_idtitlecontains=search) )

queryset = queryset.filter( Q(user_id__username__contains=search) | Q(competition_id__title__contains=search) ) 在这段代码中，首先检查search变量是否有值。如果有值，就执行下面的代码块。在...

if isinstance(user, QuerySet): user = user.first() payload = jwt_payload_handler(user) token = jwt_encode_handler(payload)

首先，它检查 user 是否是一个 QuerySet 对象，如果是，则通过调用 first() 方法获取第一个匹配的用户对象。然后，使用 jwt_payload_handler() 函数生成包含用户信息的负载(payload)。最后，使用 jwt_...

sdjl.objects.filter(sd_filename=request.GET.get('filename'),sd_user=request.user.name)这样的表达式是否正确，返回值是什么，如何从返回值中将内容转化为数组使用

这是一个 Django ORM 查询语句，用于查询名为 request.GET.get('filename') 并且用户为 request.user.name 的 sdjl 数据库表中的记录。返回值是一个 QuerySet 对象，它包含了符合查询条件的多条记录。要将 ...

def export_as_excel(self, request, queryset):

这个函数的作用是将当前ModelAdmin类中选定的queryset对象导出为Excel文件。在函数中，request参数表示当前的HTTP请求对象，queryset参数表示选中的对象集合。函数的具体实现可以采用Python中的第三方库，比如...

def show(request): id=request.GET.get('id') info = test01.objects.filter(id=id) context={ 'info':info } print(info) return render(request,'show.html',context)写出HTML语句

{% if info %} 信息详情编号: {{ info.id }} 名称: {{ info.name }} 日期: {{ info.date }} {% else %} 没有找到匹配的信息。 {% endif %} 这段代码使用 Django 模板语言 (DTL) 格式来检查查询结果是否...

qs = qs.filter(name=request.GET['name']),当前qs查询出来5个QuerySet实例，如何将这5条数据根据name和age去重，并且保证去重后结果不是字典，而是跟qs = qs.filter(name=request.GET['name'])结果类型一致，并且将重复的条数定义为新字段添加在数据中

qs = qs.filter(name=request.GET['name']) distinct_qs = qs.values('name', 'age').annotate(count=Count('id', distinct=True)).values('name', 'age', 'count') 这段代码会将 qs 中符合条件的数据按照 name...

通过覆写get_export_queryset方法将数据打印到控制台

fields = [field.name for field in queryset.model._meta.fields] writer.writerow(fields) for obj in queryset: writer.writerow([getattr(obj, field) for field in fields]) return response 在上面...

def export_as_excel(self, request, queryset): meta = self.model._meta # 用于定义文件名, 格式为: app名.模型类名 field_names = [field.name for field in meta.fields] # 模型所有字段名 response = HttpResponse(content_type='application/msexcel') # 定义响应内容类型 response['Content-Disposition'] = f'attachment; filename={meta}.xlsx' # 定义响应数据格式 wb = Workbook() # 新建Workbook ws = wb.active # 使用当前活动的Sheet表 ws.append(field_names) # 将模型字段名作为标题写入第一行 for obj in queryset: # 遍历选择的对象列表 for field in field_names: data = [f'{getattr(obj, field)}' for field in field_names] # 将模型属性值的文本格式组成列表 ws.append(data) # 写入模型属性值 wb.save(response) # 将数据存入响应内容 return response export_as_excel.icon = 'el-icon-export' export_as_excel.short_description = '导出Excel' # 该动作在admin中的显示文字

这段代码定义了一个自定义的按钮 export_as_excel，用于批量导出数据为 Excel 文件。具体实现如下： - 获取当前模型的 meta 信息，用于定义文件名； - 获取模型的所有字段名，作为 Excel 文件的标题；...

相关推荐

Django之全局使用request.user.username的实例详解

Python库 | django_polymorphic_queryset-0.2.1-py3-none-any.whl

Python的Django框架中的select_related函数对QuerySet 查询的优化

if search: queryset = queryset.filter( Q(user_id__username__contains=search) | Q(competition_id__title__contains=search) )

if isinstance(user, QuerySet): user = user.first() payload = jwt_payload_handler(user) token = jwt_encode_handler(payload)

sdjl.objects.filter(sd_filename=request.GET.get('filename'),sd_user=request.user.name)这样的表达式是否正确，返回值是什么，如何从返回值中将内容转化为数组使用

def export_as_excel(self, request, queryset):

def show(request): id=request.GET.get('id') info = test01.objects.filter(id=id) context={ 'info':info } print(info) return render(request,'show.html',context)写出HTML语句

通过覆写get_export_queryset方法将数据打印到控制台

最新推荐

Python学习笔记16 - 猜数字小游戏

机器人比赛内容的讲解，帮助简单了解一下机器人比赛的注意事项

shumaguan.rar

BSC绩效考核指标汇总 (2).docx

管理建模和仿真的文件

【进阶】Flask中的会话与用户管理

卷积神经网络实现手势识别程序

BSC资料.pdf

"互动学习：行动中的多样性与论文攻读经历"

【进阶】Flask中的请求处理

if search: queryset = queryset.filter( Q(user_idusernamecontains=search) | Q(competition_idtitlecontains=search) )