[PyDB2-discuss] callproc/LOB/scrollable cursor support

[Eunsoo P. <eun...@ho...>]

Hi,

I've been using pyDB2 and editing here and there, just to get additional 
support for the features that I need. I never worked on open source code 
before so I don't really know about editing and sharing etiquette for 
this, so pardon me if I'm doing anything wrong.

Attached is edited version of _db2_module.c and _db2_module.h - I just 
moved it to .h just to reduce .c size. - and DB2.py which supports,

1. procedure calling
2. large LOB support thru file handle.
3. scrollable cursor

Usage for number 1 is unchaned.
For large LOB support, here is the sample code.

import os
import DB2
f = open( 'sample.jpg' )
data = f.read()
f.close()

conn = DB2.connect( dsn='test', uid='testuser', pwd='testpass')
curs = conn.cursor()
curs.execute( 'INSERT INTO test(Data) values(?)", data ) ;
curs.close()
conn.close()

scrollable cursor, you'll need to set bScrollable = 1 in cursor 
creation. Only static cursor is supported.
import DB2
conn = DB2.connect( dsn='test', uid='testuser', pwd='testpass')
curs = conn.cursor(bScrollable=1)
curs.execute( 'select * from test')
curs.fetchscroll( size=10, orient = 5, offset = 5 )
# this will get you record set  size of 10, starting from offset 5 from 
absolute position ( SQL_FETCH_ABSOLUTE ).

scrollable cursor will be a bit slower than non-scrollable cursor, but 
good thing with that is, SQLRowCount will return row count for SELECT 
command with scrollable cursor.

Thanks,
Eunsoo Park