#ij<rddlZddlmZddlmZmZddlmZmZm Z m Z m Z m Z ddl mZmZmZmZmZmZmZddlmZddlmZmZmZGdd e ZGd d ZGd d eeZGddeeZGddeeZGddeeZ GddeeZ!GddeeZ"GddeeZ#eee e!e"e#edZ$y)N)EmptyResultSet)NotSupportedErrormodels)ColPairsExistsFuncResolvedOuterRefSubqueryValue)Exact GreaterThanGreaterThanOrEqualInIsNullLessThanLessThanOrEqual)Query)ANDOR WhereNodecHeZdZdZdZej ZdZdZ dZ y)TupleTc,t|jSN)lensource_expressionsselfs _/var/www/html/office/venv/lib/python3.12/site-packages/django/db/models/fields/tuple_lookups.py__len__z Tuple.__len__s4**++c,t|jSr)iterrrs r __iter__zTuple.__iter__"sD++,,r"c |jdkr_t|jdx}tr@|j }d|_t|g|jddj ||S|j ||S)N)%rVALUES)get_database_version isinstancerrcopyfunctionas_sql)rcompiler connection first_exprs r as_sqlitezTuple.as_sqlite%s  * * ,w 6:11!4 4Je< $*J"*J Bd&=&=ab&ABII* {{8Z00r"N) __name__ __module__ __qualname__allows_composite_expressionsr.rField output_fieldr!r%r3r"r rrs)#' H6<<>L,- 1r"rcjeZdZdZfdZdZdZdZdZfdZ d fd Z fd Z d Z fd Z xZS) TupleLookupMixinTc|jr,|j|j|j S|jt||j Sr)rhs_is_direct_valuecheck_rhs_is_tuple_or_list"check_rhs_length_equals_lhs_length!check_rhs_is_supported_expressionsuperget_prep_lookuprhsr __class__s r rCz TupleLookupMixin.get_prep_lookup4sT  # # %  + + -  3 3 5xx  2 2 4 G # %xxr"ct|jttfs+|j }t |j d|dy)N lookup of z must be a tuple or a list)r,rDtuplelist get_lhs_str ValueError lookup_namerlhs_strs r r?z+TupleLookupMixin.check_rhs_is_tuple_or_list=sL$((UDM2&&(G##&k':TU 3r"ct|j}|t|jk7r.|j}t |j d|d|dy)NrH must have z elements)rlhsrDrKrLrM)rlen_lhsrOs r r@z3TupleLookupMixin.check_rhs_length_equals_lhs_lengthDs\dhh- c$((m #&&(G##&k'+gYiX  $r"ct|jttfsN|j }|jj j }t|jd|d|dy)N subquery lookup of z7 only supports OuterRef and QuerySet objects (received )) r,rDr rrKrFr4rLrMrrOrhs_clss r rAz2TupleLookupMixin.check_rhs_is_supported_expressionLss$((%5u$=>&&(Ghh((11G##&&:7)DIIP STV ?r"ct|jtr)t|jjj Sdj d|jD}d|dS)Nz, c3FK|]}t|jywr)reprname).0fs r z/TupleLookupMixin.get_lhs_str..Ys=qd166l=s!(rV)r,rRrr[fieldr\join)rnamess r rKzTupleLookupMixin.get_lhs_strUsO dhh )++, ,II=DHH==EugQ< r"ct|jttfrt |jSt |Sr)r,rRrIrJrrB get_prep_lhsrEs r rezTupleLookupMixin.get_prep_lhs\s2 dhh .$((# #w#%%r"ctt||||\}}t|jtsd|d}||fS)Nr`rV)rB process_lhsr,rRr)rr0r1rRsqlparamsrFs r rgzTupleLookupMixin.process_lhsas?g)(JD V$((E*cU!*CF{r"c|jrlt|j|jDcgc]*\}}t |dr|nt ||j ,}}}|jt|S|j|j\}}t|jtrd|z|fSt|jtrt|5||Stdcc}}w)Nr/r9z(%s)z=Composite field lookups only work with composite expressions.)r>ziprRrDhasattrr r9compilerr,rrrB process_rhsrL) rr0r1colvalargsrhrirFs r rozTupleLookupMixin.process_rhsgs  # # %!$DHHdhh 7  CsH-s1A1ABCD##E4L1 1"**4884KC$((H-|V++DHHe,w*8Z@@ S!s/C2cFt|jjd)Nzp.get_fallback_sql() must be implemented for backends that don't have the supports_tuple_lookups feature enabled.)NotImplementedErrorrFr4)rr0r1s r get_fallback_sqlz!TupleLookupMixin.get_fallback_sql}s+!~~&&'(W X  r"cz|jjsmt|jtrS|jj r=t|t tttfr|j}d|d}t||jjs|j||St|=||S)N"zN" cannot be used to target composite fields through subqueries on this backend)features*supports_tuple_comparison_against_subqueryr,rDrsubqueryr rrrrMrsupports_tuple_lookupsrurBr/)rr0r1lookupmsgrFs r r/zTupleLookupMixin.as_sqls##NN488U+!!{$6/R%%FF855 $C( (""99((:> >w~h 33r"r)r4r5r6r7rCr?r@rArKrergrorur/ __classcell__rFs@r r<r<1s@#'  &  , 44r"r<ceZdZfdZxZS) TupleExactcNt|jtrtt|||S|j ||t|j|jDcgc]\}}t||}}}t|t}|j ||Scc}}wN connector) r,rDrrBr<r/rorlrRr rr)rr0r1rprqlookupsrootrFs r ruzTupleExact.get_fallback_sqls dhh &)47*M M :.47txx3JKxsC5c?KKC0{{8Z00Ls%B!)r4r5r6rur~rs@r rrs  1 1r"rceZdZdZdZy) TupleIsNullc|j}t|ttfrt |dk(r|d}t|t r|St d)Nr*rz>The QuerySet value for an isnull lookup must be True or False.)rDr,rIrJrboolrL)rrDs r rCzTupleIsNull.get_prep_lookupsKhh cE4= )c#h!ma&C c4 J L  r"c|j}|jDcgc]}t||}}t||rtnt }|j ||Scc}wr)rDrRrrrrr/)rr0r1rDrprrs r r/zTupleIsNull.as_sqlsQ hh/3xx86#s#88#B3?{{8Z009sAN)r4r5r6rCr/r:r"r rrs  1r"rceZdZdZy)TupleGreaterThanc|j||tjttg}tjt t g}|jDcgc]}tdD]}|}}}|jDcgc]}tdD]}|} }}t|dd} t| dd} t| }t| }t|} t|} t| ||g| x}}t| | D]M\}}t|} t|} t| ||g| }|jj||}O|j!||Scc}}wcc}}wNrro itertoolscycler r rrrRrangerDr$nextrrlchildrenappendr/rr0r1r connectorsrp_ cols_listrq vals_list cols_iter vals_iterr|rrnodechilds r ruz!TupleGreaterThan.get_fallback_sqls] :.//;"67__b#Y/ $(HH?SeAh?S?S? ?$(HH?SeAh?S?S? ?3B( 3B( 9o9og$ S!1 2iHHtIy1 HC']FZ(Ivc3/0IFE MM  'D  {{8Z00#@? E4 E:Nr4r5r6rur:r"r rr1r"rceZdZdZy)TupleGreaterThanOrEqualc|j||tjttg}tjt t g}|jDcgc]}tdD]}|}}}|jDcgc]}tdD]}|} }}t|} t| } t| }t| }t|} t|} t| ||g| x}}t| | D]M\}}t|} t|} t| ||g| }|jj||}O|j!||Scc}}wcc}}wNrrrrs r ruz(TupleGreaterThanOrEqual.get_fallback_sqlsO :.//;"67__b#Y/ $(HH?SeAh?S?S? ?$(HH?SeAh?S?S? ?O O 9o9og$ S!1 2iHHtIy1 HC']FZ(Ivc3/0IFE MM  'D  {{8Z00#@? E. E4Nrr:r"r rrrr"rceZdZdZy) TupleLessThanc|j||tjttg}tjt t g}|jDcgc]}tdD]}|}}}|jDcgc]}tdD]}|} }}t|dd} t| dd} t| }t| }t|} t|} t| ||g| x}}t| | D]M\}}t|} t|} t| ||g| }|jj||}O|j!||Scc}}wcc}}wrrorrrr rrrRrrDr$rrrlrrr/rs r ruzTupleLessThan.get_fallback_sqls] :.//8U"34__b#Y/ $(HH?SeAh?S?S? ?$(HH?SeAh?S?S? ?3B( 3B( 9o9og$ S!1 2iHHtIy1 HC']FZ(Ivc3/0IFE MM  'D  {{8Z00#@?rNrr:r"r rrrr"rceZdZdZy)TupleLessThanOrEqualc|j||tjttg}tjt t g}|jDcgc]}tdD]}|}}}|jDcgc]}tdD]}|} }}t|} t| } t| }t| }t|} t|} t| ||g| x}}t| | D]M\}}t|} t|} t| ||g| }|jj||}O|j!||Scc}}wcc}}wrrrs r ruz%TupleLessThanOrEqual.get_fallback_sqlsO :.//8U"34__b#Y/ $(HH?SeAh?S?S? ?$(HH?SeAh?S?S? ?O O 9o9og$ S!1 2iHHtIy1 HC']FZ(Ivc3/0IFE MM  'D  {{8Z00#@?rNrr:r"r rrrr"rcDeZdZfdZdZdZdZfdZfdZxZ S)TupleInc|jr<|j|j|j|jS|j t t ||jSr) r>r?*check_rhs_is_collection_of_tuples_or_lists+check_rhs_elements_length_equals_lhs_lengthcheck_rhs_is_queryrBr<rCrDrEs r rCzTupleIn.get_prep_lookup,sc  # # %  + + -  ; ; =  < < > xx  # # % "D 9 ;xxr"ctd|jDs+|j}t|jd|dy)Nc3HK|]}t|ttfywr)r,rIrJ)r]valss r r_zETupleIn.check_rhs_is_collection_of_tuples_or_lists..8sHt:dUDM2Hs "rHz( must be a collection of tuples or lists)allrDrKrLrMrNs r rz2TupleIn.check_rhs_is_collection_of_tuples_or_lists7sQHtxxHH&&(G##&k';:: Ir"ct|jtfd|jDs.|j }t |j d|ddy)Nc3:K|]}t|k(ywr)r)r]rrSs r r_zFTupleIn.check_rhs_elements_length_equals_lhs_length..As=D7c$i'=srHrQz elements each)rrRrrDrKrLrM)rrOrSs @r rz3TupleIn.check_rhs_elements_length_equals_lhs_length?sedhh-=DHH==&&(G##&k';$I^5 >r"ct|jttfsN|j }|jj j }t|jd|d|dy)NrUz" must be a Query object (received rV) r,rDrr rKrFr4rLrMrWs r rzTupleIn.check_rhs_is_queryHsp$((UH$56&&(Ghh((11G##&&:7)D44;;aA 7r"c |jstt|||S|j}|st g}|j }|D]l}td|Dr|jtt||Dcgc]*\}}t|dr|nt||j,c}}n|st |jt|Scc}}w)Nc3$K|]}|du ywrr:r]rqs r r_z&TupleIn.process_rhs..a/33$;/r/rk)r>rBr<rorDrrRanyrrrlrmr r9rn) rr0r1rDresultrRrrprqrFs r rozTupleIn.process_rhsQs''))4.zs:6 "&)#;;hG %'6s$')r1rrc3$K|]}|du ywrr:rs r r_z+TupleIn.get_fallback_sql..rr)rDrr,rrchain from_iterable get_compiler get_selectcloneadd_qrQrlrRr rnrr>rBr<r/rrrrrr) rr0r1rD rhs_exprsrprqrrRrrrrFs @r ruzTupleIn.get_fallback_sqlushh c5 !!556 "..*.EPPRSTU 6I))+C II3txx;STxsC5c?TU ##F3K0 0))+)47*M M r*hh DD/$//7:3~F83uS#FGF MM 7c!B C  D}} {{8Z00-U"Gs 3F=G) r4r5r6rCrrrrorur~rs@r rr+s' "0H%1%1r"r)exactgtgteltlteinisnull)%rdjango.core.exceptionsr django.dbrrdjango.db.models.expressionsrrrr r r django.db.models.lookupsr r rrrrrdjango.db.models.sqlrdjango.db.models.sql.whererrrrr<rrrrrrr tuple_lookupsr:r"r rs1/'991D1.c4c4L 1!5 11"F1,1'181.0B181$h181+_18o1o1f  "    r"