aws / aws/amazon-redshift-python-driver
Feature request: `autocommit` as connector `__init__` property
- Dominant language
- Python
- Stars
- 220
- Forks
- 86
- PR merge metrics
- No merged PRs in 30d
Description
Currently, to set `autocommit` to `True`, we have to explicitly run:
```
connection.autocommit = True
```
Is there a way to pass `autocommit` as a property to the connector constructor? Something like:
```
redshift_connector.connect({
autocommit=True,
**connection_params
})
```
We are trying to build an SQL client for our customers with Redshift as one of the underlying data-sources. It would be much cleaner this way avoiding unnecessary if-else conditioning.
Contributor guide
Research direction
Start at the redshift_connector.connect entry point and trace how connection parameters reach the connection object, then inspect the existing connection.autocommit behavior. Done means the connector accepts autocommit during construction and preserves the current explicit assignment behavior; add or update the relevant connector tests to cover the constructor option.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- aws, python
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100