[DB-SIG] IBM DB2 module v0.97

Man-Yong Lee manyong@gnu.org
Wed, 20 Dec 2000 18:47:39 +0900


Hi~ db-sig people,

I've just released IBM DB2 module v0.97 for Python now.

Hopefully, BLOB and CLOB is supported with reasonable
usage like these:

cs.execute("INSERT INTO HJ0 VALUES (?)", \
    DB2.BLOB('/bin/bash'))

clob = DB2.CLOB()
clob.setValue('A' * 1024)

cs.execute("INSERT INTO HJ1 VALUES (?, ?)", \
    ( 1, clob ) )

And you get BLOB, CLOB instance when you fetch rows:

cs.execute("SELECT * FROM HJ0 FETCH FIRST 1 ROW ONLY")
cs.fetchone()

--> (DB2.BLOB(....), )

You can get data in Python string with getValue() method.

The download site is:

ftp://people.linuxkorea.co.kr/pub/DB2/

Thanks to the people who sent me bug reports.

TODO:

- DATE, TIME, TIMESTAMP class for seamlese integration
  with Python.
- DBLOB support

-- 
Happy Python!
             Man-Yong (Bryan) Lee  <yong@linuxkorea.co.kr>