ó ®â0_c@s¡dZddlmZddlmZddlmZdZdZdej fd„ƒYZ d e fd „ƒYZ d e fd „ƒYZ d e fd„ƒYZdS(sG Code to manage the creation and SQL rendering of 'where' constraints. iÿÿÿÿ(tEmptyResultSet(ttree(tcached_propertytANDtORt WhereNodecBsŒeZdZeZed„Zd„Zd„Zd„Z d„Z d„Z d„Z d„Z ed „ƒZed „ƒZed „ƒZRS( s½ Used to represent the SQL where-clause. The class is tied to the Query class that created it (in order to create the correct SQL). A child is usually an expression producing boolean values. Most likely the expression is a Lookup instance. However, a child could also be any class with as_sql() and either relabeled_clone() method or relabel_aliases() and clone() methods and contains_aggregate attribute. c Csa|js|dfS||jA}|r5|jtkpH| oH|jtk}|rd|jrdd|fSg}g}x–|jD]‹}t|dƒrß|j|ƒ\}}|dk rÀ|j |ƒn|dk r|j |ƒqqz|jrø|j |ƒqz|j |ƒqzW|r*|j ||j|jƒnd} |rQ|j ||j|jƒnd} | | fS(sÖ Returns two possibly None nodes: one for those parts of self that should be included in the WHERE clause and one for those parts of self that must be included in the HAVING clause. t split_havingN( tcontains_aggregatetNonetnegatedt connectorRRtchildrenthasattrRtappendt __class__( tselfR t in_negatedtmay_need_splitt where_partst having_partstct where_partt having_partt having_nodet where_node((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyRs,       ''c Csyg}g}|jtkr4t|jƒd}}ndt|jƒ}}xÈ|jD]½}y|j|ƒ\}} Wntk r|d8}n.X|r´|j|ƒ|j| ƒn |d8}|dkræ|jrİdgfSt‚n|dkrT|jrt‚qdgfSqTqTWd|j} | j |ƒ} | ro|jrMd| } qot|ƒdkrod| } qon| |fS(s Returns the SQL version of the where clause and the value to be substituted in. Returns '', [] if this node matches everything, None, [] if this node is empty, and raises EmptyResultSet if this node can't match anything. iits %s sNOT (%s)s(%s)( R RtlenR tcompileRR textendR tjoin( Rtcompilert connectiontresultt result_paramst full_neededt empty_neededtchildtsqltparamstconnt sql_string((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pytas_sql?s<             cCs1g}x$|jD]}|j|jƒƒqW|S(N(R Rtget_group_by_cols(RtcolsR$((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR*sscCs|jS(N(R (R((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pytget_source_expressionsyscCs.t|ƒt|jƒks!t‚||_dS(N(RR tAssertionError(RR ((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pytset_source_expressions|s!cCskxdt|jƒD]S\}}t|dƒr;|j|ƒqt|dƒr|j|ƒ|j|}t|dƒr_|jj|jƒƒq1|jj|ƒq1W|S(sİ Creates a clone of the tree. Must only be called on root nodes (nodes with empty subtree_parents). Childs must be either (Contraint, lookup, value) tuples, or objects supporting .clone(). R R R tclone(Rt _new_instanceR R R R R R4(RR4R$((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR4Œs cCs|jƒ}|j|ƒ|S(N(R4R/(RR2R4((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR0›s  cs6t|tjƒr/t‡fd†|jDƒƒS|jS(Nc3s|]}ˆj|ƒVqdS(N(t_contains_aggregate(t.0R(tcls(s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pys £s(t isinstanceRtNodetanyR R(R8tobj((R8s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR6 scCs |j|ƒS(N(R6(R((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR¦scCstd„|jDƒƒS(Ncss|]}|jVqdS(N(t is_summary(R7R$((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pys ¬s(R;R (R((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR=ªs(t__name__t __module__t__doc__RtdefaulttFalseRR)R*R,R.R/R4R0t classmethodR6RRtpropertyR=(((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyRs  ! 4     t NothingNodecBs#eZdZeZddd„ZRS(s& A node that matches nothing. cCs t‚dS(N(R(RRR((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR)µsN(R>R?R@RBRRR)(((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyRE¯st ExtraWherecBs&eZeZd„Zddd„ZRS(cCs||_||_dS(N(tsqlsR&(RRGR&((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyt__init__½s cCsBg|jD]}d|^q }dj|ƒt|jp;dƒfS(Ns(%s)s AND ((RGRtlistR&(RRRR%RG((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR)Ás N(R>R?RBRRHRR)(((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyRF¹s tSubqueryConstraintcBs eZeZd„Zd„ZRS(cCs(||_||_||_||_dS(N(taliastcolumnsttargetst query_object(RRKRLRMRN((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyRHËs   cCsD|j}|j|jƒ|jd|ƒ}|j|j|j|ƒS(NR(RNt set_valuesRMt get_compilertas_subquery_conditionRKRL(RRRtquerytquery_compiler((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyR)Ñs (R>R?RBRRHR)(((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyRJÆs N(R@tdjango.core.exceptionsRt django.utilsRtdjango.utils.functionalRRRR:RtobjectRERFRJ(((s</tmp/pip-unpacked-wheel-BAJOf3/django/db/models/sql/where.pyts¡