gnue/common/src/dbdrivers/_pgsql DBdriver.py

[James Thompson]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     James Thompson <address@hidden> 02/06/28 17:54:06

Modified files:
        common/src/dbdrivers/_pgsql: DBdriver.py 

Log message:
        postgresql db driver should now typecast int fields properly

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/src/dbdrivers/_pgsql/DBdriver.py.diff?tr1=1.15&tr2=1.16&r1=text&r2=text

Patches:
Index: gnue/common/src/dbdrivers/_pgsql/DBdriver.py
diff -c gnue/common/src/dbdrivers/_pgsql/DBdriver.py:1.15 
gnue/common/src/dbdrivers/_pgsql/DBdriver.py:1.16
*** gnue/common/src/dbdrivers/_pgsql/DBdriver.py:1.15   Fri Jun 28 00:03:37 2002
--- gnue/common/src/dbdrivers/_pgsql/DBdriver.py        Fri Jun 28 17:54:06 2002
***************
*** 179,187 ****
               'type':'field', 'nativetype': rs[2],
               'required': rs[3] and not rs[4]}
  
!       if rs[2] in ('int8','int2','int4','numeric',
!                    'float4','float8','money','bool'):
          attrs['datatype']='number'
        elif rs[2] in ('date','time','timestamp','abstime','reltime'):
          attrs['datatype']='date'
        else:
--- 179,188 ----
               'type':'field', 'nativetype': rs[2],
               'required': rs[3] and not rs[4]}
  
!       if rs[2] in ('numeric','float4','float8','money','bool'):
          attrs['datatype']='number'
+       elif rs[2] in ('int8','int2','int4'):
+         attrs['datatype']='integer'
        elif rs[2] in ('date','time','timestamp','abstime','reltime'):
          attrs['datatype']='date'
        else: