|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /lib64/python2.7/site-packages/sqlalchemy/orm/ |
Upload File : |
�
���\c @ s� d Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m
Z
d d
l m Z d d l m
Z
d d l m Z d d
l m Z d d l m Z d e f d � � YZ e j j d d e �d e f d � � Y� Z e j j d d e �d e f d � � Y� Z e j j d d e �d e f d � � Y� Z e j j d d e �e j d d � d e f d � � Y� � Z d S( s� Descriptor properties are more "auxiliary" properties
that exist as configurational elements, but don't participate
as actively in the load/persist ORM loop.
i ( t
attributes( t
properties( t query( t MapperProperty( t PropComparator( t _none_seti ( t event( t exc( t schema( t sql( t util( t
expressiont DescriptorPropertyc B s e Z d Z d Z d � Z RS( sS :class:`.MapperProperty` which proxies access to a
user-defined descriptor.c s; � � d t f � � f d � � Y} � j d k rj t � j � j d � } � j | � rj | � _ qj n � j d k r� � f d � } � f d � } � f d � } t d | d | d | � � _ n t j � j � � j
j � j � j � � f d � d
� j d � �} | � j � | _ � j
j � j | � d S( Nt
_ProxyImplc sb e Z e Z e Z e Z e � � f d � � Z d � Z e
� d � r` e j � f d � Z
n RS( c s t � j � j � j j S( N( t getattrt class_t namet implt uses_objects( t self( t mappert prop( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR * s c S s
| | _ d S( N( t key( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __init__. s t get_historyc s � j | | | � S( N( R ( R t statet dict_t passive( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR 3 s ( t __name__t
__module__t Falset accepts_scalar_loadert Truet expire_missingt
collectiont propertyR R t hasattrR t PASSIVE_OFFR ( ( R R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR
% s c s t | � j | � d S( N( t setattrR ( t objt value( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt fset? s c s t | � j � d S( N( t delattrR ( R' ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt fdelB s c s t | � j � S( N( R R ( R' ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt fgetE s R, R) R+ c s
� j � � S( N( t _comparator_factory( ( R R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt <lambda>N s t doct original_property( t objectt
descriptort NoneR R R t _is_userland_descriptorR# R t create_proxied_attributet parentR/ R t
class_managert instrument_attribute( R R R
t descR) R+ R, t
proxy_attr( ( R R R sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt instrument_class" s( ! N( R R t __doc__R3 R/ R; ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR s s sqlalchemy.orm.propertiest
add_to_allt CompositePropertyc B s� e Z d Z e j d d � d � � Z d � Z d � Z d � Z e j d � � Z
e j d � � Z e d
� � Z
d � Z d � Z e j d
� � Z e j d � Z d � Z d e j f d � � YZ d e f d � � YZ d � Z RS( s� Defines a "composite" mapped attribute, representing a collection
of columns as one attribute.
:class:`.CompositeProperty` is constructed using the :func:`.composite`
function.
.. seealso::
:ref:`mapper_composite`
t extensions 0.7s� :class:`.AttributeExtension` is deprecated in favor of the :class:`.AttributeEvents` listener interface. The :paramref:`.composite.extension` parameter will be removed in a future release.c O s� t t | � j � | | _ | | _ | j d t � | _ | j d t � | _ | j d d � | _
| j d | j j
� | _ d | k r� | j d � | _ n t j | � | j � d S( sQ Return a composite column-based property for use with a Mapper.
See the mapping documentation section :ref:`mapper_composite` for a
full usage example.
The :class:`.MapperProperty` returned by :func:`.composite`
is the :class:`.CompositeProperty`.
:param class\_:
The "composite type" class, or any classmethod or callable which
will produce a new instance of the composite object given the
column values in order.
:param \*cols:
List of Column objects to be mapped.
:param active_history=False:
When ``True``, indicates that the "previous" value for a
scalar attribute should be loaded when replaced, if not
already loaded. See the same flag on :func:`.column_property`.
:param group:
A group name for this property when marked as deferred.
:param deferred:
When True, the column property is "deferred", meaning that it does
not load immediately, and is instead loaded when the attribute is
first accessed on an instance. See also
:func:`~sqlalchemy.orm.deferred`.
:param comparator_factory: a class which extends
:class:`.CompositeProperty.Comparator` which provides custom SQL
clause generation for comparison operations.
:param doc:
optional string that will be applied as the doc on the
class-bound descriptor.
:param info: Optional data dictionary which will be populated into the
:attr:`.MapperProperty.info` attribute of this object.
:param extension:
an :class:`.AttributeExtension` instance,
or list of extensions, which will be prepended to the list of
attribute listeners for the resulting descriptor placed on the
class.
t active_historyt deferredt groupt comparator_factoryt infoN( t superR> R t attrst composite_classt getR R@ RA R3 RB t popt __class__t
ComparatorRC RD R
t set_creation_ordert _create_descriptor( R R RF t kwargs( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR d s :
c C s$ t t | � j | � | j � d S( N( RE R> R; t _setup_event_handlers( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR; � s c C s | j � d S( s Initialization which occurs after the :class:`.CompositeProperty`
has been associated with its parent mapper.
N( t _setup_arguments_on_columns( R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt do_init� s c sF � f d � } � f d � } � f d � } t | | | � � _ d S( st Create the Python descriptor that will serve as
the access point on instances of the mapped class.
c s� t j | � } t j | � } � j | k r� g � j D] } t | | � ^ q7 } � j | k r� | j d k s� t j | � r� � j | � | � j <| j
j j | d � j g � q� n | j
� j d � S( N( R t
instance_dictt instance_stateR t _attribute_keysR R3 R t
issupersetRG t managert dispatcht refreshRH ( t instanceR R R t values( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR, � s % %c s� t j | � } t j | � } | j � j } | j � j t j � } x, | j j D] } | | | | | j � } qS W| | � j <| d k r� x] � j D] } t | | d � q� Wn9 x6 t
� j | j � � D] \ } } t | | | � q� Wd S( N( R RR RS RV R RH t NO_VALUERW t setR R3 RT R& t zipt __composite_values__( RY R( R R t attrt previoust fnR ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR) � s
c s� t j | � } t j | � } | j � j t j � } | j � j } | j j | | | j � x! � j
D] } t | | d � qi Wd S( N(
R RS RR RI R R[ RV RW t removeR RT R& R3 ( RY R R R` R_ R ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR+ � s N( R# R2 ( R R, R) R+ ( ( R sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRM � s c C s, g | j D] } t | j j | j � ^ q
S( N( t propsR R6 R R ( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt _comparable_elements� s c C s� g } x� | j D]� } t | t � r@ | j j | d t �} nY t | t j � re | j j | } n4 t | t j
� r� | j } n t j
d | f � � | j | � q W| S( Nt _configure_mapperss[ Composite expects Column objects or mapped attributes/attribute names as arguments, got: %r( RF t
isinstancet strR6 t get_propertyR R t Columnt _columntopropertyR t InstrumentedAttributeR# t sa_exct
ArgumentErrort append( R Rc R_ R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRc � s
c C s, g | j D] } t | t j � r
| ^ q
S( N( RF Rf R Ri ( R t a( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt columns s c C sc x\ | j D]Q } | j | _ | j rO | j | _ d t f d t f f | _ n | j | _ q
Wd S( sw Propagate configuration arguments made on this composite
to the target columns, for those that apply.
RA t
instrumentN( Rc R@ RA R t strategy_keyRB ( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRP s c s� � f d � } � f d � } � f d � � � f d � } � f d � } t j � j d | d t �t j � j d | d t �t j � j d | d t d
t �t j � j d | d t d
t �t j � j d | d t d
t �d
S( s> Establish events that populate/expire the composite attribute.c s � | | d t �d S( Nt
is_refresh( R ( R t args( t _load_refresh_handler( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt load_handler s c s � | | d t �d S( NRs ( R ( R Rt ( Ru ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt refresh_handler! s c s~ | j } | r# � j | k r# d Sx! � j D] } | | k r- d Sq- W� j g � j D] } | j | ^ qW � | � j <d S( N( t dictR RT RG ( R Rt Rs R t kR ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRu $ s c sA | d k s$ t � j � j | � r= | j j � j d � n d S( N( R3 R\ RT t intersectionRx RI R ( R t keys( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt expire_handler5 s $c s | j j � j d � d S( s� After an insert or update, some columns may be expired due
to server side defaults, or re-populated due to client side
defaults. Pop out the composite value here so that it
recreates.
N( Rx RI R R3 ( R t
connectionR ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt insert_update_handler9 s t after_insertt rawt after_updatet loadt propagateRX t expireN( R t listenR6 R ( R Rv Rw R| R~ ( ( Ru R sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRO s
c C s g | j D] } | j ^ q
S( N( Rc R ( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRT U s c C s g } g } t } x� | j D]� } | j } | j | j j | | � } | j � r\ t } n | j � }
|
r~ | j |
� n
| j
d � | j r� | j | j � q | j
d � q W| r� t
j | j | � g d | j | � g � St
j d | j | � g d � Sd S( s> Provided for userland code that uses attributes.get_history().N( ( ( ( R Rc R RV R R t has_changesR t non_deletedt extendRn R3 t deletedR t HistoryRG ( R R R R t addedR� t has_historyR R t histR� ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR Y s*
c C s | j | | � S( N( RC ( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR- y s t CompositeBundlec B s e Z d � Z d � Z RS( c C s, | | _ t t j | � j | j | � d S( N( R# RE R> R� R R ( R t property_t expr( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR } s c s � � f d � } | S( Nc s) � j j g � D] } | | � ^ q � S( N( R# RG ( t rowt proc( t procsR ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� � s ( ( R R R� t labelsR� ( ( R� R sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt create_row_processor� s ( R R R R� ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� | s RK c B sb e Z d Z d Z e d � � Z d � Z d � Z d � Z e
j d � � Z d � Z
d � Z RS( s� Produce boolean, comparison, and other operators for
:class:`.CompositeProperty` attributes.
See the example in :ref:`composite_operations` for an overview
of usage , as well as the documentation for :class:`.PropComparator`.
.. seealso::
:class:`.PropComparator`
:class:`.ColumnOperators`
:ref:`types_operators`
:attr:`.TypeEngine.comparator_factory`
c C s
| j � S( N( t __clause_element__( R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt clauses� s c C s t j d t | j � S( NRB ( R t
ClauseListR Rd ( R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� � s c C s t j | j | j � � S( N( R> R� R R� ( R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt _query_clause_element� s c C s~ | d k r. g | j j D] } d ^ q } n@ t | | j j � rR | j � } n t j d | j | f � � t | j | � S( Ns) Can't UPDATE composite attribute %s to %r(
R3 R RT Rf RG R^ Rl Rm R] Rd ( R R( R RZ ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt _bulk_update_tuples� s "c C sF | j r8 g | j j D] } t | j j | j � ^ q S| j j Sd S( N( t _adapt_to_entityR Rd R t entityR ( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRd � s ,c C s� | d k r( d g t | j j � } n | j � } g t | j j | � D] \ } } | | k ^ qJ } | j r� g | D] } | j | � ^ qx } n t j | � S( N(
R3 t lenR Rd R^ R] R� t adapterR t and_( R t otherRZ Ro t bt comparisonst x( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __eq__� s 4 %c C s t j | j | � � S( N( R t not_R� ( R R� ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __ne__� s N( R R R< R3 t __hash__R# R� R� R� R� R
t memoized_propertyRd R� R� ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRK � s
c C s t | j j j � d | j S( Nt .( Rg R6 R R R ( R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __str__� s ( s 0.7s� :class:`.AttributeExtension` is deprecated in favor of the :class:`.AttributeEvents` listener interface. The :paramref:`.composite.extension` parameter will be removed in a future release.( R R R< R
t deprecated_paramsR R; RQ RM R� Rd Rc R# Rp RP RO RT R R% R R- R t BundleR� R RK R� ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR> V s$ G ; : It ConcreteInheritedPropertyc B s e Z d Z d � Z d � Z RS( s4 A 'do nothing' :class:`.MapperProperty` that disables
an attribute on a concrete subclass that is only present
on the inherited mapper, not the concrete classes' mapper.
Cases where this occurs include:
* When the superclass mapper is mapped against a
"polymorphic union", which includes all attributes from
all subclasses.
* When a relationship() is configured on an inherited mapper,
but not on the subclass mapper. Concrete mappers require
that relationship() is configured explicitly on each
subclass.
c C sP d } xC | j j � D]2 } | j | j } t | t � s | j } Pq q W| S( N( R3 R6 t iterate_to_roott _propsR Rf R� RC ( R R t comparator_callablet mt p( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR- � s c sQ t t � � j � � f d � � d t f � � f d � � Y} | � � _ d S( Nc s& t d � j � j � j f � � d S( Nsg Concrete %s does not implement attribute %r at the instance level. Add this property explicitly to %s.( t AttributeErrorR6 R ( ( R ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt warn� s t NoninheritedConcretePropc s8 e Z � f d � Z � f d � Z � � f d � Z RS( c s � � d S( N( ( t sR' R( ( R� ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __set__ s c s � � d S( N( ( R� R' ( R� ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt
__delete__ s c s | d k r � j S� � d S( N( R3 R2 ( R� R' t owner( R R� ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __get__ s ( R R R� R� R� ( ( R R� ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� � s ( RE R� R R1 R2 ( R R� ( ( R R� sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR � s ( R R R< R- R ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� � s
t SynonymPropertyc B sM e Z d d d d d d � Z e j d � � Z d � Z d � Z d � Z RS( c C sx t t | � j � | | _ | | _ | | _ | | _ | pO | rL | j pO d | _ | rg | | _
n t j | � d S( s} Denote an attribute name as a synonym to a mapped property,
in that the attribute will mirror the value and expression behavior
of another attribute.
e.g.::
class MyClass(Base):
__tablename__ = 'my_table'
id = Column(Integer, primary_key=True)
job_status = Column(String(50))
status = synonym("job_status")
:param name: the name of the existing mapped property. This
can refer to the string name ORM-mapped attribute
configured on the class, including column-bound attributes
and relationships.
:param descriptor: a Python :term:`descriptor` that will be used
as a getter (and potentially a setter) when this attribute is
accessed at the instance level.
:param map_column: **For classical mappings and mappings against
an existing Table object only**. if ``True``, the :func:`.synonym`
construct will locate the :class:`.Column` object upon the mapped
table that would normally be associated with the attribute name of
this synonym, and produce a new :class:`.ColumnProperty` that instead
maps this :class:`.Column` to the alternate name given as the "name"
argument of the synonym; in this way, the usual step of redefining
the mapping of the :class:`.Column` to be under a different name is
unnecessary. This is usually intended to be used when a
:class:`.Column` is to be replaced with an attribute that also uses a
descriptor, that is, in conjunction with the
:paramref:`.synonym.descriptor` parameter::
my_table = Table(
"my_table", metadata,
Column('id', Integer, primary_key=True),
Column('job_status', String(50))
)
class MyClass(object):
@property
def _job_status_descriptor(self):
return "Status: %s" % self._job_status
mapper(
MyClass, my_table, properties={
"job_status": synonym(
"_job_status", map_column=True,
descriptor=MyClass._job_status_descriptor)
}
)
Above, the attribute named ``_job_status`` is automatically
mapped to the ``job_status`` column::
>>> j1 = MyClass()
>>> j1._job_status = "employed"
>>> j1.job_status
Status: employed
When using Declarative, in order to provide a descriptor in
conjunction with a synonym, use the
:func:`sqlalchemy.ext.declarative.synonym_for` helper. However,
note that the :ref:`hybrid properties <mapper_hybrids>` feature
should usually be preferred, particularly when redefining attribute
behavior.
:param info: Optional data dictionary which will be populated into the
:attr:`.InspectionAttr.info` attribute of this object.
.. versionadded:: 1.0.0
:param comparator_factory: A subclass of :class:`.PropComparator`
that will provide custom comparison behavior at the SQL expression
level.
.. note::
For the use case of providing an attribute which redefines both
Python-level and SQL-expression level behavior of an attribute,
please refer to the Hybrid attribute introduced at
:ref:`mapper_hybrids` for a more effective technique.
.. seealso::
:ref:`synonyms` - Overview of synonyms
:func:`.synonym_for` - a helper oriented towards Declarative
:ref:`mapper_hybrids` - The Hybrid Attribute extension provides an
updated approach to augmenting attribute behavior more flexibly
than can be achieved with synonyms.
N(
RE R� R R t
map_columnR2 RC R< R3 R/ RD R
RL ( R R R� R2 RC R/ RD ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR s l c C sm t | j j | j � } t | d � s; t | j t � rf t j d | j j j
| j | f � � n | j S( NR# sG synonym() attribute "%s.%s" only supports ORM mapped attributes, got %r( R R6 R R R$ Rf R# R Rl t InvalidRequestErrorR ( R R_ ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt _proxied_property� s "c C s= | j } | j r' | j | | � } n | j | | � } | S( N( R� RC ( R R R t comp( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR- � s
c O s+ t | j j | j � } | j j | | � S( N( R R6 R R R R ( R t argt kwR_ ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR � s c C s | j r| j | j j k rI t j d | j | j j | j f � � np | j j | j | j k r� | j | j j | j j | j k r� t j d | j | j | j | j f � � n t j
| j j | j � } | j | j | d | d t �| j | _
n | | _ d S( Ns> Can't compile synonym '%s': no column on table '%s' named '%s'sp Can't call map_column=True for synonym %r=%r, a ColumnProperty already exists keyed to the name %r for column %rt initt setparent( R� R t persist_selectablet cRl Rm R t descriptionRj R t ColumnPropertyt _configure_propertyR t _mapped_by_synonymR6 ( R R6 R� R� ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt
set_parent� s( % N(
R R R3 R R
R� R� R- R R� ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� s t
s 0.7s� :func:`.comparable_property` is deprecated and will be removed in a future release. Please refer to the :mod:`~sqlalchemy.ext.hybrid` extension.t ComparablePropertyc B s) e Z d Z d d d d � Z d � Z RS( s; Instruments a Python property for use in query expressions.c C sf t t | � j � | | _ | | _ | p= | r: | j p= d | _ | rU | | _ n t j
| � d S( s� Provides a method of applying a :class:`.PropComparator`
to any Python descriptor attribute.
Allows any Python descriptor to behave like a SQL-enabled
attribute when used at the class level in queries, allowing
redefinition of expression operator behavior.
In the example below we redefine :meth:`.PropComparator.operate`
to wrap both sides of an expression in ``func.lower()`` to produce
case-insensitive comparison::
from sqlalchemy.orm import comparable_property
from sqlalchemy.orm.interfaces import PropComparator
from sqlalchemy.sql import func
from sqlalchemy import Integer, String, Column
from sqlalchemy.ext.declarative import declarative_base
class CaseInsensitiveComparator(PropComparator):
def __clause_element__(self):
return self.prop
def operate(self, op, other):
return op(
func.lower(self.__clause_element__()),
func.lower(other)
)
Base = declarative_base()
class SearchWord(Base):
__tablename__ = 'search_word'
id = Column(Integer, primary_key=True)
word = Column(String)
word_insensitive = comparable_property(lambda prop, mapper:
CaseInsensitiveComparator(
mapper.c.word, mapper)
)
A mapping like the above allows the ``word_insensitive`` attribute
to render an expression like::
>>> print SearchWord.word_insensitive == "Trucks"
lower(search_word.word) = lower(:lower_1)
:param comparator_factory:
A PropComparator subclass or factory that defines operator behavior
for this property.
:param descriptor:
Optional when used in a ``properties={}`` declaration. The Python
descriptor or property to layer comparison behavior on top of.
The like-named descriptor will be automatically retrieved from the
mapped class if left blank in a ``properties`` declaration.
:param info: Optional data dictionary which will be populated into the
:attr:`.InspectionAttr.info` attribute of this object.
.. versionadded:: 1.0.0
N( RE R� R R2 RC R< R3 R/ RD R
RL ( R RC R2 R/ RD ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR � s B c C s | j | | � S( N( RC ( R R ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR- s N( R R R< R3 R R- ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR� � s IN( R< t R R R t
interfacesR R R
R R R Rl R R R R t langhelperst dependency_forR R> R� R� t deprecated_clsR� ( ( ( sE /usr/lib64/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt <module> s2 :� �5�