def post(self): name = self.get_argument("name", "") phone = self.get_argument("phone", "") email = self.get_argument("email", "") sex = self.get_argument("sex", "") degree = self.get_argument("degree", "") major = self.get_argument("major", "") school = self.get_argument("school", "") city = self.get_argument("city", "") attention_job = self.get_argument("attention_job", "") marry = self.get_argument("marry", "") birthday = self.get_argument("birthday", "") id_card = self.get_argument("id_card", "") remarks = self.get_argument("remarks", "") from bin.base import get_id_name #获取用户名和id user_id = get_id_name(self.current_user)[0] columns = "user_id,name,sex,birthday,phone,email,marry,degree,major,school,city,attention_job,id_card,remarks" values = {"user_id": user_id, "name": name, "sex": sex, "birthday": birthday, "phone": phone, "email": email, "marry": marry, "degree": degree, "major": major, "school": school, "city": city, "attention_job": attention_job, "id_card": id_card, "remarks": remarks} table = "user_baseinfo" from optsql.insertMySQL import insert_baseinfo insert_id = insert_baseinfo(columns, values, table) #把信息插入数据库,并返回该行数据的id if insert_id: rtinfo = {"status": 0, "result": insert_id} else: rtinfo = {"status": 1, "result": "添加失败!"} self.write(base.get_json(rtinfo))
def post(self): skill_id = self.get_argument("skill_id", "") from optsql.deleteMySQL import delete_one_info result = delete_one_info(info_id=skill_id, table="skill") #删除该skill_id的一行信息 if result: rt_info = {"status": 0, result: "删除成功!"} else: rt_info = {"status": 1, result: "删除失败!"} self.write(base.get_json(rt_info))
def post(self): project_id = self.get_argument("id", "") from optsql.searchMySQL import search_one_info result = search_one_info(id=project_id, table="project_experience") if result: rtinfo = dict(status=0, result=result) else: rtinfo = dict(status=1, result="未查到相关信息。") self.write(base.get_json(rtinfo))
def post(self): project_id = self.get_argument("id", "") from optsql.deleteMySQL import delete_one_info result = delete_one_info(info_id=project_id, table="project_experience") if result: rtinfo = dict(status=0, result=result) else: rtinfo = dict(status=1, result="删除失败") self.write(base.get_json(rtinfo))
def post(self): job_id = self.get_argument("id", "") from optsql.updateMySQL import update_one_state result = update_one_state(id=job_id, table="job_experience") if result: rtinfo = {"status": 0, "result": result} else: rtinfo = {"status": 1, "result": "更改失败!"} self.write(base.get_json(rtinfo))
def post(self): baseinfo_id = self.get_argument("baseinfo_id", "") if baseinfo_id: from optsql.searchMySQL import search_one_info result = search_one_info(id=baseinfo_id, table="user_baseinfo") rt_info = {"status": 0, "result": result} else: rt_info = {"status": 1, "result": "出错了~"} self.write(base.get_json(rt_info))
def post(self): project_id = self.get_argument("id", "") from optsql.updateMySQL import update_one_state result = update_one_state(id=project_id, table="project_experience") if result: rtinfo = dict(status=0, result="更改成功!") else: rtinfo = dict(status=1, result="更改失败!") return self.write(base.get_json(rtinfo))
def post(self): baseinfo_id = self.get_argument("baseinfo_id", "") if baseinfo_id: from optsql.deleteMySQL import delete_one_info rt_info = delete_one_info(info_id=baseinfo_id, table="user_baseinfo") if rt_info: result = {"status": 0, "rtinfo": "删除成功!"} else: result = {"status": 1, "rtinfo": "删除失败!"} else: result = {"status": 2, "rtinfo": "未知原因,删除失败!"} self.write(base.get_json(result))
def post(self): img_id = self.get_argument("imgurl_id", "") if img_id: from optsql.searchMySQL import search_one_imgurl img_url = search_one_imgurl(img_id=img_id) #查询该id对应的图片存储地址 if img_url: result = {"status": 0, "img_url": img_url} else: result = {"status": 1, "img_url": "出错了~"} else: result = {"status": 2, "img_url": "没有查到该图片~"} self.write(base.get_json(result))
def post(self): user_id = base.get_id_name(self.current_user)[0] baseinfo_id = self.get_argument("baseinfo_id", "") table = "user_baseinfo" from optsql.updateMySQL import update_info_state rt_info = update_info_state(user_id=user_id, info_id=baseinfo_id, table=table) if rt_info: result = {"status": 0, "rt_info": rt_info} else: result = {"status": 1, "rt_info": "更改失败!"} self.write(base.get_json(result))
def post(self): img_id = self.get_argument("img_id", "") if img_id: user_id = base.get_id_name(self.current_user)[0] from optsql.updateMySQL import update_info_state rt_info = update_info_state(user_id=user_id, info_id=img_id, table="images") #更改对应img_id的state为1 if rt_info: result = {"status": 0, "rt_info": "更改成功!"} else: result = {"status": 1, "rt_info": "更改失败!"} else: result = {"status": 2, "rt_info": "网络连接错误~"} self.write(base.get_json(result))
def post(self): user_id = base.get_id_name(self.current_user)[0] skill_name = self.get_argument("skill_name", "") master_degree = self.get_argument("master_degree", "") from optsql.insertMySQL import insert_one_skill insert_id = insert_one_skill(user_id=user_id, skill_name=skill_name, master_degree=master_degree) #把专业技能信息插入数据库 if insert_id: from optsql.searchMySQL import search_one_info insert_info = search_one_info(id=insert_id, table="skill") #查询刚插入行的信息 rt_info = {"status": 0, "result": insert_info} else: rt_info = {"status": 1, "result": "添加失败!"} return self.write(base.get_json(rt_info))
def post(self): img_id = self.get_argument("img_id", "") if img_id: from optsql.searchMySQL import search_one_imgurl img_url = search_one_imgurl(img_id=img_id) #先查询图片id对应的url if img_url: import os os.remove(img_url) #删除存储在文件中的图 from optsql.deleteMySQL import delete_one_imgurl delete_one_imgurl(img_id=img_id) #删除数据库的url result = {"status": 0, "rt_info": "删除成功!"} else: result = {"status": 1, "rt_info": "不存在改图~"} else: result = {"status": 2, "rt_info": "网络连接错误~"} self.write(base.get_json(result))
def post(self): job_id = self.get_argument("id", "") project_name = self.get_argument("project_name", "") project_starttime = self.get_argument("project_starttime", "") project_endtime = self.get_argument("project_endtime", "") project_detail = self.get_argument("project_detail", "") values = dict(project_name=project_name, project_starttime=project_starttime, project_endtime=project_endtime, project_detail=project_detail ) from optsql.updateMySQL import update_one_project_experience result = update_one_project_experience(id=job_id, values=values) if result: rtinfo = dict(status=0, result=result) else: rtinfo = dict(status=1, result="更改失败!") self.write(base.get_json(rtinfo))
def post(self): job_id = self.get_argument("id","") coperation_name = self.get_argument("coperation_name", "") coperation_position = self.get_argument("coperation_position", "") coperation_starttime = self.get_argument("coperation_starttime", "") coperation_endtime = self.get_argument("coperation_endtime", "") coperation_duty = self.get_argument("coperation_duty", "") values = dict(coperation_name=coperation_name, coperation_position=coperation_position, coperation_starttime=coperation_starttime, coperation_endtime=coperation_endtime, coperation_duty=coperation_duty ) from optsql.updateMySQL import update_one_jobexperience result = update_one_jobexperience(id=job_id, values=values) if result: rtinfo = dict(status=0, result=result) else: rtinfo = dict(status=1, result="更改失败!") self.write(base.get_json(rtinfo))
def post(self): project_name = self.get_argument("project_name", "") project_starttime = self.get_argument("project_starttime", "") project_endtime = self.get_argument("project_endtime", "") project_detail = self.get_argument("project_detail", "") values = dict(project_name=project_name, project_starttime=project_starttime, project_endtime=project_endtime, project_detail=project_detail ) print values user_id = base.get_id_name(self.current_user)[0] from optsql.insertMySQL import insert_one_project_experience insert_id = insert_one_project_experience(user_id=user_id, values=values) if insert_id: rt_info = dict(status=0, insert_id=insert_id) else: rt_info = dict(status=1, insert_id=0) self.write(base.get_json(rt_info))
def post(self): coperation_name = self.get_argument("coperation_name", "") coperation_position = self.get_argument("coperation_position", "") coperation_starttime = self.get_argument("coperation_starttime", "") coperation_endtime = self.get_argument("coperation_endtime", "") coperation_operating_duty = self.get_argument("coperation_operating_duty", "") user_id = base.get_id_name(self.current_user)[0] values = dict(coperation_name=coperation_name, coperation_position=coperation_position, coperation_starttime=coperation_starttime, coperation_endtime=coperation_endtime, coperation_operating_duty=coperation_operating_duty ) from optsql.insertMySQL import insert_one_job_experience insert_id = insert_one_job_experience(user_id=user_id, values=values) if insert_id: rtinfo = {"status": 0, "insert_id": insert_id} else: rtinfo = {"status": 1, "result": "保存失败!"} self.write(base.get_json(rtinfo))
def post(self): name = self.get_argument("name", "") phone = self.get_argument("phone", "") email = self.get_argument("email", "") sex = self.get_argument("sex", "") degree = self.get_argument("degree", "") major = self.get_argument("major", "") school = self.get_argument("school", "") marry = self.get_argument("marry", "") city = self.get_argument("city", "") attention_job = self.get_argument("attention_job", "") birthday = self.get_argument("birthday", "") id_card = self.get_argument("id_card", "") remarks = self.get_argument("remarks", "") baseinfo_id = self.get_argument("baseinfo_id", "") values = {"name": name, "sex": sex, "birthday": birthday, "phone": phone, "email": email, "marry": marry, "degree": degree, "major": major, "school": school, "city": city, "attention_job": attention_job, "id_card": id_card, "remarks": remarks} from optsql.updateMySQL import update_base_info rt_info = update_base_info(baseinfo_id=baseinfo_id, values=values) result = {"status": 0, "rt_info": rt_info} self.write(base.get_json(result))
def get(self): user_id = base.get_id_name(self.current_user)[0] user_skill_info = get_skill_info(user_id=user_id) #查询该用户专业技能的所有信息 self.write(base.get_json(user_skill_info))