SQLAlchemy 使用 SQLite 丢失时区信息

使用SQLAlchemy时SQLite丢失时区信息的问题及解决方法

python
from sqlalchemy import create_engine, Column, String, DateTime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from datetime import datetime, timezone
Base = declarative_base()
class Event(Base):
    __tablename__ = 'events'
    id = Column(String, primary_key=True)
    timestamp = Column(String)
# 创建SQLite内存数据库引擎
engine = create_engine('sqlite:///:memory:')
# 创建表
Base.metadata.create_all(engine)
# 创建会话
Session = sessionmaker(bind=engine)
session = Session()
# 添加带有时区信息的事件
event = Event(id='1', timestamp=datetime.now(timezone.utc).isoformat())
session.add(event)
session.commit()
# 查询事件并输出
queried_event = session.query(Event).filter_by(id='1').first()
print(f"Queried Event Timestamp: {queried_event.timestamp}")