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()