def getRoomList(user_id):
filters = {AddressBook.be_focused_user_id == user_id}
res = dBSession.query(AddressBook).order_by(
AddressBook.updated_at.desc()).filter(*filters).all()
data = {"list": Utils.db_l_to_d(res)}
return data
def getRoomList(user_id):
filters = {
AddressBook.be_focused_user_id == user_id
}
data = dBSession.query(AddressBook).order_by(AddressBook.updated_at.desc()).filter(*filters).all()
data = Base.formatBody(Utils.db_l_to_d(data))
return data
def getRoomList(user_id):
# 获取消息房间列表
filters = {UserRoomRelation.user_id == user_id}
data = dBSession.query(UserRoomRelation).order_by(
UserRoomRelation.updated_at.desc()).filter(*filters).all()
data = Base.formatBody(Utils.db_l_to_d(data))
return data
def delete(params, user_info):
filters = {Room.room_uuid == params['room_uuid']}
roomData = Room().getOne(filters)
if roomData['type'] == 0:
address_book_data = Utils.db_l_to_d(
AddressBook.get(params['room_uuid']))
filters = {AddressBook.room_uuid == params['room_uuid']}
AddressBook().delete(filters)
filters = {Room.room_uuid == params['room_uuid']}
Room().delete(filters)
for item in address_book_data:
roomList = AddressBook.getRoomList(
item['be_focused_user_id'])['data']
socketio.emit('room',
Utils.formatBody(roomList),
namespace="/room",
room='@broadcast.' +
str(item['be_focused_user_id']))
roomList = AddressBook.getRoomList(
item['focused_user_id'])['data']
socketio.emit('room',
Utils.formatBody(roomList),
namespace="/room",
room='@broadcast.' +
str(item['focused_user_id']))
else:
user_room_relation_data = Utils.db_l_to_d(
UserRoomRelation.get(params['room_uuid']))
filters = {
UserRoomRelation.room_uuid == params['room_uuid'],
UserRoomRelation.user_id == user_info['data']['id']
}
data = UserRoomRelation().delete(filters)
filters = {Room.room_uuid == params['room_uuid']}
Room().delete(filters)
filters = {UserRoomRelation.room_uuid == params['room_uuid']}
UserRoomRelation().delete(filters)
for item in user_room_relation_data:
roomList = UserRoomRelation.getRoomList(
item['user_id'])['data']
socketio.emit('groupRoom',
Utils.formatBody(roomList),
namespace='/room',
room='@broadcast.' + str(item['user_id']))
return Utils.formatBody()
def create(user_info, params):
# 加入房间号
data = ChatService().groupChatCreate(user_info, params)
if data:
#添加后同步房间
user_room_relation_data = Utils.db_l_to_d(UserRoomRelation.get(data['room_uuid']))
for item in user_room_relation_data:
roomList = UserRoomRelation.getRoomList(item['user_id'])['data']
socketio.emit('groupRoom', Utils.formatBody(roomList), namespace='/room', room='@broadcast.'+str(item['user_id']))
return Utils.formatBody(data, msg='创建成功')
return Utils.formatError(Code.BAD_REQUEST,msg='创建失败')
def create(params, user_info):
# 加入房间号
data = ChatService().groupChatCreate(params, user_info)
if data:
#添加后同步房间
user_room_relation_data = Utils.db_l_to_d(UserRoomRelation.get(data['room_uuid']))
for item in user_room_relation_data:
roomList = UserRoomRelation.getRoomList(item['user_id'])
socketio.emit('groupRoom', Utils.formatBody(roomList), namespace='/api', room='@broadcast.'+str(item['user_id']))
return Utils.formatBody(data, msg='创建成功')
return Utils.formatError(CONST['CODE']['BAD_REQUEST']['value'],msg='创建失败')
def groupChatCreate(user_info, params):
# 加入房间号
data = ChatService().groupChatCreate(user_info, params)
if data:
#添加后同步房间
user_room_relation_data = Utils.db_l_to_d(
UserRoomRelation.get(data['room_uuid']))
for item in user_room_relation_data:
roomList = UserRoomRelation.getRoomList(item['user_id'])
socketio.emit('groupRoom',
Utils.formatBody(roomList),
namespace='/api',
room='@broadcast.' + str(item['user_id']))
return BaseController().successData(data, msg='创建成功')
return BaseController().error(msg='创建失败')
def leftJoin():
data = dBSession.query(Suggest).outerjoin(
Users, Users.id == Suggest.users_id).all()
data_msg = Utils.db_l_to_d(data)
return data_msg
def on_to_many():
data = dBSession.query(Suggest).filter(
Users.id == Suggest.users_id).all()
# all方法返回列表要进行处理才能调用sqlalchemy_serializer的to_dict方法
data_msg = Utils.db_l_to_d(data)
return data_msg
def getInfo():
""" 不通过鉴权获取用户信息 """
id = request.json.get('id')
data = Users.query.filter_by(id=id).all()
datas = Utils.db_l_to_d(data)
return BaseController().successData(datas)
def rawGetList(page_no, per_page, filters):
dataObj = dBSession.query(AddressBook).order_by(
AddressBook.created_at.desc()).filter(*filters).all()
data = {"addressBookList": Utils.db_l_to_d(dataObj)}
return data
def rawGetList(page_no, per_page, filters):
dataObj = dBSession.query(AddressBook).order_by(AddressBook.created_at.desc()).filter(*filters).all()
addressBookList = Utils.db_l_to_d(dataObj)
data = Base.formatBody(
{"addressBookList": addressBookList})
return data
def getData(uuid):
obj = dBSession.query(ImgShard).filter_by(
uuid=uuid).order_by('index').all()
data = Utils.db_l_to_d(obj)
return data
