def receive(username, groupID, time, msg): user = UserService.getProfile() user_groupID = user[-1] if user_groupID == groupID: DB.execute( 'INSERT INTO message_group(from_username, group_id, time, message) VALUES (?,?,?,?)', (username, groupID, time, msg))
def update(self): first_name = self.e1.get() last_name = self.e2.get() year = self.e4.get() faculty = self.e5.get() setup.current_user.update(first_name, last_name, year, faculty) UserService.updateProfile(first_name, last_name, faculty, year) print(first_name, last_name, year, faculty) print(UserService.getProfile())
def send(msg): username = UserService.getProfile()[0] timestamp = datetime.utcnow() msgEntity = BroadcastMessageEntity(username, { 'timestamp': str(timestamp), 'message': msg }) setup.net.sendMessageBroadcast(msgEntity) DB.execute( 'INSERT INTO message_broadcast(from_username, time, message) VALUES (?,?,?)', (username, str(timestamp), msg))
def createGroup(groupName, limitPerson): username = UserService.getProfile()[0] DB.executemultiplesql([( 'REPLACE INTO `group`(group_id, group_name, max_person) VALUES (?,?,?)', (username, groupName, limitPerson)), ('UPDATE `user` SET group_id=? WHERE username=?', ( username, username, )), ('UPDATE self SET is_admin=1 WHERE username=?', (username, ))])
def send(msg): user = UserService.getProfile() username = user[0] groupID = user[-1] if (groupID != '0'): timestamp = datetime.utcnow() msgEntity = GroupMessageEntity(username, groupID, { 'timestamp': str(timestamp), 'message': msg }) setup.net.sendMessageGroup(msgEntity) DB.execute( 'INSERT INTO message_group(from_username, group_id, time, message) VALUES (?,?,?,?)', (username, groupID, str(timestamp), msg))
def requestJoinGroup(groupID): username = UserService.getProfile()[0] req = Request(username, groupID) setup.net.sendGroupJoinRequest(req)
def getAll(): groupID = UserService.getProfile()[-1] result = DB.execute( 'SELECT `user`.firstname, time, message FROM message_group INNER JOIN `user` ON message_group.from_username=`user`.username WHERE message_group.group_id=? ORDER BY time ASC', (groupID, )) return result.fetchall()
def receiveJoinOK(self, groupID: int): logger.info(f"Confirm joining groupID={groupID}") username = UserService.getProfile()[0] UserService.updateGroup(username, groupID) messagebox.showinfo('Accept request', 'Joined group ' + str(groupID))
def receiveGroupJoinRequest(self, req: Request): logger.info(f"Receive request to joining group {req}") if UserService.isAdmin() and UserService.getProfile()[-1] == req.groupID: JoinRequest(req)