ޠjXESrSSKJr SSKrSSKJr SSKJr SSK Jr SSK J r SSK Jr SSKJr SS KJr SSKJr \R&"\5r"S S 5r"S S 5r"SS5r\R2rg)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_columnc(\rSrSrSrSrSrSrSrg)Bakery"zCallable 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 clscachecXlX lgNr )selfcls_rs N/var/www/html/gaurav/venv/lib/python3.13/site-packages/sqlalchemy/ext/baked.py__init__Bakery.__init__0s  c:URURX5$rr )r initial_fnargss r__call__Bakery.__call__4sxx J55r)rrN) __name__ __module__ __qualname____firstlineno____doc__ __slots__rr__static_attributes__rrr r "s I6rr c\rSrSrSrSrSSjr\SSj5rSr SSjr S r S r S r S rS rSrSSjrSrSSjrSSjrSrSrSrSrSrg) BakedQuery8z3A builder object for :class:`.query.Query` objects.)steps_bakery _cache_key_spoiledc^SUlURX#5 U/UlSUlXlg)Nr$F)r*_update_cache_keyr(r+r))rbakeryrrs rrBakedQuery.__init__=s, z0 \   rNc>[U[R"XS95$)zCConstruct a new bakery. :return: an instance of :class:`.Bakery` ) size_alert)r rLRUCache)rsize _size_alerts rr.BakedQuery.bakeryDsc4==FGGrc[R[5nURUl[UR5UlUR UlUR UlU$r)r&__new__r*listr(r)r+)rb1s r_cloneBakedQuery._cloneNsH    +  #\\ mm  rcJU=RUR4U-- slgr)r*__code__rfnrs rr-BakedQuery._update_cache_keyVs BKK>D00rct[U[5(aUR"U6 U$URU5 U$r) isinstancetuple add_criteriarothers r__iadd__BakedQuery.__iadd__Ys9 eU # #   u %    e $ rcl[U[5(aUR"U6$URU5$r)rBrC with_criteriarEs r__add__BakedQuery.__add__`s1 eU # #%%u- -%%e, ,rc^URX5 URRU5 U$)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 rrDBakedQuery.add_criteriafs) r( " rcDUR5R"U/UQ76$)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. )r:rDr>s rrJBakedQuery.with_criteriaqs {{}))"4t44rc[X5$)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$URU5$r)rVrTs rrBakedQuery.__call__s((rcU(dHUR(d7UR5nU=RS- slUR/UlSUlU$)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. ) _query_onlyT)r+r:r*_retrieve_baked_queryr()rfull _spoil_points rspoilBakedQuery.spoilsF(DMM;;=L  # #'7 7 #&<<=DJ  rc6URUR4-$)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_clsrTs r_effective_keyBakedQuery._effective_keys'"4"4!666rcFUR5nURXUS9 U$)z)Cloning version of _add_lazyload_options.) cache_path)r:_add_lazyload_options)roptionseffective_pathrfqs r_with_lazyload_options!BakedQuery._with_lazyload_optionss% KKM JOrc4^^SnU(dTnTHcnUR(dUR(dM'UR5nUcURSS9 MKUS(aS5eXFS- nMe UR UU4SjUR U5 g) 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. r$NT)r]zloader options with variable bound parameters not supported with baked queries. Please use new-style select() statements for cached ORM queries.rc@>URT5R"T6$r)_with_current_pathrh)rjrirhs r2BakedQuery._add_lazyload_options..sa**>:BBGLr)_is_legacy_option_is_compile_state_generate_cache_keyr_rDpath)rrhrirfkeyoptcks `` rrg BakedQuery._add_lazyload_optionss'JC$$(=(=(=,,.:JJDJ)!!u'9 a5LC  L OO  rcURRURU5S5nUc>URU5nUR S5URURU5'UR U5$r)r)getrc _as_query with_session)rrUquerys rr\ BakedQuery._retrieve_baked_querysp   !4!4W!=tD =NN7+E9>9K9K:DLL,,W5 6!!'**rcURU5nSUlUR5nURR(a UU4UR UR U5'X#4$r)r}rU _statement_20_compile_options_bake_okr)rc)rrUr statements r_bakeBakedQuery._bakesdw' '')   % % . .:DLL,,W5 6 rc[U[5(aUnOR[U[5(a&URnUc[R "S5eO[ S[U5-5eURU5$)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.) rBrrrUsa_exc ArgumentError TypeErrortyper})rquery_or_sessionrUs rto_queryBakedQuery.to_querysD & 0 0&G (% 0 0&..G**G ;'() ~~g&&rclURS"U5nURSSH nU"U5nM U$Nrrn)r()rrUrsteps rr}BakedQuery._as_query,s8 1 g&JJqrNDKE# r)r)r*r+r()r$)N)Fr)rrrr r!r"r classmethodr.r:r-rGrKrDrJrVrr_rcrkrgr\rrr}r#r$rrr&r&8sw= IId1g  Y]&&)  B rcJU(aURRU5 U$r)rextend)rfnss r_using_post_criteriaResult._using_post_criteriaSs     & &s + rc&URU/5$)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_criteriaXs.(("..rcURRUR5RUR5nUR H nU"U5nM U$r)rr}rUrrr)rrjr?s rr}Result._as_queryqsG GG  dll + 2 24<< @%%B1A&rc4[UR55$r)strr}rs r__str__Result.__str__ws4>>#$$rc>UR5R5$r)_iter__iter__rs rrResult.__iter__zszz|$$&&rc~URnURR(aUR(aUR 5R 5$UR RURUR5S5up#UcURUR5up#UR(aURUR5nOUnURH nU"U5nM URn[UR5nURUR UR S.5 URR#X6US9nUR$RSS5(aUR'5nUR$RSS5(aUR)5nU$)N)NN)_sa_orm_load_optionscompiled_cache)execution_optionsis_single_entityFfiltered)rrUenable_baked_queriesr+r}rr)r|rcrrrrdict_execution_optionsr load_optionsexecute _attributesscalarsunique) rrrrrjr?rrresults rr Result._iter}s_ WW||00BKK>>#))+ +::>>   dll +\  =!xx 5 E << T\\*AA%%B1A& !5!56  ()"$**  %% 1B&     ! !"4e < <^^%F    ! !*e 4 4]]_F rc^[R"[S55mURR U4Sj5nUR UR 5RUR5R5$)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&>URT5$r)_legacy_from_self)rjcols rrqResult.count..sQ-@-@-Er) rcountr rrJrVrUrrscalar)rrrs @rr Result.countsXjj,- WW " "#E F~~dll+224<<@GGIIrcUR5n[U[R5(dU$US$![R a gf=f)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`. rN)onerBcollections_abcSequenceorm_exc NoResultFound)rrets rr Result.scalarsK ((*Cc?#;#;<< q6M$$  s088AAc URRS5nURUR5R UR 5R UR5R5R5$)zBReturn the first row. Equivalent to :meth:`_query.Query.first`. c&URSS5$r)slice)rjs rrqResult.first..sQWWQ]r) rrJrVrUrrrrrfirst)rrs rr Result.firsts[WW " "#: ; NN4<< ( VDLL ! ! !$"5"5 6 UW UW  rc>UR5R5$)z[Return exactly one result or raise an exception. Equivalent to :meth:`_query.Query.one`. )rrrs rr Result.one zz|!!rc>UR5R5$)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>UR5R5$)z;Return all rows. Equivalent to :meth:`_query.Query.all`. )rallrs rr Result.allrrcURRS"UR5nURXR5$)zPRetrieve an object based on identity. Equivalent to :meth:`_query.Query.get`. r)rr(rU _get_impl_load_on_pk_identity)ridentrs rr| Result.gets4 a .u&?&?@@rc f^^^ ^ ^URSRSmTRum m U U UUU4SjnTRnUR 5nU=R T 4- slUR U[ST555n[TTR5VVs0sHupxT URU_M n nn[URTR5R"S0U D65n [U 5n U S:a[ R""5eU (aU S$gs snnf)z6Load the given primary key identity from the database.r parententityc>TnUR5nUR5 SUlST ;aQ[T RT 5VVs1sHup4UbM TUR iM nnn[ R"X5n[ R"USS054Ul T RH nU"U5nM U$s snnf)N _orm_adaptT) r:_get_condition _order_byzip primary_keyrwsql_utiladapt_criterion_to_null_deep_annotate_where_criteriar) r_lcl_get_clauserjrvaluenonesr? _get_clause _get_paramsmapperprimary_key_identityrs rsetup*Result._load_on_pk_identity..setups)O A   AK++'***,@''  )K$(('#+"B"B## '',9MN!A ))qE*H%s B>B>c3&# UHoSLv M g7frr$).0elems r .Result._load_on_pk_identity..%sG2F$2FsrnNr$) _raw_columns _annotationsrrr:r*rJrCrrrwr8rVrUrrrMultipleResultsFound)rrUrrrrrid_valrrrlrrrs` ` @@@rrResult._load_on_pk_identitys(##A&33NC#)#5#5 [  @WW YY[ +'    5G2FGG  (+$f&8&8( (#  $ ( (& 0(  bnnT\\299CFCD K q5..0 0 !9  s(D-)rrrrUN)rrrr r!r"rrrrr}rrrrrrrrrr|rr#r$rrrSrS5sb=I!  /2 %'%N J  "*"AArrS)r!collections.abcabcrloggingrrrormr orm.queryr orm.sessionrsqlrr r getLoggerrlogr r&rSr.r$rrrsk* ! " !66,zzzAAH   r