Show
Ignore:
Timestamp:
03/08/07 23:12:42 (2 years ago)
Author:
mfenniak
Message:

Add support for NULL DB parameters and values

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • pg8000/trunk/pg8000-test.py

    r815 r816  
    1212 
    1313db.execute("DROP TABLE t1") 
    14 db.execute("CREATE TABLE t1 (f1 int primary key, f2 int not null, f3 varchar(50) not null)") 
     14db.execute("CREATE TABLE t1 (f1 int primary key, f2 int not null, f3 varchar(50) null)") 
    1515 
    1616s1 = pg8000.PreparedStatement(db, "INSERT INTO t1 (f1, f2, f3) VALUES ($1, $2, $3)", int, int, str) 
    …… 
    1818s1.execute(2, 10, "he\u0173llo") 
    1919s1.execute(3, 100, "hello") 
    20 s1.execute(4, 1000, "hello") 
     20s1.execute(4, 1000, None) 
    2121s1.execute(5, 10000, "hello") 
    2222s1.execute(6, 100000, "hello")