Repository files navigation

This package provides a drop-in replacement of SQLAlchemy's built-inDateTimetype withtimezone=True option enabled. Although SQLAlchemy's built-inDateTime type providestimezone=True option, since some vendors likeSQLite and MySQL don't providetimestamptz data type, the option doesn'tmake any effect on these vendors.

UtcDateTime type is equivalent to the built-inDateTime withtimezone=True option enabled on vendors that supporttimestamptze.g. PostgreSQL, but on SQLite or MySQL, it shifts alldatetime.datetimevalues to UTC offset before store them, and returns always awaredatetime.datetime values through result sets.

Long story short,UtcDateTime does:

• take only awaredatetime.datetime,
• return only awaredatetime.datetime,
• never take or return naivedatetime.datetime,
• ensure timestamps in database always to be encoded in UTC, and
• work as you'd expect.

A SQLAlchemy helper function,utcnow(), is provided as an alternativetofunc.now() for generatingUtcDateTime values on the server. Forexample:Column('time', UtcDateTime(), default=utcnow()).

Written byHong Minhee atSpoqa, and distributed under MIT license.