Path: csiph.com!aioe.org!bofh.it!news.nic.it!robomod From: Edward Betts Newsgroups: linux.debian.bugs.dist,linux.debian.devel,linux.debian.maint.python Subject: Bug#1015720: ITP: sqlalchemy-utc -- SQLAlchemy type to store timezone aware datetime values Date: Tue, 19 Jul 2022 22:20:01 +0200 Message-ID: X-Original-To: Debian Bug Tracking System X-Mailbox-Line: From debian-bugs-dist-request@lists.debian.org Tue Jul 19 20:15:10 2022 Old-Return-Path: X-Spam-Flag: NO X-Spam-Score: -3.761 Reply-To: Edward Betts , 1015720@bugs.debian.org Resent-To: debian-bugs-dist@lists.debian.org Resent-Cc: debian-devel@lists.debian.org, debian-python@lists.debian.org, wnpp@debian.org X-Debian-Pr-Message: report 1015720 X-Debian-Pr-Package: wnpp MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline X-Debian-Message: from BTS X-Mailing-List: archive/latest/1725908 List-ID: List-URL: Approved: robomod@news.nic.it Lines: 22 Organization: linux.* mail to news gateway Sender: robomod@news.nic.it X-Original-Date: Tue, 19 Jul 2022 21:13:25 +0100 X-Original-Message-ID: <20220719201325.zrmiproyhh7txhnx@4angle.com> Xref: csiph.com linux.debian.bugs.dist:1110386 linux.debian.devel:105079 linux.debian.maint.python:14258 Package: wnpp Severity: wishlist Owner: Edward Betts X-Debbugs-Cc: debian-devel@lists.debian.org, debian-python@lists.debian.org * Package name : sqlalchemy-utc Version : 0.14.0 Upstream Author : Hong Minhee * URL : https://github.com/spoqa/sqlalchemy-utc * License : MIT Programming Lang: Python Description : SQLAlchemy type to store timezone aware datetime values UtcDateTime type is equivalent to the built-in 'DateTime' with 'timezone=True' option enabled on vendors that support 'timestamptz' e.g. PostgreSQL, but on SQLite or MySQL, it shifts all 'datetime.datetime' values to UTC offset before store them, and returns timezone aware 'datetime.datetime' values through result sets. This is a dependency of the pydantic-sqlalchemy Python library. I plan to maintain this package as part of the Python modules team.