Show
Ignore:
Timestamp:
03/10/07 00:21:37 (2 years ago)
Author:
mfenniak
Message:

Add float and decimal output types

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • pg8000/trunk/pg8000-test.py

    r824 r827  
    77import pg8000 
    88 
    9 db = pg8000.Connection(host='joy', user='pg8000-test', database='pg8000-test', password='pg8000-test', socket_timeout=5) 
     9#db = pg8000.Connection(host='joy', user='pg8000-test', database='pg8000-test', password='pg8000-test', socket_timeout=5) 
    1010#db = pg8000.Connection(host='localhost', user='mfenniak') 
    11 #db = pg8000.Connection(user="mfenniak", unix_sock="/tmp/.s.PGSQL.5432") 
     11db = pg8000.Connection(user="mfenniak", unix_sock="/tmp/.s.PGSQL.5432") 
    1212 
    1313print "testing db.execute and error recovery in NoData query" 
     
    8181assert tuple(cur1.iterate_dict()) == ({"?column?": 5},) 
    8282 
     83cur1.execute("SELECT $1", 22.333) 
     84retval = tuple(cur1.iterate_dict()) 
     85assert retval == ({"?column?": 22.332999999999998},) 
     86 
     87cur1.execute("SELECT $1", decimal.Decimal("22.333")) 
     88retval = tuple(cur1.iterate_dict()) 
     89assert retval == ({"?column?": decimal.Decimal("22.333")},) 
     90 
    8391cur1.execute("SELECT 5000::smallint") 
    8492assert tuple(cur1.iterate_dict()) == ({"int2": 5000},)