o d>e4Z9ej%Gd?d@d@e9Z:ej%GdAdBdBe#e!Z;ej%GdCdDdDe!ZGdIdJdJeZ?GdKdLdLe?e&Z@GdMdNdNe?e(ZAGdOdPdPe?e)ZBGdQdRdRe?e*ZCGdSdTdTe?e+ZDGdUdVdVZEej%GdWdXdXeEe'ZFej%GdYdZdZeEe5ZGej%Gd[d\d\eEe6ZHej%Gd]d^d^eEe7ZIej%Gd_d`d`eEe8ZJej%GdadbdbeEe9ZKej%GdcddddeEe:ZLdS)eN)EmptyResultSet FullResultSet)BaseDatabaseOperations)Case ExpressionFuncValueWhen) BooleanField CharField DateTimeFieldField IntegerField UUIDField)RegisterLookupMixin) OrderedSet)RemovedInDjango60Warning)cached_property) make_hashablec@seZdZdZdZdZddZddZdd Zd.d d Z d d Z ddZ ddZ ddZ ddZd.ddZddZddZddZddZed d!Zed"d#Zd$d%Zd&d'Z d/d(d)Zd*d+Zed,d-ZdS)0LookupNTFcCsj|||_|_||_||_t|jdr|j}ng}|r0ddlm}t||r0t d||_ dS)Nget_bilateral_transformsrQueryzBBilateral transformations on nested querysets are not implemented.) lhsrhsget_prep_lookup get_prep_lhshasattrrdjango.db.models.sql.queryr isinstanceNotImplementedErrorbilateral_transforms)selfrrr!rr#K/var/www/html/venv/lib/python3.10/site-packages/django/db/models/lookups.py__init__s       zLookup.__init__cCs|jD]}||}q|SN)r!)r"value transformr#r#r$apply_bilateral_transforms/s  z!Lookup.apply_bilateral_transformscCs|jjd|jd|jdS)N(, )) __class____name__rrr"r#r#r$__repr__4szLookup.__repr__c Cs|dur|j}|jr| |\}}t |ts:|r:|ddkr:d|}||fS| ||S)Nr1as_sqlrr*z(%s)) rr!rErrr2r)r4r5rr6rr9)r"r;r<r'r@rCr#r#r$ process_rhsos    zLookup.process_rhscCst|jd SNrN)rrr/r#r#r$rEzLookup.rhs_is_direct_valuecCs$g}|D] }||q|Sr&)rFr8get_group_by_cols)r"colssourcer#r#r$rRs zLookup.get_group_by_colscCshd}g}|j|jfD]}|j|rtt|dddd}d}||q |r,t||n|}|||S)NFT)then)default) rrops0conditional_expression_supported_in_where_clauserr r7typerN)r"r;r<wrappedexprsexprlookupr#r#r$ as_oracles   zLookup.as_oraclecCstSr&)r r/r#r#r$r2szLookup.output_fieldcCs|j|j|jfSr&)r-rrr/r#r#r$identityzLookup.identitycCst|tstS|j|jkSr&)rrNotImplementedr_)r"otherr#r#r$__eq__s  z Lookup.__eq__cCstt|jSr&)hashrr_r/r#r#r$__hash__rQzLookup.__hash__cCsJ|}||_|j||||||_t|jdr#|j||||||_|SrL)copy is_summaryrr4rr)r"r5 allow_joinsreuse summarizefor_savecr#r#r$r4s   zLookup.resolve_expressioncCs|jjjs d|d}||fS)Nz CASE WHEN z THEN 1 ELSE 0 END)r<features&supports_boolean_expr_in_select_clause)r"r;r@rCr#r#r$ select_formats  zLookup.select_formatcCs|jjo|jjSr&)rallowed_defaultrr/r#r#r$rpr`zLookup.allowed_defaultr&)NTNFF)r. __module__ __qualname__ lookup_namerKcan_use_none_as_rhsr%r)r0rDrFrIrrr9rMrOrErRr^rr2propertyr_rcrer4rorpr#r#r#r$rs:       rc@s,eZdZdZdZdZeddZddZdS) Transformz RegisterLookupMixin() is first so that get_lookup() and get_transform() first examine self and then check output_field. FrGcCs |dSNr)rFr/r#r#r$rs z Transform.lhscCs2t|jdr |j}ng}|jr||j|S)Nr)rrr bilateralr7r-)r"r!r#r#r$rs   z"Transform.get_bilateral_transformsN) r.rqrr__doc__rxarityrurrr#r#r#r$rvs  rvcs.eZdZdfdd ZddZddZZS) BuiltinLookupNcst|||\}}|jj}t|jjdr6|jjjt jur6t dt |jjj |d}|j|||}|j|j||}|t|fS)Nfield_cast_sqlzsThe usage of DatabaseOperations.field_cast_sql() is deprecated. Implement DatabaseOperations.lookup_cast() instead.)r<)superrMrr2get_internal_typerrWr-r|rwarningswarnrdb_type lookup_castrslist)r"r;r<rlhs_sqlrCfield_internal_typerr-r#r$rMs"   zBuiltinLookup.process_lhscCsF|||\}}|||\}}|||||}d||f|fSNz%s %s)rMrOr8 get_rhs_op)r"r;r<rrCrhs_sql rhs_paramsr#r#r$rNs   zBuiltinLookup.as_sqlcC|j|j|Sr& operatorsrsr"r<rr#r#r$rzBuiltinLookup.get_rhs_opr&)r.rqrrrMrNr __classcell__r#r#rr$r{sr{c@eZdZdZdZddZdS)FieldGetDbPrepValueMixinzZ Some lookups require Field.get_db_prep_value() to be called on their inputs. FcsJt|jjdd}t|ddp|jjj|js|g}dfdd|DfS)N target_fieldget_db_prep_valuer3cs(g|]}t|dr |n|ddqS)rNT)prepared)r).0vr<rr#r$ s  z?FieldGetDbPrepValueMixin.get_db_prep_lookup..)getattrrr2r$get_db_prep_lookup_value_is_iterable)r"r'r<fieldr#rr$r9s  z+FieldGetDbPrepValueMixin.get_db_prep_lookupN)r.rqrrryrr9r#r#r#r$rs rcsBeZdZdZdZddZfddZddZd fd d ZZ S) FieldGetDbPrepValueIterableMixinzg Some lookups require Field.get_db_prep_value() to be called on each value in an iterable. TcCs^t|jdr |jSg}|jD]}t|drn|jr't|jjdr'|jj|}||q|S)Nr4rJ)rrrKrr2rJr7)r"prepared_values rhs_valuer#r#r$r&s    z0FieldGetDbPrepValueIterableMixin.get_prep_lookupcs"|r |||St||Sr&)rErDr}rO)r"r;r<rr#r$rO4s z,FieldGetDbPrepValueIterableMixin.process_rhscCs<|g}t|dr||j}t|dr||\}}||fS)Nr4rN)rr4r5r6)r"r;r<r@paramrCr#r#r$resolve_expression_parameter<s    z=FieldGetDbPrepValueIterableMixin.resolve_expression_parameterNcsJt|}tfddt|D\}}tj|}|t|fS)Nc3s$|] \}}||VqdSr&)r)rr@rr;r<r"r#r$ Ks  zEFieldGetDbPrepValueIterableMixin.batch_process_rhs..)r}rDzip itertoolschain from_iterabletuple)r"r;r<r pre_processedr@rCrrr$rDDs  z2FieldGetDbPrepValueIterableMixin.batch_process_rhsr&) r.rqrrryrrrOrrDrr#r#rr$rs rc@seZdZdZdZddZdS)PostgresOperatorLookupz*Lookup defined by operators on PostgreSQL.NcCsD|||\}}|||\}}t|t|}d||j|f|fS)Nz%s %s %s)rMrOrpostgres_operator)r"r;r<r lhs_paramsrrrCr#r#r$ as_postgresqlYsz$PostgresOperatorLookup.as_postgresql)r.rqrrryrrr#r#r#r$rTs rcs,eZdZdZfddZfddZZS)ExactexactcsVddlm}t|j|r&|jr"|jjs!|j|jdgntdt S)NrrpkzSThe QuerySet value for an exact lookup must be limited to one result using slicing.) rrrr has_limit_onehas_select_fieldsclear_select_clause add_fields ValueErrorr}rr"rrr#r$rds     zExact.get_prep_lookupcs`t|jtr)t|jddr)|j|jr)|||\}}|jr!dnd}|||fSt ||S)N conditionalFr3zNOT %s) rrboolrrrWrXrMr}rN)r"r;r<rrCtemplaterr#r$rNss   z Exact.as_sql)r.rqrrrsrrNrr#r#rr$r`s rc$eZdZdZdZfddZZS)IExactiexactFcs2t||\}}|r|j|d|d<||fSrw)r}rOrWprep_for_iexact_queryr"qnr<rrCrr#r$rOszIExact.process_rhs)r.rqrrrsrKrOrr#r#rr$rrc@eZdZdZdS) GreaterThangtNr.rqrrrsr#r#r#r$rrc@r)GreaterThanOrEqualgteNrr#r#r#r$rrrc@r)LessThanltNrr#r#r#r$rrrc@r)LessThanOrEquallteNrr#r#r#r$rrrcs$eZdZeZeZfddZZS)IntegerFieldOverflowcsf|j}t|tr,|jj}|j|\}}|dur!||kr!|j|dur,||kr,|j t ||Sr&) rrintrr2r~rWinteger_field_rangeunderflow_exceptionoverflow_exceptionr}rO)r"r;r<rr min_value max_valuerr#r$rOs  z IntegerFieldOverflow.process_rhs)r.rqrrrrrrOrr#r#rr$rsrc eZdZdZfddZZS)IntegerFieldFloatRoundingz Allow floats to work as query values for IntegerField. Without this, the decimal portion of the float would always be discarded. cs$t|jtr t|j|_tSr&)rrfloatmathceilr}rr/rr#r$rs  z)IntegerFieldFloatRounding.get_prep_lookup)r.rqrrryrrr#r#rr$rrc@ eZdZdS)IntegerFieldExactNr.rqrrr#r#r#r$rrc@eZdZeZdS)IntegerGreaterThanNr.rqrrrrr#r#r#r$rrrc@r)IntegerGreaterThanOrEqualNrr#r#r#r$rsrc@r)IntegerLessThanNr.rqrrrrr#r#r#r$rrrc@r)IntegerLessThanOrEqualNrr#r#r#r$rrrcsTeZdZdZfddZfddZfddZdd Zfd d Zd d Z Z S)Inincs<t}|r|jD]}t|dd}r||O}q |S)Nget_refs)r}rrErr)r"refsr get_rhs_refsrr#r$rs   z In.get_refscsPddlm}t|j|r#|jjdd|jjs#|j|jdgt S)NrrT) clear_defaultr) rrrrclear_orderingrrrr}rrrr#r$rs    zIn.get_prep_lookupcst|jdd}|dur||jkrtd|rPz t|j}|dWnty5dd|jD}Ynw|s:t| |||\}}dd |d}||fSt ||S)N_dbzvSubqueries aren't allowed across different databases. Force the inner query to be evaluated using `list(inner_query)`.cSsg|]}|dur|qSr&r#)rrr#r#r$rsz"In.process_rhs..r*r+r,) rraliasrrErdiscard TypeErrorrrDjoinr}rO)r"r;r<db_rhsrr=r> placeholderrr#r$rOs$  zIn.process_rhscCsd|S)NzIN %sr#rr#r#r$r z In.get_rhs_opcs>|j}|r|rt|j|kr|||St||Sr&)rWmax_in_list_sizerEr:rsplit_parameter_list_as_sqlr}rN)r"r;r<rrr#r$rNs  z In.as_sqlcCs|j}|||\}}|||\}}dg}g} tdt||D];} | dkr-|d|d|| ||| | |} || | |} d| } || |d| | q"|dd|| fS)Nr*rz OR z%s IN (r+r,) rWrrMrDranger:r7r8r)r"r;r<rrrrrin_clause_elementsrCoffsetr=r> param_groupr#r#r$rs$        zIn.split_parameter_list_as_sql) r.rqrrrsrrrOrrNrrr#r#rr$rs     rcs0eZdZdZdZfddZfddZZS) PatternLookupz%%%s%%Fcs>t|jds |jr|j|j|j}||St||SrP) rrr! pattern_opsrsformat pattern_escr}r)r"r<rpatternrr#r$r5s   zPatternLookup.get_rhs_opcsFt||\}}|r|r|js|j|j|d|d<||fSrw)r}rOrEr! param_patternrWprep_for_like_queryrrr#r$rOGs   zPatternLookup.process_rhs)r.rqrrrrKrrOrr#r#rr$r1s  rc@r)ContainscontainsNrr#r#r#r$rPrrc@r) IContains icontainsNrr#r#r#r$rUrrc@eZdZdZdZdS) StartsWith startswithz%s%%Nr.rqrrrsrr#r#r#r$rZrc@r) IStartsWith istartswithNrr#r#r#r$r `rr c@r)EndsWithendswithz%%%sNr r#r#r#r$r er r c@r) IEndsWith iendswithNrr#r#r#r$rkrrc@seZdZdZddZdS)RangercCsd|d|dfS)NBETWEEN %s AND %srrGr#rr#r#r$rtszRange.get_rhs_opN)r.rqrrrsrr#r#r#r$rps rc@r)IsNullisnullFcCst|jts tdt|jtr4|jjdus |jjdkr+|jjr+|jr't }|t }||jr0t nt }|| ||\}}|jrEd||fSd||fS)Nz>The QuerySet value for an isnull lookup must be True or False.rz %s IS NULLz%s IS NOT NULL) rrrrrrr'rm!interprets_empty_strings_as_nullsrrrM)r"r;r<result_exceptionr@rCr#r#r$rN}s&       z IsNull.as_sqlN)r.rqrrrsrKrNr#r#r#r$rxs rcr)RegexregexFcs\|j|jvr t||S|||\}}|||\}}|j|j}|||f||fSr&)rsrr}rNrMrOrW regex_lookup)r"r;r<rrrr sql_templaterr#r$rNs z Regex.as_sql)r.rqrrrsrKrNrr#r#rr$rrrc@r)IRegexiregexNrr#r#r#r$rrrcs4eZdZddZfddZddZddZZS) YearLookupcCsTddlm}t|j|}|jjj}t|tr |jj||d}|S|jj||d}|S)Nr)ExtractIsoYear)iso_year) django.db.models.functionsrrrr2r rW%year_lookup_bounds_for_datetime_field!year_lookup_bounds_for_date_field)r"r<yearrrr2boundsr#r#r$year_lookup_boundss     zYearLookup.year_lookup_boundsc s||r7||||jj\}}|||\}}|||}|||j\}}||||d||f|fSt ||Sr) rErMrrOget_direct_rhs_sqlr%rr8get_bound_paramsr}rN) r"r;r<rrCrrBstartfinishrr#r$rNs zYearLookup.as_sqlcCrr&rrr#r#r$r&rzYearLookup.get_direct_rhs_sqlcCstd)NzAsubclasses of YearLookup must provide a get_bound_params() method)r r"r(r)r#r#r$r'szYearLookup.get_bound_params)r.rqrrr%rNr&r'rr#r#rr$rs  rc@seZdZddZddZdS) YearExactcCsdS)Nrr#rr#r#r$r&szYearExact.get_direct_rhs_sqlcCs||fSr&r#r*r#r#r$r'rzYearExact.get_bound_paramsN)r.rqrrr&r'r#r#r#r$r+s r+c@eZdZddZdS)YearGtcC|fSr&r#r*r#r#r$r'zYearGt.get_bound_paramsNr.rqrrr'r#r#r#r$r- r-c@r,)YearGtecC|fSr&r#r*r#r#r$r'r/zYearGte.get_bound_paramsNr0r#r#r#r$r2r1r2c@r,)YearLtcCr3r&r#r*r#r#r$r'r/zYearLt.get_bound_paramsNr0r#r#r#r$r4r1r4c@r,)YearLtecCr.r&r#r*r#r#r$r'r/zYearLte.get_bound_paramsNr0r#r#r#r$r5r1r5cr) UUIDTextMixinzs Strip hyphens from a value when filtering a UUIDField on backends without a native datatype for UUID. cs`|jjs#ddlm}|rt|j|_||jtdtdtd|_t ||\}}||fS)Nr)Replace-rr1) rmhas_native_uuid_fieldr r7rErrr r}rO)r"rr<r7rrCrr#r$rOs  zUUIDTextMixin.process_rhs)r.rqrrryrOrr#r#rr$r6rr6c@r) UUIDIExactNrr#r#r#r$r:rr:c@r) UUIDContainsNrr#r#r#r$r;rr;c@r) UUIDIContainsNrr#r#r#r$r<rr<c@r)UUIDStartsWithNrr#r#r#r$r= rr=c@r)UUIDIStartsWithNrr#r#r#r$r>rr>c@r) UUIDEndsWithNrr#r#r#r$r?rr?c@r) UUIDIEndsWithNrr#r#r#r$r@rr@)Mrrrdjango.core.exceptionsrr"django.db.backends.base.operationsrdjango.db.models.expressionsrrrrr django.db.models.fieldsr r r r rrdjango.db.models.query_utilsrdjango.utils.datastructuresrdjango.utils.deprecationrdjango.utils.functionalrdjango.utils.hashablerrrvr{rrrregister_lookuprrrrrrrrrrrrrrrrrrr r rrrrrrr+r-r2r4r5r6r:r;r<r=r>r?r@r#r#r#r$s       .$6 #   S)