用户头像mysql保存

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    avatar_url VARCHAR(255)
);

import os
import uuid
import mysql.connector

# 假设文件已经上传到服务器，并且文件名为 uploaded_avatar.jpg
file_path = 'path/to/uploaded_avatar.jpg'

# 生成唯一的文件名
unique_filename = str(uuid.uuid4()) + '.jpg'
new_file_path = os.path.join('path/to/avatar/directory', unique_filename)

# 移动文件到指定目录
os.rename(file_path, new_file_path)

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)
cursor = db.cursor()

# 插入或更新用户头像路径
sql = "UPDATE users SET avatar_url = %s WHERE id = %s"
val = (new_file_path, user_id)
cursor.execute(sql, val)

# 提交更改
db.commit()

# 关闭连接
cursor.close()
db.close()