ó H`¾Tc@sNdZddlmZmZddlmZddlmZddlmZmZm Z m Z m Z ddlm Z ddlmZdd lmZd efd „ƒYZejjd ƒd efd„ƒYƒZejjd ƒdefd„ƒYƒZejjd ƒdefd„ƒYƒZejjd ƒdefd„ƒYƒZdS(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(tMapperPropertytPropComparator(t _none_set(t attributesi(tutiltsqltexcteventtschema(t expression(t properties(tquerytDescriptorPropertycBseZdZdZd„ZRS(sS:class:`.MapperProperty` which proxies access to a user-defined descriptor.c s8ˆ‰dtf‡fd†ƒY}ˆjdkrgtˆjˆjdƒ}ˆj|ƒrg|ˆ_qgnˆjdkrćfd†}‡fd†}‡fd†}td|d|d|ƒˆ_ntj ˆjƒˆj jˆjˆj‡‡fd †d ˆj d ˆƒ}|ˆjƒ|_ ˆj jˆj|ƒdS( Nt _ProxyImplcsJeZeZeZeZd„ZeˆdƒrHe j ‡fd†Z nRS(cSs ||_dS(N(tkey(tselfR((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt__init__%st get_historycsˆj|||ƒS(N(R(Rtstatetdict_tpassive(tprop(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR)s( t__name__t __module__tFalsetaccepts_scalar_loadertTruetexpire_missingt collectionRthasattrRt PASSIVE_OFFR((R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR s  cst|ˆj|ƒdS(N(tsetattrtname(tobjtvalue(R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytfset3scst|ˆjƒdS(N(tdelattrR (R!(R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytfdel6scst|ˆjƒS(N(tgetattrR (R!(R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytfget9sR'R#R%cs ˆjˆƒS(N(t_comparator_factory((tmapperR(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytGstdoctoriginal_property(tobjectt descriptortNoneR&tclass_Rt_is_userland_descriptortpropertyRtcreate_proxied_attributetparentR+timplt class_managertinstrument_attribute(RR)R tdescR#R%R't proxy_attr((R)RRse/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytinstrument_classs0     N(RRt__doc__R/R+R:(((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR sssqlalchemy.orm.propertiestCompositePropertycBsÙeZdZd„Zd„Zd„Zd„Zejd„ƒZ ejd„ƒZ e d„ƒZ d„Z d „Zejd „ƒZejd „Zd „Zd ejfd„ƒYZdefd„ƒYZd„ZRS(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` cOs¨||_||_|jdtƒ|_|jdtƒ|_|jddƒ|_|jd|j j ƒ|_ d|kr|jdƒ|_ nt j|ƒ|jƒdS(s©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. :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`. .. versionchanged:: 0.7 This flag specifically becomes meaningful - previously it was a placeholder. :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. .. versionadded:: 0.8 :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. **Deprecated.** Please see :class:`.AttributeEvents`. tactive_historytdeferredtgrouptcomparator_factorytinfoN(tattrstcomposite_classtgetRR=R>R/R?tpopt __class__t ComparatorR@RARtset_creation_ordert_create_descriptor(RR0RBtkwargs((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR]s6     cCs$tt|ƒj|ƒ|jƒdS(N(tsuperR<R:t_setup_event_handlers(RR)((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR: scCs|jƒdS(sInitialization which occurs after the :class:`.CompositeProperty` has been associated with its parent mapper. N(t_setup_arguments_on_columns(R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytdo_init¤scsF‡fd†}‡fd†}‡fd†}t|||ƒˆ_dS(stCreate the Python descriptor that will serve as the access point on instances of the mapped class. csÎtj|ƒ}tj|ƒ}ˆj|kr»gˆjD]}t||ƒ^q7}ˆj|kr»|jdk s€tj|ƒ r»ˆj |Œ|ˆj<|j j j |dˆjgƒq»n|j ˆjdƒS(N(Rt instance_dicttinstance_stateRt_attribute_keysR&R/Rt issupersetRCtmanagertdispatchtrefreshRD(tinstanceRRRtvalues(R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR'±s"%csòtj|ƒ}tj|ƒ}|jˆj}|jˆjtjƒ}x,|jjD]}|||||j ƒ}qSW||ˆj<|dkrµx]ˆj D]}t ||dƒq˜Wn9x6t ˆj |jƒƒD]\}}t |||ƒqÎWdS(N(RRORPRSRRDtNO_VALUERTtsetR5R/RQRtzipt__composite_values__(RVR"RRtattrtprevioustfnR(R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR#Ìs  cs‡tj|ƒ}tj|ƒ}|jˆjtjƒ}|jˆj}|jj|||j ƒx!ˆj D]}t ||dƒqiWdS(N( RRPRORERRXRSRTtremoveR5RQRR/(RVRRR]R\R(R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR%ÝsN(R2R.(RR'R#R%((Rse/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRI«s cCs,g|jD]}t|jj|jƒ^q S(N(tpropsR&R4R0R(RR((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt_comparable_elementsèscCs®g}x¡|jD]–}t|tƒr@|jj|dtƒ}nYt|tjƒre|jj|}n4t|t j ƒrƒ|j }nt j d|fƒ‚|j|ƒqW|S(Nt_configure_mapperss[Composite expects Column objects or mapped attributes/attribute names as arguments, got: %r(RBt isinstancetstrR4t get_propertyRRtColumnt_columntopropertyRtInstrumentedAttributeR2tsa_exct ArgumentErrortappend(RR`R\R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR`ïs   cCs,g|jD]}t|tjƒr |^q S(N(RBRcRRf(Rta((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytcolumnsscCsixb|jD]W}|j|_|jrU|j|_|jdtfdtfƒ|_n|j|_q WdS(swPropagate configuration arguments made on this composite to the target columns, for those that apply. R>t instrumentN(R`R=R>t_strategy_lookupRtstrategy_classR?(RR((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRMs    csχfd†}‡fd†}‡fd†}tjˆjd|dtƒtjˆjd|dtƒtjˆjd|dtdtƒtjˆjd |dtdtƒtjˆjd |dtdtƒd S( s>Establish events that populate/expire the composite attribute.csw|j}ˆj|krdSx!ˆjD]}||kr&dSq&WˆjgˆjD]}|j|^qPŒ|ˆjProvided for userland code that uses attributes.get_history().N((((RR`RRSR5Rt has_changesRt non_deletedtextendRkR/tdeletedRtHistoryRC( RRRRtaddedR„t has_historyRRthistR‚((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRKs,      cCs|j||ƒS(N(R@(RR)((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR(mstCompositeBundlecBseZd„Zd„ZRS(cCs,||_ttj|ƒj|j|ŒdS(N(R2RKR<R‰RR(RR2texpr((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRqs cs‡‡fd†}|S(Ncs,ˆjjgˆD]}|||ƒ^qŒS(N(R2RC(trowtresulttproc(Rtprocs(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRws ((RR RŽtlabelsR((RRŽse/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytcreate_row_processorvs(RRRR(((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR‰ps RGcBsYeZdZdZed„ƒZd„Zd„Ze 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`. See also: :class:`.PropComparator` :class:`.ColumnOperators` :ref:`types_operators` :attr:`.TypeEngine.comparator_factory` cCs |jƒS(N(t__clause_element__(R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytclauses‘scCstjdt|jŒS(NR?(R t ClauseListRRa(R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR‘•s cCstj|j|jƒƒS(N(R<R‰RR‘(R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt_query_clause_element™scCsF|jr8g|jjD]}t|jj|jƒ^qS|jjSdS(N(t_adapt_to_entityRRaR&tentityR(RR((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRas ,cCs£|dkr(dgt|jjƒ}n |jƒ}gt|jj|ƒD]\}}||k^qJ}|jr–g|D]}|j|ƒ^qx}ntj |ŒS(N( R/tlenRRaR[RZR•tadapterRtand_(RtotherRWRltbt comparisonstx((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt__eq__©s  1 %cCstj|j|ƒƒS(N(Rtnot_Rž(RRš((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt__ne__¶sN(RRR;R/t__hash__R2R’R‘R”Rtmemoized_propertyRaRžR (((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRG|s   cCst|jjjƒd|jS(Nt.(RdR4R0RR(R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt__str__¹s(RRR;RR:RNRIRR¢RaR`R2RmRMRLRQRRRR(R tBundleR‰RRGR¤(((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR<Os   C   =  1"  =tConcreteInheritedPropertycBs eZdZd„Zd„ZRS(s4A '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. cCsPd}xC|jjƒD]2}|j|j}t|tƒs|j}PqqW|S(N(R/R4titerate_to_roott_propsRRcR¦R@(RR)tcomparator_callabletmtp((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR(Ïs cs>‡fd†‰dtf‡‡fd†ƒY}|ƒˆ_dS(Ncs&tdˆjˆjˆjfƒ‚dS(NsgConcrete %s does not implement attribute %r at the instance level. Add this property explicitly to %s.(tAttributeErrorR4R((R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pytwarnÚstNoninheritedConcretePropcs8eZ‡fd†Z‡fd†Z‡‡fd†ZRS(cs ˆƒdS(N((tsR!R"(R­(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt__set__áscs ˆƒdS(N((R¯R!(R­(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt __delete__äscs|dkrˆjSˆƒdS(N(R/R.(R¯R!towner(RR­(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt__get__çs (RRR°R±R³((R­R(se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR®às(R-R.(RR®((R­Rse/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRÙs (RRR;R(R(((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR¦½s tSynonymPropertycBsAeZddddd„Zejd„ƒZd„Zd„ZRS(cCsS||_||_||_||_|p<|r9|jp<d|_tj|ƒdS(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. :param name: the name of the existing mapped property. This can refer to the string name of any :class:`.MapperProperty` 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: if ``True``, the :func:`.synonym` construct will locate the existing named :class:`.MapperProperty` based on the attribute name of this :func:`.synonym`, and assign it to a new attribute linked to the name of this :func:`.synonym`. That is, given a mapping like:: class MyClass(Base): __tablename__ = 'my_table' id = Column(Integer, primary_key=True) job_status = Column(String(50)) job_status = synonym("_job_status", map_column=True) The above class ``MyClass`` will now have the ``job_status`` :class:`.Column` object mapped to the attribute named ``_job_status``, and the attribute named ``job_status`` will refer to the synonym itself. This feature is typically used in conjunction with the ``descriptor`` argument in order to link a user-defined descriptor as a "wrapper" for an existing column. :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` - examples of functionality. :ref:`mapper_hybrids` - Hybrids provide a better approach for more complicated attribute-wrapping schemes than synonyms. N( R t map_columnR.R@R;R/R+RRH(RR RµR.R@R+((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRñs 9    cCst|jj|jƒjS(N(R&R4R0R R2(R((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt_proxied_property5scCs=|j}|jr'|j||ƒ}n|j||ƒ}|S(N(R¶R@(RR)Rtcomp((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR(9s   cCs|jr|j|jjkrItjd|j|jj|jfƒ‚np|jj|j|jkr¹|j|jj|jj|jkr¹tjd|j|j|j|jfƒ‚nt j |jj|jƒ}|j |j|d|dt ƒ|j|_ n||_dS(Ns>Can't compile synonym '%s': no column on table '%s' named '%s'spCan't call map_column=True for synonym %r=%r, a ColumnProperty already exists keyed to the name %r for column %rtinitt setparent(RµRt mapped_tabletcRiRjR t descriptionRgR tColumnPropertyt_configure_propertyRt_mapped_by_synonymR4(RR4R¸R«((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt set_parentBs( "  % N( RRR/RRR¢R¶R(RÀ(((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR´îs  B tComparablePropertycBs&eZdZddd„Zd„ZRS(s;Instruments a Python property for use in query expressions.cCsA||_||_|p*|r'|jp*d|_tj|ƒdS(s· Provides a method of applying a :class:`.PropComparator` to any Python descriptor attribute. .. versionchanged:: 0.7 :func:`.comparable_property` is superseded by the :mod:`~sqlalchemy.ext.hybrid` extension. See the example at :ref:`hybrid_custom_comparators`. 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. N(R.R@R;R/R+RRH(RR@R.R+((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRcs?  cCs|j||ƒS(N(R@(RR)((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyR(§sN(RRR;R/RR((((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyRÁ_sDN(R;t interfacesRRRRtRRRRiRRR R R R t langhelperstdependency_forR<R¦R´RÁ(((se/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/orm/descriptor_props.pyt s"(8ÿn0p