def get_skill_info(user_id):
"""返回该用户专业技能的相关信息"""
from optsql.searchMySQL import search_oneuser_allinfo
user_skill_info = search_oneuser_allinfo(table="skill", user_id=user_id) #查询该用户的所有技能信息
user_skill_info = base.delete_userid_statement(user_skill_info)
user_skill_info = base.delete_createtime_statement(user_skill_info)
return user_skill_info
def get_job_experience_info(user_id):
"""获取该用户想展示的所有工作经验"""
job_experience_infos = search_state1_allinfo(table="job_experience", user_id=user_id)
job_experience_infos = base.delete_userid_statement(job_experience_infos)
job_experience_infos = base.delete_createtime_statement(job_experience_infos)
for x in job_experience_infos:
x["coperation_starttime"] = base.delete_time(str(x["coperation_starttime"]))
x["coperation_endtime"] = base.delete_time(str(x["coperation_endtime"]))
return job_experience_infos
def get_project_experience_info(user_id):
"""获取该用户想展示的所有项目经验"""
project_experience_infos = search_state1_allinfo(table="project_experience", user_id=user_id)
project_experience_infos = base.delete_userid_statement(project_experience_infos)
project_experience_infos = base.delete_createtime_statement(project_experience_infos)
for x in project_experience_infos:
x["project_starttime"] = base.delete_time(str(x["project_starttime"]))
x["project_endtime"] = base.delete_time(str(x["project_endtime"]))
print project_experience_infos
return project_experience_infos
def get_state1_baseinfo(user_id=""):
"""根据用户id获取用户想展示的基本信息"""
result = search_state1_allinfo(table="user_baseinfo", user_id=user_id)
if result:
base_info = result[0]
base_info = base.delete_userid_statement(base_info)
base_info = base.delete_createtime_statement(base_info)
else:
base_info = 0
return base_info
def get_state1_headimg(user_id=""):
"""根据用户id获取用户想展示的头像的url"""
result = search_state1_allinfo(table="images", user_id=user_id)
if result:
headimg_info = result[0]
headimg_info = base.delete_userid_statement(headimg_info)
headimg_info = base.delete_createtime_statement(headimg_info)
else:
headimg_info = 0
return headimg_info
def get_all_skillinfo(user_id=""):
"""获取该用户的所有专业技能信息"""
skill_infos = search_state1_allinfo(table="skill", user_id=user_id)
skill_infos = base.delete_userid_statement(skill_infos)
skill_infos = base.delete_createtime_statement(skill_infos)
return skill_infos