【Django 2021年最新版教程21】数据库查询 model 多条数据 queryset转dict字典返回渲染到前端

Love The Way You Lie 2022-10-05 12:51 207阅读 0赞

model.objects.filter()、model.objects.all()等返回的是queryset格式，是对象的列表list

render需要接收的是dict格式

所以需要将queryset转成dict，但是不能直接转，会报错

# 'QuerySet' object has no attribute '\_meta' #

可以将queryset list循环，对其中的每个对象使用model\_to\_dict转换

# 设置预约信息页面
    def admin_setting_booking_info(request):
        system_configurations = SystemConfiguration.objects.filter(Q(configuration_name='allow_booking_date_start') | Q(configuration_name='allow_booking_date_end') | Q(configuration_name='days_showed_at_most_one_time') | Q(configuration_name='maximum_number_per_day'))
    
        context = {}
        for system_configuration in system_configurations:
            temp = model_to_dict(system_configuration)
            print(temp)
            context[temp['configuration_name']] = temp['configuration_value']
    
        print(context)
        return render(request, './adminWeb/setting_booking_info.html', context)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyODgxOTA_size_16_color_FFFFFF_t_70][]

<div class="col-md-10">
                            <div class="form-group">
                              <label class="bmd-label-floating">可预约的开始日期</label>
                              <input type="date" class="form-control" id="allow_booking_date_start" value="{
       { allow_booking_date_start }}" style='text-indent:140px;'>
                            </div>
                          </div>
                          <div class="col-md-10">
                            <div class="form-group">
                              <label class="bmd-label-floating">可预约的截止日期</label>
                              <input type="date" class="form-control" id="allow_booking_date_end" value="{
       { allow_booking_date_end }}" style ='text-indent:140px;'>
                            </div>
                          </div>
                          <div class="col-md-10">
                            <div class="form-group">
                              <label class="bmd-label-floating">一次最多展示多少天（大于等于1的整数）</label>
                              <input type="number" class="form-control" id="days_showed_at_most_one_time" value="{
       { days_showed_at_most_one_time }}" style ='text-indent:140px;'>
                            </div>
                          </div>
                          <div class="col-md-10">
                            <div class="form-group">
                              <label class="bmd-label-floating">每日最多可预约人数</label>
                              <input type="number" class="form-control" id="maximum_number_per_day" value="{
       { maximum_number_per_day }}" style ='text-indent:140px;'>
                            </div>
                          </div>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyODgxOTA_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyODgxOTA_size_16_color_FFFFFF_t_70]: /images/20221005/df65ba769a4f4b3cb66b68d33853fff2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTMyODgxOTA_size_16_color_FFFFFF_t_70 1]: /images/20221005/65ff9cd6d10a4232b455876c21f6f267.png