The adodbapi module is a PEP-249 (DB-API 2.0) compliant interface for Microsoft ADO. It allows you to connect to various data sources and execute SQL queries.
Key Features:
- Column Name Access: You can retrieve data by column name directly from the row object.
- Parameter Styles: Supports multiple
paramstyles: 'qmark', 'named', 'format', 'pyformat', and 'dynamic'.- If using
'named', you must pass a dictionary of parameters to the .execute() method. - If using
'format', 'pyformat', or 'dynamic', you may pass a dictionary if the SQL string is formatted correctly.
- Context Managers: Connection objects act as context managers for transactions (automatically committing or rolling back), and Cursor objects act as context managers to ensure they are automatically closed.
# Example of data retrieval by column name
for row in myCurser.execute("select name,age from students"):
print("Student", row.name, "is", row.age, "years old.")
