microsoft / microsoft/mssql-rs
Can PyCoreCursor.execute have a configurable timeout?
- 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
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