def project_deluser(*args, **kwargs):
project_id = request.json.get("project_id")
user_id = request.json.get("user_id")
try:
pro_user = ProjectUser(project_id=project_id, user_id=user_id)
db_session.add(pro_user)
db_session.commit()
return make_response(jsonify({'code': 200, 'msg': u'删除项目用户成功!'}))
except Exception as e:
return make_response(jsonify({'code': 401, 'error_msg': u'删除项目用户失败!'}))
def api_delete(*args,**kwargs):
api_id = request.json.get('api_id') # 接口描述
try:
api = db_session.query(Api).filter_by(id=api_id).one()
db_session.delete(api)
db_session.commit()
return make_response(jsonify({"code":200,"msg": u'删除接口成功'}))
except Exception as e:
return make_response(jsonify({"code":404,"error_msg": u'新增接口失败'}))
def script_adduser(*args,**kwargs):
user_id = request.json.get('user_id')
script_id = request.json.get('script_id')
try:
userscript = UserScript(user_id=user_id,script_id=script_id)
db_session.add(userscript)
db_session.commit()
return make_response(jsonify({"code": 200, "msg": u'添加用户成功'}))
except Exception as e:
return make_response(jsonify({"code": 404, "msg": e}))
def project_del(*args, **kwargs):
# 判断是否还有挂接的接口
project = request.json.get("project_name")
version = request.json.get("project_version")
try:
pro = Project(project=project, version=version)
db_session.delete(pro)
db_session.commit()
return make_response(jsonify({'code': 200, 'msg': u'删除项目成功!'}))
except Exception:
return make_response(jsonify({'code': 401, 'error_msg': u'删除项目失败!'}))
def results_delete(*args, **kwargs):
results_id = request.json.get("results_id") # 有可能报错这里
try:
result = db_session.query(Results).filter(
Results.id.in_(results_id)).all()
db_session.delete(result)
db_session.commit()
return make_response(jsonify({"code": 200, "msg": u'删除成功'}))
except Exception as e:
print('results_delete接口有可能results_id参数格式错误')
return make_response(jsonify({"code": 404, "error_msg": u'删除失败'}))
def script_delete(*args,**kwargs):
user_id = request.json.get('user_id')
script_id = request.json.get('script_id')
try:
script = db_session.query(UserScript).filter_by(user_id=user_id).filter_by(script_id=script_id).one()
if script.id is not None:
db_session.query(Script).filter_by(script_id=script_id).delete()
db_session.commit()
return make_response(jsonify({"code": 200, "msg": u'脚本删除成功'}))
except Exception as e:
return make_response(jsonify({"code": 404, "msg": e}))
def api_add(*args,**kwargs):
project_name = request.json.get("project_name")
module_sub = request.json.get("module_sub")
api_description = request.json.get("api_description") # 接口描述
try:
project = db_session.query(Project).filter_by(project=project_name).one()
api = Api(project_id=project.id,module_sub=module_sub,api_description=api_description)
db_session.add(api)
db_session.commit()
return make_response(jsonify({"code":200,"msg": u'新增接口成功'}))
except Exception as e:
return make_response(jsonify({"code":404,"error_msg": u'新增接口失败'}))
def project_add(*args, **kwargs):
# 用户自己添加脚本或者，
# 前端校验必输项
project = request.json.get("project_name")
version = request.json.get("project_version")
try:
pro = Project(project=project, version=version)
db_session.add(pro)
# db_session.rollback()
db_session.commit()
return make_response(jsonify({'code': 200, 'msg': u'添加项目成功!'}))
except Exception as e:
print(e)
return make_response(jsonify({'code': 401, 'msg': u'添加项目失败!'}))
def api_upgrade(*args,**kwargs):
api_id = request.json.get('api_id') # 接口描述
# project_name = request.json.get("project_name")
module_sub = request.json.get("module_sub")
api_description = request.json.get("api_description")
try:
db_session.query(Api).filter_by(id=api_id).upgrade(module_sub=module_sub,
api_description=api_description)
db_session.commit()
return make_response(jsonify({"code":200,"msg": u'修改接口成功'}))
except Exception as e:
return make_response(jsonify({"code":404,"error_msg": u'新增接口失败'}))
def project_update(*args, **kwargs):
# 判断是否还有挂接的接口
project_id = request.json.get("project_id")
project = request.json.get("project_name")
version = request.json.get("project_version")
try:
db_session.query(Project).filter_by(id=project_id).update(
project=project, version=version)
db_session.commit()
return make_response(jsonify({'code': 200, 'msg': u'删除项目成功!'}))
except Exception:
return make_response(jsonify({'code': 401, 'error_msg': u'删除项目失败!'}))
def script_upgrade(*args,**kwargs):
user_id = request.json.get('user_id')
script_id = request.json.get('script_id')
script_content = request.json.get('script_content')
description = request.json.get('script_description')
try:
script = db_session.query(UserScript).filter_by(user_id=user_id).filter_by(script_id=script_id).one()
if script.id is not None:
db_session.query(Script).filter_by(script_id=script_id).update(script_content=script_content,description=description)
db_session.commit()
return make_response(jsonify({"code": 200, "msg": u'脚本更新成功'}))
except Exception as e:
return make_response(jsonify({"code": 404, "msg": e}))
def script_add(*args,**kwargs):
# 用户自己添加脚本或者，
username = request.json.get('username')
api_description = request.json.get('api_description')
try:
user = db_session.query(User).filter_by(username=username).one()
user_id = user.id
api = db_session.query(Api).filter_by(api_description=api_description).one()
api_id = api.id
api_user = db_session.query(ApiUser).filter_by(user_id=user_id,api_id=api_id).one()
api_user_id = api_user.id
except Exception as e:
return make_response(jsonify({"code": 404,"error_msg":e}))
script_content = request.json.get('script_content')
description = request.json.get('script_description')
try:
script = Script(api_user_id=api_user_id,script_content=script_content,description=description)
db_session.add(script)
db_session.commit()
return make_response(jsonify({"code": 200,"msg": u'脚本添加成功'}))
except Exception as e:
return make_response(jsonify({"code": 404, "error_msg": e}))