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)