{ "info": { "author": "Hong Minhee", "author_email": "hongminhee@member.fsf.org", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: Implementation :: CPython", "Programming Language :: Python :: Implementation :: PyPy", "Programming Language :: Python :: Implementation :: Stackless", "Programming Language :: SQL", "Topic :: Database :: Front-Ends", "Topic :: Software Development" ], "description": "SQLAlchemy-Utc\n==============\n\n.. image:: https://badge.fury.io/py/SQLAlchemy-Utc.svg?\n :target: https://pypi.python.org/pypi/SQLAlchemy-Utc\n.. image:: https://travis-ci.org/spoqa/sqlalchemy-utc.svg?branch=master\n :target: https://travis-ci.org/spoqa/sqlalchemy-utc\n.. image:: https://codecov.io/github/spoqa/sqlalchemy-utc/coverage.svg?branch=master\n :target: https://codecov.io/github/spoqa/sqlalchemy-utc?branch=master\n\nThis package provides a drop-in replacement of SQLAlchemy's built-in `DateTime`_\ntype with ``timezone=True`` option enabled. Although SQLAlchemy's built-in\n``DateTime`` type provides ``timezone=True`` option, since some vendors like\nSQLite and MySQL don't provide ``timestamptz`` data type, the option doesn't\nmake any effect on these vendors.\n\n``UtcDateTime`` type is equivalent to the built-in ``DateTime`` with\n``timezone=True`` option enabled on vendors that support ``timestamptz``\ne.g. PostgreSQL, but on SQLite or MySQL, it shifts all ``datetime.datetime``\nvalues to UTC offset before store them, and returns always aware\n``datetime.datetime`` values through result sets.\n\nLong story short, ``UtcDateTime`` does:\n\n- take only aware ``datetime.datetime``,\n- return only aware ``datetime.datetime``,\n- never take or return naive ``datetime.datetime``,\n- ensure timestamps in database always to be encoded in UTC, and\n- work as you'd expect.\n\nA SQLAlchemy helper function, ``utcnow()``, is provided as an alternative\nto ``func.now()`` for generating ``UtcDateTime`` values on the server. For\nexample: ``Column('time', UtcDateTime(), default=utcnow())``.\n\nWritten by `Hong Minhee`_ at Spoqa_, and distributed under MIT license.\n\n.. _DateTime: http://docs.sqlalchemy.org/en/latest/core/type_basics.html#sqlalchemy.types.DateTime\n.. _Hong Minhee: https://hongminhee.org/\n.. _Spoqa: http://www.spoqa.com/\n\n\nChangelog\n=========\n\n0.10.0\n------\n\nReleased on January 25, 2018.\n\n- Dropped support of older Python versions: 2.6, 3.2, and 3.3.\n [`#2`_ by George Leslie-Waksman]\n- Added ``sqlalchemy_utc.utcnow()`` function as an alternative to\n ``sqlalchemy.sql.functions.now()`` for generating ``UtcDateTime`` values\n on the database server. [`#4`_ by George Leslie-Waksman]\n\n.. _#2: https://github.com/spoqa/sqlalchemy-utc/pull/2\n.. _#4: https://github.com/spoqa/sqlalchemy-utc/pull/4\n\n\n0.9.0\n-----\n\nFirst version. Released on June 22, 2016.\n", "description_content_type": null, "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/spoqa/sqlalchemy-utc", "keywords": "", "license": "MIT License", "maintainer": "", "maintainer_email": "", "name": "SQLAlchemy-Utc", "package_url": "https://pypi.org/project/SQLAlchemy-Utc/", "platform": "", "project_url": "https://pypi.org/project/SQLAlchemy-Utc/", "project_urls": { "Homepage": "https://github.com/spoqa/sqlalchemy-utc" }, "release_url": "https://pypi.org/project/SQLAlchemy-Utc/0.10.0/", "requires_dist": null, "requires_python": "", "summary": "SQLAlchemy type to store aware datetime values", "version": "0.10.0" }, "last_serial": 4203578, "releases": { "0.10.0": [ { "comment_text": "", "digests": { "md5": "9f439a6f6b14ea125ed2137dee87a446", "sha256": "ec5395dfa4d237239c162a1b83283d88c8e2a94219512708634c55329c900278" }, "downloads": -1, "filename": "SQLAlchemy_Utc-0.10.0-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "9f439a6f6b14ea125ed2137dee87a446", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 6589, "upload_time": "2018-01-25T07:21:27", "url": "https://files.pythonhosted.org/packages/7e/84/85cb683933ac5c2e1d5d3d33de06e72d761c9e172dc627e2b0b73a327d1d/SQLAlchemy_Utc-0.10.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "37d76ac8a24559fc2a548cd6dd7d1fac", "sha256": "fed53af37d250168b99eba8f9908a50e34e10dab3c32d38df3e65601ac951baf" }, "downloads": -1, "filename": "SQLAlchemy-Utc-0.10.0.tar.gz", "has_sig": true, "md5_digest": "37d76ac8a24559fc2a548cd6dd7d1fac", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3854, "upload_time": "2018-01-25T07:21:23", "url": "https://files.pythonhosted.org/packages/76/0b/27d7010ff4d208a5b839388a67ba48ebaa5a4a213cc66e79b34fcdb449b5/SQLAlchemy-Utc-0.10.0.tar.gz" } ], "0.9.0": [ { "comment_text": "", "digests": { "md5": "4acdd6271da6704f190af226bea32c5b", "sha256": "a04ce6627ab914653553f8409f4b1cf1be5c8c25ab0d74bb7a4968cee655ae35" }, "downloads": -1, "filename": "SQLAlchemy_Utc-0.9.0-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "4acdd6271da6704f190af226bea32c5b", "packagetype": "bdist_wheel", "python_version": "3.5", "requires_python": null, "size": 4601, "upload_time": "2016-06-21T16:46:04", "url": "https://files.pythonhosted.org/packages/e6/dc/5783b0e51bf38b3af38379eb256e13d38d4944c5304dfd449b67e84dfbed/SQLAlchemy_Utc-0.9.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d2640d5abb0809344f26daa534b53907", "sha256": "0f41792a992facef8a000d0bcba080326dc89c21a0ba1b869b00c4bfeb9afc6d" }, "downloads": -1, "filename": "SQLAlchemy-Utc-0.9.0.tar.gz", "has_sig": true, "md5_digest": "d2640d5abb0809344f26daa534b53907", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2963, "upload_time": "2016-06-21T16:45:56", "url": "https://files.pythonhosted.org/packages/88/e1/75eaf6be52581819971fdc4cbeb30065abff1fd490c86676e69405086a89/SQLAlchemy-Utc-0.9.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "9f439a6f6b14ea125ed2137dee87a446", "sha256": "ec5395dfa4d237239c162a1b83283d88c8e2a94219512708634c55329c900278" }, "downloads": -1, "filename": "SQLAlchemy_Utc-0.10.0-py2.py3-none-any.whl", "has_sig": true, "md5_digest": "9f439a6f6b14ea125ed2137dee87a446", "packagetype": "bdist_wheel", "python_version": "3.6", "requires_python": null, "size": 6589, "upload_time": "2018-01-25T07:21:27", "url": "https://files.pythonhosted.org/packages/7e/84/85cb683933ac5c2e1d5d3d33de06e72d761c9e172dc627e2b0b73a327d1d/SQLAlchemy_Utc-0.10.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "37d76ac8a24559fc2a548cd6dd7d1fac", "sha256": "fed53af37d250168b99eba8f9908a50e34e10dab3c32d38df3e65601ac951baf" }, "downloads": -1, "filename": "SQLAlchemy-Utc-0.10.0.tar.gz", "has_sig": true, "md5_digest": "37d76ac8a24559fc2a548cd6dd7d1fac", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3854, "upload_time": "2018-01-25T07:21:23", "url": "https://files.pythonhosted.org/packages/76/0b/27d7010ff4d208a5b839388a67ba48ebaa5a4a213cc66e79b34fcdb449b5/SQLAlchemy-Utc-0.10.0.tar.gz" } ] }