将pydantic对象写入sqlalchemy json列

from sqlalchemy import Column, Integer, JSON, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from pydantic import BaseModel

# 创建SQLAlchemy引擎和会话
engine = create_engine('数据库连接字符串')
Session = sessionmaker(bind=engine)
session = Session()

# 创建基础模型
Base = declarative_base()

# 定义数据模型
class MyModel(Base):
    __tablename__ = 'my_table'
    id = Column(Integer, primary_key=True)
    data = Column(JSON)

# 定义pydantic数据模型
class MyPydanticModel(BaseModel):
    name: str
    age: int

# 创建一个pydantic对象
pydantic_obj = MyPydanticModel(name='John', age=25)

# 将pydantic对象转换为字典
data_dict = pydantic_obj.dict()

# 创建SQLAlchemy模型对象并存储到数据库
sqlalchemy_obj = MyModel(data=data_dict)
session.add(sqlalchemy_obj)
session.commit()