+ ihJlRt^RIt^RIHtHt^RIHtHtHt^RIH t H t H t !RR4t R*Rlt !RR 4t!R R 4t!R R ] 4t!RR] 4t!RR] 4t!RR] 4t!RR]4t]!]]4]!]]R^RR7t]P-4]!]]R^RR7t]P-4]!]]RRRR7t]P-4]!R]RR R!R7t]P-4]!R"]R#R$R%R7t]P-4]!R&]R'R(R)R7t]P-4R#)+z1Implementation of the Range type and adaptation N)ProgrammingErrorInterfaceError) ISQLQuoteadaptregister_adapter)new_typenew_array_type register_typeca]tRt^#toRtRtRRltRtRt] R4t ] R4t ] R4t ] R 4t ] R 4t] R 4t] R 4tR tRtRtRtRtRtRtRtRtRtRtRtVtR#)RangeamPython 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 NcV'g+VR9d\RV: 24hWnW nW0nR#R;Vn;VnVnR#)[)zbound flags not valid: N)r z(]z()z[]) ValueError_lower_upper_bounds)selflowerupperboundsemptys&&&&&iC:\Users\petid\OneDrive\Desktop\Maestro\MAESTRO\maestro-backend\venv\Lib\site-packages\psycopg2/_range.py__init__Range.__init__/sE55 #:6*!EFFKK!L7; ;DK ;$+ cVPfVPP R2#RPVPPVPVP VP4#)Nz (empty=True)z{}({!r}, {!r}, {!r}))r __class____name__formatrrrs&r__repr__Range.__repr__:sV << nn--.l; ;)001H1H T[[$,,8 8rcVPfR#VP^,\VP4R\VP4VP^,.pRP V4#)Nrz, )rstrrrjoin)ritemss& r__str__ Range.__str__AsY <<  LLO      LLO  wwu~rc VP#)z:The lower bound of the range. `!None` if empty or unbound.)rrs&rr Range.lowerN{{rc VP#)z:The upper bound of the range. `!None` if empty or unbound.)rrs&rr Range.upperSr+rc VPRJ#)z`!True` if the range is empty.Nrrs&risempty Range.isemptyXs||t##rc >VPfR#VPRJ#)z0`!True` if the range doesn't have a lower bound.NFrrrs&r lower_infRange.lower_inf]  << {{d""rc >VPfR#VPRJ#)z1`!True` if the range doesn't have an upper bound.NFrrrs&r upper_infRange.upper_infdr6rc jVPeVPfR#VP^,R8H#)z4`!True` if the lower bound is included in the range.F[r3rs&r lower_incRange.lower_inck- << 4;;#6||A#%%rc jVPeVPfR#VP^,R8H#)z4`!True` if the upper bound is included in the range.F]r8rs&r upper_incRange.upper_incrr?rcVVPfR#VPe>VP^,R8XdWP8dR#MWP8:dR#VPe@VP^,R8XdWP8dR#R#WP8dR#R#)NFr<rATrrr)rxs&&r __contains__Range.__contains__ys <<  ;; "||A#%{{? # # ;; "||A#%{{? #  # rcVPRJ#Nr/rs&r__bool__Range.__bool__s||4''rc\V\4'gR#VPVP8H;'d;VPVP8H;'dVPVP8H#F) isinstancer rrrrothers&&r__eq__ Range.__eq__s[%'' u||+.. u||+..  - /rc.VPV4'*#rJ)rRrPs&&r__ne__ Range.__ne__s;;u%%%rcZ\VPVPVP34#rJ)hashrrrrs&r__hash__Range.__hash__s T[[$++t||<==rc\V\4'g\#RF3p\W4p\W4pW48XdK!VfR#VfR#W48u# R#)rTFrrr)rOr NotImplementedgetattr)rrQattr self_value other_values&& r__lt__ Range.__lt__s\%''! !3D ,J!%.K(#$!//4rc4W8XdR#VPV4#T)rbrPs&&r__le__ Range.__le__ =;;u% %rc\\V\4'dVPV4#\#rJ)rOr rbr]rPs&&r__gt__ Range.__gt__s$ eU # #<<% %! !rc4W8XdR#VPV4#re)rjrPs&&r__ge__ Range.__ge__rhrc~VPUu/uF"p\W4'gKV\W4bK$ up#uupirJ) __slots__hasattrr^)rslots& r __getstate__Range.__getstate__s>?&'$*=*gd))&? ??s::cPVP4Fwr#\WV4K R#rJ)r&setattr)rstaterrvalues&& r __setstate__Range.__setstate__s ;;=KD D &)rrEr\)NNr F)r __module__ __qualname____firstlineno____doc__rprr r'propertyrrr0r4r9r=rBrGrKrRrUrYrbrfrjrmrsry__static_attributes____classdictcell__ __classdict__s@rr r #s0I <8 $$## ## && && ,(/&> & " & ?''rr c\PWV4pTPV'*;'d T;'gR4V#)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_rangers;4 ! !'L AF \22l::d; Mrc@a]tRt^toRtRtRtRtRtRt Rt Vt R#) RangeAdapterz`ISQLQuote` adapter for `Range` subclasses. This is an abstract class: concrete classes must set a `name` class attribute or override `getquoted()`. NcWnR#rJ)adapted)rrs&&rrRangeAdapter.__init__s rc2VP\JdV#R#rJ)_protor)rprotos&&r __conform__RangeAdapter.__conform__s ;;) #K $rcWnR#rJ)_conn)rconns&&rprepareRangeAdapter.prepares rc VPf \R4hVPpVP'd#RVPP R4,#VP eT\ VP 4p\VR4'dVPVP4VP4pMRpVPeT\ VP4p\VR4'dVPVP4VP4pMRpVPP R4R,V,R,V,R,VPP R4,R ,#) NzMRangeAdapter must be subclassed overriding its name or the getquoted() methods 'empty'::utf8rsNULL(s, s, 's')) nameNotImplementedErrorrr0encoderrrqrr getquotedrr)rrarrs& rrRangeAdapter.getquoteds& 99 %,- - LL 999$))"2"26":: : 77 aggAq)$$ $**%KKMEE 77 aggAq)$$ $**%KKMEEyy'$.6>Fyy''/0278 8r)rr) rr{r|r}r~rrrrrrrrs@rrrs* D88rrca]tRtRtoRtR RltRt]R4t] P!R] P4t ] P!R4t R R ltR R ltR tVtR#) 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. NcJW@nVPW4VPP;'g!VPPP p\ V3W`P4VnVe'\V3VR,VP4Vn R#RVn R#)NARRAY) subtype_oid_create_rangesadapterrrrrparse typecasterrarray_typecaster)rrroidr array_oidrs&&&&&& rrRangeCaster.__init__$s& G-||  CCDLL$:$:$C$C"C64<  $2 dWndoo%?D !%)D !rc <RVn\V\4'd)\V\3/4VnWPnM'\ V\4'dV\JdWnVPf \R4hRVn\V\4'd\V\3/4Vn\ V\4'dV\JdW nTPf \R4hR# \dLi;i \dL9i;i)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) rrOr$typerr issubclass TypeErrorranger )rrrs&&&rrRangeCaster._create_ranges2s  gs # #,"=DL 'LL  g|44#<7#*L << LN N  '3''!'E8R8 '5))gU.B$  :: CE E !     s%&C<AD < D  D  DDc \^RIHp^RIHpV!V4wrgVPP R8d'\ RVPP ,4hVPpRV9dVPR^4wrMTp Rp VPRW34VP4p V 'gwRp VPV8XdVPR 4R p VPR V34VP4p V 'd V R ,wrX 'dTPR 4W8wd#VP'gVP4V 'g\ RV R24hV R,wrp\WWVR7# \ dLi;i X 'dTPR 4ii;i)zlReturn a `RangeCaster` instance for the type *pgrange*. Raise `ProgrammingError` if the type is not found. )STATUS_IN_TRANSACTION)_solve_conn_cursiX`z'range types not available in version %s.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 :NNz#ROLLBACK TO SAVEPOINT register_typezPostgreSQL range 'z ' not found:NrNrrr)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 #2wu4U< <)$  LL!FGs*09E>)#F> F  F F  FF+a] ( \(|\[ ) # 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 (["\\])\1cVfR#VR8XdVPRR7#VPPV4pVf\RV R24hVP ^4pVf2VP ^4pVeVP P RV4pVP ^4pVf2VP ^4pVeVP P RV4pVe9VPVPV4pVPVPV4pVP ^4VP ^4,pVPWEV4#)NrT)rzfailed to parse range: ''z\1) r _re_rangematchrgroup _re_undoublesubcastr)rscurmrrrs&&& rrRangeCaster.parses& 9 <::D:) ) NN  # 9 #;A3a!@A A  =GGAJE ))--eU;  =GGAJE ))--eU; ?HHT--u5EHHT--u5Eaggaj(zz%//rc\VPV4VPe\VPV4\VPVP 4R#rJ)r rrrrr)rscopes&&rrRangeCaster._registers>doou-  , $// 7T\\2r)rrrrrrJ)rr{r|r}r~rr classmethodrrecompileVERBOSErrrrrrrs@rrrsj )!EFJ<J33rrc]tRtRtRtRtR#) 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. Nrr{r|r}r~rrrrrrs   rrc]tRtRtRtRtR#) DateRangeiz#Represents :sql:`daterange` values.rNrrrrrr-rrc]tRtRtRtRtR#) DateTimeRangeiz!Represents :sql:`tsrange` values.rNrrrrrrs+rrc]tRtRtRtRtR#)DateTimeTZRangeiz#Represents :sql:`tstzrange` values.rNrrrrrrrrrc*a]tRtRtoRtRtRtVtR#)NumberRangeAdapteriz1Adapt a range if the subtype doesn't need quotes.cVPpVP'dR#VP'g4\VP4P 4P R4pMRpVP'g4\VP4P 4P R4pMRpRVP^, V RV VP^, R2PR4#)s'empty'asciir#r,) rr0r4rrrdecoder9rrr)rrrrs& rrNumberRangeAdapter.getquoteds LL 999{{{ !''N,,.55g>EE{{{!''N,,.55g>EEAIIaL>%%1a@HHQQrrN)rr{r|r}r~rrrrs@rrrs;RRrri@iAriViWiBiiC daterangeiHi:iItsrangeiDiZiE tstzrangeiFiiGrN)r~rpsycopg2._psycopgrrrrrrrrr 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