如果没有SQLAlchemy,答案基本上已经在这个问题上了:让它变得天真,但要以这样的方式存储相同的时区(读作:UTC):if now.tzinfo is not None:
now = now.astimezone(utc).replace(tzinfo=None)
return now
这将确保始终存储UTC(但如果传递naive,请确保它始终为naive!当从数据库中取出该项时,请确保再次使其具有UTC意识:
^{pr2}$
由于MySQL不支持支持tz的对象,所以可以删除检查(它应该始终是None)。在
对于SQLAlchemy,也可以使用相同的方法(但是扩展了让SA自动执行)。为此,我们使用TypeDecorator:class TZDateTime(TypeDecorator):
"""
Coerces a tz-aware datetime object into a naive utc datetime object to be
stored in the database. If already naive, will keep it.
On return of the data will restore it as an aware object by assuming it
is UTC.
Use this instead of the standard :class:`sqlalchemy.types.DateTime`.
"""
impl = DateTime
def process_bind_param(self, value, dialect):
if value.tzinfo is not None:
value = value.astimezone(utc).replace(tzinfo=None)
return value
def process_result_value(self, value, dialect):
if value.tzinfo is None:
value = utc.localize(value)
return value
这样可以确保处理的数据在UTC上始终是tz感知的,只要总是将原始值生成为UTC:datetime.datetime.utcnow()。在
定义列时,请使用该列而不是常规类型:class Test(Base):
__tablename__ = 'test'
created_at = Column(TZDateTime)