在SQLAlchemy中使用BLOB的示例

pip install sqlalchemy

from sqlalchemy import create_engine, Column, Integer, String, LargeBinary
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    avatar = Column(LargeBinary)

engine = create_engine('sqlite:///users.db')
Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

import io
import requests

# 下载一张图片
url = 'https://example.com/avatar.png'
response = requests.get(url)
avatar_data = response.content

# 将用户添加到数据库
new_user = User(name='John Doe', avatar=avatar_data)
session.add(new_user)
session.commit()

# 查询用户
user = session.query(User).filter_by(name='John Doe').first()

# 将头像保存为文件
with open('avatar.png', 'wb') as f:
    f.write(user.avatar)