在SQLAlchemy中创建动态类

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String

Base = declarative_base()

DynamicClass = type('DynamicClass', (Base,), {})

DynamicClass.__tablename__ = 'my_table'
DynamicClass.id = Column(Integer, primary_key=True)
DynamicClass.name = Column(String(50))

# 创建数据库表
Base.metadata.create_all(engine)

# 插入数据
session.add(DynamicClass(name='John'))
session.commit()

# 查询数据
result = session.query(DynamicClass).filter_by(name='John').first()
print(result.name)