def updFromProjectSettingByProjectId(requset): code, data, message = None, None, None try: checkUserSession(requset) settingId = requset.GET.get('settingId') projectId = requset.GET.get('projectId') ambientId = requset.GET.get('ambientId') fileName = requset.GET.get('fileName') remotePath = requset.GET.get('remotePath') remarks = requset.GET.get('remarks') if settingId and projectId and ambientId and fileName and remotePath: projectSettingDao.updFromProjectSettingByProjectId(settingId, projectId, ambientId, fileName, remotePath, remarks=remarks) code, message = 200, '配置文件信息,更新完成' else: raise Exception( '参数报错: settingId, projectId, ambientId, fileName, remotePath 都不能为空!' ) except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def delApiListFromRoleIdByRoleId(requset): code, data, message = None, None, None try: checkUserSession(requset) roleId = requset.GET.get('roleId') apiList = requset.GET.get('apiList') if roleId and apiList: roleInfo = roleInfoDao.getAllFromRoleInfoByRoleId(roleId) if roleInfo.api_list == '*': raise Exception("权限报错: 不能修改admin权限!") apiList = json.loads(apiList) if roleInfo.api_list: dbApiList = json.loads(roleInfo.api_list) dbApiList = list(set(dbApiList).difference(set(apiList))) roleInfoDao.updAllFromRoleInfoByRoleId( roleId, apiList=json.dumps(dbApiList)) code, message = 200, '删除权限完成' else: raise Exception('权限报错: 该角色没有需要删除的权限!') else: raise Exception('参数报错: roleId, apiList 都不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def updContentFromReleaseOrdeByOrderId(requset): code, data, message = None, None, None try: checkUserSession(requset) orderId = requset.GET.get('orderId') orderTitle = requset.GET.get('orderTitle') orderContent = requset.GET.get('orderContent') ambientId = requset.GET.get('ambientId') releaseTime = requset.GET.get('releaseTime') executorId = requset.GET.get('executorId') artisanId = requset.GET.get('artisanId') productId = requset.GET.get('productId') ftpPath = requset.GET.get('ftpPath') remarks = requset.GET.get('remarks') if orderId: releaseOrderDao.updContentFromReleaseOrdeByOrderId(orderId, orderTitle, orderContent, ambientId, releaseTime, executorId, artisanId, productId, ftpPath=ftpPath, remarks=remarks) code, message = 200, '更新工单内容成功' else: raise Exception('参数报错: orderId 不能为空') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromRoleInfoAndApiInfoByRoleId(requset): code, data, message = None, None, None try: checkUserSession(requset) apiId = requset.GET.get('roleId') if apiId: roleInfo = roleInfoDao.getAllFromRoleInfoByRoleId(apiId) if roleInfo.api_list == '*': apiInfoList = apiInfoDao.getAllFromApiInfo() elif roleInfo.api_list: apiIdList = json.loads(roleInfo.api_list) apiInfoList = apiInfoDao.getAllFromApiInfoByApiIdList( apiIdList) else: apiInfoList = [] code = 200 data = { 'roleInfo': OrmConversion(roleInfo), 'apiInfoList': OrmConversion(list(apiInfoList)) } else: raise Exception('参数报错: roleId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getGitNameFromGitInfo(requset): code, data, message = None, None, None try: checkUserSession(requset) gitInfoList = gitInfoDao.getGitNameFromGitInfo() code, data = 200, {'gitInfoList': list(gitInfoList)} except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getGroupIdAndGroupNameFromUserGroup(requset): code, data, message = None, None, None try: checkUserSession(requset) userGroupList = userGroupDao.getGroupIdAndGroupNameFromUserGroup() code, data = 200, {'userGroupList': list(userGroupList)} except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getIdAndVlanNameFromVlan(requset): code, data, message = None, None, None try: checkUserSession(requset) vlanList = vlanDao.getIdAndVlanNameFromVlan() code, data = 200, {'vlanList': list(vlanList)} except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromAmbient(requset): code, data, message = None, None, None try: checkUserSession(requset) ambientList = ambientDao.getAllFromAmbient() code, data = 200, {'ambientList': OrmConversion(list(ambientList))} except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllUserInfo(request): code, data, message = None, None, None try: checkUserSession(request) groupId = request.GET.get("groupId") userInfoList = userInfoDao.getAllUserInfo(groupId=groupId) code, data = 200, list(userInfoList) except Exception as e: code, message = 300, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromTaskListByTaskId(request): code, data, message = None, None, None try: checkUserSession(request) taskId = request.GET.get('taskId') if taskId is None: raise Exception('taskId不能为空') else: taskList = taskListDao.getAllFromTaskListByTaskId(taskId) code, data = 200, {'taskList': taskList} except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getBranchsFromGitByProjectId(requset): code, data, message = None, None, None try: checkUserSession(requset) projectId = requset.GET.get('projectId') if projectId: branchs = gitInfoDao.getBranchsFromGitByProjectId(projectId) code, data = 200, {'branchs': branchs} else: raise Exception('参数报错: projectId 不能为空') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromGitInfoByGitId(requset): code, data, message = None, None, None try: checkUserSession(requset) gitId = requset.GET.get('gitId') if gitId: gitInfo = gitInfoDao.getAllFromGitInfoByGitId(gitId) code, data = 200, {'gitInfo': OrmConversion(gitInfo)} else: raise Exception('参数报错: gitId 不能为空') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse(JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromUsreInfoByUserId(request): code, data, message = None, None, None try: checkUserSession(request) userId = request.GET.get('userId') if userId is None: raise Exception('参数报错: userId不能为空!') userInfo = userInfoDao.getAllFromUsreInfoByUserId(userId) code, data = 200, {'userInfo': userInfo} except Exception as e: code, message = 300, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def delFromApiInfoByApiId(requset): code, data, message = None, None, None try: checkUserSession(requset) apiId = requset.GET.get('apiId') if apiId: apiInfoDao.delFromApiInfoByApiId(apiId) code, message = 200, '更新完成' else: raise Exception('参数报错: apiId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def delFromProjectSettingByProjectId(requset): code, data, message = None, None, None try: checkUserSession(requset) settingId = requset.GET.get('settingId') if settingId: projectSettingDao.delFromProjectSettingByProjectId(settingId) code, message = 200, '删除配置文件完成' else: raise Exception('参数报错: settingId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def delFromReleaseOrderByOrderId(requset): code, data, message = None, None, None try: checkUserSession(requset) orderId = requset.GET.get('orderId') if orderId: releaseOrderDao.delFromReleaseOrderByOrderId(orderId) code, message = 200, '删除工单完成' else: raise Exception('参数报错: orderId 不能为空') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromUserGroupByGroupId(requset): code, data, message = None, None, None try: checkUserSession(requset) groupId = requset.GET.get('groupId') if groupId: userGroup = userGroupDao.getAllFromUserGroupByGroupId(groupId) code, data = 200, {'userGroup': OrmConversion(userGroup)} else: raise Exception('参数报错: groupId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromValnById(requset): code, data, message = None, None, None try: checkUserSession(requset) id = requset.GET.get('id') if id and id.isdigit(): vlanInfo = vlanDao.getAllFromValnById(id) code, data = 200, {'vlan': OrmConversion(vlanInfo)} else: raise Exception('参数报错: id不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getAllFromTaskLogListByTaskId(request): data = {} taskId = request.GET.get('taskId') try: checkUserSession(request) if taskId is None: data['message'] = '参数报错: taskId不能为空!' else: taskLogList = taskLogListDao.getAllFromTaskLogListByTaskId(taskId) for taskLog in taskLogList: data[taskLog.log_id] = model_to_dict(taskLog) except Exception as e: data['message'] = str(e) finally: return HttpResponse(json.dumps(data, cls=DateEncoder, ensure_ascii=False).encode('utf-8'))
def delFromVlanById(requset): code, data, message = None, None, None try: checkUserSession(requset) id = requset.GET.get('id') if id and id.isdigit(): vlanDao.delFromVlanById(id) code, message = 200, '删除成功' else: raise Exception('参数报错: id不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def getNewSaltId(request): code, data, message = None, None, None try: checkUserSession(request) newHost = hostInfoDao.getNewSaltId() if newHost: data = newHost else: raise Exception("暂无新主机") code = 200 except Exception as e: code, message = 300, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def updStatusFromReleaseOrderByOrderId(requset): code, data, message = None, None, None try: checkUserSession(requset) orderId = requset.GET.get('orderId') status = requset.GET.get('status') if orderId and status: releaseOrderDao.updStatusFromReleaseOrderByOrderId(orderId, status) code, message = 200, '工单状态更新完成' else: raise Exception('参数报错: orderId, status 都不能为空') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def setFromRoleInfo(requset): code, data, message = None, None, None try: checkUserSession(requset) roleName = requset.GET.get('roleName') remarks = requset.GET.get('remarks') if roleName: roleInfoDao.setFromRoleInfo(roleName, remarks) code, message = 200, '添加完成' else: raise Exception('参数报错: roleName 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def updPassWordFromUserInfo(request): code, data, message = None, None, None try: userInfo = checkUserSession(request) oldPassWrod = request.GET.get('oldPassWrod') newPassWord = request.GET.get('newPassWord') if oldPassWrod and newPassWord: #: 密旧码验证 oldPassWrod = hash(oldPassWrod) dbPassWord = userInfoDao.getPassWordFromUserInfoByUserId( userInfo['user_id']) if oldPassWrod != dbPassWord: raise Exception('参数报错: 老密码错误,请重新输入谢谢!') #: 新密码更新 newPassWord = hash(newPassWord) userInfoDao.updAllFromUserInfoByUserId(userInfo['user_id'], password=newPassWord) code, message = 200, '密码修改成功' else: raise Exception("参数报错: 新旧密码不能为空!") except Exception as e: code, message = 300, str(e) finally: NATS_publish("updPassWordFromUserInfo") kafka_saveLog("updPassWordFromUserInfo", code) return HttpResponse( JsonResponse(code=code, message=message, data=None).getJson())
def getAllFromRoleInfoByRoleId(requset): code, data, message = None, None, None try: checkUserSession(requset) apiId = requset.GET.get('roleId') if apiId: roleInfo = roleInfoDao.getAllFromRoleInfoByRoleId(apiId) code = 200 data = {'roleInfo': OrmConversion(roleInfo)} else: raise Exception('参数报错: roleId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def delFromRoleInfoByRoleId(requset): code, data, message = None, None, None try: checkUserSession(requset) roleId = requset.GET.get('roleId') if roleId: userGroupDao.updRoleIdIsNoneFromUserGroupByRoleId(roleId) roleInfoDao.delFromRoleInfoByRoleId(roleId) code, message = 200, '更新完成' else: raise Exception('参数报错: apiId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def updPassWordFromUserInfo(request): code, data, message = None, None, None try: userInfo = checkUserSession(request) oldPassWrod = request.GET.get('oldPassWrod') newPassWord = request.GET.get('newPassWord') if oldPassWrod and newPassWord: #: 密旧码验证 h = hashlib.sha256() h.update(bytes(oldPassWrod, encoding='utf-8')) oldPassWrod = h.hexdigest() dbPassWord = userInfoDao.getPassWordFromUserInfoByUserId( userInfo['user_id']) if oldPassWrod != dbPassWord: raise Exception('参数报错: 老密码错误,请重新输入谢谢!') #: 新密码更新 p = hashlib.sha256() p.update(bytes(newPassWord, encoding='utf-8')) newPassWord = p.hexdigest() userInfoDao.updAllFromUserInfoByUserId(userInfo['user_id'], password=newPassWord) code, message = 200, '密码修改成功' else: raise Exception("参数报错: 新旧密码不能为空!") except Exception as e: code, message = 300, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=None).getJson())
def setFromReleaseOrder(requset): code, data, message = None, None, None try: userInfo = checkUserSession(requset) orderTitle = requset.GET.get('orderTitle') orderContent = requset.GET.get('orderContent') releaseTime = requset.GET.get('releaseTime') executorId = requset.GET.get('executorId') ambientId = requset.GET.get('ambientId') artisanId = requset.GET.get('artisanId') authorId = userInfo['user_id'] productId = requset.GET.get('productId') remarks = requset.GET.get('remarks') ftpPath = requset.GET.get('ftpPath') if orderTitle and orderContent and releaseTime and ambientId and artisanId and authorId and productId and executorId: releaseOrder = releaseOrderDao.setFromReleaseOrder(orderTitle, orderContent, releaseTime, ambientId, executorId, artisanId, authorId, productId, remarks=remarks, ftpPath=ftpPath) code, message = 200, '添加工单完成' else: raise Exception( '参数报错: orderTitle, orderContent, releaseTime, ambientId, executorId, artisanId, authorId, productId 都不能为空' ) except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def delFromUserGroupByGroupId(requset): code, data, message = None, None, None try: checkUserSession(requset) groupId = requset.GET.get('groupId') if groupId: userInfoDao.updGroupIdFromUserInfoByGroupId(groupId) userGroupDao.delFromUserGroupByGroupId(groupId) code, message = 200, '删除完成' else: raise Exception('参数报错: groupId 不能为空!') except Exception as e: code, data, message = 300, None, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=data).getJson())
def updInfoFromUserInfo(request): code, data, message = None, None, None try: userInfo = checkUserSession(request) userName = request.GET.get('userName') phone = request.GET.get('phone') email = request.GET.get('email') if userName: if phone: checkUserInfo = userInfoDao.getFromUserInfoByLogin(phone) if checkUserInfo and checkUserInfo.user_id != userInfo[ 'user_id']: raise Exception("参数报错: 手机号码已存在") if email: checkUserInfo = userInfoDao.getFromUserInfoByLogin(phone) if checkUserInfo and checkUserInfo.user_id != userInfo[ 'user_id']: raise Exception("参数报错: 邮箱已存在") userInfoDao.updAllFromUserInfoByUserId(userInfo['user_id'], userName=userName, phone=phone, email=email) code, message = 200, '信息更新成功' else: raise Exception('参数报错: 用户名不能修改为空!') except Exception as e: code, message = 300, str(e) finally: return HttpResponse( JsonResponse(code=code, message=message, data=None).getJson())