+ SR#) N)partial)chain)EmptyResultSet FieldError FullResultSet) DatabaseErrorNotSupportedError) LOOKUP_SEP)ColPairsFOrderByRawSQLRefValue) AutoField composite)CastRandom)Lookup)select_related_descend)CURSORGET_ITERATOR_CHUNK_SIZEMULTI NO_RESULTS ORDER_DIR ROW_COUNTSINGLE)Query get_order_dir)TransactionManagementError)RemovedInDjango70Warningdjango_file_prefixes)cached_property) make_hashable)_lazy_re_compilec8aa]tRt^!toV3RltRtRtVtV;t#) PositionRefc2<Wn\SV` W#4R#N)ordinalsuper__init__)selfr*refssource __class__s&&&&]/var/www/html/data_capital/venv/lib/python3.14/site-packages/django/db/models/sql/compiler.pyr,PositionRef.__init__"s  &c0\VP4R3#)N)strr*)r-compiler connections&&&r1as_sqlPositionRef.as_sql&s4<< "$$r3)r*) __name__ __module__ __qualname____firstlineno__r,r9__static_attributes____classdictcell__ __classcell__r0 __classdict__s@@r1r'r'!s'%%r3r'cna]tRt^*to]!R]P ]P,4tR&Rlt Rt R'Rlt R'Rlt Rt Rt]R 4tR'R ltR tR tR tRtRtRtRtRtRtR(RltR)RltRtR*RltRtRt R+Rlt!Rt"Rt#Rt$Rt%R t&RRR]'3R!lt(R"t)]*R]'3R#lt+R$t,R%t-Vt.R#), SQLCompilerz^(.*)\s(?:ASC|DESC).*cWnW nW0nW@nRR/VnRVnRVnRVnRVnR#)*N) queryr8using elide_empty quote_cacheselectannotation_col_map klass_info_meta_ordering)r-rHr8rIrJs&&&&&r1r,SQLCompiler.__init__1sE $ ':  "&"r3c RVPP RVPPP RVP: RVP : R2 #))r0r=rHmodelr8rIr-s&r1__repr__SQLCompiler.__repr__CsU++,-ZZ%%2234//,GDJJ> D r3Fca\;QJd3V3RlSPP4F 'dK RM( RM$!V3RlSPP44'dSPP4SP VR7wSnSnSn\SP 4Sn R#)c3d<"TF%pSPPV,^8HxK' R#5irNrHalias_refcount).0ar-s& r1 *SQLCompiler.setup_query..Ks'O:NQtzz((+q0:N-0FTwith_col_aliasesN) allrH alias_mapget_initial_alias get_selectrLrNrMlen col_count)r-rcsf&r1 setup_querySQLCompiler.setup_queryJs 3O$**:N:NO333O$**:N:NO O O JJ ( ( *@D-APA = T_d&=T[[)r3c VPVR7VP4pVPPP VPP RJR7wVnVnVnVPW P4p\V4Vn VPVPV,V4pW2V3#)z Do any necessary class setup immediately prior to producing SQL. This is for things that can't necessarily be done in __init__ because we might not have all the pieces in place at that time. rbN) must_group_by) rj get_order_byrHwheresplit_having_qualifygroup_byhavingqualifyget_extra_selectrLboolhas_extra_select get_group_by)r-rcorder_by extra_selectrqs&& r1 pre_sql_setupSQLCompiler.pre_sql_setupRs *:;$$&04 0@0@0U0U**--T91V1 - DK,,X{{C $\ 2$$T[[<%?Jx//r3c VPPf.#.p\4pVPPRJdVPPFp\VR4'gVPP V4p\ V\ 4'dLVPV9d9VPVP4VPVP4KKVPV4K /p\V^R7F<wpwrXp V 'dWvV&W9dKVPVP44K> VP'g9VF2wpwrp V 'dKVPVP44K4 VP'dVPP4MRp V FpVPV4K .p\4pVP!W=4pVP"P$P&pVFpVP)V4wrT'd#TP/T4;pe\1T4RrMTP3Y T 4wr\5T 4pT T3T9gKkTPY34TPT T34K V# \*\,3dKi;i)z Return a list of 2-tuples of form (sql, params). The logic of what exactly the GROUP BY clause contains is hard to describe in other words than "if it passes the test suite, then it is correct". Tr9startr5)rHrqsethasattr resolve_ref isinstancerr.addappendr/ enumerateextendget_group_by_colsrOrrcollapse_group_byr8featuresallows_group_by_select_indexcompilerrgetr6 select_formatr$)r-rLrx expressions group_by_refsexprselected_expr_positionsr*_aliassqlparamsis_refhaving_group_byresultseenrposition params_hashs&&& r1rwSQLCompiler.get_group_bybspL ::   &I  ::  d *  ++tX..::11$7DdC((yy 5%))$))4#**4;;76 &&t,,#%)26)C %G%du07-%   t557 8*D"""/7++sFv&&t'='='?@ 08 >B[[[$++779b#D   t $$u,,[J  OO $ $ A A % D "ll40 -!8!4$/w> ' ' 3s)C8C8".s"'F FDM*'Fsc3*"TF pRV3xK R#5ir)r5)r]cols& r1r_rs.#4+srTrrempty_result_set_value0Trr5)rHrL default_colsget_select_maskget_default_columnsselectedryitemsannotation_selectlistrangerhrrr6 annotationsintrr rTselect_relatedget_related_selectionsrrrrrNotImplementedrr)r-rcrLrNr select_maskcolsrrindexr expression select_idxrretcol_idxrrrrs&& r1rgSQLCompiler.get_selectsH$  JJ%%%$***A*A*ABBjj002 :: " " "++K8D::$$D ::   &'+zz'>'>'D'D'F /.  --335 H! //0 //03t9<MM.7 8K8K8Q8Q8S.T**j#..!%!7!7 !CJ C00!((/!%!1Jj(33 E 34/U !4::#3#3_mTJ/8/B +J+%/E" MM:- .0C :: $ $ $"&"="=f"R 0C, -  ' ' 3 JC C"ll3/ V"//c6B V}!1gY1  JJc6]E2 3'!( ++#" N)01>*&*^;"%rC"&,,u5K/L"MKC  8"ll5;7 V 8s$#M*N:1N:N:N:9N:c # "VPP'dVPPpMVPP'gVPPpM|VPP'dVPPpMIVPP 4;p'd&VP 'dVP pWnM.pVPP'd\R,wr4M\R,wr4/pV'dVP;p'dVPPpVPPp/p \V^R7F_wp wrp \WV 4p V'd)\V \4'gV P!W4pMT pV 'd W9dT MTW\&WV &Ka VEF p\#VR4'Ed\V\$4'd\'WP(4p\V\*4'gVP-4pVPP'g!VP/4pVP14VP3VP44pV'gN\VP4\64'dVP3VP4P84;p'dVP:fVP<e'VP>P@PB'dVP/4pVVnMQVPPD'd6VP/4p\GVPHVPJ4VnVVRJ3xEKVR8Xd\+\M44R3xEK\OW4wppVR8HpVP3V4;p'd\+VVR7R3xEK+VPPPP3V4;p 'dTp.pMN#)(6t$.HEu233eU++ (:(:;E!%11!IIKEzz333!JJLE**,+//0@0@A u//33'5'9'9%:J:J:O:O'PPP ))1e6F6F6N11RRR % +5(... % +.z @Q@Q+R(Zt333|fh'..&u:V ::(((T[[["!C&Z@%GG $66 ++-&3 7 YXsA[12[18[1>[10[1([1*[1>B [1B[1"A[1%A [12A[143[1(C [16A[1?[1[1-[15[1C)[1=C[1[1A [1#[/$ [1c .p\4pVP4EFJwr4VPVPRRR7pV'EgVPP'EdVP 'Ed{VP pVP pVP Fwrp Wh8XgKVPP'dCWPP9d)\V\4'dWP8XgKlTP\V 'dT MVPPV4.4M \!VPP 4^,p RV 2p VPP"F1p V P'd \%R4hV P'Wz4K3 VPP)WZ4VP\W4.4VP+V4wrVP,P/V 4^,p\1V4pVV3V9dEK#VP3VV34VP5W]W334EKM V#)z Return a list of 2-tuples of the form (expr, (sql, params, is_ref)) for the ORDER BY clause. The order_by clause can alter the select clause (for example it can add aliases to clauses that do not yet have one, or it can add totally new select clauses). TN) allow_joinsreuse __orderbycolz:ORDER BY term does not match any column in the result set.)rrrrHrrLrhas_select_fieldsrrr rset_source_expressionsrrcolumnrhcombined_queriesradd_annotationadd_select_colrordering_partssearchr$rr)r-rrrrresolvedsrcexpr_srcsel_exprr col_alias order_by_idxqrrwithout_orderingrs& r1rnSQLCompiler.get_order_bysu 002LD..tzztSW.XH6djj333 ))??.2kk*H!JJ888 )ZZ-I-I I *8Q 7 7IqA '/K +.$6 HH& 4 5 MM86%:; <_3` r3cf.pVPP'dVPP'grVUu.uF qD^,NK ppVFTwpwrxp VPP V4^,p V 'dK5W3V9gK?VP WjV3R34KV V#uupiN)rHdistinctrrrr) r-rxrLryt select_sqlrrrrr s &&& r1rtSQLCompiler.get_extra_select/s ::   tzz'A'A'A(./1A$$J//7++sF#'#6#6#=#=c#B1#E v#3"LIMIT/OFFSET not allowed in subqueries of compound statements.z:ORDER BY not allowed in subqueries of compound statements.Nunion differenceFz ALLz{}({})c3N<"TFwrSPV4V3xK R#5ir))format)r]rrbracess& r1r_1SQLCompiler.get_combinator_sql..s! @%YSv}}S!4(%"%z {} )r8rrHr get_compilerrIrJ%supports_slicing_ordering_in_compound is_slicedrrnr_get_combinator_part_sqlrrhr set_operatorssubqueryzipr)joinr)r-rrdrrH compilersr7partsempty_compilercombinator_sql sql_parts args_partsrrpartr*s&&& @r1get_combinator_sqlSQLCompiler.get_combinator_sqlXs??++44 4   tzz4??D>+++'X((**'T &!H  T::8DE" Z1_w!64::;O;O;O */N & LL66~F G,,:::F :( f $Nzz"""x'U'U'UF # @% @!  --/44Y?@D MM$ ~c &" (Z<-GE%-N  s:H+ H00 IIIcVPPpVPPpVeSVPPf;VPP 4VnVPP V4VP RR7wrEVPP'diVP'gRPV4pWE3#VPP'gVP'gRPV4pWE3#VPP'd$VP'dRPV4pWE3#)NTrbzSELECT * FROM ({})r') r8rrHrclone set_valuesr9r supports_parentheses_in_compoundr)r2r.)r-r7rrpart_sql part_argss&& r1r0$SQLCompiler._get_combinator_part_sqls??++::&&  HNN$;$;$C%^^113HN NN % %h /&ootoD >> $ $ $<<</66x@""  ###EEE!==2""ZZ X%S%S%S}}X.H""r3c@aaaaa.pVP'dVPVP4VP'dVPVP4VPP 4oRSnSPP V4SnVPRR7^,UUUu/uFwr#qBVbK upppo\SP44o\4o/oVVVVV3RlpV!\VPP444VPPSP4UUu/uFwr$V\WB4bK upp4Vn .pVP!4FfvrsV!VP#44TPTPSP4UUu/uFwr$V\WB4bK upp44Kh SP%VP&VP(VP*R7pVP-RRR7wrVP/VP4wrRV RVP(P0P3R4R V .p S'dSP4Uu.uF'q@P(P0P3V4NK) ppR R P5V4R .V ORNVP(P0P3R 4Np \V 4V ,pV'dd.pVF9pVP/V4wppVPV4VP7V4K; V P7RR P5V4.4W3#uupppiuuppiuuppiuupi)Trbc<V'dVP4pVS9dK!SPV4;p'dVSV&KA\V\4'd"VP VP 44Kx\V\ 4'd5VPS9d"VP VP 44KK\S4pRV 2pSPV4SPW4VSV&KR#)qualN) poprrrrget_source_expressionsrr.rhrr) rr select_aliasnum_qual_alias inner_query qual_aliases replacementsrLselect_aliasess & r1collect_replacements9SQLCompiler.get_qualify_sql..collect_replacementss"(<'%+ZZ%55\5)5L&f--&&t'B'B'DEc**yy6#**4+F+F+HI7&)%6N%).)9#:L $$\2..tB)5L&!r3)r8rJF) with_limitsrcSELECT * FROM ()rsWHERESELECT, zFROM ( qualify_maskzORDER BY)rorrrrHr?r2r0rgrvaluesrrsleavesreplace_expressionsrrrnrIr-rIr8rJr9rrrr4r)r- where_partsrrrrPrx order_by_exprinner_query_compiler inner_sql inner_params qualify_sqlqualify_paramsrrr ordering_sqlsr ordering_sqlordering_paramsrLrMrNrLrOs& @@@@@r1get_qualify_sqlSQLCompiler.get_qualify_sqls= :::   tzz * ;;;   t{{ +jj&&( # '--77 D  /3ooto.TUV.W .WNDU%K.W V]]_-u   6 6& T$,,"5"5"789||777C7I7I7K L7K T3u# #7K L  !%!2!2!4 M !E!E!G H OO11?K?Q?Q?ST?S T3u++?ST "5 +77 JJ4??@P@P 8 #7"="=" #>#  '+ll4<<&@#    OO   * *9 5     HN}}WeOO''2259DW $    ##..~> Fl#n4 M$04 X0F- o$$\2 o.% MM:tyy'?@ A~c 8 MU4XsNN N-Nc .VPPP4pVPPpTP T;'g \ V4R7wrVpRpT;'dVPP p VPPpVPPp V'de\V RPV44'g\RPV44hVPW@PP4wrEM@VP'dVP4wrRpEMVP!4wrVP#4wppVP$eVP'VP$4MR.3wppVP.eVP'VP.4MR.3wppR.p .p VPP0'd;VPP2P5V V4wppV V, p W, p .pVP6V,F`wpwpppV'd-V: RVPP2P9V4: 2pV P;V4VP=V4Kb V R P?V4., p V'dV R .VO, p MMVPPP@'d(WPPP@., p V P;V4VPPB'EdV PD'EdVPPG4'dV PH'd \KR 4hV 'dV PL'g \R 4hVPPNpVPPPpVPPRpVPPTpV'dV PV'g \R 4hV'dV PX'g \R4hV'dV PZ'g \R4hV'dV P\'g \R4hVPP2P_VVVPa4VR7pV'd$V Pb'dV P=V4V'd*V P=RV,4V P;V4.pVF(wp p!VP=V 4V P;V!4K* V'd}V 'd \eR4hT;'g%VPP2Pg4pV P=RR P?V4,4VPh'dRpV'deV'g4V P;VPP2Pk44V P=RV,4V P;V4VPPl'dtV Po^VPP2Pp!VPPlP3/VPPlPrB4V'd.p"VF,wpwp#p$pV"P=V#4V P;V$4K. RR P?V"4,p%V'dV Pt'd R.V ORNV%Np MV P=V%4V 'd^V P=VPP2PwVPPxVPPz44V'd$V Pb'gV P=V4VPP|'EdNV'EdE.p&.p'\VP6^R7Fwp(wp)ppV'daV&P=VPP2P9R4: RVPP2P9V4: 24KrV)PV)PR/4p*V*PWP4wp+p,V&P=V+4V'P;V,4K RR P?V&4: RRP?V 4: R2\V'V ,43VPPV4#RP?V 4\V 43VPPV4# \(dTP*'dhR.ppEL0\,d R.ppELAi;i \,d R.ppEL&i;i TPPT4i;i) z Create the SQL for this query. Return the SQL string and list of parameters. If 'with_limits' is False, any limit/offset information is not included in the query. rbNzsupports_select_{}z-{} is not supported on this database backend.z0 = 1rVz AS rWFROMz:select_for_update cannot be used outside of a transaction.zNLIMIT/OFFSET is not supported with select_for_update on this database backend.z1NOWAIT is not supported on this database backend.z6SKIP LOCKED is not supported on this database backend.z8FOR UPDATE OF is not supported on this database backend.z+>+P+P+RHMM-$))H2E"EF***#'# doo&9&9&H&H&JKMM+"67MM(+zz&&& OO''<< //66**1199/7+A+xOOE*MM(+08 -tyy/BB ("N"N"N/L&L#L|LFMM,/  OO''88 ++TZZ-A-A x'E'E'E o.zz"""||!  1:4;;a1P-E-FAu#**!% 3 3 > >z J $ 3 3 > >u E(.'='=#\\:6( 0g7Ag70 g7:g7A7g7:A:g75Ag7 g7"g7>A$g7#g75-g7#g7,D(g70g7'gg g7 ggg7gg7!g40g73g44g77hNc .pVf!VPP4;pfV#T;'gVPP4pRV/p\\P !V44pVP FpVPPPp WP8XdRp V'dAV e=\VPPV PP4'dK}V'd W9dKVPPW9W&4p VPV 4p VPV 4K V#)a  Compute the default columns for selecting every field in the base model. Will sometimes be called to pull in related models (e.g. via select_related), in which case "opts" and "start_alias" will be given to provide a starting point for the traversal. Return a list of strings, quoted appropriately for use in SQL directly, as well as a set of aliases used in the select statement (if 'as_pairs' is True, return a list of (alias, col_name) pairs instead of strings as the first component and None as the second component). N)rHrrfrrunnestconcrete_fieldsrT_metaconcrete_model issubclassjoin_parent_modelget_colr) r-r start_aliasoptsrr seen_modelsselect_mask_fieldsrrTrrs &&&&& r1rSQLCompiler.get_default_columnss < ++--6 !CCTZZ%A%A%C [)  !1!1+!>?))EKK%%44E "%%%44ekk6P6Pu>JJ00kWE]]5)F MM& !/*0 r3c <.p.pVPP4pVPPFpVP\4pVP WSR4wrgrrp VPP WyV 4wrxpVFp W@PP9d7VPVPPPV44KSVPV !W44wrVPV 4VPV4K K W3#)z Return a quoted list of fields to use in DISTINCT ON part of the query. This method can alter the tables in the query, and thus it must be called before get_from_clause(). N) rHrrrr _setup_joins trim_joinsrrr8rrr)r-rrrrr6rtargetsrjoinspathtransform_functionrrps& r1ruSQLCompiler.get_distinctszz""$JJ..DJJz*EDHDUDUTE AAd/A!% 5 5gd K GA!::777MM$//"5"5"@"@"FG<<(:6(IJDAMM!$MM!$ " /~r3c  Raa\SV4wopVR8HpSP\4pSPWV4wp p pp p pp V P'EdVP 'Edt\ V RR4VR ,8wEdZSR8wEdR\ V RR4'Eg>T;'g \4p\;QJd.V3RlV 4FNK 5M!V3RlV 44pW9d \R4hVPV4.pVP Fp\VR 4'd?\V\4'g)V'dVP4MVP4p\V\4'd-VP!VP#S \ 24R34KVP%V3R lSP'VW#We444K V#SP(P+WV 4wrpV Uu.uFp\V !VV4VR 7R3NK up#uupi) z Return the table alias (the name might be ambiguous, the alias will not be) and column name for ordering by the given 'name' parameter. The 'name' is of the form 'field1__field2__...__fieldN'. rattnameNpkhas_transformsFc3t<"TF-p\SPPV,RR4xK/ R#5i) join_colsN)rrHre)r]jr-s& r1r_1SQLCompiler.find_ordering_name..Ys/MR ,,Q/dCCUs58z!Infinite loop caused by ordering.rc3^<"TF"wrVPS \ 24V3xK$ R#5ir))prefix_referencesr )r]rrrs& r1r_rks7) ++tfZL,ABFK)s*-r)rrr r is_relationrrrrrrrrr descrrrrrrHr)r-rrrr already_seenrrpiecesrrrrr join_tupleresultsitemrrsff&&&& r1rSQLCompiler.find_ordering_name7s$D-8 ef_ J'   fE 2            y$/6":= .0@%HH(0035LMRMRJ) !DEE   Z (G 4!566z'@@+5499;$((*DdG,,NN//4& 0EFN(,(?(?d5)& N JJ11'$G '51j I5 Q   sH$c T;'gVPP4pVPPWV4wrEr&rxVR,pWEW6WrV3#)z Helper method for get_order_by() and get_distinct(). get_ordering() and get_distinct() must produce same target columns on same input, as the prefixes of get_ordering() and get_distinct() must match. Executing SQL where this is not true is an error. r)rHrf setup_joins) r-rrrrrrrrs &&&& r1rSQLCompiler._setup_joinsxsZ77557@D @V@V %A =Tb uT9KKKr3c n.p.p\VPPP44F_wr4VPPV,'gK*VP V4wrVVP V4VPV4Ka VPPFpVPPV4wr8W0PP9g%VPPV,^8XgK^VP RVPV4,4K W3#)a Return a list of strings that are joined together to go after the "FROM" part of the query, as well as a list any extra parameters that need to be included. Subclasses, can override this to create a from-clause via a "select". This should only be called after any SQL construction methods that might change the tables that are needed. This means the select columns, ordering, and distinct must be done first. z, %s) rrHrerr\rrr extra_tables table_aliasr) r-rrr from_clause clause_sql clause_paramsrrs & r1rvSQLCompiler.get_from_clauses#( (<(<(B(B(D"E E::,,U33(, [(A %J MM* % MM- ( #F ((Azz--a0HE ZZ111::,,U3q8 ftu'==>)~r3c |aaVV3Rlp.p V'gVSPP8dV #S'g5SPP4oSPP4p\ 4p VfC\ SPP \4pV'dSPP pRp SPEF-p V PV P4V'dVPV P/4p V P'gUV 'gV PV9d<\RV P: RRPV!44;'gR: 24hMRp \WWb4'gKVPV 4;'g/pR V P P"R T R RR V P$R V P&'dV P P$MRRR/pV P)V4.pSPP+V P.SV4wpppVR,pSP-VVV P P"P.R7pVF0pVP)\1V44VP)VR34K2 VVR&SP3VVV P P"P.VV^,V V4pV !VV4EK0 V'Ed1SP4Uu.uFNpVP6P&'gK!VP8'dK5VVP6VP:3NKP ppVEFwppp\VVVV4'gKVPV4;'g/pVP=4pV PV4SPP+V.SV4pVP>R,p\AVSP"4;'dVSP"JpR VR VR RR VP$R VP$RV/pV P)V4.pSP-VVVP.SP"R7pVF0pVP)\1V44VP)VR34K2 VVR&VPV/4p SP3VVVP.VV^,V V4pV !VV4EK RpRp Rp!\CV4EFp"V^8dEMV"SPPD9gK+V PV"4SPP+V".SV4wp#pp$ppV$P"pVR,p\AVSP"4;'dVSP"JpR TR T#R RR \1V4^8:d \GVV#4MT R \GV!V"4RV/pV P)V4.pVPV"V#34;'g/p%SP-V%VVP.SP"R7pVF0pVP)\1V44VP)VR34K2 VVR&VPV"/4p&SP3VV%VP.VV^,V&VR7pV !VV4EK \ V4PIV 4p'V''dJRV'4p(\RRPV(4: RRPV!44;'gR: 24hV #uupi)z Fill in the information needed for a select_related query. The current depth is measured as the number of connections away from the root model (for example, cur_depth=1 means we are looking at models with direct connections to the root model). c<RSP4pRSP4p\WSPP4#)c3`"TF$qP'gKVPxK& R#5ir))rrr]fs& r1r_QSQLCompiler.get_related_selections.._get_field_choices..sKk]]faffks..c3"TF=pVPP'gK!VPP4xK? R#5ir))runiquerelated_query_namers& r1r_rs4-A77>>-**,,-s A"A)fieldsrelated_objectsrrH_filtered_relations)direct_choicesreverse_choicesrr-s r1_get_field_choices>SQLCompiler.get_related_selections.._get_field_choicessDKdkkKN--O 1O1O r3NcWR&R#)rNr5)rNrs&&r1get_related_klass_infosCSQLCompiler.get_related_selections..get_related_klass_infoss 0C, -r3z/Non-relational field given in select_related: 'z'. Choices are: rWz(none)FrTrreverse local_setter remote_settercR#r)r5)xys&&r14SQLCompiler.get_related_selections..sRVr3r)rrrT)rrrcPV'dVPPW!4R#R#r)) remote_fieldset_cached_value) final_fieldobjfrom_objs&&&r1r8SQLCompiler.get_related_selections..local_setterHs,,==hLr3cR#r)r5)rrs&&r1local_setter_noop=SQLCompiler.get_related_selections..local_setter_noopMsr3c\W V4R#r))setattr)rrrs&&&r1r9SQLCompiler.get_related_selections..remote_setterPs ,r3)r root_alias cur_depth requested restrictedc34"TFpRV,xK R#5i)z'%s'Nr5)r]ss& r1r_5SQLCompiler.get_related_selections..s!G6F&1**6Fz/Invalid field name(s) given in select_related: z. Choices are: r)%rH max_depthrrfrrrdictrrrrrrr4rrrTrrrrrrrhrrr many_to_many related_modelrrrrrrr&))r-rLrrr r r r rr fields_foundrrnextrelated_select_maskrNrrrrcolumnsrnext_klass_infosorelated_fieldsrelated_object related_fieldrTrelated_field_name join_inforrrrrr join_optsfield_select_masknext_requestedfields_not_foundinvalid_fieldss)f&&f&&&& r1r"SQLCompiler.get_related_selectionss" !i$***>*>>& &::&&(D557Ju  #DJJ$=$=tDJ JJ55  DA   QVV $ }}QVVR0}}}qvv2(!" $ *<*> ? K K8 K )!PP"-//!"4":": --5 2 278xxxANN33EVu J & &z 2M#'::#9#9166(D*#U Aq!UAq"IE..#Q^^=Q=Q=W=W/G$$S[1 sDk*+8J '#::#$$**A    $J0@ Akn :---A77>>.*+...AGGQ__--  9G4 u-"  &1oon&E&K&K#%2%E%E%G"  !34 JJ22'($  "+( ;WWTZZ@W U]t"N$C$C#]%C%C!;  $**:6 " 22' % $ 3 #C!((V5MM3+.#/< ?+ }}%7<#'#>#>'KKM$ ( 4DEa9Gd M   -Yq=4::999 $$T*=AZZ=S=Sj>:KIua&OOE!"IE"5$**5QQ%tzz:Q  !4&"5zQ$L+>!2')E%{ "J(..z:$&M(3{8K(L(R(RPR%"66)$)"[[$(JJ 7G '%,,S[9 sDk2 '3@J/%.]]4%._get_parent_klass_infos'066EEN-;-A-A-I-I-O-O-Q) *00<< \[u#,6,G&,GL!KK 5a8??EEU#{{<8;BBHHKW % ,G&  .R &sA/C62A(C1C1%C6c<VR,PPpVR,FRpSPV,^,PPV8XgK8SPV,^,u# R#)z Find the first selected column from a model. If it doesn't exist, don't lock a model. select_fields is filled recursively, so it also contains fields from the parent models. rTrN)rrrLrrT)rNrr-r-s& r1"_get_first_selected_col_from_modelZSQLCompiler.get_select_for_update_of_arguments.._get_first_selected_col_from_modelsc(066EEN *? ; ; ;;|,Q/66<<N;;|4Q77!._get_field_choices..s&H :&&Hc3,<"TF pSV3xK R#5ir)r5r5s& r1r_r6s&O :&&Or7r) collectionsdequerNpopleftrrr r4rr)queue parent_pathrNrrr.r-s @r1rJSQLCompiler.get_select_for_update_of_arguments.._get_field_choicess%%doo'>&?@E*/--/' &D L&w/E!),, % 2 25[5%**5D$//$// &OA|). J1u%(?S_$%)__%8%8%J%J:%V"#-#?#?#P %)9%7%JJ$WJMQQ& r3c#"VPp\VP44p\\V4F3pVF&wpwrgWE,pVF p V !WV4pK WV&K( VxK5 R#5ir))r8rrmap) r-rowsrHr8rowposrJrvalue converters &&& r1apply_convertersSQLCompiler.apply_converterssn__ ***,- tT?C,6((e!&I%eDE"' C -7 I #sA/A1cj\;QJdRV4F 'gK R# R#!RV44#)c3B"TFp\V\4xK R#5ir))rr )r]rs& r1r_3SQLCompiler.has_composite_fields.. sRk :j(33ksTF)any)r-rs&&r1has_composite_fields SQLCompiler.has_composite_fieldss-sRkRssRsRsRkRRRr3c #("\V4UUu.uF8wr4\V\4'gK\W3\ V4,4NK: ppp\ \ V4F$pVFp\Wg,43Wg&K VxK& R#uuppi5ir))rrr slicerhrOrr)r-rPrrGrcol_pair_slicesrQrRs&&& r1composite_fields_to_tuples&SQLCompiler.composite_fields_to_tuples"s"+;!7 !7 *h/ *E!Z( )!7  tT?C&!#(O-'I #  sBB B ABc VfVP\W4R7pVP^VPUu.uF qU^,NK ppVP V4p\ P !V4pV'dVPW4pVPV4'dVPW4pV'd\\V4pV#uupi)z>Return an iterator over the results from executing this query.) chunked_fetch chunk_size) execute_sqlrrLrirEr from_iterablerUr[r`rOr) r-rtuple_expectedrcrdrrrHrPs &&&&& r1 results_iterSQLCompiler.results_iter/s ?&&]'G!% A ?@ ?1A$$ ?@((0 ""7+ ((:D  $ $V , ,224@D ud#D AsC c >\VP\44#)zh Backends (e.g. NoSQL) can override this in order to use optimized versions of "query has any results." )rurerrUs&r1 has_resultsSQLCompiler.has_resultsFs D$$V,--r3c rT;'g\pVP4wrEV'g\hT'dTP P 4pMTP P4pTPYE4T\8XdTPTP4#T\8XdT#T\8XdKTP!4pT'd T^TP"TP4#TTP4#T\8XdTP4R#\%TTP P&P(TP*'d TP"MRT4p T'd'TP P&P,'g \/T 4#T # \dT\8Xd\ .4u#R#i;i \d*pTP4h \dTRhi;iRp?ii;i TP4i;i TP4i;i)a Run the query against the database and return the result(s). The return value depends on the value of result_type. When result_type is: - MULTI: Retrieves all rows using fetchmany(). Wraps in an iterator for chunked reads when supported. - SINGLE: Retrieves a single row using fetchone(). - ROW_COUNT: Retrieves the number of rows in the result. - CURSOR: Runs the query, and returns the cursor object. It is the caller's responsibility to close the cursor. N)rr9rriterr8chunked_cursorcursorexecute Exceptioncloserrrowcountrrfetchoneri cursor_iterrempty_fetchmany_valuervcan_use_chunked_readsr) r- result_typercrdrrrpevalrs &&&& r1reSQLCompiler.execute_sqlMs"//Z  ++-KC$$ __335F__++-F  NN3 ' ) #   & M &  oo'q4>>2   * $ LLN   OO $ $ : :"333DNN    DOO$<$<$R$R$R <  i e#Bx    "  ! "T! "    s_ F.1G HH$H$:H$.!GG H $G54H5HHH H!$H6c #"\VP44pVPPPpV'd&VP 4R8Xd\ PM\pVFPpVFGp\V\4'g+RPVUu.uF qc!V4NK up4xKCVxKI KR R#uupi5i)jsonrrN) rrerHrr)lowerr~dumpsr6rr4)r-rformat_output_formatterrQrScs& r1 explain_querySQLCompiler.explain_querysd&&()**))00)0W]]_5N4::TWC!%--((#GA$4Q$7#GHHK $HsBC C .C )rOrMrir8rJrvrrrNrsrHrKrLrIro)T)F)TF)NNN)NrN)NNrNN)/r;r<r=r>r%re MULTILINEDOTALLrr,rVrjrzrwr classmethodrrgrrnrtrrrr<r0rfr9rrurrrvrrrErUr[r`rrhrkrrerr?r@rCs@r1rErE*s %  ryy N #$ *0 eN@++ `,D^@;z  %3j#4^@a9F1f4? B L Dg#RhT, S * .. uAXHT   r3rEcPa]tRtRtoRtR tRtRtRtRt Rt R Rlt R t Vt R#) SQLInsertCompileriNc VfT.rTMDVeV!W0VP4wrEM*\VR4'dVPV4wrEMRV.rTVPPP WE4pWE3#)aG Take a field and a value intended to be saved on that field, and return placeholder SQL and accompanying params. Check for raw values, fields with get_placeholder_sql(), and compilable defined in that order. When field is None, consider the value raw and use it as the placeholder, with no corresponding parameters returned. r9z%s)r8rrrmodify_insert_params)r-rget_placeholder_sqlr{rrs&&&& r1 field_as_sqlSQLInsertCompiler.field_as_sqlsz =r ,.cIKC S( # #,,s+KC$$99#F{r3c \VR4'dVPVPRRR7pVP'd\ RV: RV: R24hVP 'd\ RVP: R V: R 24hVP'd\ R VP: R V: R 24hVPW PR 7#) z Prepare a value to be used in a query by resolving it if it is an expression and otherwise calling the field's get_db_prep_save(). rFTrfor_savezFailed to insert expression "z" on z<. F() expressions can only be used to update, not to insert.3Aggregate functions are not allowed in this query (=).2Window expressions are not allowed in this query (r8) rrrHcontains_column_references ValueErrorcontains_aggregaterrcontains_over_clauseget_db_prep_saver8)r-rrSs&&&r1 prepare_valueSQLInsertCompiler.prepare_values 5. / /,, -E /// DI5R''' "'**e5))) zz5*%%e%HHr3c VPP'd\W!P4#VP VRR7#)z Get the given field's value off the given obj. pre_save() is used for things like auto_now on DateTimeField. Skip it if this is a raw query. T)r)rHrawrrpre_save)r-rrs&&&r1 pre_save_valSQLInsertCompiler.pre_save_vals3 ::>>>3 . .~~ct~,,r3c  "aaa V'g..3#SUu.uFp\VRR4NK upo VV V3RlV4pRV4p\V!wrgVUU U u.uFqU U u.uF qFqNK K up p NK pp pp Wg3#uupiuup p iuup p pi)a Take a sequence of N fields and a sequence of M rows of values, and generate placeholder SQL and parameters for each field and value. Return a pair containing: * a sequence of M rows of N SQL placeholder strings, and * a sequence of M rows of corresponding parameter values. Each placeholder string may contain any number of '%s' interpolation strings, and each parameter row will contain exactly as many params as the total number of '%s's in the corresponding placeholder row. rNc3R<"TFpV3Rl\SSV44xK R#5i)c3N<"TFwrpSPWV4xK R#5ir))r)r]rrrSr-s& r1r_>SQLInsertCompiler.assemble_as_sql...s1 :5E!!%eDD:r,Nr3)r]rQrget_placeholder_sqlsr-s& r1r_4SQLInsertCompiler.assemble_as_sql..s6! "  9<0#:   "s$'c34"TFp\V!xK R#5ir)r)r]rQs& r1r_rs"N8M398Mr)rr3) r-r value_rowsrrows_of_fields_as_sqlsql_and_param_pair_rowsplaceholder_rows param_rowsrQpsrrs ff& @r1assemble_as_sql!SQLInsertCompiler.assemble_as_sqlsr6M FL EKEGE0$ 7V ! "! #O8M"N(+,C'D$@JJz333R1qq33z J++1 ,4JsA? B B0B B c  aaVPoVPP4pVPPP VPP R7pV: RS!VP4: 2.p\VPP4;p'Ed^RI H oVPPPp.p\V4EFsp\VPV4p\VP V4p .p VPP"F6p V !V 4p \%V S4'g V!V 4p V P'V 4K8 VP)4'gVP'V 4K\+V4^8dU\,;QJdV3RlV 4F 'dK RM RM!V3RlV 44'dVP/V4EKV'dVP'V 4EK+V!VP04p V U u.uFp \%V S4'dT MT NK p p VP'V 4EKv \\3V!4pVP'RRP5V3RlV44,4M|VPP"Uu.uF'qPPP74.NK) ppR .pVP'RS!VP8P:4,4VP<'*;'d!VPPP>pVPAWN4wppVPPPCVVPP R VPPD4R VPPF44pVP<'EdlVPPPH'EdEVPPPJ'd9VP'VPPPMVV44TpM8VP'R RP5V^,4,4V^,.pV'dVP'V4VPPPOVP<4wpVn(V'd&VP'V4VVPP., pRP5V4\S\TPV!V443.#V'dVP'VPPPMVV44V'dVP'V4RP5V4\R;QJd.R V4FNK 53.#!R V443.#V'dVP'V4\3VV4UUu.uF3wppRP5.VOR RP5V4,N4V3NK5 upp#uup iuupiuuppi)) on_conflictrr)DatabaseDefaultc3<<"TFp\VS4xK R#5ir))r)r]rSrs& r1r_+SQLInsertCompiler.as_sql..=s+DP5Juo66LsFTz(%s)rWc3H<"TFpS!VP4xK R#5ir)r)r]rqns& r1r_rVs,J6aR\\6"Nc38"TFqPxK R#5ir)rrs& r1r_ro 87!XX7c38"TFqPxK R#5ir)rrs& r1r_rprrz VALUES (%s)c34"TFqFq"xK K R#5ir)r5)r]rrs& r1r_rs,P2RQRQr),rrHrr8rinsert_statementrdb_tablerrdjango.db.models.expressionsrr'supports_default_keyword_in_bulk_insertrrrobjsrrhas_db_defaultrhrdremove db_defaultr3r4pk_default_valuerrreturning_fieldshas_bulk_insertron_conflict_suffix_sql update_fields unique_fieldscan_return_columns_from_insert can_return_rows_from_bulk_insertbulk_insert_sqlreturning_columnsreturning_paramsrrrf)r-rrrrr value_colsr field_preparefield_pre_save field_valuesrrSprepared_db_defaultrrcan_bulkrrrrr_sqlrvalsrrs& @@r1r9SQLInsertCompiler.as_sqls$ __zz""$??..?? ..@ .r$--/@AB$**++, ,6 , D((PP 4Jf '(:(:E B !():):E!B! ::??C*3/E%e_== -e 4 ''. + ++--%%l3 v;?ss+DP+sss+DP+((MM%(:%%l3 '4E4D4D&E#".   ".&e_==,"#".  !!,/U&Vc:./J MM&499,J6,J#JJ KCG**//BQQ$$5578/ VF MM&2dggnn#55 6%% % R R$//*B*B*R*R (,';';F'O$*!%!4!4!K!K  JJ " " 8tzz77 8 8tzz77 8 "   ! ! !((GGG''HHH OO''77@PQ$ mdii8H8K.LLM$Q-% 45,0??+>+>+P+P%%, (E4( e$40011XXf%uU-@-@-H'IJK K  MM$//--==fFVW X% 45XXf%uu,P,PuQR Ru,P,P'PQR R% 45 ##3Z@@GAtAFAMDIIaL$@ABDI@ M  lsY,-Y  9YcBV'dM\VPP4^8wd)VPPP 'gQhVPP 4pWn.pVPP4;_uu_4pVP4FwrVVPWV4K VP'g .uuRRR4#\VPP4pVPPP 'dV^8g.VPPP'dkV^8XddVPPPW@P4pVPU u.uFqPVP 4NK pp MV'dz\#V^,;p \$4'd[V PVP 4.pVPPP'VVP V P(43.pM .uuRRR4#RRR4VP+V4p V 'dVP-XV 4p\/X4#uup i +'giLK;ir )rhrHrr8rrrrrpr9rqrrfetch_returned_rowsrrrrrlast_insert_idrrErUr) r-rrrrprrobj_lenrPrreturning_fieldrHs && r1reSQLInsertCompiler.execute_sqls DJJOO$)OO,,MMM  zz""$ 0 __ # # % %#{{} s+ -((( & % $**//*G((IIIaK((GGGGWXL**>>11CGBWBWXBW dmm4BWX!j#3A#66 ''(// >?++::" MM+22A& % %B((. ((z:DDz+Y& %s9rrrrrrr9rer?r@rs@r1rrs9BI:-),Vzx--r3rc\a]tRtRto]R4t]R4t]R4tRt Rt Rt Vt R#) SQLDeleteCompilericaSPP4\V3RlSPP44^8H#)c3d<"TF%pSPPV,^8xK' R#5irZr[)r]rr-s& r1r_1SQLDeleteCompiler.single_alias..s'R=Q4::,,Q/!3=Qra)rHrfsumrerUsfr1 single_aliasSQLDeleteCompiler.single_aliass6 $$&RTZZ=Q=QRRVWWWr3c(aa\V\4'dVPS8H#\VR4'gR#\;QJd.VV3RlVP 44F 'gK R# R#!VV3RlVP 444#)rIFc3H<"TFpSPVS4xK R#5ir))_expr_refs_base_model)r] source_expr base_modelrs& r1r_:SQLDeleteCompiler._expr_refs_base_model..s( <   % %k: > >.s6   & &tTZZ-=-= > >s36TF)rZrrHrrYrochildrenrUsfr1 contains_self_reference_subquery2SQLDeleteCompiler.contains_self_reference_subqueryss  &&--/1A1A1J1J ss s s  &&--/1A1A1J1J   r3cRVPVP4,pVPVP4wr4T RT 2\ T43# \dTR3u#i;i)zDELETE FROM %sz WHERE r5)r base_tablerrorr)r-rHdeleterors&& r1_as_sqlSQLDeleteCompiler._as_sqlsk!DOOE4D4D$EE  LL5ME(%-77 2:  sAA%$A%c 6VP'dTVPPP'gVP'gVP VP 4#VP P4p\Vn VP4VP PPPpVPVP P44.Vn\VP P4pVPPP"'g@VP%VPR7P'4wrE\)RV,V4pVP+RV4VP V4#)N Create the SQL for this query. Return the SQL string and list of parameters. rzSELECT * FROM (%s) subquerypk__in)rr8r"delete_can_self_reference_subqueryrrrHr?rr0clear_select_clauserTrrrrfrLupdate_can_self_selectr-r9r add_filter)r-innerqrouterqrrs& r1r9SQLDeleteCompiler.as_sqls%     OO $ $ G G G888<< + +!!# ""$ ZZ   # # & &DJJ$@$@$BCD tzz''(''>>>!---IPPRKC9C?HF(F+||F##r3r5N) r;r<r=r>r#rrrrrr9r?r@rs@r1rrsPXX     8$$r3rcRaa]tRtRtoRtRtRtV3RltRtV3Rlt Rt Vt V;t #) SQLUpdateCompileriNc  >VP4VPP'gR#VPp..r2VPPEFwrEp\ VR4'dVP VPRRR7pVP 'd\RVP: RV: R24hVP'd\RVP: RV: R24h\V\4'd\R VP,4hMb\ VR 4'dQVP'dVPV4pM,\R V: R V: R VPP : R24hVP#W`P$R7pV!VP&4p\)VRR4;pe@V!W`VP$4wrVP+V RV 24VP-V 4EK\ VR4'd>VP/V4wrVP+V RV 24VP-V 4EKVP+V R24VP+V4EK" VPP0p RV!V 4,RP3V4.p VP/VPP44wrV P+RV ,4VP8'dkVP$P:P=VP84wqnV'd-V P+V4V P-VP>4RP3V 4\AW:,43# \6d.p Li;i)rrFTrrrrrzNComposite primary keys expressions are not allowed in this query (%s=F('pk')).prepare_database_savezTried to update field z with a model instance, z. Use a value compatible with rrrNz = r9z = %sz UPDATE %s SETrWrorr)rir5)!rzrHrYrrrrrrrrr rr TypeErrorr0r;rr8rrrrrrr4rorrrrrr)r-rrY update_paramsrrTr{ quoted_namerrrrrrors& r1r9SQLUpdateCompiler.as_sqls! zz   M __ "B !%!2!2 E#s011,,JJED-)))$&+jj#7+++$&+jj#7c8,,$68= C- 566%%%33E:C#!#u'?'?A (((ICU\\*K'.u6KT'RR#2#T__M   S67$$V,h''"ll3/   S67$$V,  U34$$S)Y"3Z %% bi ' IIf   . LL)9)9:ME MM*u, -  ,0??+>+>+P+P%%, (E( e$ d334xx}'=!>>> F s/'N NNc <\SV`V4pVRJpT;'g^pVPP4FEpVP VP 4PV4pV'gK7V'gKATpRpKG V#)z Execute the specified update. Return the number of rows affected by the primary update query. The "primary update query" is the first non-empty query that is executed. Row counts for any subsequent, related queries are not available. NF)r+rerHget_related_updatesr-rI)r-ry row_countis_emptyrH aux_row_countr0s&& r1reSQLUpdateCompiler.execute_sqlTs|G' 4 $NN ZZ335E!..tzz:FF{SMxMM*  6r3c .VPP4'd \R4hV'd'VPPP 'g VP \4pR.V,#WnVPP4;_uu_4pVP4wrEVPWE4VPPPW0P4pRRR4VPP4pVPUu.uFqP!VP"4NK p pVP%V 4p V 'dVP'XV 4p\)X4# +'giL;iuupi)z Execute the specified update and return rows of the returned columns associated with the specified returning_field if the backend supports it. zEUpdate returning is not implemented for queries with related updates.Nr5)rHrrr8rcan_return_rows_from_updatererrrpr9rqrrrrrrrErUr) r-rrrprrrPrrrrHs && r1execute_returning_sql'SQLUpdateCompiler.execute_returning_sqlis3 :: ) ) + +%W  !??++GGG((3I4)# # 0 __ # # % %++-KC NN3 '??&&::--D& zz""$:>:O:OP:O dmm,:OP((. ((z:DDz& %Qs!AE?$#F? F c <aVPPP4pVPP4VPP 4pVPP 'g V^8XdR#VPP \R7pRVnVPRR7/Vn .Vn VP4pVPP.p.pVPP Fp\;QJd+RVP!V44F 'dK RM RM!RVP!V444'dVP#V^34KpVP#V\%V434VP#VP&PP4K VP)V4\*SV`Y4VP.pV^8;'d&VP0P2P4'*p VPP74VPP 'g V 'd.p \8P:!\<4p VP?VP@4PC\D4Fbp V U u.uFq'dT MV ^,NK pp V PGV4VF'wpoW,PGV3RlV 44K) Kd VPPIRV 4WPn%MVPPIRV4VPPMV4R#uup i) a If the update depends on results from other tables, munge the "where" conditions to match the format required for (portable) SQL updates. If multiple updates are required, pull out the id values to update at this point so that they don't change as a result of the progressive updates. N)klassFT)forcec3L"TFqPPxK R#5ir)) join_fieldr)r]rs& r1r_2SQLUpdateCompiler.pre_sql_setup..s8X++8Xs"$c34<"TF qS,xK R#5ir)r5)r]rrs& r1r_r"s.FAxxsr)'rHr\rrfcount_active_tablesrelated_updatesrrrclear_orderingrrLrrrrdget_path_to_parentrrhr add_fieldsr+rzis_composite_pkr8rr clear_wherer9 defaultdictrr-rIrerrr related_idsr)r-rcountrHrrrelated_ids_indexrelatedr)must_pre_selectidentsr,rPrQrparentrr0s& @r1rzSQLUpdateCompiler.pre_sql_setups ::4499; $$& ..0zz)))eqj    u -$ 4(  ~~'',,zz11Gs8<8O8OPW8Xsss8<8O8OPW8X "(('16 "(('3v;)?@ gmm..3342   .. AI M Mdoo66MMM   :: % % %F%11$7K**4::6BB5IEIJTcos3q69TJ c"%6MFE'...F.FF&7J JJ ! !(F 3%0JJ " JJ ! !(E 2 ""#34Ks1M6rr5) r;r<r=r>rrr9rerrzr?r@rArBs@@r1r r s-K?Z*@?5?5r3r c&a]tRtRtoRtRtVtR#)SQLAggregateCompileric 6..r!VPPP4FLpVPV4wrEVP WV4wrEVP V4VP V4KN \VPP4VnRPV4p\V4pVPPPVPVPR7PRR7wrgRV: RV: R2pW', pW3#)rrW)rJTrbrprqrs)rHrrYrrrrrhrir4rrLr-rIrJr9)r-rr annotationann_sql ann_paramsinner_query_sqlinner_query_paramss& r1r9SQLAggregateCompiler.as_sqls "V**66==?J"&,,z": G",":":4*"U G JJw  MM* % @ TZZ99:iinv.2jj.D.D.Q.Q JJ((/R/  &$& ' ,+14_E${r3)riN)r;r<r=r>r9r?r@rs@r1r5r5sr3r5c#aa"\VV3RlV4FpVfTMVUu.uFqURVNK upxK! SP4R#uupi SP4i;i5i)zO Yield blocks of rows from a cursor and ensure the cursor is closed when done. c&<SPS4#r)) fetchmany)rpitersizesr1rcursor_iter..s&"2"28"rSs LL61QQ83+?<<S3/6%#%x x v3_ _D 9$ 9$xE5 E5P;2 r3