Class Integer

lib/sqlalchemy/sql/sqltypes.py:365–422

A type for ``int`` integers.

class Integer(HasExpressionLookup, TypeEngine[int]):
    """A type for ``int`` integers."""

    __visit_name__ = "integer"

    operator_classes = OperatorClass.INTEGER

    if TYPE_CHECKING:

        @util.ro_memoized_property
        def _type_affinity(self) -> Type[Integer]: ...

    def get_dbapi_type(self, dbapi):
        return dbapi.NUMBER

    @property
    def python_type(self):
        return int

    def _resolve_for_literal(self, value):
        if value.bit_length() >= 32:
            return _BIGINTEGER
        else:
            return self

    def literal_processor(self, dialect):
        def process(value):
            return str(int(value))

        return process

    @util.memoized_property
    def _expression_adaptations(self):
        return {
            operators.add: {
                Date: Date,
                Integer: self.__class__,
                Numeric: Numeric,
                Float: Float,
            },
            operators.mul: {
                Interval: Interval,
                Integer: self.__class__,
                Numeric: Numeric,
                Float: Float,
            },
            operators.truediv: {
                Integer: Numeric,
                Numeric: Numeric,
                Float: Float,
            },
            operators.floordiv: {Integer: self.__class__, Numeric: Numeric},
            operators.sub: {
                Integer: self.__class__,
                Numeric: Numeric,
                Float: Float,
            },
        }