h;FdZddlZddlZddlZddlmZddlmZddlm Z m Z m Z ddl m Z ddlmZejdZed d Zd ZGd d ejZGddZGddZGddZddZdZdZGddZdS)z Various data structures used in query construction. Factored out from django.db.models.query to avoid making the main module very large and/or so that they can be used by other modules without getting into circular import difficulties. N) namedtuple) FieldError)DEFAULT_DB_ALIAS DatabaseError connections) LOOKUP_SEP)treedjango.db.modelsPathInfozGfrom_opts to_opts target_fields join_field m2m direct filtered_relationc#jK|V|D]}t|Ed{VdSN)__subclasses__ subclassesclssubclasss [/var/www/surfInsights/venv3-11/lib/python3.11/site-packages/django/db/models/query_utils.pyrrsW III&&((((h''''''''''((c|eZdZdZdZdZdZeZdZdddfd Z d Z d Z d Z d Z dZ ddZdZefdZdZxZS)Qze Encapsulate filters as objects that can then be combined logically (using `&` and `|`). ANDORXORTNF) _connector_negatedctg|t|||dS)N)children connectornegated)super__init__sorteditems)selfrrargskwargs __class__s rr!z Q.__init__0sQ 5t5fV\\^^445       rcPt|dddurt||s|S|s)t|tr|S||}|||||||S)N conditionalF)r)getattr TypeErrorcopy isinstancercreateadd)r$otherconnobjs r_combinez Q._combine7s 5- / /5 8 8E"" " ::<<  E1-- 99;; kkDk)) d t rc8|||jSr )r3rr$r0s r__or__zQ.__or__Ds}}UDG,,,rc8|||jSr )r3rr5s r__and__z Q.__and__G}}UDH---rc8|||jSr )r3rr5s r__xor__z Q.__xor__Jr9rcV|}||Sr )r,negate)r$r2s r __invert__z Q.__invert__Ms!iikk  rcl||||dd|\}}|||S)NF) allow_joins split_subqcheck_filterable summarize)_add_q promote_joins)r$queryr@reuserCfor_saveclausejoinss rresolve_expressionzQ.resolve_expressionRsM   #" %   E""" rc#K|V|jD]N}t|tr|d}t|dr|Ed{VJ|VOdS)zg Recursively yield this Q object and all subexpressions, in depth-first order. flattenN)rr-tuplehasattrrN)r$childs rrNz Q.flattenbs  ]  E%'' !aui((  ==??********   rc ddlm}m}ddlm}ddlm}ddlm}|d}| D]8\} } t| ds || } | | | d 9| |d d t|j jr7|t!||d | n||||} | |duS#t&$r'} t(d|| Yd} ~ d Sd} ~ wwxYw)z| Do a database query to check if the expressions of the Q instance matches against the expressions. r) BooleanFieldValue)Coalesce)Query)SINGLENrKF)selectrM_checkT) output_field)usingz.Got a database error calling check() on %r: %s)django.db.modelsrSrTdjango.db.models.functionsrUdjango.db.models.sqlrVdjango.db.models.sql.constantsrWr#rPadd_annotationrfeaturessupports_comparing_boolean_expradd_qr get_compiler execute_sqlrloggerwarning) r$againstr[rSrTrUrVrWrFnamevaluecompileres rcheckzQ.checkqs 98888888777777......999999d "==?? < @RSSDT]## >T\ ) )#'>F< < &!%F: T6!!r)NTNFF)rqrp __qualname____doc__rrrrtr)r!r3r6r8r;r>rKrNrrmrv __classcell__)r's@rrr#s  C B CGK)-          ---...... SX   $4: " " " " " " "rrc&eZdZdZdZddZdZdS)DeferredAttributez A wrapper for a deferred-loading field. When the value is read from this object the first time, the query is executed. c||_dSr )field)r$r}s rr!zDeferredAttribute.__init__s  rNc||S|j}|jj}||vr4||}|||gn|||<||S)zx Retrieve and caches the value from the datastore on the first lookup. Return the cached value. N)fields)__dict__r}attname_check_parent_chainrefresh_from_db)r$instancerdata field_namevals r__get__zDeferredAttribute.__get__sw  K Z' T ! !**844C{(( (====#&Z Jrc|j}||jj}|jjr |j|krt ||jSdS)z Check if the field value can be fetched from a parent field already loaded in the instance. This can be done if the to-be fetched field is a primary key field. N)_metaget_ancestor_linkr}model primary_keyr*r)r$ropts link_fields rrz%DeferredAttribute._check_parent_chainsT ~++DJ,<== : ! 9djJ&>&>8Z%788 8trr )rqrprwrxr!rrrrr{r{sP     &     rr{ceZdZdZdZdZdS)class_or_instance_methodz Hook used in RegisterLookupMixin to return partial functions depending on the caller type (instance or class of models.Field). c"||_||_dSr ) class_methodinstance_method)r$rrs rr!z!class_or_instance_method.__init__s(.rcn|tj|j|Stj|j|Sr ) functoolspartialrr)r$rowners rrz class_or_instance_method.__get__s4  $T%6>> > !5x@@@rN)rqrprwrxr!rrrrrrsA ///AAAAArrc0eZdZdZejddZdZeeeZ e eZdZ dZ e dZe d Zdd Zdd ZeeeZe eZdd Zdd ZeeeZe eZdS)RegisterLookupMixincR||dSr ) get_lookupsget)r$ lookup_names r _get_lookupzRegisterLookupMixin._get_lookups$!!%%k4888rN)maxsizechdtj|D}||S)NcDg|]}|jdiS) class_lookups)rr).0parents r z9RegisterLookupMixin.get_class_lookups..s7   9?FO   4 4   r)inspectgetmro merge_dicts)rrs rget_class_lookupsz%RegisterLookupMixin.get_class_lookupss?  CJ>RUCVCV   }---rc`|}t|ddx}ri||S|SNinstance_lookups)rr*)r$rrs rget_instance_lookupsz(RegisterLookupMixin.get_instance_lookupssE..00 &t-?FF F  98m8'78 8rcddlm}||}|*t|dr|j|S|t ||sdS|S)Nr)LookuprZ)django.db.models.lookupsrrrPrZ get_lookup issubclass)r$rrfounds rrzRegisterLookupMixin.get_lookupsp333333  -- =WT>::=$// << <  Zv%>%> 4 rcddlm}||}|*t|dr|j|S|t ||sdS|S)Nr) TransformrZ)rrrrPrZ get_transformr)r$rrrs rrz!RegisterLookupMixin.get_transformsp666666  -- =WT>::=$22;?? ?  Zy%A%A 4 rcXi}t|D]}|||S)z Merge dicts in reverse to preference the order of the original list. e.g., merge_dicts([a, b]) will preference the keys in 'a' over those in 'b'. )reversedupdate)dictsmergedds rrzRegisterLookupMixin.merge_dictss8 %  A MM!     rc\t|D]}|jdSr )rr cache_clearrs r_clear_cached_class_lookupsz/RegisterLookupMixin._clear_cached_class_lookupss9"3 5 5H  & 2 2 4 4 4 4 5 5rct||j}d|jvri|_||j|<||S)Nr)rrrrrlookuprs rregister_class_lookupz)RegisterLookupMixin.register_class_lookup sI   ,K #, . . "C )/+& ''))) rcL||j}d|jvri|_||j|<|Sr)rrrr$rrs rregister_instance_lookupz,RegisterLookupMixin.register_instance_lookups7   ,K T] 2 2$&D !-3k* rcP||j}|j|=|dS)zn Remove given lookup from cls lookups. For use in tests only as it's not thread-safe. N)rrrrs r_unregister_class_lookupz,RegisterLookupMixin._unregister_class_lookup"s5   ,K  k * '')))))rc(||j}|j|=dS)zs Remove given lookup from instance lookups. For use in tests only as it's not thread-safe. N)rrrs r_unregister_instance_lookupz/RegisterLookupMixin._unregister_instance_lookup,s#   ,K  !+ . . .rr )rqrprwrr lru_cacherrrr classmethodrr staticmethodrrrrregister_lookuprr_unregister_lookuprrrrrs999Y&&&..'&.  +*+<>RSSK# $566\55[5/.7O(K(=>>****////21 "= +{+CDDrrFc|jsdS|jjr|sdS|r'|r||vrdS|s |j|vrdS|s |jrdS|r9|r7|j|vr.||vr*t d|jjjd|jddS)af Return True if this field should be used to descend deeper for select_related() purposes. Used by both the query construction code (compiler.get_related_selections()) and the model instance creation code (compiler.klass_info). Arguments: * field - the field to be checked * restricted - a boolean field, indicating if the field list has been manually restricted using a requested clause) * requested - The select_related() dictionary. * select_mask - the dictionary of selected fields. * reverse - boolean, True if we are checking a reverse select related FzField rozM cannot be both deferred and traversed using select_related at the same time.T) remote_field parent_linkrelated_query_namerinullrrr object_name)r} restricted requested select_maskreverses rselect_related_descendr;s  u %gu  u//11BB5 5:Y665 %*u     J) # #  $ $ LU[&2 L LUZ L L L    4rctdt|dzD]A}tj|d|}||r|||dfcSBdS)z Check if the lookup_parts contains references to the given annotations set. Because the LOOKUP_SEP is contained in the default annotation names, check each prefix of the lookup_parts for a match. rMrN)Nr)rangelenrjoinr) lookup_parts annotationsnlevel_n_lookups rrefs_expressionrbsz 1c,''!+ , ,44#ac):;; ??> * * 4!<#33 3 3 3 4 8rcpfd}||p%t|ddo||jjS)z Check that self.model is compatible with target_opts. Compatibility is OK if: 1) model and opts match (where proxy inheritance is removed) 2) model is parent of opts' model or the other way around cjj|jkp5|jjvp|vSr )rconcrete_modelget_parent_list)rrs rrmz-check_rel_lookup_compatibility..checkwsO K &$*= = /"ek&A&A&C&CC /,,... rrF)r*rr)r target_optsr}rms` rcheck_rel_lookup_compatibilityrosX     5   }e,,Iu{7H1I1IrcFeZdZdZeddZdZdZdZdZ dS) FilteredRelationz7Specify custom filtering in the ON clause of SQL joins. conditionc|std||_d|_t|tstd||_g|_dS)Nzrelation_name cannot be empty.z*condition argument must be a Q() instance.) ValueError relation_namealiasr-rrru)r$rrs rr!zFilteredRelation.__init__s\ ?=>> >* )Q'' KIJJ J" rct||jstS|j|jko|j|jko|j|jkSr )r-r'NotImplementedrrrr5s r__eq__zFilteredRelation.__eq__sQ%00 "! !  %"5 5 2 ek) 2%/1 rc|t|j|j}|j|_|jdd|_|S)Nr)rrrrru)r$clones rrzFilteredRelation.clones8 !3t~NNNj Yqqq\  rc td)zz QuerySet.annotate() only accepts expression-like arguments (with a resolve_expression() method). z0FilteredRelation.resolve_expression() is unused.)NotImplementedError)r$r%r&s rrKz#FilteredRelation.resolve_expressions ""TUUUrc|j}||jt|j}||S)N)rG)rFbuild_filtered_relation_qrsetrucompile)r$rk connectionrFwheres ras_sqlzFilteredRelation.as_sqls?//c$)nn/UU&&&rN) rqrprwrxrr!rrrKrrrrrrs{AA34133    VVV'''''rr)F)rxrrlogging collectionsrdjango.core.exceptionsr django.dbrrrdjango.db.models.constantsr django.utilsr getLoggerrfr rNoderr{rrrrrrrrrr s""""""------BBBBBBBBBB111111  - . . :M   ((( u"u"u"u"u" u"u"u"p&&&&&&&&R A A A A A A A A dEdEdEdEdEdEdEdEN$$$$N   :''''''''''''''''''''r