diff options
Diffstat (limited to 'doc/build/dialects/postgresql.rst')
| -rw-r--r-- | doc/build/dialects/postgresql.rst | 31 |
1 files changed, 30 insertions, 1 deletions
diff --git a/doc/build/dialects/postgresql.rst b/doc/build/dialects/postgresql.rst index 05b63506e..c466f0377 100644 --- a/doc/build/dialects/postgresql.rst +++ b/doc/build/dialects/postgresql.rst @@ -126,6 +126,33 @@ mixin: ``psycopg2``, it's recommended to upgrade to version 2.5 or later before using these column types. +When instantiating models that use these column types, you should pass +whatever data type is expected by the DBAPI driver you're using for +the column type. For :mod:`psycopg2` these are +:class:`~psycopg2.extras.NumericRange`, +:class:`~psycopg2.extras.DateRange`, +:class:`~psycopg2.extras.DateTimeRange` and +:class:`~psycopg2.extras.DateTimeTZRange` or the class you've +registered with :func:`~psycopg2.extras.register_range`. + +For example: + +.. code-block:: python + + from psycopg2.extras import DateTimeRange + from sqlalchemy.dialects.postgresql import TSRANGE + + class RoomBooking(Base): + + __tablename__ = 'room_booking' + + room = Column(Integer(), primary_key=True) + during = Column(TSRANGE()) + + booking = RoomBooking( + room=101, + during=DateTimeRange(datetime(2013, 3, 23), None + ) PostgreSQL Constraint Types --------------------------- @@ -140,7 +167,9 @@ For example:: from sqlalchemy.dialects.postgresql import ExcludeConstraint, TSRANGE - class RoomBookings(Base): + class RoomBooking(Base): + + __tablename__ = 'room_booking' room = Column(Integer(), primary_key=True) during = Column(TSRANGE()) |