ydb-python-sdk icon indicating copy to clipboard operation
ydb-python-sdk copied to clipboard

feature: Support parametrized query without prepare

Open rekby opened this issue 2 years ago • 0 comments

Feature Request

Describe the Feature Request

Support use typed parameters to query without prepare

        result = tx.execute(
            "SELECT $hostName",
            parameters= {
            "$hostName": "test.local",
        },
        )

Now it raise BadRequest error:

raise exc_obj(_format_issues(response_proto.issues), response_proto.issues)
ydb.issues.BadRequest: message: "ydb/core/kqp/kqp_session_actor.cpp:882: Missing value for parameter: $hostName" severity: 1

In current version prepare need for parse query by server and return argument with types.

rekby avatar Jan 13 '23 05:01 rekby