new Interval type patch contribute

[Former user]

Here is a small patch to add support of storing timedelta valuesin SQL databases. If possible it tries to use native DB support of timedelta (just PostgreSQL for now), if there is no such it fallbacks to store timedeltas as sqltypes.DateTime with base of zero timestamp.

[Former user]

Interval type patch

[Mike Bayer]

revised patch

[Mike Bayer]

attached is a revised patch which adds a template method to TypeDecorator such that the interval type need not duplicate the code within dialect_impl(). Also, the check for the PGDialect and the retrieval of the DateTime dialect implementation have been extracted into two methods since the latter is an expensive operation that is not needed within convert_bind_param() and convert_result_value().

need to verify that this new patch functions correctly. Alternatively, provide a patch for test/sql/testtypes.py that adds unit test support for this new type.

[Former user]

Corrected revised patch, tested on PostgreSQL and sqlite

[Former user]

FIX: Interval type doesn't work with orm

[Mike Bayer]

committed + unit test (not orm though) in changeset:2746

[Former user]

Patch to revision 2746.

IMPROVE: more clearer handle if Interval type will have native support in multiple engines FIX: now correctly work with orm, heavily tested.

[Former user]

FIX: incorrect handle of Null values

[Mike Bayer]

changeset:2914

[Mike Bayer]

Removing milestone: 0.3.9 (automated comment)