3 a@sddlmZdZGdddeZGdddeejZGdddeejZGd ddeejZ Gd d d eejZ Gd d d eejZ GdddeejZ dS))types INT4RANGE INT8RANGENUMRANGEc@s$eZdZdZGdddejjZdS)RangeOperatorsaN This mixin provides functionality for the Range Operators listed in Table 9-44 of the `PostgreSQL documentation`__ for Range Functions and Operators. It is used by all the range types provided in the ``postgres`` dialect and can likely be used for any range types you create yourself. __ https://www.postgresql.org/docs/devel/static/functions-range.html No extra support is provided for the Range Functions listed in Table 9-45 of the PostgreSQL documentation. For these, the normal :func:`~sqlalchemy.sql.expression.func` object should be used. cspeZdZdZfddZddZddZdd Zd d ZeZ d d Z e Z ddZ ddZ ddZddZZS)z!RangeOperators.comparator_factoryz-Define comparison operations for range types.cs2|dkrttj|j|S|jjddd|SdS)zT) is_comparison)superrcomparator_factory__ne__exprop)selfother) __class__K/tmp/pip-build-6_cqtusv/SQLAlchemy/sqlalchemy/dialects/postgresql/ranges.pyr s z(RangeOperators.comparator_factory.__ne__cKs|jjddd|S)zBoolean expression. Returns true if the right hand operand, which can be an element or a range, is contained within the column. z@>T)r)r r )r rkwrrrcontains)sz*RangeOperators.comparator_factory.containscCs|jjddd|S)zsBoolean expression. Returns true if the column is contained within the right hand operand. z<@T)r)r r )r rrrr contained_by0sz.RangeOperators.comparator_factory.contained_bycCs|jjddd|S)zBoolean expression. Returns true if the column overlaps (has points in common with) the right hand operand. z&&T)r)r r )r rrrroverlaps6sz*RangeOperators.comparator_factory.overlapscCs|jjddd|S)zsBoolean expression. Returns true if the column is strictly left of the right hand operand. z<>T)r)r r )r rrrrstrictly_right_ofDsz3RangeOperators.comparator_factory.strictly_right_ofcCs|jjddd|S)zBoolean expression. Returns true if the range in the column does not extend right of the range in the operand. z&T)r)r r )r rrrrnot_extend_left_ofRsz4RangeOperators.comparator_factory.not_extend_left_ofcCs|jjddd|S)z}Boolean expression. Returns true if the range in the column is adjacent to the range in the operand. z-|-T)r)r r )r rrrr adjacent_toXsz-RangeOperators.comparator_factory.adjacent_tocCs|jjd|S)zRange expression. Returns the union of the two ranges. Will raise an exception if the resulting range is not contiguous. +)r r )r rrrr__add__^sz)RangeOperators.comparator_factory.__add__)__name__ __module__ __qualname____doc__r rrrr __lshift__r __rshift__rrrr __classcell__rr)rrr s r N)rrrr sqltypesZ ConcatenableZ Comparatorr rrrrr src@seZdZdZdZdS)rz(Represent the PostgreSQL INT4RANGE type.N)rrrr __visit_name__rrrrrfsc@seZdZdZdZdS)rz(Represent the PostgreSQL INT8RANGE type.N)rrrr r%rrrrrlsc@seZdZdZdZdS)rz'Represent the PostgreSQL NUMRANGE type.N)rrrr r%rrrrrrsc@seZdZdZdZdS) DATERANGEz(Represent the PostgreSQL DATERANGE type.N)rrrr r%rrrrr&xsr&c@seZdZdZdZdS)TSRANGEz&Represent the PostgreSQL TSRANGE type.N)rrrr r%rrrrr'~sr'c@seZdZdZdZdS) TSTZRANGEz(Represent the PostgreSQL TSTZRANGE type.N)rrrr r%rrrrr(sr(N)rrr) rr$__all__objectrZ TypeEnginerrrr&r'r(rrrrs Y