snowflakedb / snowflakedb/snowflake-connector-python

Session/cursor specific `paramstyle`

Open
#1,185 2 comments 2 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

feature status-triage_done triaged
Dominant language
Python
Stars
730
Forks
574
Avg merge
5h 45m
Merged PRs (30d)
16

Description

What is the current behavior?

The paramstyle must be declared before opening a connection.

What is the desired behavior?

To be able to declare the paramstyle on a finer grain level.

How would this improve snowflake-connector-python?

Provide users with more flexibility to set their paramstyle without requiring different connections.

By default, the connector uses pyformat, however, in some places we want to be able to use other paramstyles, such as qmark, however this requires creating a new connection just for a single query using a different parameter.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files, tests, or entry points are named. Start by tracing where paramstyle is declared before a connection opens and determine how cursor- or session-level configuration could fit; done means users can use qmark or another paramstyle without creating a separate connection.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.