def home():
if request.method == 'POST':
m = Message(content=request.form['content'])
m.content = html.escape(m.content)
m.save()
body = """
<html>
<body>
<h1>Class Message Board</h1>
<h2>Contribute to the Knowledge of Others</h2>
<form method="POST">
<textarea name="content"></textarea>
<input type="submit" value="Submit">
</form>
<h2>Wisdom From Your Fellow Classmates</h2>
"""
for m in Message.select():
body += """
<div class="message">
{}
</div>
""".format(m.content)
return body
def send_message(user_id, user_message, talk_to):
user_name = ""
# Find user's name with user_id
for user in server_data_container.user_list:
if user['user_id'] == user_id:
user_name = user['user_name']
break
format_msg = Message(user_id, talk_to, user_message)
# Group chat here
if talk_to == 0:
print('Group chat', format_msg)
format_msg.content = "<%s>: %s" % (user_name, format_msg.content)
for user in server_data_container.user_list:
if user['user_id'] != user_id:
user['message_queue'].put(format_msg)
# Individual talk here
else:
print('Individual chat', format_msg)
for user in server_data_container.user_list:
if user['user_id'] == talk_to and user_id != talk_to:
user['message_queue'].put(format_msg)
db = MySQL()
db.modify(
"INSERT INTO Message (user_id, content, destination) VALUES (%s,%s,%s)",
int(user_id), user_message, int(talk_to))
def read_message(self, msg_list):
count = 0
c = self.__conn.cursor()
c.execute(
"SELECT id,from_user,from_nick,from_remark,to_user,to_nick,content,recvtime,reply,sendtime,status FROM message WHERE status=0 ORDER BY id LIMIT 5"
)
rows = c.fetchall()
if not rows:
return count
for row in rows:
msg = Message()
msg.id = row[0]
msg.from_user = row[1]
msg.from_nick = row[2]
msg.from_remark = row[3]
msg.to_user = row[4]
msg.to_nick = row[5]
msg.content = row[6]
msg.recvtime = row[7]
msg.reply = row[8]
msg.sendtime = row[9]
msg.status = row[10]
msg_list.append(msg)
count = count + 1
print("read message id " + str(msg.id))
if count > 10:
break
return count
def text_reply(msg):
'''
print "MsgType: " + str(msg.MsgType)
print "MsgId: " + str(msg.MsgId)
print "FromUserName: "******"ToUserName: "******"Content: " + msg.Content
print "Message: " + msg.text
print "Actual Nick Name: " + msg.actualNickName
print "IsAt: " + str(msg.isAt)
'''
# if msg.isAt:
print "New Message: " + msg.text
m = Message()
m.id = 0
m.from_user = msg.FromUserName
m.from_nick = msg.actualNickName
m.from_remark = ChatDB.get_remark_by_userid(m.from_user)
m.to_user = msg.ToUserName
m.to_nick = ChatDB.get_nickname_by_userid(m.to_user)
m.content = msg.Content
m.recvtime = get_cur_time()
m.status = 0
ChatDB.save_new_message(m)
# msg.user.send(u'@%s\u2005I received: %s' % (msg.actualNickName, msg.text))
pass
def test_insert_message():
for i in range(1, 2):
msg = Message()
msg.id = 0
msg.from_user = "******"
msg.from_nick = "常胜将军"
msg.to_user = "******"
msg.to_nick = "李四"
msg.content = "1，大，200"
# msg.content = "取消"
msg.recvtime = get_cur_time()
msg.status = 0
last_id = ChatDB.save_new_message(msg)
print("Message ID inserted is " + str(last_id))
msg.id = last_id
msg.reply = "success"
msg.sendtime = get_cur_time()
msg.status = 2
# ChatDB.update_reply_message(msg)
pass
def save(content, msg_time):
msg = Message()
msg.content = content
msg.time = msg_time
return msg.save()
