pyodbc
pyodbc copied to clipboard
set statement attributes
You can set connection-level attributes via set_attr but not cursor-level settings. Note that I haven't had time for tests here yet, but can put them together if adding this to the project makes sense.
- fix: set timeout before attempting connection timeout
- feat: adding set_attr to cursor
It does seem like a missing piece of the API - thanks. Could you add at least one test for PostgreSQL, MySQL, or SQL Server?
I'm also curious about the impetus for this. Were you looking for a statement timeout?
I really like this idea.
I really appreciate the note in the doc string that only integers are supported right now. That will help a lot.
This could be useful for setting SQL_ATTR_ENABLE_AUTO_IPD statement attribute as well.