]jl=8%SrSSKJr SSKrSSKJrJrJrJrJ r SSK J r SSK J r JrJr SSKJr SS KJrJr SS KJrJrJrJr SS KJr SS KJr SS KJr \(aSSKJ r Sr!Sr""SS\5r#"SS5r$\ \%\&/S4r'S\(S'S#Sjr)\ "\)5r*"SS\$5r+\ \%\&/S4r,S\(S'S$Sjr-\ "\-5r.\R^"S5r0S%S&Sjjr1\Rd\Rf\RhS .r5"S!S"\$5r6g)'z& Utility module to manipulate queries ) annotationsN) TYPE_CHECKINGAny NamedTuple TypeAlias TypeGuard) lru_cache)CallableMappingSequence)errors)pqsql)BufferParamsQueryQueryNoTemplate)PyFormat)Template)TemplateProcessor) Transformeri2c4\rSrSr%S\S'S\S'S\S'Srg ) QueryPartbytesprez int | stritemrformatN)__name__ __module__ __qualname____firstlineno____annotations____static_attributes__r!M/home/mande/repo/quber/.venv/lib/python3.13/site-packages/psycopg/_queries.pyrrs J O r(rc\rSrSrSrSR 5rS SjrSSjrSSjr \ SSj5r \ SSj5r SS jr SS jrS rg ) PostgresQuery"zG Helper to convert a Python query and parameters into Postgres format. z^ query params types formats _tx _want_formats _parts _encoding _order chXlSUlSUlSUlSUlU SUlSUlg)Nr!r()_txparamstypes _want_formatsformatsquery_order)self transformers r)__init__PostgresQuery.__init__,s76: &( 5937   (, r(c[U[5(aURX5$URU5nUbi[ U5[ ::a[ U5[ ::a[nO[nU"XRR5uUl Ul Ul UlOXl S=Ul Ul URU5 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) isinstancer_convert_template _ensure_byteslenMAX_CACHED_STATEMENT_LENGTHMAX_CACHED_STATEMENT_PARAMS _query2pg_query2pg_nocacher.encodingr3r1r4_partsdumpr5r3varsfs r)convertPostgresQuery.convert;s eX & &))%6 6""5)  E 99I!<<(%GHxx((H DDJ*DKJ/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_paramsrDr4r1r. dump_sequencer/r0r2r5rGr/s r)rEPostgresQuery.dump^s  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 rstrr TypeErrorr$)rGtsequences r)is_params_sequence PostgresQuery.is_params_sequenceos J 9U H$YHh ' ' 4%0N0NHg & &H  T //02 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 g7fNr!).0irGs r) .s(QKqD=Ks  ) r+rZr>eProgrammingErrorr;rintrWrVKeyErrorjoinsorted)partsrGorderrs ` r)rM)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??AEc[U[5(a%URURR5$[U[ R 5(aURUR5$U$r^)r;rVencoder.rCr Composableas_bytes)r5r3s r)r=PostgresQuery._ensure_bytessQ eS ! !<< 1 12 2 s~~ . .>>$((+ +Lr(cUb [S5e[USURS9nUR5 URUlUR (auURR UR UR5UlURR=(d SUlURRUlgSUlSUlSUlg)NA'execute()' with string template query doesn't support parametersT server_paramstxr!) rWrr.processr3r/rNr2r0r5r3rGtps r)r<PostgresQuery._convert_templates  S uDTXX F XX 99((00BJJGDK-2DJ88++DLDKDJDLr()r4rDr.r1r2r/r3r0N)r6rr3rrG Params | NonereturnNonerGr{r|r})rGrr|zTypeGuard[Sequence[Any]])rilist[QueryPart]rGrrjzlist[str] | Noner|z Sequence[Any])r3rr|rr3rrGr{r|r})r"r#r$r%__doc__split __slots__r7rIrE staticmethodrZrMr=r<r'r!r(r)r+r+"s}  EG -!F "$  &, 5E    D 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;rreappendrr rVr>rcrdrg) r3rCrirjchunksr2partseenphs r)rBrBs  )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(c:\rSrSrSrSrS SjrS SjrS SjrSr g) PostgresClientQueryzA PostgresQuery subclass merging query and arguments client-side. )templatecz[U[5(aURX5$URU5nUbc[ U5[ ::a[ U5[ ::a[nO[nU"XRR5uUl Ul Ul O XlSUl URU5 gr:)r;rr<r=r>r?r@_query2pg_client_query2pg_client_nocacher.rCrr4rDr3rErFs r)rIPostgresClientQuery.converts eX & &))%6 6""5)  E 99I!<<%5,67xx?P?P6Q 3DM4; JDK $r(c^Ub`TRTRUTR5n[U4SjU55TlTR TR-TlgSTlg)rLNc3b># UH$obTRRU5OSv M& g7f)NsNULL)r. as_literal)r_pr5s r)ra+PostgresClientQuery.dump..+s* NT-##A&WDfs,/)rMrDr4rTr/rr3rOs` r)rEPostgresClientQuery.dump#s]  55dkk4UF NT DK4DJDKr(cUb [S5e[USURS9nUR5 URUlUR Ulg)NrrFrs)rWrr.rvr3r/rws r)r<%PostgresClientQuery._convert_template2sK  S uEdhh G XX ii r()r4rDr/r3rNrzr~r) r"r#r$r%rrrIrEr<r'r!r(r)rrsI8   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_percentNrrs%sr() rr;rrerrrVr rg)r3rCrirjrrrrs r)rrCsZ % 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$URS5=n 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 '%%'rssbtz8only '%s', '%b', '%t' are allowed as placeholders, got 'z1positional and named placeholders cannot be mixed)_re_placeholderfinditerspanrr>rrAUTOgrouprcrdrdecoderR _ph_to_fmt)r3rCrricurmrrvr`phtyperpre1m1rr s r)rrxs}9;E C A  % %e ,!&&)A,' cXffQil-  eDk4() eT]# B A F c%j. 9 IIiQ 6 7 V IS''!* B &&U|HDHtOR0Ea%L  ;$$66!9Q<=)//1!4;;HEFaI 5[$$@ WF "$$WWQZ&&x014 /0ggajjqwwqz  *a$ZF 4: %$$C BrsG$ )Cv./ Q] c%j.` Ir()stbc2\rSrSrSSjrSSjrS SjrSrg) PostgresRawQueryic[U[5(aURX5$URU5UlS=UlUlURU5 gr^)r;rr<r=r3r1r4rEr5r3rGs r)rIPostgresRawQuery.convertsL eX & &))%6 6''. +//T[ $r(cUb[RU5(d [S5e[R/[ U5-UlURRXR 5Ul URR=(d SUl URRUl gSUl SUl SUl g)Nz,raw queries require a sequence of parametersr!) r+rZrWrrr>r1r.rNr/r0r2)r5rGs r)rEPostgresRawQuery.dumps   33D99 NOO"*--3t9!rsv # GG7777( "   [ [ ~  CLSS 9 /3 /3/3D/3n ' ( ; -; |& CLCC "* "*"*4"*J56**   LPF FFDHFFT -- -- //  } r(