9h>HFSrSSKrSSKJrJr SSKJrJrJr SSKJ r J r J r "SS5r S-Sjr "S S 5r"S S 5r"S S\ 5r"SS\ 5r"SS\ 5r"SS\ 5r"SS\5r\"\\5 \"\\SSSS9r\R-5 \"\\SSSS9r\R-5 \"\\SSS S9r\R-5 \"S!\S"S#S$S9r\R-5 \"S%\S&S'S(S9r\R-5 \"S)\S*S+S,S9r\R-5 g).z1Implementation of the Range type and adaptation N)ProgrammingErrorInterfaceError) ISQLQuoteadaptregister_adapter)new_typenew_array_type register_typec\rSrSrSrSrSSjrSrSr\ S5r \ S 5r \ S 5r \ S 5r \ S 5r\ S 5r\ S5rSrSrSrSrSrSrSrSrSrSrSrSrg)Range#amPython representation for a PostgreSQL |range|_ type. :param lower: lower bound for the range. `!None` means unbound :param upper: upper bound for the range. `!None` means unbound :param bounds: one of the literal strings ``()``, ``[)``, ``(]``, ``[]``, representing whether the lower or upper bounds are included :param empty: if `!True`, the range is empty _lower_upper_boundsNcU(d(US;a[SU<35eXlX lX0lgS=Ul=UlUlg)N)[)z(]z()z[]zbound flags not valid: ) ValueErrorrrr)selflowerupperboundsemptys A/var/www/html/env/lib/python3.13/site-packages/psycopg2/_range.py__init__Range.__init__/sE55 #:6*!EFFKK!L7; ;DK ;$+ cURcURRS3$SRURRURUR UR5$)Nz (empty=True)z{}({!r}, {!r}, {!r}))r __class____name__formatrrrs r__repr__Range.__repr__:sV << nn--.l; ;)001H1H T[[$,,8 8rcURcgURS[UR5S[UR5URS/nSR U5$)Nrrz, )rstrrrjoin)ritemss r__str__ Range.__str__AsY <<  LLO      LLO  wwu~rcUR$)z:The lower bound of the range. `!None` if empty or unbound.)rr"s rr Range.lowerN{{rcUR$)z:The upper bound of the range. `!None` if empty or unbound.)rr"s rr Range.upperSr/rcURSL$)z`!True` if the range is empty.Nrr"s risempty Range.isemptyXs||t##rc:URcgURSL$)z0`!True` if the range doesn't have a lower bound.NFrrr"s r lower_infRange.lower_inf]  << {{d""rc:URcgURSL$)z1`!True` if the range doesn't have an upper bound.NFrrr"s r upper_infRange.upper_infdr:rc\URb URcgURSS:H$)z4`!True` if the lower bound is included in the range.Fr[r7r"s r lower_incRange.lower_inck- << 4;;#6||A#%%rc\URb URcgURSS:H$)z4`!True` if the upper bound is included in the range.Fr&]r<r"s r upper_incRange.upper_incrrCrc&URcgURb4URSS:XaXR:agOXR::agURb5URSS:XaXR:aggXR:agg)NFrr@r&rETrrr)rxs r __contains__Range.__contains__ys <<  ;; "||A#%{{? # # ;; "||A#%{{? #  # rcURSL$Nr3r"s r__bool__Range.__bool__s||4''rc[U[5(dgURUR:H=(a9 URUR:H=(a URUR:H$)NF) isinstancer rrrrothers r__eq__ Range.__eq__sQ%'' u||+. u||+.  - /rc.URU5(+$rN)rUrSs r__ne__ Range.__ne__s;;u%%%rcZ[URURUR45$rN)hashrrrr"s r__hash__Range.__hash__s T[[$++t||<==rc[U[5(d[$SH.n[X5n[X5nX4:XaM Uc gUc gX4:s $ g)NrTF)rRr NotImplementedgetattr)rrTattr self_value other_values r__lt__ Range.__lt__s\%''! !3D ,J!%.K(#$!//4rc0X:XagURU5$NT)rdrSs r__le__ Range.__le__ =;;u% %rcZ[U[5(aURU5$[$rN)rRr rdr_rSs r__gt__ Range.__gt__s$ eU # #<<% %! !rc0X:XagURU5$rg)rlrSs r__ge__ Range.__ge__rjrc~URVs0sH!n[X5(dMU[X5_M# sn$s snfrN) __slots__hasattrr`)rslots r __getstate__Range.__getstate__s>?&'$*=*gd))&? ??s::cNUR5Hup#[XU5 M grN)r*setattr)rstatertvalues r __setstate__Range.__setstate__s ;;=KD D &)rrI)NNrF)r __module__ __qualname____firstlineno____doc__rrrr#r+propertyrrr4r8r=rArFrKrOrUrXr\rdrhrlrorur{__static_attributes__rrr r #s0I <8 $$## ## && && ,(/&> & " & ?'rr c[RXU5nURU(+=(a U=(d S5 U$)aCreate and register an adapter and the typecasters to convert between a PostgreSQL |range|_ type and a PostgreSQL `Range` subclass. :param pgrange: the name of the PostgreSQL |range| type. Can be schema-qualified :param pyrange: a `Range` strict subclass, or just a name to give to a new class :param conn_or_curs: a connection or cursor used to find the oid of the range and its subtype; the typecaster is registered in a scope limited to this object, unless *globally* is set to `!True` :param globally: if `!False` (default) register the typecaster only on *conn_or_curs*, otherwise register it globally :return: `RangeCaster` instance responsible for the conversion If a string is passed to *pyrange*, a new `Range` subclass is created with such name and will be available as the `~RangeCaster.range` attribute of the returned `RangeCaster` object. The function queries the database on *conn_or_curs* to inspect the *pgrange* type and raises `~psycopg2.ProgrammingError` if the type is not found. If querying the database is not advisable, use directly the `RangeCaster` class and register the adapter and typecasters using the provided functions. N) RangeCaster_from_db _register)pgrangepyrange conn_or_cursgloballycasters rregister_rangers54 ! !'L AF \2l:d; Mrc4\rSrSrSrSrSrSrSrSr Sr g) RangeAdapterz`ISQLQuote` adapter for `Range` subclasses. This is an abstract class: concrete classes must set a `name` class attribute or override `getquoted()`. NcXlgrN)adapted)rrs rrRangeAdapter.__init__s rc.UR[LaU$grN)_protor)rprotos r __conform__RangeAdapter.__conform__s ;;) #K $rcXlgrN)_conn)rconns rprepareRangeAdapter.prepares rcURc [S5eURnUR(aSURR S5-$UR bR[ UR 5n[US5(aURUR5 UR5nOSnURbR[ UR5n[US5(aURUR5 UR5nOSnURR S5S-U-S-U-S-URR S5-S -$) NzMRangeAdapter must be subclassed overriding its name or the getquoted() methods 'empty'::utf8rsNULL(s, s, 's')) nameNotImplementedErrorrr4encoderrrsrr getquotedrr)rrarrs rrRangeAdapter.getquoteds$ 99 %,- - LL 99$))"2"26":: : 77 aggAq)$$ $**%KKMEE 77 aggAq)$$ $**%KKMEEyy'$.6>Fyy''/0278 8r)rr) r r}r~rrrrrrrrrrrrrs" D8rrc\rSrSrSrS SjrSr\S5r\ R"S\ R5r \ R"S5r S S jrS S jrS rg) rizHelper class to convert between `Range` and PostgreSQL range types. Objects of this class are usually created by `register_range()`. Manual creation could be useful if querying the database is not advisable: in this case the oids must be provided. Nc:X@lURX5 URR=(d URRR n[ U4X`R5UlUb![U4US-UR5Ul gSUl g)NARRAY) subtype_oid_create_rangesadapterrrr rparse typecasterr array_typecaster)rrroidr array_oidrs rrRangeCaster.__init__$s|& G-||  CDLL$:$:$C$C"C64<  $2 dWndoo%?D !%)D !rc&SUl[U[5(a([U[405UlXRlO%[ U[5(aU[LaXlURc [S5eSUl[U[5(a[U[405Ul[ U[5(aU[LaX lURc [S5eg![a Nf=f![a N5f=f)z0Create Range and RangeAdapter classes if needed.Nz:pgrange must be a string or a RangeAdapter strict subclassz1pyrange must be a type or a Range strict subclass) rrRr(typerr issubclass TypeErrorranger )rrrs rrRangeCaster._create_ranges2s  gs # #,"=DL 'LL  g|44#<7#*L << LN N  '3''!'E8R8 '5))gU.B$  :: CE E !     s%$C3 AD3 D?D DDc(SSKJn SSKJn U"U5upgURR S:a"[ SURR -5eURnSU;aURSS5upOUn Sn URS X45 UR5n U (doS n URU:XaURS 5 S n URS U45 UR5n U (aU SSupW (aURS5 X:wa!UR(dUR5 U (d[ SUS35eU SSupn[XXUS9$![ a Nsf=f!W (aURS5 ff=f)zlReturn a `RangeCaster` instance for the type *pgrange*. Raise `ProgrammingError` if the type is not found. r)STATUS_IN_TRANSACTION)_solve_conn_cursiX`z'range types not available in version %s.r&publiczselect rngtypid, rngsubtype, typarray from pg_range r join pg_type t on t.oid = rngtypid join pg_namespace ns on ns.oid = typnamespace where typname = %s and ns.nspname = %s; FzSAVEPOINT register_typeTzSELECT rngtypid, rngsubtype, typarray, typname, nspname from pg_range r join pg_type t on t.oid = rngtypid join pg_namespace ns on ns.oid = typnamespace WHERE t.oid = %s::regtype Nz#ROLLBACK TO SAVEPOINT register_typezPostgreSQL range 'z ' not foundrrr)psycopg2.extensionsrpsycopg2.extrasrinfoserver_versionrstatussplitexecutefetchone autocommitrollbackr)rrrrrrrcurs conn_statusschematnamerec savepointrsubtypearrays rrRangeCaster._from_dbUs >4%l3  99 # #e +"#L))**$+, ,kk  $; JJsA.MFEEF   _  mmo H! ;;"77LL!:; $I   X mmo$'GMELL!FG  / MMO"$TF+68 8 #2Awu4U< <)$  LL!FGs*)8E&!E6& E30E62E33E66Fa] ( \(|\[ ) # lower bound flag (?: # lower bound: " ( (?: [^"] | "")* ) " # - a quoted string | ( [^",]+ ) # - or an unquoted string )? # - or empty (not catched) , (?: # upper bound: " ( (?: [^"] | "")* ) " # - a quoted string | ( [^"\)\]]+ ) # - or an unquoted string )? # - or empty (not catched) ( \)|\] ) # upper bound flag z (["\\])\1c~UcgUS:XaURSS9$URRU5nUc[SUS35eUR S5nUc0UR S5nUbUR R SU5nUR S 5nUc0UR S 5nUbUR R SU5nUb8URURU5nURURU5nUR S 5UR S 5-nURXEU5$) NrT)rzfailed to parse range: ''rz\1r&) r _re_rangematchrgroup _re_undoublesubcastr)rscurmrrrs rrRangeCaster.parses& 9 <::D:) ) NN  # 9 #;A3a!@A A  =GGAJE ))--eU;  =GGAJE ))--eU; ?HHT--u5EHHT--u5Eaggaj(zz%//rc[URU5 URb[URU5 [URUR 5 grN)r rrrrr)rscopes rrRangeCaster._registers>doou-  , $// 7T\\2r)rrrrrrN)r r}r~rrrr classmethodrrecompileVERBOSErrrrrrrrrrsb )!EFJ<J3rrc\rSrSrSrSrg) NumericRangeizA `Range` suitable to pass Python numeric types to a PostgreSQL range. PostgreSQL types :sql:`int4range`, :sql:`int8range`, :sql:`numrange` are casted into `!NumericRange` instances. rNr r}r~rrrrrrrrs   rrc\rSrSrSrSrg) DateRangeiz#Represents :sql:`daterange` values.rNrrrrrr-rrc\rSrSrSrSrg) DateTimeRangeiz!Represents :sql:`tsrange` values.rNrrrrrrs+rrc\rSrSrSrSrg)DateTimeTZRangeiz#Represents :sql:`tstzrange` values.rNrrrrrrrrrc\rSrSrSrSrSrg)NumberRangeAdapteriz1Adapt a range if the subtype doesn't need quotes.cURnUR(agUR(d3[UR5R 5R S5nOSnUR(d3[UR5R 5R S5nOSnSURSUSUURSS3RS5$)Ns'empty'asciir'rr,r&) rr4r8rrrdecoder=rrr)rrrrs rrNumberRangeAdapter.getquoteds LL 99{{ !''N,,.55g>EE{{!''N,,.55g>EEAIIaL>%%1a@HHQQrrN)r r}r~rrrrrrrrrs ;Rrri@iAriViWiBiiC daterangeiHi:iItsrangeiDiZiE tstzrangeiFiiG)F)rrpsycopg2._psycopgrrrrrrrr r r rrrrrrrrint4range_casterrint8range_casternumrange_casterdaterange_castertsrange_castertstzrange_casterrrrrsb6 >BBGGh'h'V>-8-8`y3y3x 5    E  e RR212 1< ".1< ".0, $$0{I $$0Y  $$0{O $$0r