/usr/lib/python3/dist-packages/sqlalchemy_utils/types/arrow.py is in python3-sqlalchemy-utils 0.32.21-1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 | from __future__ import absolute_import
from collections import Iterable
from datetime import datetime
import six
from sqlalchemy import types
from ..exceptions import ImproperlyConfigured
from .scalar_coercible import ScalarCoercible
arrow = None
try:
import arrow
except ImportError:
pass
class ArrowType(types.TypeDecorator, ScalarCoercible):
"""
ArrowType provides way of saving Arrow_ objects into database. It
automatically changes Arrow_ objects to datetime objects on the way in and
datetime objects back to Arrow_ objects on the way out (when querying
database). ArrowType needs Arrow_ library installed.
.. _Arrow: http://crsmithdev.com/arrow/
::
from datetime import datetime
from sqlalchemy_utils import ArrowType
import arrow
class Article(Base):
__tablename__ = 'article'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.Unicode(255))
created_at = sa.Column(ArrowType)
article = Article(created_at=arrow.utcnow())
As you may expect all the arrow goodies come available:
::
article.created_at = article.created_at.replace(hours=-1)
article.created_at.humanize()
# 'an hour ago'
"""
impl = types.DateTime
def __init__(self, *args, **kwargs):
if not arrow:
raise ImproperlyConfigured(
"'arrow' package is required to use 'ArrowType'"
)
super(ArrowType, self).__init__(*args, **kwargs)
def process_bind_param(self, value, dialect):
if value:
utc_val = self._coerce(value).to('UTC')
return utc_val.datetime if self.impl.timezone else utc_val.naive
return value
def process_result_value(self, value, dialect):
if value:
return arrow.get(value)
return value
def process_literal_param(self, value, dialect):
return str(value)
def _coerce(self, value):
if value is None:
return None
elif isinstance(value, six.string_types):
value = arrow.get(value)
elif isinstance(value, Iterable):
value = arrow.get(*value)
elif isinstance(value, datetime):
value = arrow.get(value)
return value
@property
def python_type(self):
return self.impl.type.python_type
|