def update_entity_type(entity_type_id: int):
"""更新"""
data: dict = request.get_json()
entity_type = EntityType.query.filter(
EntityType.entity_type_id == entity_type_id
).first()
if not entity_type:
return dbu.inner_error("该不存在或已被删除")
dbu.update(entity_type, data)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("更新失败")
return jsonify(
{"data":
{"entity_type_id": entity_type.entity_type_id},
"code": 200,
"msg": "更新角色成功"
}
)
def update_User(User_id: str):
"""更新"""
data: dict = request.get_json()
User = .query.filter(
.User_id == User_id
).first()
if not User:
return dbu.inner_error("该不存在或已被删除")
dbu.update(User, data)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("更新失败")
return jsonify(
{"data":
{"User_id": User.User_id},
"code": 200,
"msg": "更新角色成功"
}
)
def update_regex_extractor(regex_extractor_id: str):
"""更新"""
data: dict = request.get_json()
regex_extractor = RegexExtractor.query.filter(
RegexExtractor.regex_extractor_id == regex_extractor_id).first()
if not regex_extractor:
return dbu.inner_error("该不存在或已被删除")
dbu.update(regex_extractor, data)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("更新失败")
return jsonify({
"data": {
"regex_extractor_id": regex_extractor.regex_extractor_id
},
"code": 200,
"msg": "更新角色成功"
})
def get_user(user_id: int):
"""获取单个数据"""
user = User.query.filter(User.user_id == user_id).first()
if not user:
return dbu.inner_error("该不存在或已被删除")
return jsonify({"code": 200, "data": user})
def get_entity(entity_id: int):
"""获取单个数据"""
entity = Entity.query.filter(Entity.entity_id == entity_id).first()
if not entity:
return dbu.inner_error("该不存在或已被删除")
return jsonify({"code": 200, "data": entity})
def delete_User(User_id: str):
"""删除"""
User = .query.filter(
.User_id == User_id
).first()
if not User:
return dbu.inner_error("该不存在或已被删除")
db.session.delete(User)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("删除失败")
return jsonify({"data": {"User_id": User_id}, "code": 200, "msg": "删除角色成功"})
def get_regex_extractor(regex_extractor_id: str):
"""获取单个数据"""
regex_extractor = RegexExtractor.query.filter(
RegexExtractor.regex_extractor_id == regex_extractor_id).first()
if not regex_extractor:
return dbu.inner_error("该不存在或已被删除")
return jsonify({"code": 200, "data": regex_extractor})
def delete_regex_extractor(regex_extractor_id: int):
"""删除"""
regex_extractor = RegexExtractor.query.filter(
RegexExtractor.regex_extractor_id == regex_extractor_id
).first()
if not regex_extractor:
return dbu.inner_error("该不存在或已被删除")
db.session.delete(regex_extractor)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("删除失败")
return jsonify({"data": {"regex_extractor_id": regex_extractor_id}, "code": 200, "msg": "删除角色成功"})
def delete_entity_type(entity_type_id: int):
"""删除"""
entity_type = EntityType.query.filter(
EntityType.entity_type_id == entity_type_id
).first()
if not entity_type:
return dbu.inner_error("该不存在或已被删除")
db.session.delete(entity_type)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("删除失败")
return jsonify({"data": {"entity_type_id": entity_type_id}, "code": 200, "msg": "删除角色成功"})
def get_User(User_id: str):
"""获取单个数据"""
User = .query.filter(
.User_id == User_id
).first()
if not User:
return dbu.inner_error("该不存在或已被删除")
return jsonify({"code": 200, "data": User})
def get_Users():
"""获取列表"""
params = request.get_json(force=True)["list_query"]
du.time_start_end(params, "create_time")
try:
model_filter = dbu.build_filter("", params)
except Exception as e:
current_app.logger.warning(e)
return dbu.inner_error("查询失败")
query = .query.filter(*model_filter)
return dbu.paginate_data(query, params)
def add_User():
"""新增"""
data = request.get_json()
User = ()
dbu.update(User, data)
db.session.add(User)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("新增失败")
return jsonify(
{
"data": {"User_id": User.User_id},
"code": 200,
"msg": "新增成功"
}
)
def add_regex_extractor():
"""新增"""
data = request.get_json()
regex_extractor = RegexExtractor()
dbu.update(regex_extractor, data)
db.session.add(regex_extractor)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("新增失败")
return jsonify({
"data": {
"regex_extractor_id": regex_extractor.regex_extractor_id
},
"code": 200,
"msg": "新增成功"
})
def add_entity_type():
"""新增"""
data = request.get_json()
entity_type = EntityType()
dbu.update(entity_type, data)
db.session.add(entity_type)
try:
db.session.commit()
except Exception as e:
current_app.logger.warning(e)
db.session.rollback()
return dbu.inner_error("新增失败")
return jsonify(
{
"data": {"entity_type_id": entity_type.entity_type_id},
"code": 200,
"msg": "新增成功"
}
)
