def model_create(model, values):
if not values.get('id'):
values['id'] = common_util.create_id()
ref = model()
ref.update(values)
session = get_session()
with session.begin():
ref.save(session)
return values
def verify_manage_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
verify_ref = models.VerifyManage()
verify_ref.update(values)
session = get_session()
with session.begin():
verify_ref.save(session)
return values
def grade_create(values):
if not values.get('id'):
values['id'] = common_util.create_id() #str(uuid.uuid4())
grade_ref = models.GradeInfo()
grade_ref.update(values)
session = get_session()
with session.begin():
grade_ref.save(session)
return values
def relative_sign_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
relation_sign_ref = models.RelativeSignInfo()
relation_sign_ref.update(values)
session = get_session()
with session.begin():
relation_sign_ref.save(session)
return values
def teacher_sign_status_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
relation_sign_ref = models.TeacherStatusInfo()
relation_sign_ref.update(values)
session = get_session()
with session.begin():
relation_sign_ref.save(session)
return values
def school_create(values):
if not values.get('id', ''):
values['id'] = common_util.create_id() #str(uuid.uuid4())
school_ref = models.SchoolInfo()
school_ref.update(values)
session = get_session()
with session.begin():
school_ref.save(session)
return values
def wxuser_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
wxuser_ref = models.WXUserInfo()
wxuser_ref.update(values)
session = get_session()
with session.begin():
wxuser_ref.save(session)
return values
def face_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
face_ref = models.RelevanceFace()
face_ref.update(values)
session = get_session()
with session.begin():
face_ref.save(session)
return values
def student_history_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
studenthistory_ref = models.StudentHistory()
studenthistory_ref.update(values)
session = get_session()
with session.begin():
studenthistory_ref.save(session)
return values
def teacher_history_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
teacherhistory_ref = models.TeacherHistory()
teacherhistory_ref.update(values)
session = get_session()
with session.begin():
teacherhistory_ref.save(session)
return values
def class_create(values):
if not values.get('id'):
values['id'] = common_util.create_id()
class_ref = models.ClassInfo()
class_ref.update(values)
session = get_session()
with session.begin():
class_ref.save(session)
return values
def face_signin(self):
cardcode = self.get_argument('cardcode', '')
school_id = self.get_argument('school_id', '')
face_img = self.request.files.get("image", None)
tmp_id = common_util.create_id()
if not face_img or not school_id:
self.finish(
json.dumps({
'state': 1,
'message': 'school_id or img is None'
}))
return
# 将图片存储到本地
img = face_img[0]
filename = tmp_id + ".jpg"
file_path = self.static_path + self.tmp_path + filename
LOG.info("file path:%s" % file_path)
with open(file_path, 'wb') as up:
up.write(img['body'])
#获取tonken
code, face_token = face_recognition_yyl.Face_Search(
file_path, school_id)
if code != 200:
LOG.error("Search face error:%s" % code)
self.finish(
json.dumps({
'state': 2,
'message': face_token,
'code': code
}))
return
face_op = FaceLogic()
sign_op = SignLogic()
LOG.info("face token:%s" % face_token)
face_list = face_op.verify_face(face_token, school_id, cardcode)
if not face_list:
self.finish(
json.dumps({
'state': 3,
'message': 'sign fail, face no exit'
}))
else:
for face_info in face_list:
sign_op.input(face_info.get("relevance_type", 1),
face_info.get("phone", ""),
face_info.get("alias", ""), filename,
face_info.get("img_path", ""))
self.finish(json.dumps({'state': 0, 'message': 'sign ok'}))
def model_batch_create(model, lists):
"""
批量创建
:param lists: 带批量创建的数组
:return:
"""
session = get_session()
with session.begin():
try:
for data in lists:
if not data.get('id'):
data['id'] = common_util.create_id() # str(uuid.uuid4())
ref = model()
ref.update(data)
session.add(ref)
except Exception as ex:
#session.rollback()
raise ex
def batch_input_teacher(teacher_data):
"""
批量插入教师信息
:param teacher_data: 教师信息列表
:return:
"""
session = get_session()
with session.begin():
try:
for teacher_info in teacher_data:
if not teacher_info.get('id'):
teacher_info['id'] = common_util.create_id(
) # str(uuid.uuid4())
teacher_ref = models.ClassInfo()
teacher_ref.update(teacher_info)
session.add(teacher_ref)
session.commit()
except Exception as ex:
session.rollback()
raise ex
