DAY 16 将含LINE emoji团购讯息与关键字存到资料库

再上篇中撷取到的讯息只会即时传到聊天室，并不会保存下来。要保存讯息的话，就要把讯息保存到资料库。

建立讯息资料表

这边设计资料表讯息与LINE emoji存放的资料表，message_emoji的mid为FK关联到group_buying_message的mid

group_buying_message

mid	keyword	message_text

message_emoji

eid	mid	index	product_id	emoji_id

mid为FK关联到group_buying_message的mid

存放资料到资料表

def update_emoji_message(text,keyword,emojis):
    cursor = conn.cursor()
    cursor.execute("INSERT INTO group_buying_message (message_text, keyword) VALUES (%s, %s);", (text, keyword))
    cursor.execute(f"SELECT mid FROM group_buying_message WHERE message_text='{text}';")
    row = cursor.fetchone()
    for emoji in emojis:      
        cursor.execute("INSERT INTO message_emoji (mid, index, product_id, emoji_id) VALUES (%s, %s, %s, %s);", (row, emoji.index, emoji.product_id, emoji.emoji_id))
    conn.commit()
    cursor.close()
    print("successfully update emoji message")