(ph4&%SrSSKJr SSKrSSKJrJrJrJrJ r SSKJ r J r SSK J r SSKJr SS KJr SS KJr SS KJrJrJr SS KJr SS KJrJr SSKJr \ (aSSKJr Sr Sr!"SS\ 5r""SS5r#\\$\%/S4r&S\'S'S"Sjr(\ "\(5r)"SS\#5r*\\$\%/S4r+S\'S'S#Sjr,\ "\,5r-\R\"S5r/S$S%S jjr0\Rb\Rd\RfS!.r4g)&z& Utility module to manipulate queries ) annotationsN)AnyCallableMappingMatch NamedTuple)Sequence TYPE_CHECKING) lru_cache)pq)errors) Composable)BufferQueryParams)PyFormat) TypeAlias TypeGuard) conn_encoding) Transformeri2c4\rSrSr%S\S'S\S'S\S'Srg ) QueryPartbytesprez int | stritemrformatN)__name__ __module__ __qualname____firstlineno____annotations____static_attributes__r C/var/www/html/venv/lib/python3.13/site-packages/psycopg/_queries.pyrrs J O r'rc\rSrSrSrSR 5rS SjrS SjrS Sjr \ SSj5r \ SSj5r S r g ) PostgresQuery#zG Helper to convert a Python query and parameters into Postgres format. z^ query params types formats _tx _want_formats _parts _encoding _order cXlSUlSUlSUlSUl[ UR 5UlU SUlSUl g)Nr r') _txparamstypes _want_formatsformatsr connection _encodingquery_order)self transformers r(__init__PostgresQuery.__init__-sI6: &( 5937 &{'='=>  (, r'c[U[5(aURUR5nO3[U[5(aUR UR 5nOUnUb_[U5[::a[U5[::a[nO[nU"X0R5uUl Ul UlUlOX0l S=Ul UlUR!U5 gz Set up the query and parameters to convert. The results of this function can be obtained accessing the object attributes (`query`, `params`, `types`, `formats`). N) isinstancestrencoder3ras_bytesr-lenMAX_CACHED_STATEMENT_LENGTHMAX_CACHED_STATEMENT_PARAMS _query2pg_query2pg_nocacher4r0r5_partsdumpr6r4varsbqueryfs r(convertPostgresQuery.convert=s eS ! !\\$..1F z * *^^DHH-FF  F ::I!<<(%IJJ FTZ+T[$+ J/3 3D  $r'crUbURURXR5nURceURR X R5UlURR=(d SUlURRUlgSUlSUlSUlg)r Process a new set of variables on the query processed by `convert()`. This method updates `params` and `types`. Nr ) validate_and_reorder_paramsrEr5r0r- dump_sequencer.r/r1r6rHr.s r(rFPostgresQuery.dumpbs  55dkk4UF%%1 11((009K9KLDK-2DJ88++DLDKDJDLr'c:[U5nU[Ld U[LaSnU$U[LaSnU$[ U[ 5(a[ U[ [45(dSnU$[ U[5(aSnU$[S[U5R35e)NTFz8query parameters should be a sequence or a mapping, got ) typelisttupledictr<r rr=r TypeErrorr!)rHtsequences r(is_params_sequence PostgresQuery.is_params_sequencess J 9U H$YHh ' ' 4%0N0NHg & &H  T ++,. r'c ^[RT5(a[T5[U5S- :wa2[R"S[U5S- S[T5S35eT(a-[ USR [5(d [S5eT$T(a5[U5S:a&[ USS[5(d [S5eU(aUVs/sHnTUPM sn$gs snf![aE [R"S S R[U4S jU=(d S55535ef=f) z? Verify the compatibility between a query and a set of params. r zthe query has z placeholders but z parameters were passedrz2named placeholders require a mapping of parametersz=positional placeholders (%s) require a sequence of parametersr zquery parameter missing: z, c36># UHoT;dM Uv M g7f)Nr ).0irHs r( .s(QKqD=Ks  ) r*r[r@eProgrammingErrorr<rintrXr=KeyErrorjoinsorted)partsrHorderrs ` r(rO)PostgresQuery.validate_and_reorder_paramss8  + +D 1 14yCJN*(($SZ!^$45D {"9;JuQx}}c:: TUUKE Qz%(1+s/K/KS 38954DJ599: (( &(QEKRK(Q"QRSU s C?'C:6C?:C??AE) r3r5rEr-r0r1r.r4r/N)r7rr4rrH Params | NonereturnNonerHrmrnro)rHrrnzTypeGuard[Sequence[Any]])rilist[QueryPart]rHrrjzlist[str] | Nonernz Sequence[Any])r!r"r#r$__doc__split __slots__r8rKrF staticmethodr[rOr&r r'r(r*r*#sr  EG - #J "$  &, 5E    r'r*?tuple[bytes, list[PyFormat], list[str] | None, list[QueryPart]]r _Query2Pgc[X5nSn/n/n[USR[5(aUSSH{n[UR[5(deUR UR 5 UR SURS--5 UR UR 5 M} GOW[USR[5(Ga40n/nUSSGH&n[UR[5(deUR UR 5 URU;asS[U5S--nXR 4XvR'UR UR5 UR U5 UR UR 5 MXvRSUR :wa$[R"SURS35eUR XvRS5 GM) UR USR 5 SRU5XSU4$) a Convert Python query and params into something Postgres understands. - Convert Python placeholders (``%s``, ``%(name)s``) into Postgres format (``$1``, ``$2``) - placeholders can be %s, %t, or %b (auto, text or binary) - return ``query`` (bytes), ``formats`` (list of formats) ``order`` (sequence of names used in the query, in the position they appear) ``parts`` (splits of queries and placeholders). Nrs$%dr z placeholder 'z' cannot have different formatsr') _split_queryr<rreappendrrr=r@rcrdrg) r4encodingrirjchunksr1partseenphs r(rDrDs  )E"EFG%(--%%#2JDdii-- -- MM$(( # MM&DIIM2 3 NN4;; '  E!HMM3 ' '24#2JDdii-- -- MM$(( #yy$s4y1}-#%{{"3YY TYY' b!t{{+ ?1%4,,' {2QR d99oa01" MM%)-- 88F WU 22r'c0\rSrSrSrSrSSjrS SjrSrg) PostgresClientQueryzA PostgresQuery subclass merging query and arguments client-side. )templatec[U[5(aURUR5nO3[U[5(aUR UR 5nOUnUbY[U5[::a[U5[::a[nO[nU"X0R5uUl Ul UlO X0lSUl UR!U5 gr;)r<r=r>r3rr?r-r@rArB_query2pg_client_query2pg_client_nocacherr5rEr4rFrGs r(rKPostgresClientQuery.converts eS ! !\\$..1F z * *^^DHH-FF  F ::I!<<%5,89&..8Q 5T]DKJDK $r'c^Ub`TRTRUTR5n[U4SjU55TlTR TR-TlgSTlg)rNNc3b># UH$obTRRU5OSv M& g7f)NsNULL)r- as_literal)r_pr6s r(ra+PostgresClientQuery.dump..s* NT-##A&WDfs,/)rOrEr5rVr.rr4rQs` r(rFPostgresClientQuery.dumps]  55dkk4UF NT DK4DJDKr')r5rEr.r4rNrlrp) r!r"r#r$rrrtrKrFr&r r'r(rrsI< r'r/tuple[bytes, list[str] | None, list[QueryPart]]_Query2PgClientc~[XSS9nSn/n[USR[5(a[USSHPn[UR[5(deUR UR 5 UR S5 MR GO[USR[ 5(a0n/nUSSHn[UR[ 5(deUR UR 5 URU;aISnXuR4XeR'UR UR5 UR U5 MUR XeRS5 UR UR5 M UR USR 5 SRU5X24$)zP Convert Python query and params into a template to perform client-side binding F)collapse_double_percentNrrys%sr') rzr<rrer{rr=rrg)r4r|rirjr}r~rrs r(rr$sZ % HE"EF%(--%%#2JDdii-- -- MM$(( # MM%  E!HMM3 ' '24#2JDdii-- -- MM$(( #yy$#%{{"3YY TYY' b! d99oa01 TYY' MM%)-- 88F U ))r's"(?x) % # a literal % (?: (?: \( ([^)]+) \) # or a name in (braces) . # followed by a format ) | (?:.) # or any char, really ) c/nSnSn[RU5H?nXURS5SnURXe45 URS5SnMA U(aURXSS45 OURUS45 /nSnSn U[ U5:GaX8upeUc-UR[ US[ R55 U$URS5n U S:Xa$U(aSn X8S-upXj-U -U 4X8S-'X8 MU S:XaN[R"SXRS5SSR5SRU5S35eU S:Xa[R"S 5eU S SS ;a8[R"S URS5RU5S35eURS5(a URS5RU5OUn U (d [U 5n O$U [U 5La[R"S 5e[U S SnUR[ XmU55 US- nU[ U5:aGMU$)Nrr s%%%s%(zincomplete placeholder: ''s% zfincomplete placeholder: '%'; if you want to use '%' as an operator you can double it up, i.e. use '%%'ryssbtz8only '%s', '%b', '%t' are allowed as placeholders, got 'z1positional and named placeholders cannot be mixed)_re_placeholderfinditerspanr{r@rrAUTOgrouprcrdrsdecoderT _ph_to_fmt)r4r|rricurmrrvr`phtyperpre1m1rrs r(rzrz[s|68E C A  % %e ,!&&)A,' cXffQil-  eDk4() eT]# B A F c%j. 9 IIiQ 6 7 X IUWWQZ ;&U|HDHtOR0Ea%L  ;$$66!9Q<=)//1!4;;HEFaI 5[$$@ WF "$$WWQZ&&x014 /0ggajjqwwqz  *a$ZF 4: %$$C BrsG$ )Cv./ Q_ c%j.b Ir')stb)r4rr|r=rnrv)r4rr|r=rnr)asciiT)r4rr|r=rboolrnrq)5rr __future__rretypingrrrrrr r functoolsr r rrcsqlrabcrrr_enumsr_compatrr _encodingsrrrArBrr*rr=rwr%rDrCrrrrcompilerrzrTEXTBINARYrr r'r(rsj # <<*&&)% "   DDP  CLSS 9 /3 /3/3D/3n ' ( 2-2j& CLCC "* "*"*4"*J56**    LPG GGDHGGV -- -- // r'