jPdZddlZddlZddlZddlZddlmZmZddlm Z m Z ddl m Z m Z mZddlmZddlmZmZddlmZmZmZdd lmZdd lmZdd lmZmZmZm Z m!Z!m"Z"m#Z#m$Z$dd l%m&Z&dd l'm(Z(ddl)m*Z*ddl+m,Z,m-Z-m.Z.ddl/m0Z0m1Z1m2Z2m3Z3ddl4m5Z5m6Z6m7Z7m8Z8ddl9m:Z:m;Z;mZ>ddl?m@Z@ddlAmBZBddlCmDZDddgZEeBdZFeBdZGdZHdZIdZJdZKdZLedd ZMGd!dZNed"d#ZOGd$deZPd)d&ZQGd'd(ZRdS)*aW Create SQL statements for QuerySets. The code in here encapsulates all of the SQL construction so that QuerySets themselves do not have to (and could be backed by things other than SQL databases). The abstraction barrier only works one way: this module has to know all about the internals of models in order to get the information it needs. N)Counter namedtuple)IteratorMapping)chaincountproduct)ascii_uppercase)FieldDoesNotExist FieldError)DEFAULT_DB_ALIASNotSupportedError connections)Count) LOOKUP_SEP)BaseExpressionColExistsFOuterRefRefResolvedOuterRefValue)Field)MultiColSource)Lookup)Qcheck_rel_lookup_compatibilityrefs_expression)INNERLOUTER ORDER_DIRSINGLE) BaseTableEmptyJoin MultiJoin)ANDOR ExtraWhere NothingNode WhereNode)cached_property)_lazy_re_compile)NodeQueryRawQueryz['`\"\]\[;\s]|--|/\*|\*/z[\w-]+c|tSttjd|DS)Nc3PK|]!}|jr|j|jfn|jfV"dSN)concretenameattname.0fs i/var/www/finuniver-perm.ru/html/portfolio/venv/lib/python3.11/site-packages/django/db/models/sql/query.py z,get_field_names_from_opts..?sL  AB1: Passing a QuerySet within a FilteredRelation is not supported.c2g|]}t|Sget_child_with_renamed_prefix)r9 grand_childprefix replacements r; z1get_child_with_renamed_prefix..ys5   .fk;OO   r=)django.db.models.queryrSrEr/rename_prefix_from_qrN startswithrreplacerrFrXcopyr6 ValueErrorset_source_expressionsget_source_expressions)rZr[rIrSrPrQs`` r;rXrX]s//////%@#FK???%S >>&:- . . 6++fk155C#q!! Jgc3G&H&H J/ SIICCx%   : *!4 5 5 D++FKCCEJ E8 $ $  L    , - -   $$     #(#?#?#A#A      Lr=cjtjfd|jD|j|jS)Nc2g|]}t|SrVrW)r9crZr[s r;r\z(rename_prefix_from_q..s&SSS1 &v{A > >SSSr=)rcreaterM connectornegated)rZr[rOs`` r;r^r^s> 8SSSSS SSS    r=JoinInfo) final_fieldtargetsrAjoinspathtransform_functioncZeZdZdZd dZdZdZdZdZdZ e d Z d Z d Z d S)r1zA single raw SQL query.rVcx||_||_||_d|_d\|_|_i|_i|_dS)NrN)paramssqlusingcursorlow_mark high_mark extra_selectannotation_select)selfrurvrts r;__init__zRawQuery.__init__sD   )0% t~!#r=c,||Sr4cloner|rvs r;rzRawQuery.chainszz%   r=c:t|j||jS)N)rt)r1rurtrs r;rzRawQuery.clones% <<<.s'UUUk +a.))UUUr=)rw_execute_queryrrv introspectionidentifier_converter description)r|rs @r; get_columnszRawQuery.get_columnssN ;     ! ! ! +9N UUUUT[=TUUUUr=c|t|jjjst |j}n|j}t|Sr4)rrrvfeaturescan_use_chunked_readslistrwiter)r|results r;__iter__zRawQuery.__iter__sQ 4:&/E !$+&&FF[FF||r=c(d|jjd|dS)N) __class____name__r|s r;__repr__zRawQuery.__repr__s!^444ddd;;r=cd|jdSt|jtrtntSr4)rtrErdictrNrs r; params_typezRawQuery.params_types* ; 4!$+w77BttUBr=cb|j|jS|j||jzSr4)rrurtrs r;__str__zRawQuery.__str__s/   #8Ox$**4;7777r=ct|j}|j}|jj|t ur!t fd|jD}nF|tur&fd|jD}n|d}ntd|z| |_ |j |j |dS)Nc3.K|]}|VdSr4rV)r9valadapters r;r<z*RawQuery._execute_query..s+??C773<<??????r=c.i|]\}}||SrVrV)r9keyrrs r; z+RawQuery._execute_query..s'LLLHCc773<<LLLr=zUnexpected params type: %s) rrvropsadapt_unknown_valuerNrtritems RuntimeErrorrwexecuteru)r| connectionrrtrs @r;rzRawQuery._execute_querys , & .4 %  ????4;?????FF D LLLL 8I8I8K8KLLLFF  FF;kIJJ J ''))  DHf-----r=N)rV)r __module__ __qualname____doc__r}rrrrrpropertyrrrrVr=r;r1r1s!! $ $ $ $!!!===VVV   <<<CCXC 888 .....r= ExplainInfo)formatoptionsceZdZdZdZdZeegZdZe Z e Z dZ dZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZdZd Z dZ!dZ"dZ#dZ$dZ%dZ&dZ'dZ(dZ)dZ*edfZ+dZ,ded Z-e.d Z/e0d Z1d Z2dZ3dZ4dfdZ5dZ6dZ7dgdZ8dZ9dZ:dZ;dZdZ?dgdZ@dZAdgdZBdgdZCdZDdhd ZEd!ZFdid#ZGd$ZHd%ZId&ZJd'ZKdgd(ZLd)ZMd*ZNdgd+ZOd,ZPd-ZQded.ZRd/ZSd0ZTdgd1ZUd2ZVdjd3ZWdjd4ZXd5ZYd6ZZd7Z[d8Z\d9Z] dkd:Z^d;Z_d<Z`d=Zad>Zb dld?Zcd@ZddmdAZe dndBZfdCZgehdodDZiehdEZjdpdFZkdGZldHZmdIZndqdJZodKZpe.dLZqdMZrdNZsdOZtdPZudQZvdRZwdSZxdedTZydUZzdodVZ{dedWZ|dXZ}dYZ~dZZd[Zd\Zd]Zd^Zd_Zd`Ze.daZe.dbZdcZddZdS)rr0zA single SQL query.TN SQLCompilerTFrVrc||_i|_i|_||_i|_i|_t |_t|_ i|_ i|_ i|_ dSr4) modelalias_refcount alias_map alias_colsexternal_aliases table_mapr> used_aliasesr,where annotationsextra_filtered_relations)r|rrs r;r}zQuery.__init__$sh   $ !#EE[[  #%   r=c t|jdkr%|jd}t|ddp|jSt|jdkr8t t |jjSdS)NrTrtarget) lenselectgetattrfieldr{nextrvalues output_field)r|rs r;rzQuery.output_field@s t{  q [^F68T22Bfl B ' ( (A - -T3::<<==>>K K. -r=c |jD]}|cSdSr4)rr|aliass r; base_tablezQuery.base_tableHs&^  ELLL  r=c:|\}}||zS)a( Return the query as a string of SQL with the parameter values substituted in (use sql_with_params() to see the unsubstituted string). Parameter values won't necessarily be quoted correctly, since that is done by the database interface at execution time. )sql_with_params)r|rurts r;rz Query.__str__Ms#**,, VV|r=cZ|tS)zw Return the query as an SQL string and the parameters that will be substituted into the query. ) get_compilerr as_sqlrs r;rzQuery.sql_with_paramsXs%   !12299;;;r=cR|}||t|<|S)z4Limit the amount of work when a Query is deepcopied.)rid)r|memors r; __deepcopy__zQuery.__deepcopy___s#RXX r=c||td|r t|}|j|j||||S)NzNeed either using or connection)rbrrcompiler)r|rvr elide_emptys r;rzQuery.get_compileres\ =Z/>?? ?  ,$U+J5z~&&t}55 *e[   r=c,|jr |jjSdS)z Return the Options instance (the model._meta) from which to start processing. Normally, this is self.model._meta, but it can be changed by subclasses. N)r_metars r;get_metazQuery.get_metans# : $:# # $ $r=ct}|j|_|j|_|j|_|j|_|j|_|j|_|j |_|j |_ |j |j |_ |j r#td|j D|_ d|_|j|_|j|j|_|j|j|_|jdurtj|j|_d|jvr|j|_|j|_|j|_|jdd|S)zf Return a copy of the current Query. A lightweight alternative to deepcopy(). Nc6g|]}|SrVr)r9querys r;r\zQuery.clone..s BBB5BBBr=F subq_aliasesr)r%r__dict__rarrrrrrrannotation_select_maskcombined_queriesrN_annotation_select_cacherextra_select_mask_extra_select_cacheselect_relateddeepcopyrrrpop)r|objs r;rz Query.clonews gg }))++ !05577++-- #499;;++-- J$$&& *//11  & 2)-)D)I)I)K)KC &   #(BBD,ABBB$$C (,$JOO%%  ! -$($:$?$?$A$AC !  # /&*&>&C&C&E&EC #  e + +"&s/A!B!BC  T] * *#05577C ,1133"&":"?"?"A"A t,,, r=c|}|r|j|kr||_|jst|_d|_t |dr||S)z Return a copy of the current Query that's ready for another operation. The klass argument changes the type of the Query, e.g. UpdateQuery. F _setup_query)rrfilter_is_stickyr>rrFr)r|klassrs r;rz Query.chainst jjll  "S]e++!CM# %"uuC $ 3 ' '        r=cX|}|||Sr4)rchange_aliases)r| change_maprs r;relabeled_clonezQuery.relabeled_clones(  Z((( r=c@|jsd}|||Sr4rget_col)r|rrrs r;_get_colzQuery._get_cols% E~~eU+++r=c* |siSd}d}ij}|D]\}}||ddd}|jst d|z|g|tfd|Dz}|tfd|Dz}| }|j |<|t||<fd|D} |j \} } } td j Dp| } t!jt$sjs| s|s|s| sjsjrd d lm}}d|_|j|}d|_d|_| j|d |js"|jr>| r<jj j!"|#f|_d|_| stI}t!jt$r!jD]}||z}| D]}||z}jD].\}}|%r|&|/| |i}| D]\}}i'|gd D]j}|(|x}sLtS|dz}d|}t||}|||<||j |<||g||<k| |j |<|j*dkrJ|jsC|js<jj j!"|#f|_*n}d_*d_i_+j rIdj Dfd| D_ n| _ | d|jD}td|D }|d |,d|_d|_|-||}|.t^}||}nP|0|j}tc|2|f|}tgti|j|S)zU Return the dictionary with the values of the existing aggregations. FTN allow_joinsreuse summarizez!%s is not an aggregate expressionc3PK|] }tj|ddV!dS)contains_subqueryFNrrr9refr|s r;r<z(Query.get_aggregation..sL!!(-/BEJJ!!!!!!r=c3PK|] }tj|ddV!dS)contains_over_clauseTNrrs r;r<z(Query.get_aggregation..sL(-/EtLLr=cFi|]}|j|SrV)rr)r9rr|s r;rz)Query.get_aggregation..s,VVVUeT-11%88VVVr=c38K|]}t|ddVdS)contains_aggregateTN)r)r9 annotations r;r<z(Query.get_aggregation..sC $8$??r=r)AggregateQueryforce) resolve_refsrT__colrVc6i|]\}}t|||SrV)r)r9rr s r;rz)Query.get_aggregation..Qs8   )zz**J   r=cBi|]\}}||SrV)replace_expressions)r9r aggregate replacementss r;rz)Query.get_aggregation..Us=$$$(y988FF$$$r=cg|] }|j SrV)empty_result_set_value)r9 expressions r;r\z)Query.get_aggregation..]s+     -   r=c3(K|] }|tuVdSr4)NotImplemented)r9rs r;r<z(Query.get_aggregation..as'VV6f6VVVVVVr=)r)5rr check_aliasrLr TypeErrorappend_annotation_maskanyget_refsrrrset_annotation_maskrsplit_having_qualifyrrEgroup_byrN is_sliceddistinct combinatordjango.db.models.sql.subqueriesr rsubqueryrselect_for_updaterr{clear_ordering default_colsrpkrget_initial_aliasr>get_group_by_colsadd _gen_colsgetrrr clear_limitsr execute_sqlr#get_convertersrapply_convertersrzip) r|rvaggregate_exprs refs_subquery refs_windowrraggregate_exprr aggregates_havingqualifyhas_existing_aggregationr  inner_query outer_queryannotation_maskrHannotation_aliasr col_refscolcol_refindex col_aliasempty_set_resultrrr convertersrs ` @r;get_aggregationzQuery.get_aggregationsS I   !%!<%4%:%:%<%< < < !E>   U # # #&99$dd:I/ M Ce KLLL  ' ' 0 0 0 S!!!!$--//!!! M 3$--// K"55lCCI&/D U #2;LUI.. / /WVVVoVVV    !7888"Z<<>>67 "&"2"9"9";";    !$ t}e , ,e 1~e 1(e 1 e 1  e 1  e 1}e 1e 1 G F F F F F**,,K#'K (.[AAK,1K )).K &  + +D,B C C C  & &U & 3 3 3' E +0H (+33K4Q4Q4S4STT,K(,1 (E '*eeO!$-77?$(M??D+t}}>OO%/%6%6%8%8@@ '9+=+=+?+??9=8N8T8T8V8VBB4(*%7799B+//0@AAA33ODDDH$.$4$4$6$6   y! >>9+E>JJ00C'/||C'8'88GH #H  1$3EOO "%i"5"5(/ =@ / :#::I;GGG(/L%%1:1N1N 22 '.."b((#0)#:)J$'// 0M0M0O0OPP& "KDK %D DJ .  -1-=-C-C-E-E    $$$$,6,<,<,>,>$$$  $.  $ $Z 0 0 0  );BBDD   VVEUVVVVVV """...  """(- %%* "++E{+KK%%f-- >%FF!001N1U1U1W1WXXJ(33VIzJJKKFC 5v>>???r=c|}||dtdidS)zO Perform a COUNT() query using the current filter constraints. __count*)rrHr)r|rvrs r; get_countzQuery.get_countps7jjll""59eCjj*ABB9MMr=c|jSr4)rrs r; has_filterszQuery.has_filtersws zr=c|}|jr|jsb|jdurE|d|jjjDd|d| |j r.|j dkr#td|j D|_ | d|r|d |t!dd |S) NTc3$K|] }|jV dSr4r7r8s r;r<zQuery.exists..s$II1QYIIIIIIr=F allow_aliasesunionc3BK|]}|dVdS)F)limitN)exists)r9combined_querys r;r<zQuery.exists..sG''"%%E%22''''''r=r rT)higha)rr"r!r  add_fieldsrrconcrete_fields set_group_byclear_select_clauserr#rNr' set_limitsadd_annotationr)r|rVrOs r;rWz Query.existszs& JJLL  $q{ $zT!! II (8(HIII5 U333 ! ! # # #  !,'"9"9!&''&'&8'''""A  t$$$  ! LLaL  q3'''r=c||}||}|S)Nrv)rWr has_results)r|rvrOrs r;rczQuery.has_resultss8 KK  >>>..##%%%r=c :|}|D]3}t|rd|vrtd|d4t |||_||}d|S)Nz--zInvalid option name: .rb ) rEXPLAIN_OPTIONS_PATTERN fullmatchrbr explain_inforjoin explain_query)r|rvrrrO option_namers r;explainz Query.explains JJLL" K KK+55kBB K;&& !I!I!I!IJJJ'%VW55>>>..yy//11222r=cj|jkrtdjrtdj|jkrtdj|jkrtd}||hi|tk}|rtntj }t|dd}| fdj Dt}t|j d d }|D]} |j | } | } | | } | jt kr|| || | | kr| | <|j| s| | ||xj|jzc_|j} | j| ||jr'fd |jDnd _|t8krjr|jrt=dj|jt} j | j |j | |j | r!| xj"|j"z c_"|j#pj#_#|j$pj$_$d S)aN Merge the 'rhs' query into the current one (with any 'rhs' effects being applied *after* (that is, "to the right of") anything in the current query. 'rhs' is not modified during a call to this function. The 'connector' parameter describes how to connect filters from the 'rhs' query. z4Cannot combine queries on two different base models.z3Cannot combine queries once a slice has been taken.z6Cannot combine a unique query with a non-unique query.z6Cannot combine queries with different distinct fields.)excludeFc3RK|]!}j|jtk|V"dSr4r join_typer )r9jr|s r;r<z Query.combine..s@  ):)D)M)MA)M)M)M)M  r=rTNrc:g|]}|SrVrr9rBrs r;r\z!Query.combine..s'SSSS00<<SSSr=rVzSWhen merging querysets using 'or', you cannot have extra(select=...) on both sides.)%rrr!r"distinct_fieldsr* bump_prefixr(r>r JoinPromoter add_votesrrrjrsr r,discardr unref_aliasupdate_join_typesrrrrelabel_aliasesr set_selectr)rrbupdaterset_extra_mask extra_tablesorder_byextra_order_by)r|rQri initial_alias conjunctionr joinpromoter rhs_votes rhs_tablesrrj new_aliaswrrs` @r;combinez Query.combines : " "RSS S > SQRR R =CL ( (TUU U  3#6 6 6TUU U..00  }o666 3& %=#dn*=*=#Iq%88     ~      EE #-((,  , ,E='D'' 33D $e 44I~&& i((( MM) $ $ $ !!$- 5!%e, ,   +++y)))&&t,,, S-- IOO   *%%% q)$$$ :  OOSSSS SSS T T T TDK ??z ci  7 #)$$$EE  ! -  $ $T%; < < <  ,  $ $S%: ; ; ;  3    1 2 2 2 S-- 5  !0GD4Gr=c|i}i||j<|jD]}||jd}||jd}||||iS|rx|js)ttt|||i}|j j j j }||j |||D]\} }|j| x} r:|| j} || | fi}| j}nC|| } t+| ds| j}||i}|j j j }||j |||S)Nr)r)r\rr6r7 setdefault is_relationr rr remote_fieldrrconcrete_model_get_defer_select_maskrrr. get_field relation_namerrF) r|rAmask select_maskr field_maskfield_att_maskfield_select_mask related_model field_namefiltered_relationrelation reverse_rels r;rzQuery._get_defer_select_masks  K! DG )  E%*d33J!XXemT::N!n&<&&ub1111 (=$T$z*:*:%;%;<<<$/$:$:5"$E$E! % 2 8 > M ++!'5F '+jjll   "J $($<$@$@$L$LL  F>>*;*IJJ$/$:$:J;QSU$V$V! "nnZ88 {G44#)$/$:$:5"$E$E!!K- M **!'5Fr=c|j\}}|siSi}|D]7}|}|tD]}||i}8|}|r|||S|||S)a Convert the self.deferred_loading data structure to an alternate data structure, describing the field that *will* be loaded. This is used to compute the columns to select from the database and also by the QuerySet class to work out which fields are being initialized on each model. Models that have all their fields included aren't mentioned in the result, only those that have field restrictions in place. )deferred_loadingsplitrrrrr)r| field_namesdeferrr part_maskpartrAs r;get_select_maskzQuery.get_select_maskYs"2 U I% ; ;JI"((44 ; ;%00r::  ;}}  ;..tT:: :))$555r=c:|j|}|s#|r!|d}|j|xxdz cc<|dfS|r7d|jt |jdzfz}||n||jn|}|g|j|<d|j|<|dfS)a Return a table alias for the given table_name and whether this is a new alias or not. If 'create' is true, a new alias is always created. Otherwise, the most recently created alias for the table (if one exists) is reused. rrTF%s%dNT)rr.r alias_prefixrrappendr)r| table_namerhr alias_listrs r; table_aliaszQuery.table_aliasos^'' 33  * qME   & & &! + & & &%<   1d/T^1D1Dq1HIIE   e $ $ $ $,=+H!''j +0DN: &%&E"d{r=c0|j|xxdz cc<dS)z-Increases the reference count for this alias.rTNrrs r; ref_aliaszQuery.ref_aliass' E"""a'"""""r=rTc0|j|xx|zcc<dS)z-Decreases the reference count for this alias.Nr)r|ramounts r;r~zQuery.unref_aliass' E"""f,"""""r=c trdjj*jjJjj}|oj|jt k}jjt k}jjs|rQ|sOjj<fdjDdSdS)a  Promote recursively the join type of given aliases and its children to an outer join. If 'unconditional' is False, only promote the join if it is nullable or the parent join is an outer join. The children promotion is done to avoid join chains that contain a LOUTER b INNER c. So, if we have currently a INNER b INNER c and a->b is promoted, then we must also promote b->c automatically, or otherwise the promotion of a->b doesn't actually change anything in the query results. rNc3PK|] }j|jkr|v|V!dSr4)r parent_alias)r9rjraliasesr|s r;r<z&Query.promote_joins..sQ~d+8EAAG++,+++ r=) rrrrsrr!nullablepromoteextend)r|rr parent_louteralready_louterrs`` @r; promote_joinszQuery.promote_joinss<w-- KKNNE~e$.6>%(2>>>>%0=LQ !=!G6!Q "^E2<FNu%. -  (,u(=(E(E(G(Gu% $%     r=cbt|}|r|d}|j|jtkri|j||j|<|j|j}|j|jtkr|||dSdS)a Change join type from LOUTER to INNER for all joins in aliases. Similarly to promote_joins(), this method must ensure no join chains containing first an outer, then an inner join are generated. If we are demoting b->c join in chain a LOUTER b LOUTER c then we must demote a->b automatically, or otherwise the demotion of b->c doesn't actually change anything in the query results. . rN) rrrrsr!demoterr r)r|rrrs r; demote_joinszQuery.demote_joinssw-- 1KKNNE~e$.&88(,u(=(D(D(F(Fu%#~e4A >,/9UBBNN<000  1 1 1 1 1r=c|jD]4\}}|||dz }|||5dS)zp Reset reference counts for aliases so that they match the value passed in `to_counts`. rN)rrarr.r~)r| to_countsr cur_refcount unref_amounts r;reset_refcountszQuery.reset_refcountssn $(#6#;#;#=#=#C#C#E#E 2 2 E<')--q*A*AAL   UL 1 1 1 1 2 2r=cttsJ|jt |jtr%tfd|jD|_tfd|jD|_|j o$fd|j D|_  D]\}}||j vr|j | }||j |<|j ||j |<|j |=|j |=|j|j}t!|D]\}}||kr|||<nfd|j D|_dS)z Change the aliases in change_map (which maps old-alias -> new-alias), relabelling any references to them in select columns and the where clause. c:g|]}|SrVrwrxs r;r\z(Query.change_aliases..s'JJJS$$Z00JJJr=c:g|]}|SrVrwrxs r;r\z(Query.change_aliases..s'TTTS00<<TTTr=cBi|]\}}||SrVrw)r9rrBrs r;rz(Query.change_aliases..s=1 1 1 S $$Z001 1 1 r=cLi|] \}}|||p|v!SrVr.)r9raliasedrs r;rz(Query.change_aliases..sI! ! ! w NN5% ( (7+Iez6I! ! ! r=N)r> isdisjointrrrrEr rNrrrrrrrr enumerater)r|r old_aliasr alias_data table_aliasesposrs ` r;rzQuery.change_aliasess:))**;*;*=*=>>>>> "":... dmU + + !JJJJDMJJJDMTTTT TTTUU + 1 1 1 1  ,22441 1 1  %/$4$4$6$6   Iy.. 2BB:NNJ(2DN9 %-1-@-KD  *#I.y) N:+@AM' 66   UI%%)2M#&E&! ! ! ! #'"7"="="?"?! ! ! r=cfd}j|jkrdStjdz}t|D],\}}|jvr |_n||krt d-jjg_|jj|_ifdtjDdS)a; Change the alias prefix to the next letter in the alphabet in a way that the other query's aliases and this query's aliases will not conflict. Even tables that previously had no alias will get an alias after this call. To prevent changing aliases use the exclude parameter. c3*Kt}ttjdz}|Vt dD]P}|r|||dn|}t ||D]}d|Vd}QdS)a Generate a sequence of characters in alphabetical order: -> 'A', 'B', 'C', ... When the alphabet is finished, the sequence will continue with the Cartesian product: -> 'AA', 'AB', 'AC', ... rTN)repeat)r chrordrrrDr rj)alphabetrZnseqsr|s r; prefix_genz%Query.bump_prefix..prefix_gens'HT.//!344FLLL1XX  .0sA   C''v!2C 88'''r=) rsysgetrecursionlimitrrRecursionErrorrTrr)r| other_queryrorlocal_recursion_limitrrZs` ` r;rzzQuery.bump_prefixsK     $   8 8 8 F !$ 5 7 72 =$ZZ\\22  KCT...$*!***$L+!-33T5F4GHH#.#;#A#A$BS#T#T  ?G      "+DN";";        r=c|jr|j}||nJ|jrA|||jd}nd}|S)zf Return the first alias for this query, after increasing its reference count. N)rrrrrjbase_table_classrdb_tablers r;r*zQuery.get_initial_alias7sl > OE NN5 ! ! ! ! Z IId33DMMOO4LdSSTTEEE r=cbtd|jDS)z Return the number of tables in this query with a non-zero reference count. After execution, the reference counts are zeroed, so tables added in compiler will not be seen by this method. cg|]}|dSrTrV)r9rs r;r\z-Query.count_active_tables..KsIII%5IAIIIr=)rrrrs r;count_active_tableszQuery.count_active_tablesEs0 II4#6#=#=#?#?IIIJJJr=cfd|jD}|r0j|vrj}n|d}|||S|jdj\}}jr=|jjjtksj rt}nt}|_|_|j|<jx}r} | t|hz} t|j} | || _| t|jkr"|j||j|<|S)a+ Return an alias for the 'join', either reusing an existing alias for that join or creating a new one. 'join' is either a base_table_class or join_class. The 'reuse' parameter can be either None which means all joins are reusable, or it can be a set containing the aliases that can be reused. A join is always created as LOUTER if the lhs alias is LOUTER to make sure chains like t1 LOUTER t2 INNER t3 aren't generated. All new joins are created as LOUTER if the join is nullable. c2g|]\}}|v |k|Sr4rV)r9rZrtrjrs r;r\zQuery.join..Zs:   1 ed 1:r=T)rhrNru)rrrrrrrsrr!rr r>rrLr) r|rjr reuse_aliases reuse_aliasrr9rsr resolve_reuse joins_lens `` r;rjz Query.joinMs     ,,..    =00". ,B/ NN; ' ' ' ## ODD '~d/0:fDD D" ! &DN  $u $ 6 6  B!M( #E eW 4 DN++I%6%I%IM&J&&D " 3t~....(,(:(:5(A(Au% r=cV||vr||S||}|s|S|}|D]v}||vr|j}||}|j|s|j}+||}||jg||} |j}| jdx}||<w|p|dS)a} Make sure the given 'model' is joined in the query. If 'model' isn't a parent of 'opts' or if it is None this method is a no-op. The 'alias' is the root alias for starting the join, 'seen' is a dict of model -> alias of existing joins. It must also contain a mapping of None -> some alias. This will be returned in the no-op case. rN)get_base_chainrparentsget_ancestor_link setup_joinsr6rn) r|rArrseenr curr_opts int_model link_field join_infos r;join_parent_modelzQuery.join_parent_models D==; ##E** L  : :ID  %O Y $Y/ %O "44Y??J((*/):IuMMI!I&/ob&9 9EDOO"T "r=cXt|rtddS)NzbColumn aliases cannot contain whitespace characters, quotation marks, semicolons, or SQL comments.)FORBIDDEN_ALIAS_PATTERNsearchrbrs r;rzQuery.check_aliass9 " ) )% 0 0 /   r=c(|||dd}|r|gn@fdt|jD}||||j<dS)z0Add a single annotation expression to the Query.TN)rrc3(K|] }|k|V dSr4rV)r9valuers r;r<z'Query.add_annotation..s5E>>!>>>r=)rrLrrfromkeysr{rr)r|r rrr?s ` r;r`zQuery.add_annotations 224TQU2VV  6  ' ' 0 0 0 0!]]4+ABBO  $ $_ 5 5 5",r=c|}|d|_|jjgRi|jr't fd|jD|_|j D]O\}}|jgRi}t|dr|j |j ||j|<Pj D]a\}} t| to| jjjj|kp$t| t(o| j| jk|j |<b|S)NTc2g|]}|jgRiSrV)rL)r9rXargskwargsrs r;r\z,Query.resolve_expression..sF&6N5eMdMMMfMMr=r)rrzr%rrLr#rNrrrrFrrrrEr& join_fieldrrrr$rr) r|rr r rrrresolvedrtables ``` r;rLzQuery.resolve_expressions  %   & &u>t>>>v>>>   %**/*@&&E "  +1133 . .JC/u/GGGGGGHx!344 I)001GHHH%-E c " "!O1133  LE55$''K$28AUJ-5),,V1AUEV1V  "5 ) )  r=ctjjj}fd|dDS)Nc0g|]}|jjv|SrV)rr)r9rBr|s r;r\z+Query.get_external_cols..s3   yD111 111r=T)include_external)rrrrrMr-)r|exprss` r;get_external_colszQuery.get_external_colssad&--//1DEE    ~~ed~CC    r=cj|}td|Dr|p|gS|S)Nc3$K|] }|jV dSr4)possibly_multivalued)r9rBs r;r<z*Query.get_group_by_cols..s%AACs'AAAAAAr=)rr)r|wrapper external_colss r;r+zQuery.get_group_by_colssG ..00 AA=AAA A A %Ot$ $r=c |jrB|jjs6|d|jD]}|d||\}}|jrd|z}||fS)NFr )rz(%s))r%r*ignores_unnecessary_order_by_in_subqueriesr'rrr)r|rrrrurts r;rz Query.as_sqls M 2'R 2   e  , , ,. 2 2$$5$1111'':'>>EEGG V = 3,CF{r=ct|dr||}n[t|ttfr?fd|D}t |}t|dr||S||S|S)NrL)rrrc3FK|]}|VdSr4)resolve_lookup_value)r9 sub_valuer can_reuser|s r;r<z-Query.resolve_lookup_value..sI)))Y LLr=_make)rFrLrErrNtype)r|rr!rrrtype_s` `` r;rzQuery.resolve_lookup_values 5. / / !,,'# -EE e} - - !!&FKKEug&& &uf~%5==  r=c|t}|jr>t||j\}}|r$|j|}|rt ||}|d|fS|||\}}}} |dt|t| z } t| dkr4| s2td|d|j j d| | dfS)zX Solve the lookup type from the lookup (e.g.: 'foobar__id__icontains'). rVrrTzInvalid lookup "z " for model ".F) rrrrr names_to_pathrrr rr) r|lookuprlookup_splittedr expression_lookupsrr9r lookup_parts field_partss r;solve_lookup_typezQuery.solve_lookup_type s!,,z22   :-<!1.. *J* :!-j9 =!$Z!*>\ARAR*R&RS |  q  *664==??0999; [%//r=ct|dr6t|jj||st d|d|jddSdS)z Check whether the object passed while querying is of the correct type. If not, raise a ValueError specifying the wrong object. rzCannot query "z ": Must be "z " instance.N)rFrrrrb object_name)r|rrArs r;check_query_object_typezQuery.check_query_object_type$sn 5' " " 1%+2CT5QQ  juud...0    r=c~|jrt|trG|js@t |j||s*t d|jjjd|jdt|dr| |||dSt|dr|D]}| |||dSdSdS)z3Check the type of object passed to query relations.zCannot use QuerySet for "z": Use a QuerySet for "r&rrN) rrEr0has_select_fieldsrrrbrr/rFr0)r|rrrAvs r;check_related_objectszQuery.check_related_objects0s   A5%(( A/ A7u{D%PP A !j{(444d6F6F6FH(( A,,UD%@@@@@ ++ AAAA00D%@@@@' A A" A AAAr=ct|dr-t|ddst|jjdzt|dr,|D]}||dSdS)z>Raise an error if expression cannot be used in a WHERE clause.rL filterableTz$ is disallowed in the filter clause.rdN)rFrrrrrdcheck_filterable)r|rrHs r;r7zQuery.check_filterableGs :3 4 4 W  d> >  $$-1  :7 8 8 ,"99;; , ,%%d++++ , , , ,r=c |pdg^}}|D]}|||}||}|s1|||}d}||}|sdS|||}|j9|js2|dvrt d|d|dS|dkrF|jdkr;t t jjr|d|dS|S)a1 Try to extract transforms and lookup from given lhs. The lhs value is something that works like SQLExpression. The rhs value is what the lookup is going to compare against. The lookups is a list of names to extract using get_lookup() and get_transform(). exactN)r9iexactz Cannot use None as a query valueisnullTr) try_transform get_lookuprQcan_use_none_as_rhsrbrr r!interprets_empty_strings_as_nulls) r|lookupsrPrQ transforms lookup_namer6 lookup_classr(s r; build_lookupzQuery.build_lookupTs?$+#7wi [ 0 0D$$S$//CC~~k22  $$S+66C!K>>+66L c3'' : f&@ "555 !CDDD+3>>(++C66 6 7 " " b  ,-6X!,3>>(++C66 6 r=c*||}|r ||S|jj}tj||j}|rdd|z}nd}td|d|jd|)z Helper method for build_lookup(). Try to fetch and initialize a transform for name parameter from lhs. z, perhaps you meant %s?z or rezUnsupported lookup 'z' for z# or join on the field not permitted) get_transformrrdifflibget_close_matches get_lookupsrjr r)r|rPr6transform_classrsuggested_lookups suggestions r;r<zQuery.try_transforms ++D11  "?3'' '+5L ' 9c&2244!! ! !6EV9W9WW  *!%|'<'<'z%Query.build_filter..s<   !QY]]1a=P=P9P9PA9P9P9Pr=)r! allow_manyNrr;rrV)2rErr r_add_qrFrrrLrrDr,r(r-r7rrrarrrr*rrrr4rlrArn _lookup_joinsr' split_excludenames_with_pathr trim_joinsrmrorrrrBrQ is_nullablerrsr!r=r,rr)r| filter_exprrNrOr!rrPr7rr conditionargrr@partsreffed_expression used_joinsrArrWrerm join_listrB lookup_typeclause require_outerrCrUs @r; build_filterzQuery.build_filtersJ k4 ( ( CABB B k1 % % ;;- /&'%!1#"3    ; 4 5 5 =; u== W UVVV#66+Y)7Ii00 J --wiDII i[C888"< < U D  Q((#% )I%** $U   & &y'OPP P P P P P P Q )/***$(OO  y % % !     Y ' ' '  , J7||q  mmGAJ 0EuMM$7I$5y7L-- I,A5IIC%%gsE:: + I;#666 8 # U (= UoBU   @((IMU,B,B ) Mh&&$$WQZ00>~im4>&HH#*1:#8#8#B#BL-- I4Ea4H%PPCJJ||C77===eS))@d.>.>u|.L.L@#(<#:#:8#D#DLJJ||E5993???>zzB>>s$A+J KJ;5K;KcN|t||fdSr4)add_qr)r| filter_lhs filter_rhss r; add_filterzQuery.add_filter<s' 1j*-../////r=cfdjD}|j\}}|r j|t |dS)zo A preprocessor for the internal _add_q(). Responsible for doing final join promotion. cJh|]}j|jtk| SrVrr)r9rZr|s r;rVzQuery.add_q..Js4   ):)D)M)MA)M)M)Mr=N)rrXrrr,r(r)r|q_objectexisting_innerrgr9s` r;rkz Query.add_q?s    ~   KK$*;<<   ( JNN63 ' ' ' .)))))r=c<||ddS)NF)rr)ri)r|r^s r; build_wherezQuery.build_whereRs   % @@CCr=c,t|_dSr4)r,rrs r; clear_wherezQuery.clear_whereUs[[ r=c |j} ||jz}|p|j}t| |j} t|jt |j|} |jD]P} || ||||||||  \}}| ||r| || Q| r| |}ng}| |fS)z%Add a Q-object to the current filter.)rirj)r!rNrOrrPr7rr) rirjr,r{rrMrir|r,r)r|rqrrNrOrrPr7rrri target_clauserrI child_clause needed_inners r;rXz Query._add_qXs& 8++';8+;!Ix?OPPP #  H$5 6 6  & ; ;E)-):):&- /'%!1#"3*; * * &L,  " "< 0 0 0 ;!!, :::  '99$??LLLl**r=c 6||_||j\}}}|rtd|jzt |jD]}||\}}}|sdnd} |d| } t | D]Z\} } t|| kr(|| | krtd|jd|d@td|d|jdt|j||j|_||j |j<dS) NzAFilteredRelation's relation_name cannot contain lookups (got %r).rprTzCFilteredRelation's condition doesn't support relations outside the z (got z).zaFilteredRelation's condition doesn't support nested relations deeper than the relation_name (got z for ) rr-rrbrGr_rrr^r) r|rrrelation_lookup_partsrelation_field_partsr9r(r+lookup_field_partsshiftlookup_field_pathidxlookup_field_parts r;add_filtered_relationzQuery.add_filtered_relations"'9=9O9O  +: : 63Q ! /=> **;*EFF  F262H2H2P2P /L,a)0AAqE 27UF7 ; *34E*F*F  &&+,,s22+C04EEE(j 1>>>HF%*#)&&*;*I*I*IK ';  +   '' ' # =N !2!8999r=c gg}}t|D]P\}}|gf} |dkr| |jj}d} d} |t||} n#t$r||jvr|j|j} n||jvr|dkr|j|} t| j vrZ| j t} | | |||\} } }}| | ddn|| j } YnwxYw| E| j r| jstd|z | jjj}nv#t&$rd}YnhwxYw|dz}|dks|rTt)gt+||j|j}td|dd |n|]||jurT||}|r=| || d ||dj}t3| d r| r| | }n| j}|sjt|D]Z\}}|jrN| d |d|dz|| t=|dz|[|d}| ||j}|j}|j }| d ||| | }| f}|r5|dztC|krtd ||dzd |d |||||dzdfS)a Walk the list of names and turns them into PathInfo tuples. A single name in 'names' can generate multiple PathInfos (m2m, for example). 'names' is the path of names to travel, 'opts' is the model Options we start the name resolving from, 'allow_many' is as for setup_joins(). If fail_on_missing is set to True, then a name that can't be resolved will generate a FieldError. Return a list of PathInfo tuples. In addition return the final field (the last used join field) and target (which is a field guaranteed to contain the same value as the final field). Finally, return those names that weren't found (which are likely transforms and the final lookup). r)NrrzField %r does not generate an automatic reverse relation and therefore cannot be used for reverse querying. If it is a GenericForeignKey, consider adding a GenericRelation.rTzCannot resolve keyword 'z' into field. Choices are: , path_infosCannot resolve keyword z into field. Join on 'z' not permitted.)"rr)r6r rr{rrrrrr'rrrr rrrAttributeErrorsortedrBrjget_path_to_parentto_optsrF get_path_inform2mrr'r target_fieldsr)r|namesrArWfail_on_missingror[rr6cur_names_with_pathrrrafiltered_relation_pathr9r availablepath_to_parent pathinfos inner_posplastrlrms r;r'zQuery.names_to_pathss!#Bo"5))a a IC#'* t|| 0w|E $  P<++t,,$ P P P4111 248EEET555#(((,(@(F%!%6%DDD 1 ? E Ej Q Q>B>P>P! &+ ??;.q!  $:3B3$?@@@@ $/@/N O O P  $U-@$47;; !!K-.final_transformerAs$? =='' 'r=NrrT)rrTc |||}||S#t$rttrrwxYwr4)r<r rEr)rrr6previouswrappedrllast_field_exceptionr|s r; transformz$Query.setup_joins..transform_sm&hue44G--gt<<<!!+u55:N22 s !%%A )r6r)rru)rangerr'r functoolspartialhas_transformsrrrrdirectr]r join_classrr rrjrrk)r|rrArr!rWrnrpivotrormrestrAexcr6rrjrrrrrrlrs` @@r;rzQuery.setup_joinssCF  ( ( ( ( ( $3u::q"--  E 373E3E&5&M$( 4F440k7D #566]  / / /A::+.((((((  / 4 4D       !* 1/@!!! 04  , ,  D% #$($:$@$@$B$B!/5 $(!" + A99A>c|dd}tt|D]\}}t|dks|jsn|jrnd|jjD}d|D|sn[fd|jjDtfd|D}| | ||d|fS)a The 'target' parameter is the final field being joined to, 'joins' is the full list of join aliases. The 'path' contain the PathInfos used to create the joins. Return the final target field and table alias and the new active joins. Always trim any direct join if the target column is already in the previous table. Can't trim reverse joins as it's unknown if there's anything on the other side of the join. NrTch|] }|j SrVcolumnr9ts r;rVz#Query.trim_joins..sUUUAHUUUr=ch|] }|j SrVrrs r;rVz#Query.trim_joins..s55518555r=cVi|]%}|djv|dj|d&S)rTrr)r9r cur_targetss r;rz$Query.trim_joins..s@Q4;+--! QqT---r=c32K|]}|jVdSr4r)r9r targets_dicts r;r<z#Query.trim_joins..s*DDqL2DDDDDDr=r) rreversedrrrrforeign_related_fieldsissubsetrelated_fieldsrNr~r) r|rmrnrorinfo join_targetsrrs @@r;r\zQuery.trim_joinss%aaa"8D>>22 * *IC5zzQdk% UUdo.TUUUL55W555K'' 55 7L DDDDGDDDDDG   UYY[[ ) ) ) )b 5((r=c#nK|D]}t|tr|V|r9tt|ddr|Ed{VWt |drH|st|t r||||Ed{VdS)Nrrd)rr ) rErcallablerrrFrr-rd)clsrrr rHs r;r-zQuery._gen_colss   D$$$  ! h1488''  113333333333788 # 4(=(===//11%5!-)  r=c#TKd||DEd{VdS)Nc3$K|] }|jV dSr4)r)r9rHs r;r<z)Query._gen_col_aliases..s$@@4DJ@@@@@@r=)r-)rrs r;_gen_col_aliaseszQuery._gen_col_aliasess>@@3==+?+?@@@@@@@@@@@@r=c|j|}||sH||gD]1}t|j|t rt d2|r6||jvrt d|zt||j|S|S| t}|j|d}|%|ddD]}| ||}|S| || ||} || j| j| j\} } } |s"t'| dkrt dt'| dkrt d| | d| }||| |S)NrRzCCannot aggregate over the '%s' alias. Use annotate() to promote it.rrT)r!z?Referencing multicolumn fields with F() objects isn't supported)rr.rrErr&r r{rrrr<rrr*r\rmrnrorrpr) r|r6rrrr r field_listrrrm final_aliasres r; resolve_refzQuery.resolve_refs*%))$//  ! !22J<@@E!$."7>>(U " t555$)+/04!7!=>>>!!J//J)--jm<>A#5#5 M7||a U "44WQZMMI  Y''' r=ct||j}|j|_|\}}t|trt |}n)t|t rt |j}||||d| |\}}|j d} | j } | j } | |vr| jj j} ||| d} | | |j dj | | }|j|t(d|j| <nN| d} | | t-|}|j|t(|t1|\}}|r<|d|zdfdd|\}}||t2||fS)a When doing an exclude against any kind of N-to-many relation, we need to use a subquery. This method constructs the nested query, given the original exclude filter (filter_expr) and the portion up to the first N-to-many relation field. For example, if the origin filter is ~Q(child__name='foo'), filter_expr is ('child__name', 'foo') and can_reuse is a set of joins usable for filters in the original query. We will turn this into equivalent of: WHERE NOT EXISTS( SELECT 1 FROM child WHERE name = 'foo' AND child.parent_id = parent.id LIMIT 1 ) Tr rr9z %s__isnull)rOrNr!)rrrrErrr6rnr' trim_startrrrrr)rzr=rrr,r(rrrirr))r|r^r!r[rrlrmtrimmed_prefixcontains_louterrB select_fieldrr)rCr(r_rzor_null_conditionr9s r;rZzQuery.split_excludes.(tz**$($<!!, J j( + + 3!*--JJ  A & & 3!*/22J Z000 4(((+0*:*:?*K*K'l1oz   I  #),B   d # # #'227;;L"\"**U\!_-B"C"CRZZPUEVEVWWF KOOFC ( ( (,0E "5 ) )'227;;L!\#'7'G'GHHF KOOFC ( ( ("&"3"3F5MM"B"B <  1#'#4#4.5 $## $5$$ q MM+R 0 0 0 ,&&r=c|jtt|jD]}|dSr4)rr,r+r(r set_empty)r|rs r;rzQuery.set_empty8sK {}}c****  E OO      r=cHtd|jjDS)Nc3@K|]}t|tVdSr4)rEr+)r9rgs r;r<z!Query.is_empty..>s,KK!:a--KKKKKKr=)rrrMrs r;is_emptyzQuery.is_empty=s$KKtz7JKKKKKKr=c>|9|j#t|j|j|z|_n|j|z|_|9|j#t|j|j|z|_n|j|z|_|j|jkr|dSdS)a Adjust the limits on the rows retrieved. Use low/high to set these, as it makes it more Pythonic to read and write. When the SQL query is created, convert them to the appropriate offset and limit values. Apply any limits passed in here to the existing constraints. Add low to the current low value and clamp both to any existing high value. N)ryminrxr)r|lowrYs r;r_zQuery.set_limits@s  ~)!$T^T]T5I!J!J!%!5 ?~) #DNDMC4G H H $  3 =DN * * NN      + *r=c$d\|_|_dS)zClear any existing limits.rsNrxryrs r;r/zQuery.clear_limitsWs(/% t~~~r=c*|jdkp|jduS)Nrrrs r;r!zQuery.is_sliced[s}!?T^4%??r=c:|jduo|j|jz dkS)NrT)ryrxrs r; has_limit_onezQuery.has_limit_one_s#~T)St~ /MRS.SSr=c|j S)z Return True if adding filters to this instance is still possible. Typically, this means no limits or offsets have been put on the results. )r!rs r; can_filterzQuery.can_filterbs >!!r=cd|_d|_d|_|d|ddS)z%Remove all fields from SELECT clause.rVFN)rr(rrrrs r;r^zQuery.clear_select_clausejsG !# B   $$$$$r=c"d|_d|_dS)z Clear the list of fields to select (but not extra_select columns). Some queryset types completely replace any existing list of select columns. rVNr values_selectrs r;clear_select_fieldszQuery.clear_select_fieldsrs  r=cJ|xj|fz c_|xj|fz c_dSr4r)r|rBr6s r;add_select_colzQuery.add_select_col{s0 v  tg%r=c<d|_t||_dS)NF)r(rNr)r|colss r;rzQuery.set_selects!Dkk r=c"||_d|_dS)zW Add and resolve the given fields to the query's "distinct on" clause. TN)ryr")r|rs r;add_distinct_fieldszQuery.add_distinct_fieldss + r=c |}|} g}|D]}||t|||}||j|j|j\}} } |D]+} | | | | ,|r| |dSdS#t$rtd|zt$rft|vrtgt||j|j|j} td|dd| wxYw)zu Add the given (model) fields to the select set. Add the field names in the order specified. )rWzInvalid field name: '%s'rz into field. Choices are: rN)r*rrrrr\rmrnrorrprr'r rrBrr{rrj) r|r allow_m2mrrArr6rrmrrnrrs r;r[zQuery.add_fieldss &&((}}$ D# S S!,,JJz**D%I- /3oo%ON//+e &SSFKK < ?? ?   T!!2488/1 !j)-tyy/?/?/?A s B'CB E c g}|D]}t|trp|dkr|d}||jvr=|jr ||jvrN||t|jj n%t|ds| |t|ddrtd|z|rtd|z|r|xj|z c_dSd|_dS) a8 Add items from the 'ordering' sequence to the query's "order by" clause. These items are either field names (not column names) -- possibly with a direction prefix ('-' or '?') -- or OrderBy expressions. If 'ordering' is empty, clear all ordering from the query. ?-rLrFz[Using an aggregate in order_by() without also including it in annotate() is not allowed: %szInvalid order_by arguments: %sN)rEstr removeprefixrrr'rrrrrFrrr rdefault_ordering)r|orderingerrorsitems r; add_orderingzQuery.add_orderingsG  D$$$ $3;;((--4+++:$$*"4"4""4::j#9#94:;KLLLLT#788 $ d###t1599  :<@A   H=FGG G  * MMX %MMMM$)D ! ! !r=cj|s|js|js|jrdSd|_d|_|r d|_dSdS)a Remove any ordering settings if the current query allows it without side effects, set 'force' to True to clear the ordering regardless. If 'clear_default' is True, there will be no ordering in the resulting query (not even the model's default). NrVF)r!ryr&rrr)r|r  clear_defaults r;r'zQuery.clear_orderingsb  N "2 6:6L  F    *$)D ! ! ! * *r=c|r|jri}i}t|j|jD]%\}}t|tr|||< |||<&i||j|_||t||_t||_t|j}|j D]^\}}| x}s|r+|j s$|t||I||_t||_dS)a? Expand the GROUP BY clause required by the query. This will usually be the set of all non-aggregate fields in the return data. If the database backend supports grouping by the primary key, and the query would be equivalent, the optimization will be made automatically. N)rr3rrErrrrNrrr{rr+rrrrr ) r|rSgroup_by_annotationsrrrHr r  group_by_colss r;r]zQuery.set_group_bysm  6T/ 6$& M"4#5t{CC 7 7 tdC((7+/M%((26(//K"6K$:JKD   ' '(< = = = 4 4 6 677DK!&}!5!5D  $$!%!7!=!=!?!? / / E:%/%A%A%C%CCM  /Z%B /E: 6 67777 ....h r=ct|jtri}n|j}|D]7}|}|tD]}||i}8||_dS)z Set up the select_related data structure so that we only select certain related models (as opposed to all models, when self.select_related=True). N)rErboolrrr)r|fields field_dictrdrs r;add_select_relatedzQuery.add_select_related s d)4 0 0 -JJ,J + +EA J// + +LLr** +(r=c|ri}|rt|}ntg}|D]\} } || t| } g} | d} | dkrV| dks| | dz dkr"| t || d| dz} | dkV| | f|| <|j||s|r.|j t||t|r|xj t|z c_ |r ||_dSdS)zm Add data to the various extra_* attributes for user-created additions to the query. z%srrrT%rpN)rrrrfindrrrrrr,r*r(rrNr) r|r select_paramsrrttablesr select_pairs param_iterr6entry entry_paramsrs r; add_extrazQuery.add_extra s  , L &!-00 !"XX %||~~ ; ; e  &&&E ! jj&&Riiaxx5q>S#8#8$++D,<,<===**T3733CRii',\%: T"" J  l + + +  ;F ; JNN:eV44c : : :  /   v .    +"*D    + +r=c0tdf|_dS)z0Remove any fields from the deferred loading set.TN) frozensetrrs r;clear_deferred_loadingzQuery.clear_deferred_loading> s!*d 3r=c$|j\}}|r||df|_dS||x}r |df|_dS|t ||x}r |df|_dSdS)aj Add the given list of model field names to the set of fields to exclude from loading from the database when automatic column selection is done. Add the new field names to any existing field names that are deferred (or removed from any existing field names that are marked as the only ones for immediate loading). TFN)rrT differencer r>)r|rexistingr new_existingnew_onlys r;add_deferred_loadingzQuery.add_deferred_loadingB s/%  ;$,NN;$?$?$ED ! ! ! (22;???| ;(4e(;%%%++---";//::8DDD8;,4dND)));;r=c8|j\}}t|}d|vrF|d||jj|r||df|_dSt|df|_dS)a  Add the given list of model field names to the set of fields to retrieve when the SQL is executed ("immediate loading" fields). The field names replace any existing immediate loading field names. If there are field names already specified for deferred loading, remove those names from the new field_names before storing the new names for immediate loading. (That is, immediate loading overrides any existing immediate values, but respects existing deferrals.) r)FN) rr>remover,rr)r6r r)r|rr rs r;add_immediate_loadingzQuery.add_immediate_loading[ s/%+&& ;     t $ $ $ OODMMOO.3 4 4 4  B%0$:$:8$D$De$KD ! ! !%.k$:$:E$AD ! ! !r=c|d|_n,tt||_d|_dS)z@Set the mask of annotations that will be returned by the SELECT.N)rrrr rr|rs r;rzQuery.set_annotation_masks s< =*.D ' '*.t}}U/C/C*D*DD '(,%%%r=cV|j!|g|j|RdSdSr4)rrrs r;rzQuery.append_annotation_mask{ s>  & 2  $ $%Kt'B%KU%K%K L L L L L 3 2r=cP|d|_nt||_d|_dS)z Set the mask of extra select items that will be returned by SELECT. Don't remove them from the Query since they might be used later. N)rr>rrs r;rzQuery.set_extra_mask s0 =%)D " "%(ZZD "#'   r=c.d|_||d|_|r8|D]}||g}g}g}|js|jst|}nd|_|D]}||j vr| |!||j vr| |@||jvrtd|d|j r8| |t|jj| |||||t)||z|z}n*d|jjjD}t)|}|jdurZ|d|jjjDd|d|nl|jreg}|jD]G} t3| t4r| j|vr|j| j} | | Ht9||_t9||_||ddS)NFTzCannot select the 'z&' alias. Use annotate() to promote it.cg|] }|j SrVrQr8s r;r\z$Query.set_values.. sOOO19OOOr=c3$K|] }|jV dSr4rQr8s r;r<z#Query.set_values.. s$EEqEEEEEEr=rR)rr rr2rrrrr(rzrr{r r'rrrrrrrr\r r[r]rErrefsrNr) r|rrr extra_namesannotation_namesr:selectedr rHs r; set_valueszQuery.set_values s# ##%%%   """!% " . ( (  ''''KK! : .d&6 .#6ll $)!..AD---#**1----d444(//2222d...(*!*** 1V ..qwwz/B/BDJDTUUU#**1----    , , ,  $ $%5 6 6 6 {!:=M!MNNHHOOdj.>.NOOOK --H =D OOEEDJ$4$DEEEu      E  2 2 2  $ $ & & & & ] ,H  & &dC((7TYh-F-F+DI6D%%%%!(OODM";//  T*****r=cjjSjsiSjfdjD_jSjS)z Return the dictionary of aggregate columns that are not masked and should be used in the SELECT clause. Cache this result for performance. Nc>i|]}|jv |j|SrV)r)r9rTr|s r;rz+Query.annotation_select.. s;---(((4#A&(((r=)rrrrs`r;r{zQuery.annotation_select sr  ( 40 0! $I  ( 4----4---D ) 0 0# #r=cjjSjsiSj1fdjD_jSjS)Nc.i|]\}}|jv||SrV)r)r9rTr3r|s r;rz&Query.extra_select.. s3(((AqD. s9   d.@)@)@ADXDXADXDXDXr=rTTrcg|] }|d SrrVr9rs r;r\z$Query.trim_start.. EEEaQqTEEEr=Ncg|] }|d SrrVr&s r;r\z$Query.trim_start..* r'r=c:g|]}|SrV)r)r9r: select_aliass r;r\z$Query.trim_start..6 s%HHHQ<00HHHr=)rrrrrsr!r~rrrrrr6rrjrrget_extra_restrictionrr,r(rrrr)r|r[ all_pathsr9pathsr lookup_tables trimmed_pathsrorrpaths_in_prefixrr6 first_join select_fieldsextra_restrictionrr*s` @r;rzQuery.trim_start s ' $ $HAu   U # # # #    ~   $-Y#7#7 $ $ M4x ~mMA,=>?IVSS"&!-0E   U # # # #_* ') ) )JD$T*Q..  ! !$ ' ' ' s4yy (OOj?BGHHH#88^M-!2C$DE  6 ) )*2N )EE:+DEEEM():;L   ]=9 : : : * @ @mMA$56!! ! 7 0#666 FE:+DEEEM(7L^  E"5)A--(,(=(=N5)4))u% . HHHH-HHHIII..r=cV|jp"|jottjjS)a Check if the given field should be treated as nullable. Some backends treat '' as null and Django treats such fields as nullable for those backends. In such situations field.null can be False even if we should treat the field as nullable. )nullempty_strings_allowedrr rr?)r|rs r;r]zQuery.is_nullable9 s.z  ' Y,-6X r=)T)NNTr4)FNr)F)FFNTTTFT)FFTTTFT)TF)NT)FT)TNF)NN)rrrrrrrrrr$rr&rr(rstandard_orderingrr%rr rrxryr"ryr&select_for_update_nowaitselect_for_update_skip_lockedselect_for_update_ofselect_for_no_key_updaterr2 max_depthrrrr#combinator_allrrrrrrrir}rrr-rrrrrrrrrrrHrLrNrWrcrmrrrrrrr~rrrrrzr*rrjrrr`rLrr+rrr-r0r4r7rDr<rirnrkrtrvrXrr'rr\ classmethodr-rrrZrrr_r/r!rrr^rrrrr[rr'r]rrr rrrrrrr{rzrr]rVr=r;r0r0sL!9l^,,LH JLHFHHHIHO$$)!$NIM"#JNLN" T*L&&&&8LLXL_   <<<     $$$+++Z     ,,, q@q@q@fNNN,&&& 3 3 3 3qHqHqHf,,,,\.666,6(((----###J111&222+ + + Z5 5 5 5 n   KKK4444l###B - - - -:      *0000.   AAA. , , ,,,,\2b?b?b?b?H000***&DDD!!!'+'+'+'+R!N!N!NFr<r<r<r+>+>+@$$X$&  X K/K/K/Z     r=ASCclt|}|ddkr|dd|dfS||dfS)a Return the field name and direction for an order specification. For example, '-foo' is returned as ('foo', 'DESC'). The 'default' param is used to indicate which way no prefix (or a '+' prefix) should sort. The '-' prefix always sorts the opposite way. rrrTN)r")rdefaultdirns r; get_order_dirrCL s@ W D Qx3QRRy$q'!! $q'>r=c*eZdZdZdZdZdZdZdS)r{z] A class to abstract away join promotion problems for complex filter conditions. c||_||_|jr%|tkr t|_nt|_n |j|_||_t |_dSr4)rirjr(r)effective_connector num_childrenrvotes)r|rirGrjs r;r}zJoinPromoter.__init__` s^" < 6C+-((+.(('+~D $(YY r=cP|jjd|jd|jd|jdS)Nz (connector=z, num_children=z , negated=))rrrirGrjrs r;rzJoinPromoter.__repr__o sT~* M Mt~ M M - M M;?< M M M r=c:|j|dS)z` Add single vote per item to self.votes. Parameter can be any iterable. N)rHr)r|rHs r;r|zJoinPromoter.add_votesu s %     r=ct}t}|jD]u\}}|jtkr ||jkr|||jtks|jtkr ||jkr||v||| ||S)a Change join types so that the generated query is as efficient as possible, but still correct. So, change as many joins as possible to INNER, but don't make OUTER joins INNER if that could remove results from the query. ) r>rHrrFr)rGr,r(rr)r|r to_promote to_demoterrHs r;rzJoinPromoter.update_join_types| sUU EE !J,,.. % %LE5'2--%$:K2K2Ku%%%'3..(B..5Drcs  ++++++++--------++++++++++""""""@@@@@@@@FFFFFFFFFF------111111                    *)))))BBBBBB++++++ LKKKKKKKKKKKQQQQQQQQQQQQRRRRRRRRRRRRRR333333666666"""""" J +*+FGG+*955666 8 8 8!!!H :M   F.F.F.F.F.F.F.F.Rj(=>> n% n% n% n% n% Nn% n% n% bK    YYYYYYYYYYr=