Source code for sqlalchemy_utils.types.locale

from sqlalchemy import types

from ..exceptions import ImproperlyConfigured
from .scalar_coercible import ScalarCoercible

babel = None
    import babel
except ImportError:

[docs]class LocaleType(ScalarCoercible, types.TypeDecorator): """ LocaleType saves Babel_ Locale objects into database. The Locale objects are converted to string on the way in and back to object on the way out. In order to use LocaleType you need to install Babel_ first. .. _Babel: :: from sqlalchemy_utils import LocaleType from babel import Locale class User(Base): __tablename__ = 'user' id = sa.Column(sa.Integer, autoincrement=True) name = sa.Column(sa.Unicode(50)) locale = sa.Column(LocaleType) user = User() user.locale = Locale('en_US') session.add(user) session.commit() Like many other types this type also supports scalar coercion: :: user.locale = 'de_DE' user.locale # Locale('de', territory='DE') """ impl = types.Unicode(10) cache_ok = True def __init__(self): if babel is None: raise ImproperlyConfigured( 'Babel packaged is required with LocaleType.' ) def process_bind_param(self, value, dialect): if isinstance(value, babel.Locale): return str(value) if isinstance(value, str): return value def process_result_value(self, value, dialect): if value is not None: return babel.Locale.parse(value) def _coerce(self, value): if value is not None and not isinstance(value, babel.Locale): return babel.Locale.parse(value) return value