Mercurial > p > roundup > code
diff roundup/backends/back_postgresql.py @ 3685:4d9adb8bc3b1
Null-value sorting fixes:
- Fixed sorting of NULL values for the PostgreSQL backend. Generic
implementation of additional sort-key for NULL values, can be reused
by other (future) rdbms backends.
- Added a test for NULL value sorting and removed an override for the
Interval test for the PostgreSQL backend which had a special case for
NULL values
| author | Ralf Schlatterbeck <schlatterbeck@users.sourceforge.net> |
|---|---|
| date | Wed, 23 Aug 2006 12:57:10 +0000 |
| parents | bfb120928309 |
| children | ff9f4ca42454 |
line wrap: on
line diff
--- a/roundup/backends/back_postgresql.py Tue Aug 22 19:33:02 2006 +0000 +++ b/roundup/backends/back_postgresql.py Wed Aug 23 12:57:10 2006 +0000 @@ -1,4 +1,4 @@ -#$Id: back_postgresql.py,v 1.32 2006-08-11 00:44:00 richard Exp $ +#$Id: back_postgresql.py,v 1.33 2006-08-23 12:57:10 schlatterbeck Exp $ # # Copyright (c) 2003 Martynas Sklyzmantas, Andrey Lebedev <andrey@micro.lt> # @@ -223,11 +223,13 @@ self.cursor.execute('DROP SEQUENCE _%s_ids'%cn) self.cursor.execute('CREATE SEQUENCE _%s_ids'%cn) +class PostgresqlClass: + order_by_null_values = '(%s is not NULL)' -class Class(rdbms_common.Class): +class Class(PostgresqlClass, rdbms_common.Class): pass -class IssueClass(rdbms_common.IssueClass): +class IssueClass(PostgresqlClass, rdbms_common.IssueClass): pass -class FileClass(rdbms_common.FileClass): +class FileClass(PostgresqlClass, rdbms_common.FileClass): pass