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