ó H`¾Tc@sëdZddlmZmZddlmZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZmZmZmZmZmZmZmZddlmZmZmZmZdejfd „ƒYZd S( s5Default implementation of SQL comparison operations. i(texctutili(t operators(ttype_api(t BindParametertTrue_tFalse_tBinaryExpressiontNullt _const_exprt_clause_element_as_exprt ClauseListt ColumnElementt TextClausetUnaryExpressiontcollatet _is_literalt_literal_as_textt ClauseElementtand_tor_(t SelectBasetAliast Selectablet ScalarSelectt_DefaultColumnComparatorcBsæeZdZejd„ƒZd„Zd„Zd„Zd;e ej e fd„Z e d;d„Zd„Zd„Zd „Zd „Zd „Zd „Zd „Zd„Zd„Zd„Zi)efd6efd6efd6efd6efd6efd6efd6efd6efd6efd6efd6e ejfd6e ejfd6e ejfd6e ejfd6e ejfd 6e ejfd!6e ej fd"6e ej!fd#6e ej"fd$6e ej#fd%6e ej$fd&6e ej%fd'6e ej&fd(6ee'j(fd)6ee'j)fd*6ee'j*fd+6ee'j+fd,6eej,fd-6eej-fd.6e ej.fd/6e ej/fd06efd16efd26efd36efd46efd56efd66efd76efd86efd96Zd:„Z0RS(<sDefines comparison and math operations. See :class:`.ColumnOperators` and :class:`.Operators` for descriptions of all operations. cCs |jjS(N(texprttype(tself((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyRscOs5|j|j}|d||j|||d|ŽS(Nii(Rt__name__R(Rtoptothertkwargsto((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pytoperate!sc Ks:|j|j}|d||j||dt|d|ŽS(Nitreversei(RRRtTrue(RRRR R!((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pytreverse_operate%scCs ||jfS(sðevaluate the return type of , and apply any adaptations to the given operator. This method determines the type of a resulting binary expression given two source types and an operator. For example, two :class:`.Column` objects, both of the type :class:`.Integer`, will produce a :class:`.BinaryExpression` that also has the type :class:`.Integer` when compared via the addition (``+``) operator. However, using the addition operator with an :class:`.Integer` and a :class:`.Date` object will produce a :class:`.Date`, assuming "days delta" behavior by the database (in reality, most databases other than Postgresql don't accept this particular operation). The method returns a tuple of the form , . The resulting operator and type will be those applied to the resulting :class:`.BinaryExpression` as the final operator and the right-hand side of the expression. Note that only a subset of operators make usage of :meth:`._adapt_expression`, including math operators and user-defined operators, but not boolean comparison or special SQL keywords like MATCH or BETWEEN. (R(RRtother_comparator((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_adapt_expression*sc Ksft||tttfƒrý|tjtjfkrwt|tttfƒrwt|t |ƒ|dt j d|d|ƒS|tjtj fkr±t|t |ƒtj dtjƒS|tjtjfkrët|t |ƒtjdtj ƒStjdƒ‚n|j|||ƒ}|r=t|||dt j d|d|ƒSt|||dt j d|d|ƒSdS(Nttype_tnegatet modifierssMOnly '=', '!=', 'is_()', 'isnot()' operators can be used with None/True/False(t isinstanceRRRRteqtnetboolRRRt BOOLEANTYPEtis_R tisnotRt ArgumentErrort_check_literal(RRRtobjR)R#t_python_is_typesR ((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_boolean_compareEs<           c Ks{|j|||ƒ}|r+||}}n ||}}|dkre|jj||jƒ\}}nt|||d|ƒS(NR((R3tNonet comparatorR'R( RRRR4R#t result_typetkwtlefttright((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_binary_operatess   cKsE|tjkrt||ƒS|tjkr8t||ƒStƒ‚dS(N(RRRtNotImplementedError(RRRRR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_conjunction_operate‚s   cKs ||ƒS(N((RRRtfnR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_scalarŠscKs´t|ƒ}t|tƒr4|j|||d|ƒSt|tƒre|j|||jƒd||St|ttfƒr–|j|||d||St|tƒr»t j d|ƒ‚ng}x||D]t}t |ƒst|t j ƒs/t j d|ƒ‚q/n*|dkrtƒ}n|j||ƒ}|j|ƒqÈWt|ƒdkr‰tjd|ƒ|t jkr|||kS||kSn|j||t|Œjd|ƒd|ƒS(NR)s>in_() accepts either a list of expressions or a selectable: %risÈThe IN-predicate on "%s" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate. Consider alternative strategies for improved performance.tagainst(R R+RR6Rt as_scalarRR RRtInvalidRequestErrorRRtColumnOperatorsR7Rt _bind_paramtappendtlenRtwarntin_opR t self_group(RRRtseq_or_selectablet negate_opR:targsR!((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_in_implsF            cOstd|jƒ‚dS(Ns1Operator '%s' is not supported on this expression(R>R(RRRtargR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_unsupported_implÊscKs$t|dƒr|jS|jƒSdS(s%See :meth:`.ColumnOperators.__inv__`.tnegation_clauseN(thasattrRRt_negate(RRRR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt _inv_implÎscKst|dtjƒS(s%See :meth:`.ColumnOperators.__neg__`.toperator(RRtneg(RRRR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt _neg_implÕscKs+|j|tj|j|tj|ƒ|S(s#See :meth:`.ColumnOperators.match`.(R6Rtmatch_opR3(RRRRR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt _match_implÙs  cKst|dtjd|jƒS(s&See :meth:`.ColumnOperators.distinct`.RVR((RRt distinct_opR(RRRR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt_distinct_implásc Ksyt|t|j|tj|ƒ|j|tj|ƒdtjdtdtƒ|d|tjkritjntjd|ƒS(s%See :meth:`.ColumnOperators.between`.RVtgrouptgroup_contentsR)R*(RR R3RRtFalset between_opt notbetween_op(RRRtclefttcrightR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt _between_implæs   cKs t||ƒS(N(R(RRRRR:((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt _collate_implõsRRtinvtaddtmultsubtdivtmodttruedivt custom_opt concat_optlttleR-tgttgeR,tlike_optilike_opt notlike_opt notilike_opt contains_opt startswith_opt endswith_optdesc_optasc_opt nullsfirst_opt nullslast_opRJtnotin_opR0R1RRYR[R`RaRWtgetitemtlshifttrshiftcCsÚt|ttfƒrOt|tƒrK|jjrK|jƒ}|j|_n|St|dƒrm|jƒ}n!t|t j j ƒrŽ|j }nt|t tfƒr­|jƒSt|ttfƒsÒ|j||ƒS|SdS(Nt__clause_element__(R+R R RRt_isnullt_cloneRSR‚Rt TypeEnginet ComparatorRRRRCRF(RRRVR((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyR3&s    N(1Rt __module__t__doc__Rtmemoized_propertyRR"R%R'R7R_tNoneTypeR.R6R=R?RARORQRURXRZR\RdReRRrRqR,RpRoR-RuRvRsRttnotcontains_optnotstartswith_optnotendswith_opRt _create_desct _create_asct_create_nullsfirstt_create_nullslastR~RJR0R1R3(((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyRsz   -   =                           N(RˆtRRRRtelementsRRRRRR R R R R RRRRRRRt selectableRRRRRER(((sg/var/www/send.findwatt.com/datamanager/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.pyt s p"