sqlalchemy.dialects.postgresql.INTERVAL

class documentation

class INTERVAL(sqltypes.NativeForEmulated, sqltypes._AbstractInterval):

Known subclasses: sqlalchemy.dialects.postgresql.pg8000._PGInterval

PostgreSQL INTERVAL type.

Class Method	`adapt_emulated_to_native`	Given an impl, adapt this type's class to the impl assuming "native".
Method	`__init__`	Construct an INTERVAL.
Method	`as_generic`	Return an instance of the generic type corresponding to this type using heuristic rule. The method may be overridden if this heuristic rule is not sufficient.
Method	`coerce_compared_value`	See `.TypeEngine.coerce_compared_value` for a description.
Class Variable	`__visit_name__`	Undocumented
Class Variable	`native`	Undocumented
Instance Variable	`fields`	Undocumented
Instance Variable	`precision`	Undocumented
Property	`_type_affinity`	Return a rudimental 'affinity' value expressing the general class of type.
Property	`python_type`	Return the Python type object expected to be returned by instances of this type, if known.

Inherited from NativeForEmulated:

Class Method adapt_native_to_emulated Given an impl, adapt this type's class to the impl assuming "emulated".

Inherited from _AbstractInterval:

Property _expression_adaptations Undocumented

Inherited from _LookupExpressionAdapter (via _AbstractInterval):

Class Comparator Undocumented

Inherited from TypeEngine (via _AbstractInterval):

Class	`Comparator`	Base class for custom comparison operations defined at the type level. See `.TypeEngine.comparator_factory`.
Method	`adapt`	Produce an "adapted" form of this type, given an "impl" class to work with.
Method	`bind_expression`	Given a bind value (i.e. a `.BindParameter` instance), return a SQL expression in its place.
Method	`bind_processor`	Return a conversion function for processing bind values.
Method	`column_expression`	Given a SELECT column expression, return a wrapping SQL expression.
Method	`compare_against_backend`	Compare this type against the given backend type.
Method	`compare_values`	Compare two values for equality.
Method	`compile`	Produce a string-compiled form of this `.TypeEngine`.
Method	`dialect_impl`	Return a dialect-specific implementation for this `.TypeEngine`.
Method	`evaluates_none`	Return a copy of this type which has the `.should_evaluate_none` flag set to True.
Method	`get_dbapi_type`	Return the corresponding type object from the underlying DB-API, if any.
Method	`literal_processor`	Return a conversion function for processing literal values that are to be rendered directly without using binds.
Method	`result_processor`	Return a conversion function for processing result row values.
Method	`with_variant`	Produce a new type object that will utilize the given type when applied to the dialect of the given name.
Class Variable	`hashable`	Flag, if False, means values from this type aren't hashable.
Class Variable	`should_evaluate_none`	If True, the Python constant `None` is considered to be handled explicitly by this type.
Class Variable	`sort_key_function`	A sorting function that can be passed as the key to sorted.
Static Method	`_to_instance`	Undocumented
Method	`__repr__`	Undocumented
Method	`__str__`	Undocumented
Method	`_cached_bind_processor`	Return a dialect-specific bind processor for this type.
Method	`_cached_custom_processor`	Undocumented
Method	`_cached_literal_processor`	Return a dialect-specific literal processor for this type.
Method	`_cached_result_processor`	Return a dialect-specific result processor for this type.
Method	`_compare_type_affinity`	Undocumented
Method	`_default_dialect`	Undocumented
Method	`_dialect_info`	Return a dialect-specific registry which caches a dialect-specific implementation, bind processing function, and one or more result processing functions.
Method	`_gen_dialect_impl`	Undocumented
Method	`_resolve_for_literal`	adjust this type given a literal Python value that will be stored in a bound parameter.
Method	`_unwrapped_dialect_impl`	Return the 'unwrapped' dialect impl for this type.
Method	`copy`	Undocumented
Method	`copy_value`	Undocumented
Class Variable	`_is_array`	Undocumented
Class Variable	`_is_table_value`	Undocumented
Class Variable	`_is_tuple_type`	Undocumented
Class Variable	`_is_type_decorator`	Undocumented
Class Variable	`_isnull`	Undocumented
Class Variable	`_sqla_type`	Undocumented
Property	`_generic_type_affinity`	Undocumented
Property	`_has_bind_expression`	memoized boolean, check if bind_expression is implemented.
Property	`_has_column_expression`	memoized boolean, check if column_expression is implemented.
Property	`_static_cache_key`	Undocumented

Inherited from Traversible (via _AbstractInterval, TypeEngine):

Method	`get_children`	Return immediate child `.visitors.Traversible` elements of this `.visitors.Traversible`.
Method	`__class_getitem__`	Undocumented

@classmethod
def adapt_emulated_to_native(cls, interval, **kw):

overrides sqlalchemy.sql.type_api.NativeForEmulated.adapt_emulated_to_native

overridden in sqlalchemy.dialects.postgresql.pg8000._PGInterval

Given an impl, adapt this type's class to the impl assuming "native".

The impl will be an .Emulated class but not a .NativeForEmulated.

e.g.: postgresql.ENUM produces a type given an Enum instance.

def __init__(self, precision=None, fields=None):

Construct an INTERVAL.

Parameters
precision	optional integer precision value
fields	string fields specifier. allows storage of fields to be limited, such as `"YEAR"`, `"MONTH"`, `"DAY TO HOUR"`, etc. New in version 1.2.

def as_generic(self, allow_nulltype=False):

overrides sqlalchemy.types.TypeEngine.as_generic

Return an instance of the generic type corresponding to this type using heuristic rule. The method may be overridden if this heuristic rule is not sufficient.

>>> from sqlalchemy.dialects.mysql import INTEGER
>>> INTEGER(display_width=4).as_generic()
Integer()

>>> from sqlalchemy.dialects.mysql import NVARCHAR
>>> NVARCHAR(length=100).as_generic()
Unicode(length=100)

New in version 1.4.0b2.