def importLogLogin(): myRes = MyResponse() try: ###添加注入清单信息 f = request.files['Ffile'] uploadFile = UploadFile(f) uploadFile.import_file() xlrdReader = XlrdReader( os.path.join(uploadFile.filepath, uploadFile.filename)) xlrdReader.readSheetToList() reader_data = xlrdReader.datas reader_titles = xlrdReader.titles for index_row, row in enumerate(reader_data): sysLog = LogLogin() sysLog.FuserId = row[0] sysLog.FcreateTime = getSysDateTime() sysLog.Ffunc = row[1] sysLog.FipAddress = row[2] sysLog.Fremark = row[5] db_session.add(sysLog) db_session.commit() myRes.code = ResState.HTTP_SUCCESS except ExcelError as ex: mylog.error(ex) abort(404, "读取excel错误") except SQLAlchemyError as ex: db_session.rollback() mylog.error(ex) abort(404, sys.exc_info()[1]) finally: pass return myRes.to_json()
def login_logger(oper_descript=""): logLogin = LogLogin() logLogin.USER_KEY = g.FuserId logLogin.IP_ADDRESS = request.remote_addr logLogin.TIME_CREATE = getSysDateTime() logLogin.DESCRIPT = oper_descript try: MySqlalchemy.comAdd(logLogin) except SQLAlchemyError as ex: mylog.error(ex)
def add(): myRes = MyResponse() ROLE_NAME = MyRequest.get_verify_empty("ROLE_NAME") DESCRIPT = MyRequest.get("DESCRIPT") try: role = RoleInfo() role.ROLE_NAME = ROLE_NAME role.DESCRIPT = DESCRIPT role.TIME_CREATE = getSysDateTime() role.TIME_MODIFY = getSysDateTime() MySqlalchemy.comAdd(role) myRes.code = ResState.HTTP_SUCCESS myRes.msg = "操作成功" except MyError as ex: myRes.msg = ex except SQLAlchemyError as ex: mylog.error(ex) myRes.msg = ResState.ERROR_DB return myRes.to_json()
def add(): myRes = MyResponse() user = UserInfo() user.LOGIN_NAME = MyRequest.get_verify_empty("LOGIN_NAME", errmsg="用户名不能为空") user.USER_NAME = MyRequest.get_verify_empty("USER_NAME", errmsg="姓名不能为空") user.USER_SEX = MyRequest.get("USER_SEX", type=int) user.DPT_KEY = MyRequest.get_verify_empty("DPT_KEY", errmsg="DPT_KEY不能为空") user.set_password("123456") user.USER_POSITION = MyRequest.get("USER_POSITION", type=str) user.PHONE = MyRequest.get("PHONE", type=str) user.TIME_CREATE = getSysDateTime() user.TIME_MODIFY = getSysDateTime() try: MySqlalchemy.comAdd(user) myRes.code = ResState.HTTP_SUCCESS myRes.msg = "操作成功" except SQLAlchemyError as ex: mylog.error(ex) myRes.msg = ResState.ERROR_DB return myRes.to_json()
def update(): myRes = MyResponse() ROLE_KEY = MyRequest.get("ROLE_KEY", type=int) role_attrs = {} role_attrs["ROLE_NAME"] = MyRequest.get_verify_empty("ROLE_NAME") role_attrs["DESCRIPT"] = MyRequest.get("DESCRIPT") role_attrs["TIME_MODIFY"] = getSysDateTime() try: MySqlalchemy.comUpdate(RoleInfo, [RoleInfo.ROLE_KEY == ROLE_KEY], role_attrs) myRes.code = ResState.HTTP_SUCCESS myRes.msg = "操作成功" except SQLAlchemyError as ex: mylog.error(ex) myRes.msg = str(ex) return myRes.to_json()
def update(): myRes = MyResponse() USER_KEY = MyRequest.get("USER_KEY", type=int) upd_attr = {} upd_attr["USER_NAME"] = MyRequest.get_verify_empty("USER_NAME", errmsg="姓名不能为空") upd_attr["USER_SEX"] = MyRequest.get("USER_SEX", type=int, default=1) upd_attr["DPT_KEY"] = MyRequest.get_verify_empty("DPT_KEY", errmsg="部门ID不能为空") upd_attr["USER_POSITION"] = MyRequest.get("USER_POSITION", type=str) upd_attr["PHONE"] = MyRequest.get("PHONE", type=str) upd_attr["TIME_MODIFY"] = getSysDateTime() try: MySqlalchemy.comUpdate(UserInfo, [UserInfo.USER_KEY == USER_KEY], upd_attr) myRes.code = ResState.HTTP_SUCCESS myRes.msg = "操作成功" except SQLAlchemyError as ex: mylog.error(ex) myRes.msg = str(ex) return myRes.to_json()
def wrapper(*args, **kargs): responseInfo = func() ###操作成功后,记录操作日志 if json.loads(responseInfo.data)["code"] == ResState.HTTP_SUCCESS: try: logOper = LogOper() logOper.USER_KEY = g.USER_KEY logOper.IP_ADDRESS = request.remote_addr logOper.LOGO_FUNC = "function(name=%s,args=%s,kargs=%s)" % ( func.__name__, args, kargs) logOper.LOGO_REQ_PARAMS = json.dumps(MyRequest.getAll()) logOper.TIME_CREATE = getSysDateTime() logOper.DESCRIPT = oper_descript try: MySqlalchemy.comAdd(logOper) except SQLAlchemyError as ex: mylog.error(ex) except: print(sys.exc_info()) pass return responseInfo