| | |
| | | query = query.filter(GroupModel.group_name.like('%{}%'.format(keyword))) |
| | | items = query.order_by(GroupModel.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(GroupModel.group_id, UserModel.id, UserModel.username).outerjoin(UserModel, |
| | | # UserModel.id == UserGroupModel.user_id).filter( |
| | | # GroupModel.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": [item.to_json() for item in items]} |
| | | |
| | | |