天眼人脸识别系统-履历信息读取案例

步骤一：完善face_query.py代码

sourceai/model/face/db/face_query.py添加及修改如下代码：

from sourceai.model.face.db import face_storage
from sourceai.model.face.db import face_obj


def query(imgid, name=''):
    dbconn = face_storage.MySQL_Query()
    res = ''
    if (name == 'user'):
        res = query_userinfo(dbconn, imgid)
    elif (name == 'resume'):
        res = query_resume_info(dbconn, imgid)
  

    # print(res)
    dbconn.disconnect()
    return res
    
 def query_resume_info(dbconn, imgid):
    sql = "select  n.f_resume,f_time from tb_user m,tb_resume n where m.f_id = n.f_userid and m.f_faceid = '" + imgid + "'"
    results = dbconn.query(sql)
    datas = []

    for row in results:
        dict_data = {}
        dict_data['fid'] = imgid
        dict_data['fresume'] = row[0]
        # dict_data['ftime'] =time.strftime('%Y.%m.%d %H:%M:%S', row[1])
        dict_data['ftime'] = str(row[1])
        datas.append(dict_data)

    return datas

步骤二：完善portrait_views代码

在sourceai/controller/portrait_views.py文件中添加如下内容：

def getResume(request):
    faceid = request.POST.get('userid')
    datas = face_query.query(faceid,'resume')
    return HttpResponse(json.dumps(datas))

步骤三：调试项目

启动项目，进行人脸识别后，结果如下：