from sqlalchemy.testing.pickleable import Order
|
|
from app.config.config import settings
|
from app.models.group_model import GroupInfoModel, UserGroupModel
|
from app.models.user_model import UserModel
|
from app.service.ragflow import RagflowService
|
from app.service.token import get_ragflow_token
|
|
|
async def group_list(db, page_size: int, page_index: int, keyword: str):
|
query = db.query(GroupInfoModel)
|
if keyword:
|
query = query.filter(GroupInfoModel.group_name.like('%{}%'.format(keyword)))
|
items = query.order_by(GroupInfoModel.group_id.desc()).limit(page_size).offset(
|
(page_index - 1) * page_size).all()
|
items_list = [item.to_dict() for item in items]
|
groups = [i["id"] for i in items_list]
|
group_dict = {}
|
for group_user in db.query(UserGroupModel.group_id, UserModel.id, UserModel.username).outerjoin(UserModel,
|
UserModel.id == UserGroupModel.user_id).filter(
|
UserGroupModel.group_id.in_(groups)).all():
|
if group_user.group_id in group_dict:
|
group_dict[group_user.group_id].append({"user_id": group_user.id, "user_name": group_user.username})
|
else:
|
group_dict[group_user.group_id] = [{"user_id": group_user.id, "user_name": group_user.username}]
|
for item in items_list:
|
item["users"] = group_dict.get(item["id"], [])
|
return {"total": query.count(), "items": items_list}
|
|
|
async def create_group(db, group_name: str, group_description: str):
|
try:
|
group_model = GroupInfoModel(group_name=group_name, group_description=group_description)
|
db.add(group_model)
|
db.commit()
|
db.refresh(group_model)
|
except Exception as e:
|
print(e)
|
db.rollback()
|
return False
|
return True
|
|
|
async def edit_group_data(db, group_id: int, data):
|
try:
|
db.query(GroupInfoModel).filter(GroupInfoModel.group_id == group_id).update(data)
|
db.commit()
|
except Exception as e:
|
print(e)
|
db.rollback()
|
return False
|
return True
|
|
|
async def delete_group_data(db, group_id: int):
|
try:
|
db.query(GroupInfoModel).filter(GroupInfoModel.group_id == group_id).delete()
|
db.commit()
|
except Exception as e:
|
print(e)
|
db.rollback()
|
return False
|
return True
|
|
|
async def get_group_users(db, group_id):
|
not_group_user = []
|
in_group_user = []
|
user_list = [i.user_id for i in
|
db.query(UserGroupModel.user_id).filter(UserGroupModel.group_id.__eq__(group_id)).all()]
|
for u in db.query(UserModel.id, UserModel.username).order_by(UserModel.id.desc()).all():
|
if u.id in user_list:
|
in_group_user.append({"user_id": u.id, "user_name": u.username})
|
else:
|
not_group_user.append({"user_id": u.id, "user_name": u.username})
|
return {"in_group": in_group_user, "not_in_group": not_group_user}
|
|
|
async def save_user_to_group(db, user_id, group_id, user_list):
|
group_user_list = [i.user_id for i in
|
db.query(UserGroupModel.user_id).filter(UserGroupModel.group_id.__eq__(group_id)).all()]
|
new_users = set([i for i in user_list if i not in group_user_list])
|
delete_user = [i for i in group_user_list if i not in user_list]
|
if new_users:
|
|
user_dict = {i.id: {"rg_id": i.ragflow_id, "email": i.email} for i in
|
db.query(UserModel.id, UserModel.email, UserModel.ragflow_id).filter(
|
UserModel.id.in_(user_list)).all()}
|
ragflow_service = RagflowService(settings.fwr_base_url)
|
token = get_ragflow_token(db, user_id)
|
|
try:
|
for old_user in group_user_list:
|
if old_user in delete_user:
|
continue
|
for new_user in new_users:
|
await ragflow_service.add_user_tenant(token, user_dict[old_user]["rg_id"], user_dict[new_user]["email"],
|
user_dict[new_user]["rg_id"])
|
await ragflow_service.add_user_tenant(token, user_dict[new_user]["rg_id"], user_dict[old_user]["email"],
|
user_dict[old_user]["rg_id"])
|
for user1 in new_users:
|
for user2 in new_users:
|
if user1 != user2:
|
await ragflow_service.add_user_tenant(token, user_dict[user1]["rg_id"],
|
user_dict[user2]["email"],
|
user_dict[user2]["rg_id"])
|
except Exception as e:
|
print(e)
|
return False
|
try:
|
for user in new_users:
|
db_user = UserGroupModel(group_id=group_id, user_id=user)
|
db.add(db_user)
|
db.query(UserGroupModel).filter(UserGroupModel.group_id.__eq__(group_id), UserGroupModel.user_id.in_(delete_user)).delete()
|
db.commit()
|
except Exception as e:
|
print(e)
|
return False
|
return True
|
