Returning cursor on SQLDatabase.run even when returns_rows is empty #24581
NicolasCampana
announced in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Checked
Feature request
I want to be able to access the cursor object even when the "returns_rows" is empty when executing a query.
Motivation
For MSSQL dialect, if a UPDATE or DELETE has been made, it does not return rows but it returns the number of rows affected on "rowcount" property. I want to be able to inform the user how many rows were affected but it is not currently possible because it only returns something (even the cursor object) if the returns_rows is not empty.
Proposal (If applicable)
I think that if the user's fetch property is "cursor", it should be returned regardless if the returns_rows property is empty or not.
Should I open a issue on that?
Beta Was this translation helpful? Give feedback.
All reactions