microsoft / microsoft/mssql-rs

Can PyCoreCursor.execute have a configurable timeout?

Open
#583 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
53
Forks
14
Avg merge
1d 15h
Merged PRs (30d)
137

Description

We use mssql-python 1.15.0 and its bundled mssql_py_core for DELETE + bulkcopy_arrow in one transaction.

DELETE repeatedly fails after about 30.7 seconds on Azure SQL. In cursor.rs, execute() hardcodes timeout: Some(30), with no Python override. The bulkcopy_arrow timeout does not cover DELETE.

Could execute() expose a configurable timeout so we can keep both operations on the same connection?

Contributor guide

Open the contributing guide

Research direction

Start in cursor.rs at PyCoreCursor.execute(), where the timeout is hardcoded to Some(30), and trace how the Python binding exposes related timeout configuration for bulkcopy_arrow. Check the surrounding API and tests before changing behavior; done means callers can configure execute’s timeout while the existing default remains supported.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, python, rust, sql
Domain
backend-api-design, databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
72/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.