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))
