Active Data Objects Data-Base Application Program Interface is a PEP-249
compliant SQL database package which will work with a large number of
tabular data sources. It is tested using a Microsoft SQL Server database,
along with PostgreSQL, MySQL and Jet (Microsoft ACCESS) databases. An
included example manipulates an .xls spreadsheet using SQL commands.
Although adodbapi continues to lead in development and standardization of
API extensions (such as referencing data columns by name), version 2.6 is
mostly a maintenance release with some refactoring, and only a few new
features:
It now supports prepared SQL statements using a simple interface. For
example...
> conn = adodbapi.connect('your connection string here')
> crsr = conn.cursor()
> crsr.prepare('some SQL statement where ? = ?')
> for parameters in sequence_of_parameter_sequences:
>
crsr.execute(crsr.command, parameters)
>
In addition to the conjectured db-api version 3 standard of requiring SQL
parameter "paramstyles" of 'qmark' and 'numeric' , version 2.6 extends the
list to ['qmark', 'numeric', 'format', 'pyformat', 'dynamic']. Switching
between sequences of parameters, and dictionaries of parameters, is dynamic
for some paramstyles. [If you don't know what a 'paramstyle' is, it might
be better to remain oblivious. ;-) ]
Lightweight documentation athttp://adodbapi.sourceforge.net/quick_reference.pdf
Project at https://sourceforge.net/projects/adodbapi
_______________________________________________
Ironpython-users mailing list
Ironpython-users@python.org
https://mail.python.org/mailman/listinfo/ironpython-users
