Django mysql查询数据解析

使用 objects.filter 查出来的默认是QuerySet夹杂着object（xx）类的字符串，这玩意直接给html可以循环，但是想要在程序里直接取值需要加点操作了。

from models_app.models import host_info, asset_manage_info


def hostinfo_prot_open(request, name):
    # hostname = list(asset_manage_info.objects.values_list('name', flat=True))
    # for i in hostname:
    asset_db_all_info = select_asset_op()

    select_db_host = asset_manage_info.objects.filter(name=name).values('host')
    select_db_port = asset_manage_info.objects.filter(name=name).values('port')
    select_db_host = str(list(select_db_host[0].values())[0])
    select_db_port = str(list(select_db_port[0].values())[0])
    return_num = host_open(select_db_host, select_db_port)
    if return_num == 1:
        select_db_hostinfo_up = host_info.objects.get(name=name)
        select_db_hostinfo_up.status = return_num
        select_db_hostinfo_up.save()

        return render(request, 'asset/asset.html', {
            'asset_db_all_info': asset_db_all_info,
        })
    else:
        resolt = '主机端口不通无法执行扫描！'
        return render(request, 'asset/asset.html', {
            'aaa': resolt,
            'asset_db_all_info': asset_db_all_info,
        })

上面代码中：

select_db_port = asset_manage_info.objects.filter(name=name).values('port')
select_db_port = str(list(select_db_port[0].values())[0])

这两段表示使用filter查找字段名name为url传过来的值，然后提取此行数据中'port'字段的值

此时返回的数据类似这样 <QuerySet [{'port': '22'}]>

select_db_port[0]  == {'port': '22'}

select_db_port[0].values() == dict_values(['22'])

list(select_db_port[0].values())[0] == 22

最后再套一层str就是想要的数据了，当然我这个数据也可以不是字符串类型，具体看自己需求吧。