[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>