入库.py

import pymysql
import re

conn = pymysql.connect(
    host='localhost',
    user='root',
    password='000000',
    db='test',
    charset='utf8mb4',
    port=3306)

cur = conn.cursor()

with open(r"D:\临时文件\wechatLog\txt\你跺你也麻\林瓜瓜.txt", encoding='utf-8') as f:
    lines = f.readlines()
    filter_lines = []
    reg = "^.+[\u4E00-\u9FFF]\s\(.+\):"

    for line in lines:
        # 去除转发的聊天记录 简单过滤
        if (line.startswith('你跺你也麻') or line.startswith('喇叭精')) and re.match(reg, line):
            filter_lines.append(line.strip())

for line in filter_lines:
    s1 = line.find(" ")
    s2 = line.find("):")
    name = line[:s1]
    time = line[s1 + 2:s2]
    content = line[s2 + 2:]
    print(line)
    insert_sql = f"insert into log(user,datetime,content) values ('{name}','{time}' ,'{pymysql.escape_string(content)}')"
    cur.execute(insert_sql)
conn.commit()