+ iGRt^RIHt^RIt^RIHt^RIHt^RI Ht ^RI H t ^RI Ht^RIHt^RIHt^RIHt]P&!]4t!RR 4t!R R 4t!R R 4t]P2tR#)zBaked query extension. Provides a creational pattern for the :class:`.query.Query` object which allows the fully constructed object, Core select statement, and string compiled result to be fully cached. N)exc)util)Query)Session)func)literal_columnc4a]tRt^#toRtRtRtRtRtVt R#)BakeryzCallable which returns a :class:`.BakedQuery`. This object is returned by the class method :meth:`.BakedQuery.bakery`. It exists as an object so that the "cache" can be easily inspected. .. versionadded:: 1.2 cWnW nR#Nclscache)selfcls_rs&&&nC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\sqlalchemy/ext/baked.py__init__Bakery.__init__1s  c:VPVPW4#r r )r initial_fnargss&&*r__call__Bakery.__call__5sxx J55r)rr Nr ) __name__ __module__ __qualname____firstlineno____doc__ __slots__rr__static_attributes____classdictcell__ __classdict__s@rr r #s  I66rr ca]tRt^9toRtRtRRlt]RRl4tRt RRlt Rt Rt R t R tR tR tRR ltRtRRltRRltRtRtRtRtRtVtR#) BakedQueryz3A builder object for :class:`.query.Query` objects.c`RVnVPW#4V.VnRVnWnR#)FN) _cache_key_update_cache_keysteps_spoiled_bakery)rbakeryrrs&&&&rrBakedQuery.__init__>s, z0 \   rNc D\V\P!WR74#)zCConstruct a new bakery. :return: an instance of :class:`.Bakery` ) size_alert)r rLRUCache)r size _size_alerts&&&rr-BakedQuery.bakeryEsc4==FGGrc\P\4pVPVn\VP4VnVP VnVP VnV#r )r%__new__r(listr*r,r+)rb1s& r_cloneBakedQuery._cloneOsH    +  #\\ mm  rc\V;PVP3V,, unR#r )r(__code__rfnrs&&&rr)BakedQuery._update_cache_keyWs BKK>D00rcx\V\4'dVP!V!V#VPV4V#r ) isinstancetuple add_criteriarothers&&r__iadd__BakedQuery.__iadd__Zs9 eU # #   u %    e $ rcp\V\4'dVP!V!#VPV4#r )rArB with_criteriarDs&&r__add__BakedQuery.__add__as1 eU # #%%u- -%%e, ,rc ^VPW4VPPV4V#)zAdd a criteria function to this :class:`.BakedQuery`. This is equivalent to using the ``+=`` operator to modify a :class:`.BakedQuery` in-place. )r)r*appendr=s&&*rrCBakedQuery.add_criteriags) r( " rc FVP4P!V.VO5!#)zAdd a criteria function to a :class:`.BakedQuery` cloned from this one. This is equivalent to using the ``+`` operator to produce a new :class:`.BakedQuery` with modifications. )r9rCr=s&&*rrIBakedQuery.with_criteriars {{}))"4t44rc \W4#)zReturn a :class:`_baked.Result` object for this :class:`.BakedQuery`. This is equivalent to calling the :class:`.BakedQuery` as a Python callable, e.g. ``result = my_baked_query(session)``. )Resultrsessions&&r for_sessionBakedQuery.for_session|sd$$rc$VPV4#r )rUrSs&&rrBakedQuery.__call__s((rc V'gNVP'g<VP4pV;PR, unVP.VnRVnV#)aCancel any query caching that will occur on this BakedQuery object. The BakedQuery can continue to be used normally, however additional creational functions will not be cached; they will be called on every invocation. This is to support the case where a particular step in constructing a baked query disqualifies the query from being cacheable, such as a variant that relies upon some uncacheable value. :param full: if False, only functions added to this :class:`.BakedQuery` object subsequent to the spoil step will be non-cached; the state of the :class:`.BakedQuery` up until this point will be pulled from the cache. If True, then the entire :class:`_query.Query` object is built from scratch each time, with all creational functions being called on each invocation. T) _query_only)r+r9r(_retrieve_baked_queryr*)rfull _spoil_points&& rspoilBakedQuery.spoilsH(DMMM;;=L  # #'7 7 #&<<=DJ  rc >VPVP3,#)asReturn the key that actually goes into the cache dictionary for this :class:`.BakedQuery`, taking into account the given :class:`.Session`. This basically means we also will include the session's query_class, as the actual :class:`_query.Query` object is part of what's cached and needs to match the type of :class:`_query.Query` that a later session will want to use. )r( _query_clsrSs&&r_effective_keyBakedQuery._effective_keys'"4"4!666rc LVP4pVPWVR7V#)z)Cloning version of _add_lazyload_options.) cache_path)r9_add_lazyload_options)roptionseffective_pathreqs&&&& r_with_lazyload_options!BakedQuery._with_lazyload_optionss% KKM JOrc ^aaRpV'gSpSFvpVP'gVP'gK)VP4pVfVPRR7KQV^,'dQR4hWF^,, pKx VP VV3RlVP V4R#)aUsed by per-state lazy loaders to add options to the "lazy load" query from a parent query. Creates a cache key based on given load path and query options; if a repeatable cache key cannot be generated, the query is "spoiled" so that it won't use caching. NT)r\zloader options with variable bound parameters not supported with baked queries. Please use new-style select() statements for cached ORM queries.cB<VPS4P!S!#r )_with_current_pathrg)rirhrgs&r2BakedQuery._add_lazyload_options..sa**>:BBGLrr')_is_legacy_option_is_compile_state_generate_cache_keyr^rCpath)rrgrhrekeyoptcks&ff& rrf BakedQuery._add_lazyload_optionss'JC$$$(=(=(=,,.:JJDJ)!!uu'9 a5LC  L OO  rcVPPVPV4R4pVf?VPV4pVP R4VPVPV4&VP V4#r )r,getrb _as_query with_session)rrTquerys&& rr[ BakedQuery._retrieve_baked_querysp   !4!4W!=tD =NN7+E9>9K9K:DLL,,W5 6!!'**rcVPV4pRVnVP4pVPP'd!VV3VP VP V4&W#3#r )r{rT _statement_20_compile_options_bake_okr,rb)rrTr} statements&& r_bakeBakedQuery._bakesgw' '')   % % . . .:DLL,,W5 6 rc \V\4'dTpMX\V\4'd(VPpVf\P !R4hM\ R\V4,4hVPV4#)ahReturn the :class:`_query.Query` object for use as a subquery. This method should be used within the lambda callable being used to generate a step of an enclosing :class:`.BakedQuery`. The parameter should normally be the :class:`_query.Query` object that is passed to the lambda:: sub_bq = self.bakery(lambda s: s.query(User.name)) sub_bq += lambda q: q.filter(User.id == Address.user_id).correlate(Address) main_bq = self.bakery(lambda s: s.query(Address)) main_bq += lambda q: q.filter(sub_bq.to_query(q).exists()) In the case where the subquery is used in the first callable against a :class:`.Session`, the :class:`.Session` is also accepted:: sub_bq = self.bakery(lambda s: s.query(User.name)) sub_bq += lambda q: q.filter(User.id == Address.user_id).correlate(Address) main_bq = self.bakery( lambda s: s.query(Address.id, sub_bq.to_query(q).scalar_subquery()) ) :param query_or_session: a :class:`_query.Query` object or a class :class:`.Session` object, that is assumed to be within the context of an enclosing :class:`.BakedQuery` callable. .. versionadded:: 1.3 z1Given Query needs to be associated with a Sessionz)Query or Session object expected, got %r.) rArrrTsa_exc ArgumentError TypeErrortyper{)rquery_or_sessionrTs&& rto_queryBakedQuery.to_querysD & 0 0&G (% 0 0&..G**G ;'() ~~g&&rc|VP^,!V4pVPR,F pV!V4pK V#):NN)r*)rrTr}steps&& rr{BakedQuery._as_query-s8 1 g&JJrNNDKE# r)r,r(r+r*)r*r,r(r+)r')N)Fr )rrrrrrr classmethodr-r9r)rFrJrCrIrUrr^rbrjrfr[rrr{r r!r"s@rr%r%9s= IId1g  Y]&&)  B rcLV'dVPPV4V#r )rextend)rfnss&&r_using_post_criteriaResult._using_post_criteriaTs     & &s + rc &VPV.4#)a|Add a criteria function that will be applied post-cache. This adds a function that will be run against the :class:`_query.Query` object after it is retrieved from the cache. This currently includes **only** the :meth:`_query.Query.params` and :meth:`_query.Query.execution_options` methods. .. warning:: :meth:`_baked.Result.with_post_criteria` functions are applied to the :class:`_query.Query` object **after** the query's SQL statement object has been retrieved from the cache. Only :meth:`_query.Query.params` and :meth:`_query.Query.execution_options` methods should be used. .. versionadded:: 1.2 )r)rr>s&&rwith_post_criteriaResult.with_post_criteriaYs.(("..rcVPPVP4PVP4pVP F pV!V4pK V#r )rr{rTrrr)rrir>s& rr{Result._as_queryrsG GG  dll + 2 24<< @%%B1A&rc4\VP44#r )strr{rs&r__str__Result.__str__xs4>>#$$rc>VP4P4#r )_iter__iter__rs&rrResult.__iter__{szz|$$&&rcVPpVPP'dVP'dVP 4P 4#VP PVPVP4R4wr#VfVPVP4wr#VP'dVPVP4pMTpVPF pV!V4pK VPp\VP4pVPRVP RVP /4VPP#W6VR7pVP$PRR4'dVP'4pVP$PRR4'dVP)4pV#)N_sa_orm_load_optionscompiled_cache)execution_optionsis_single_entityFfiltered)NN)rrTenable_baked_queriesr+r{rr,rzrbrrrrdict_execution_optionsr load_optionsexecute _attributesscalarsunique) rrr}rrir>rrresults & rr Result._iter~sj WW||000BKKK>>#))+ +::>>   dll +\  =!xx 5 E <<< T\\*AA%%B1A& !5!56  & "**  %% 1B&     ! !"4e < <^^%F    ! !*e 4 4]]_F rc a\P!\R44oVPP V3Rl4pVP VP 4PVP4P4#)zreturn the 'count'. Equivalent to :meth:`_query.Query.count`. Note this uses a subquery to ensure an accurate count regardless of the structure of the original statement. *c&<VPS4#r )_legacy_from_self)ricols&rroResult.count..sQ-@-@-Er) rcountrrrIrUrTrrscalar)rrrs& @rr Result.countsXjj,- WW " "#E F~~dll+224<<@GGIIrc VP4p\V\P4'gV#V^,# \P dR#i;i)zReturn the first element of the first result or None if no rows present. If multiple rows are returned, raises MultipleResultsFound. Equivalent to :meth:`_query.Query.scalar`. N)onerAcollections_abcSequenceorm_exc NoResultFound)rrets& rr Result.scalarsK ((*Cc?#;#;<< q6M$$  s1==AAc VPPR4pVPVP4P VP 4P VP4P4P4#)zBReturn the first row. Equivalent to :meth:`_query.Query.first`. c&VP^^4#)r)slice)ris&rroResult.first..sQWWQ]r) rrIrUrTrrrrrfirst)rrs& rr Result.firsts[WW " "#: ; NN4<< ( VDLL ! ! !$"5"5 6 UW UW  rc >VP4P4#)z[Return exactly one result or raise an exception. Equivalent to :meth:`_query.Query.one`. )rrrs&rr Result.one zz|!!rc >VP4P4#)zwReturn one or zero results, or raise an exception for multiple rows. Equivalent to :meth:`_query.Query.one_or_none`. )r one_or_noners&rrResult.one_or_noneszz|''))rc >VP4P4#)z;Return all rows. Equivalent to :meth:`_query.Query.all`. )rallrs&rr Result.allrrc VPP^,!VP4pVPWP4#)zPRetrieve an object based on identity. Equivalent to :meth:`_query.Query.get`. )rr*rT _get_impl_load_on_pk_identity)ridentr}s&& rrz Result.gets4 a .u&?&?@@rc aaa a aVP^,PR,oSPwo o V V VVV3RlpSPpVP 4pV;P S 3, unTP T\;QJd.RS4FNK 5M !RS444p\SSP4UUu/uFwrxS V,PVbK p pp\VPSP4P!R/V B4p \V 4p V ^8d\ P"!4hV 'd V ^,#R#uuppi)z6Load the given primary key identity from the database. parententityc<SpVP4pVP4RVnRS 9dW\S PS 4UUu0uFwr4VeK SV,P kK ppp\ P!W4p\ P!VRR/43Vn S PF pV!V4pK V#uuppi)N _orm_adaptT) r9_get_condition _order_byzip primary_keyrusql_utiladapt_criterion_to_null_deep_annotate_where_criteriar) r}_lcl_get_clauserirvaluenonesr> _get_clause _get_paramsmapperprimary_key_identityrs & rsetup*Result._load_on_pk_identity..setups)O A   AK++'***,@''  )K$(('#+"B"B## '',9MN!A ))qE*H%s CCc3("TFqRJxK R#5ir r').0elems& r .Result._load_on_pk_identity..&sG2F$2FsNr') _raw_columns _annotationsrrr9r(rIrBrrrur7rUrTrrrMultipleResultsFound)rrTr}rrrrid_valrrrlrrrsf&&f, @@@rrResult._load_on_pk_identitys7##A&33NC#)#5#5 [  @WW YY[ +'    55G2FG55G2FGG  (+$f&8&8( (#  $ ( (& 0(  bnnT\\299CFCD K q5..0 0 !9  sE)rrrrTNr)rrrrrrrrrrr{rrrrrrrrrrzrr r!r"s@rrRrR6sk=I!  /2 %'%N J  "*"AAArrR)rcollections.abcabcrloggingrrrormr orm.queryr orm.sessionrsqlrrr getLoggerrlogr r%rRr-r'rrrsm* ! "!66,zzzAAH   r