]jfSSKJr SSKrSSKJr SSKJr SSKJr SSKJr SSKJ r SSKJ r SS KJ r SS KJ r SS KJ r SS KJr SS KJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSKJr SSK!Jr SSK"J#r# SS K$J%r% SS!K&J'r' \(aSS"K(J)r) SS#K"J*r* SS$K"J+r+ \"S%\ S&9r,\'S'r-\%(a S(S)0r.S*S)0r/O0r.0r/\R`"SUS+S)0\.D6"S,S-\ \,55r1"S.S/\ \1\,5r2"S0S1\ RF\,5r3"S2S3\3\1\,5r4"S4S5\4\,5r5"S6S7\3\\1\,5r6"S8S9\6\,5r7"S:S;\4\85r9"S<S=\4\85r:"S>S?\4\5r;"S@SA\4\5r<"SBSC\4\5r="SDSE\4\5r>"SFSG\6\85r?"SHSI\6\85r@"SJSK\6\5rA"SLSM\6\5rB"SNSO\6\5rC"SPSQ\6\5rDSRrESSrFSVSTjrGg)W) annotationsN)date)datetime) timedelta)Decimal)Any)cast)Generic)List)Optional)overload)Sequence)Tuple)Type) TYPE_CHECKING)TypeVar)Union) ADJACENT_TO) CONTAINED_BY)CONTAINS)NOT_EXTEND_LEFT_OF)NOT_EXTEND_RIGHT_OF)OVERLAP)STRICTLY_LEFT_OF)STRICTLY_RIGHT_OF)types) operators) TypeEngine)py310)Literal) ColumnElement)_TE)TypeEngineMixin_T)bound)z()[)z(]z[]slotsTkw_onlyfrozenc\rSrSr%SrSrS\S'SrS\S'\(a+\ R"SS9r S \S '\ R"S S9r S \S 'O2\ R"S.SS0\ D6r S \S '\ R"S.SS 0\ D6r S \S '\(dS/SS S.S0SjjjrS1Sjr\S1Sj5r\S1Sj5r\S1Sj5r\S1Sj5r\S1Sj5r\S1Sj5r\S2Sj5rS3SjrS4SjrS5S6SjjrS7SjrS8SjrS9Sjr\rS8Sjr S8S jr!\!r"S8S!jr#\#r$S8S"jr%S8S#jr&S:S$jr'S8S%jr(S;S&jr)S;S'jr*S;S(jr+S;S)jr,S;S*jr-S;S+jr.ScUR$z$A synonym for the 'empty' attribute.rArBs r;isempty Range.isemptyvzzr>cUR$rFrArBs r;is_emptyRange.is_empty|rIr>c&URSS:H$)z,Return True if the lower bound is inclusive.r[r4rBs r; lower_incRange.lower_inc{{1~$$r>cNUR(+=(a URSL$)zCReturn True if this range is non-empty and lower bound is infinite.N)r6r0rBs r; lower_infRange.lower_inf ::~4$**"44r>c&URSS:H$)z,Return True if the upper bound is inclusive.r]rOrBs r; upper_incRange.upper_incrRr>cNUR(+=(a URSL$)zGReturn True if this range is non-empty and the upper bound is infinite.N)r6r1rBs r; upper_infRange.upper_infrVr>c[5$r@)AbstractSingleRangerBs r;__sa_type_engine__Range.__sa_type_engine__s "$$r>c UR(agURcDURSL=(d/ URSS:XaXR:$XR:*$URc/URSS:XaXR:$XR:$URSS:XaXR:O XR:=(a/ URSS:XaXR:$XR:*$)z3Return True if this range contains the given value.FNr)r()r6r0r1r4r:values r;_contains_valueRange._contains_values :: :: ::%;;q>S( " jj(  :: ;;q>S( " jj( {{1~$ JJ **$ {{1~$ JJ   **$ r>c[UR[5(d[UR[5(ag[UR[5(d[UR[5(ag[UR[ 5(d[UR[ 5(a [ SS9$g)uADetermine the “step” for this range, if it is a discrete one.rN)days) isinstancer0intr1rrrrBs r;_get_discrete_stepRange._get_discrete_steps djj# & &*TZZ*E*E  H - - JJ2 2   D ) )Z D-I-I!$ $r>c,US;nUS;nXs=LacO OXg:XagU(aS$S$Uc U(aS$S$Uc U(aS$S$X$:XaX:XagUS;nUS;n UR5n U bDU(aU(dX- nSnO U(aX- nSnU(aU (dX:- nSn O U (aX:- nSn X:agX:agU(agU(aU (agU(dU (dXg:XagU(aS$S$U(d U(aS$S$U (d U(aS$S$g)zCompare two range bounds. Return -1, 0 or 1 respectively when `value1` is less than, equal to or greater than `value2`. When `only_value` is ``True``, do not consider the *inclusivity* of the edges, just their values. >rdrNrr>rNrXTF)rm) r:value1bound1value2bound2 only_valuesvalue1_is_lower_boundvalue2_is_lower_bound value1_inc value2_incsteps r;_compare_edgesRange._compare_edgess;"!'* 4 &* 4  # #$=2r99 ^.2 5A 5 ^-1 52 5   0z) z) &&(  %!NF!%JNF!&J$!NF!%JNF!&J ? _  j (A 51=2=1q9r92r99r>c[U[5(d[$UR(aUR(agURUR:wagURnUR SnURnUR SnUR nUR SnUR nUR Sn URX#XE5S:H=(a URXgX5S:H$)zpCompare this range to the `other` taking into account bounds inclusivity, returning ``True`` if they are equal. TFrr)rkr-NotImplementedr6r0r4r1r{ r:otherslowerslower_bolowerolower_bsuppersupper_boupperoupper_bs r;__eq__ Range.__eq__+s %''! ! ::%++ ZZ5;; &;;q><<?;;q><<?   & Cq H M##FfG1L r>cUR(agUR(agURnURSnURnURSnURX#XE5S:agURnURSnURnURSn URXgX5S:agg)z7Determine whether this range is a contained by `other`.TFrr)r6r0r4r{r1rs r; contained_byRange.contained_byFs :: ;;;;q><<?   v BQ F;;q><<?   v BQ Fr>cp[U[5(aURU5$URU5$)z.Determine whether this range contains `value`.)rkr-rrgres r;containsRange.containscs3 eU # #%%d+ +''. .r>cUR(dUR(agURnURSnURnURSnURnURSnURnURSn UR X#Xg5S:aUR X#X5S::agUR XgX#5S:aUR XgXE5S::agg)z3Determine whether this range overlaps with `other`.FrrTr6r0r4r1r{ r:rrrrrrrrrs r;overlapsRange.overlapsms ::;;q>;;q><<?<<?   & Cq H##FfG1L   & Cq H##FfG1Lr>cUR(dUR(agURnURSnURnURSnUR X#XE5S:$)zBDetermine whether this range is completely to the left of `other`.Frr)r6r1r4r0r{)r:rrrrrs r;strictly_left_ofRange.strictly_left_ofZ ::;;q><<?""6VFJJr>cUR(dUR(agURnURSnURnURSnUR X#XE5S:$)zCDetermine whether this range is completely to the right of `other`.Frrr)r:rrrrrs r;strictly_right_ofRange.strictly_right_ofrr>cUR(dUR(agURnURSnURnURSnURX#XE5S:$)z>Determine whether this does not extend to the left of `other`.Fr)r6r0r4r{)r:rrrrrs r;not_extend_left_ofRange.not_extend_left_ofZ ::;;q><<?""6VF!KKr>cUR(dUR(agURnURSnURnURSnURX#XE5S:*$)z?Determine whether this does not extend to the right of `other`.Frr)r6r1r4r{)r:rrrrrs r;not_extend_right_ofRange.not_extend_right_ofrr>cdURXX4S5nUS:Xa<UR5nUcgUS:XaUS:XaXU- :H$X:H$US:XaX:H$XU- :H$US:XaUUS:XaUS:Xd US:XaUS:XaUR5nUbgUS:H=(a US:H=(d US:H=(a US:H$g) zLDetermine whether an upper bound is immediately successive to a lower bound.TrpFrXrNrrcrd)r{rm)r:rqrrrsrtresrzs r;_upper_edge_adjacent_to_lower#Range._upper_edge_adjacent_to_lowers!!&&$G "9**,D|}S=!d]22!++S=!++!d]22 AX# cMS=cM..0## "cM"S="cM  r>cvUR(dUR(agURnURSnURnURSnURnURSnURnURSn UR XEXg5=(d UR XX#5$)z8Determine whether this range is adjacent to the `other`.Frr)r6r0r4r1rrs r; adjacent_toRange.adjacent_tos ::;;q>;;q><<?<<?11 f   / / f  r>c DUR(aU$UR(aU$URU5(d!URU5(d [S5eURnUR SnUR nUR SnURnUR SnUR nUR Sn URX#Xg5S:aUn Un OUn Un URXEX5S:aUn Un OUn U n [X[[X-5S9$)zCompute the union of this range with the `other`. This raises a ``ValueError`` exception if the two ranges are "disjunct", that is neither adjacent nor overlapping. zAAdding non-overlapping and non-adjacent ranges is not implementedrrrO) r6rr ValueErrorr0r4r1r{r-r r3r:rrrrrrrrrrlowerrlower_brupperrupper_bs r;union Range.unions ::L ;;K}}U##D,<,;;q><<?<<?   v BQ FFHFH   v BQ FFHFH 4 X5H#I  r>c$URU5$r@)rr:rs r;__add__ Range.__add__@szz%  r>c UR(dUR(aU$URnURSnURnURSnURnURSnURnURSn UR X#Xg5n UR XEX5n U S:aU S:a [ S5eUR X#X5n UR XEXg5n U S:dU S:aU$U S:aU S::a [ SSSS9$U S::a^U S:aXU S::aRUS:XaSOS nUS:wa'US :wa!UR X#Xn5S:Xa [ SSSS9$[ UU[[X>-5S 9$U S:a^U S:aXU S::aRU S :XaS OSnUS:wa'US :wa!UR XXE5S:Xa [ SSSS9$[ UU[[X-5S 9$S US U35e)zCompute the difference between this range and the `other`. This raises a ``ValueError`` exception if the two ranges are "disjunct", that is neither adjacent nor overlapping. rrz5Subtracting a strictly inner range is not implementedNTrArNrcrXrOrdzUnhandled case computing z - ) r6r0r4r1r{rr-r r3)r:rrrrrrrrrsl_vs_olsu_vs_ousl_vs_ousu_vs_olrrs r; differenceRange.differenceCs ::K;;q>;;q><<?<<?&&vJ&&vJ ac$URU5$r@)rrs r;__sub__ Range.__sub__su%%r>c UR(d'UR(dURU5(d [SSSS9$URnURSnUR nURSnURnURSnUR nURSn UR X#Xg5S:aUn Un OUn Un UR XEX5S:aUn U n OUn Un [U U [[X-5S9$)zTCompute the intersection of this range with the `other`. .. versionadded:: 2.0.10 NTrArrrO) r6rr-r0r4r1r{r r3rs r; intersectionRange.intersections ::DMM%,@,@t40 0;;q>;;q><<?<<?   v BQ FFHFH   v BQ FFHFH   X%89  r>c$URU5$r@)rrs r;__mul__ Range.__mul__s  ''r>c"UR5$r@) _stringifyrBs r;__str__ Range.__str__s  r>cUR(agURURp!UcSOUnUcSOUn[SUR5up4UUSUU3$)Nr6zTuple[str, str],)r6r0r1r r4)r:lrb0b1s r;rRange._stringifys] ::zz4::1)B)B'5aS!RD!!r>)NN)r0r/r1r/r4r3r6r5)returnr5)rzAbstractSingleRange[_T])rfr&rr5)rr)F) rqr/rrstrrsr/rtrrur5rrl)rrrr5)r Range[_T]rr5)rfzUnion[_T, Range[_T]]rr5) rqr/rrrrsr/rtrrr5)rrrr)rr)2__name__ __module__ __qualname____firstlineno____doc__r0__annotations__r1r dataclassesfieldr4r6 dc_kwonlyr!r<rCpropertyrGrKrPrTrYr\r`rgrmr{rrr __contains__rr __lshift__r __rshift__rrrrrrrrrrrr__static_attributes__rr>r;r-r-;s^*E<E<)//= =!''6t6)//JJ J J!''CCCtC #'"&  #'           $  %% 55 %% 55 %% <4" WWW W  W  W Wr 6:/L@ K"J K#J L L--- -  -  -^ ,, \!JCX&$ L(! "r>r-c,\rSrSrSr\SSj5rSrg) MultiRangeiaRepresents a multirange sequence. This list subclass is an utility to allow automatic type inference of the proper multi-range SQL type depending on the single range values. This is useful when operating on literal multi-ranges:: import sqlalchemy as sa from sqlalchemy.dialects.postgresql import MultiRange, Range value = literal(MultiRange([Range(2, 4)])) select(tbl).where(tbl.c.value.op("@")(MultiRange([Range(-3, 7)]))) .. versionadded:: 2.0.26 .. seealso:: - :ref:`postgresql_multirange_list_use`. c[5$r@)AbstractMultiRangerBs r;r`MultiRange.__sa_type_engine__s !##r>rN)rzAbstractMultiRange[_T])rrrrrrr`rrr>r;rrs($$r>rc^\rSrSrSrSrSr\S Sj5r\S Sj5rS U4Sjjr"SS\ R\ \ 5r S rU=r$) AbstractRangeiz0Base class for single and multi Range SQL types.Tc gr@rr:clskws r;adaptAbstractRange.adapts7:r>c gr@rrs r;rrsr>c >[U[[45(a<XRLa.URn[ US3XR4SU05"5$[ TU]U5$)zDynamically adapt a range type to an abstract impl. For example ``INT4RANGE().adapt(_Psycopg2NumericRange)`` should produce a type that will have ``_Psycopg2NumericRange`` behaviors and also render as ``INT4RANGE`` in SQL and DDL. RangeImpl__visit_name__) issubclassAbstractSingleRangeImplAbstractMultiRangeImpl __class__rtypesuperr)r:rr visit_namers r;rrso s46LM N N>>),,J,i(nn%!:.  7=% %r>c\rSrSrSrSSjrSSjrSSjrSSjr\r SSjr \ r SSjr SS jr SS jrSS jrSS jrSS jrSrg) AbstractRange.comparator_factoryiz-Define comparison operations for range types.c BURR[U5$)zBoolean expression. Returns true if the right hand operand, which can be an element or a range, is contained within the column. kwargs may be ignored by this operator but are required for API conformance. )exproperater)r:rrs r;r)AbstractRange.comparator_factory.containss99$$Xu5 5r>cBURR[U5$)z[Boolean expression. Returns true if the column is contained within the right hand operand. )rrrrs r;r-AbstractRange.comparator_factory.contained_by#s99$$\59 9r>cBURR[U5$)zlBoolean expression. Returns true if the column overlaps (has points in common with) the right hand operand. )rrrrs r;r)AbstractRange.comparator_factory.overlaps)s99$$We4 4r>cBURR[U5$)z[Boolean expression. Returns true if the column is strictly left of the right hand operand. )rrrrs r;r1AbstractRange.comparator_factory.strictly_left_of/s99$$%5u= =r>cBURR[U5$)z\Boolean expression. Returns true if the column is strictly right of the right hand operand. )rrrrs r;r2AbstractRange.comparator_factory.strictly_right_of7s99$$%6> >r>cBURR[U5$)zoBoolean expression. Returns true if the range in the column does not extend right of the range in the operand. )rrrrs r;r4AbstractRange.comparator_factory.not_extend_right_of?s99$$%8%@ @r>cBURR[U5$)znBoolean expression. Returns true if the range in the column does not extend left of the range in the operand. )rrrrs r;r3AbstractRange.comparator_factory.not_extend_left_ofEs99$$%7? ?r>cBURR[U5$)zeBoolean expression. Returns true if the range in the column is adjacent to the range in the operand. )rrrrs r;r,AbstractRange.comparator_factory.adjacent_toKs99$$[%8 8r>cVURR[RU5$zyRange expression. Returns the union of the two ranges. Will raise an exception if the resulting range is not contiguous. )rrraddrs r;r&AbstractRange.comparator_factory.unionQ 99$$Y]]E: :r>cVURR[RU5$r)rrrsubrs r;r+AbstractRange.comparator_factory.differenceXrr>cVURR[RU5$)zRange expression. Returns the intersection of the two ranges. Will raise an exception if the resulting range is not contiguous. )rrrmulrs r;r-AbstractRange.comparator_factory.intersection_rr>rN)rrrrrColumnElement[bool])rrrr)rrrzColumnElement[Range[_T]])rrrrrrrrrrrrrrrrrrrrr>r;comparator_factoryrsL; 6 :  5  > &  ? '  A  @  9  ; ; ;r>rr)rz Type[_TE]rrrr$)rzType[TypeEngineMixin]rrrTypeEngine[Any])rz-Type[Union[TypeEngine[Any], TypeEngineMixin]]rrrr)rrrrrrender_bind_cast __abstract__r rr Comparatorr-rrr __classcell__)rs@r;rrs:L :: (03  & : & &  &DN;Z225:>N;N;r>rc&\rSrSrSrSrSSjrSrg)r_igzBase for PostgreSQL RANGE types. These are types that return a single :class:`_postgresql.Range` object. .. seealso:: `PostgreSQL range functions `_ TcURb URO URn[U[5(a$[ U5(a [ 5$[ 5$[U[[45(a [5$[U[5(a%UR(d [5$[5$[U[5(a [5$[ R"$r@)r0r1rkrl _is_int32 INT4RANGE INT8RANGErfloatNUMRANGErtzinfoTSRANGE TSTZRANGEr DATERANGEsqltypesNULLTYPE)r:rfspecs r;_resolve_for_literal(AbstractSingleRange._resolve_for_literalts#kk5u{{5;; dC  {" {" w. / /:  h ' '$(KK79 @Y[ @ d # #; $$ $r>rN)rfz Range[Any]rrrrrrrr!r2rrr>r;r_r_gsL%r>r_c\rSrSrSrSrg)rizMMarker for AbstractSingleRange that will apply a subclass-specific adaptationrNrrrrrrrr>r;rrr>rc&\rSrSrSrSrSSjrSrg)rizvBase for PostgreSQL MULTIRANGE types. these are types that return a sequence of :class:`_postgresql.Range` objects. Tc U(d[R$USnURb URO URn[ U[ 5(a+[ SU55(a [5$[5$[ U[[45(a [5$[ U[5(a%UR(d [5$[5$[ U[ 5(a [#5$[R$)Nrc38# UHn[U5v M g7fr@)r&).0rs r; :AbstractMultiRange._resolve_for_literal..s/A9Q<<s)r/r0r0r1rkrlallINT4MULTIRANGEINT8MULTIRANGErr) NUMMULTIRANGErr+ TSMULTIRANGETSTZMULTIRANGErDATEMULTIRANGE)r:rffirstr1s r;r2'AbstractMultiRange._resolve_for_literals$$ $a#kk5u{{5;; dC ////%''%'' w. / / ? " h ' ')-<> J.:J J d # #!# #$$ $r>rN)rfzSequence[Range[Any]]rrr4rr>r;rrsL%r>rc\rSrSrSrSrg)rizLMarker for AbstractMultiRange that will apply a subclass-specific adaptationrNr6rr>r;rrr7r>rc\rSrSrSrSrSrg)r'iz(Represent the PostgreSQL INT4RANGE type.rNrrrrrrrrr>r;r'r' 2 Nr>r'c\rSrSrSrSrSrg)r(iz(Represent the PostgreSQL INT8RANGE type.rNrIrr>r;r(r(rJr>r(c\rSrSrSrSrSrg)r*iz'Represent the PostgreSQL NUMRANGE type.rNrIrr>r;r*r*s 1Nr>r*c\rSrSrSrSrSrg)r.iz(Represent the PostgreSQL DATERANGE type.rNrIrr>r;r.r.rJr>r.c\rSrSrSrSrSrg)r,i&Represent the PostgreSQL TSRANGE type.rNrIrr>r;r,r,s 0Nr>r,c\rSrSrSrSrSrg)r-i(Represent the PostgreSQL TSTZRANGE type.rNrIrr>r;r-r-rJr>r-c\rSrSrSrSrSrg)r?iz-Represent the PostgreSQL INT4MULTIRANGE type.rNrIrr>r;r?r? 7%Nr>r?c\rSrSrSrSrSrg)r@iz-Represent the PostgreSQL INT8MULTIRANGE type.rNrIrr>r;r@r@rSr>r@c\rSrSrSrSrSrg)rAiz,Represent the PostgreSQL NUMMULTIRANGE type.rNrIrr>r;rArAs 6$Nr>rAc\rSrSrSrSrSrg)rDiz-Represent the PostgreSQL DATEMULTIRANGE type.rNrIrr>r;rDrDrSr>rDc\rSrSrSrSrSrg)rBirOrNrIrr>r;rBrBs 0#Nr>rBc\rSrSrSrSrSrg)rCirQrNrIrr>r;rCrCs 2%Nr>rCiicURSL=(d' [URs=:*=(a [:*Os =(a< URSL=(d' [URs=:*=(a [:*$s $r@)r0 _min_int_32 _max_int_32r1)rs r;r&r&sV GGtO D{aggDDD  4@;!''@@[@@r>r)rz Range[int]rr5)H __future__rrrrrdecimalrtypingrr r r r r rrrrrrrrrrrrrrrrrr/sql sql.type_apir utilr! util.typingr" sql.elementsr#r$r%r&r3dc_slotsr dataclassr-rrr_rrrrlr'r(r*r.r,r-r?r@rArDrBrCr[rZr&rr>r;rfsI# "#)*'(!&"-#/ T,- HD!IHI /d/h/L "GBKL "0L "^$eBi$4;H''+;D %-b 2 %F1"5 !%xb ':;!%H/3 !#C(! !#C(!  "7+ !#D)! !(+ !#H-! &',& &',& %&w/% &'-& $%h/$ &'1&   r>