aws / aws/amazon-redshift-python-driver

Feature request: `autocommit` as connector `__init__` property

Open
#203 2 comments 0 reactions 0 assignees View on GitHub
enhancement
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.