Installation guide

mxODBC - Python ODBC Database Interface
6.8.1
Additional Attributes .......................................................................... 101
7. mxODBC Cursor Objects................................. 102
7.1 Relationship between Cursors and Connections ............. 102
7.1.1 Dependency on the Connection Object............................................. 102
7.1.2 Using multiple Cursor Objects on a single Connection...................... 102
7.2 Subpackage Support ....................................................... 103
7.3 Cursor objects as context managers................................ 103
7.3.1 Using cursor objects as context objects ............................................. 103
7.4 Cursor Type Object......................................................... 103
7.5 Cursor Object Constructors............................................ 104
connection.cursor(name=None, cursor_options=()) .............. 104
7.6 Cursor Object Methods .................................................. 104
.callproc(procname, parameters=(), parametertypes=None) .. 104
.close() .................................................................................... 104
.execute(sqlcmd, parameters=(), direct=-1,
parametertypes=None)........................................................... 104
'qmark'(default)........................................................................ 105
'named' .................................................................................... 105
.executedirect(sqlcmd, parameters=(), parametertypes=None)106
.executemany(sqlcmd, batch=(), direct=0,
parametertypes=None)........................................................... 106
.fetchall() ................................................................................. 106
.fetchmany([size=cursor.arraysize])........................................ 106
.fetchone()............................................................................... 107
.flush()..................................................................................... 107
.getcolattribute(position, info_id)............................................. 107
.getcursorname() ..................................................................... 109
.getcursoroption(option).......................................................... 109
.next()...................................................................................... 110
.nextset() ................................................................................. 110
.prepare(sqlcmd) ..................................................................... 111
.scroll(value, mode='relative').................................................. 111
.setconverter(converter) ..........................................................111
.setcursorname(name)............................................................. 111
.setcursoroption(option, value)................................................ 112