Python sqlalchemy MSSQL中的二进制密钥编码/解码

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

# 创建数据库连接
engine = create_engine('mssql+pyodbc://username:password@server/database')

# 创建会话
Session = sessionmaker(bind=engine)
session = Session()

# 创建模型
Base = declarative_base()

class MyModel(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    binary_data = Column(Binary)

# 插入二进制数据
binary_key = b'\x01\x02\x03\x04'
model = MyModel(binary_data=binary_key)
session.add(model)
session.commit()

# 查询二进制数据
result = session.query(MyModel).filter_by(id=1).first()
binary_key = result.binary_data

# 解码二进制数据
decoded_key = binary_key.decode('utf-8')

# 编码二进制数据
encoded_key = decoded_key.encode('utf-8')

# 更新二进制数据
result.binary_data = encoded_key
session.commit()