Stored procedure calls (Effect's @effect/sql-mssql Procedure):
a procedure's name, its input and output parameters and the type of the
rows it returns, run with MssqlClientService.call::
name = Parameter[str]("name", TYPES.NVarChar)
answer = Parameter[int]("answer", TYPES.Int)
get_answer = procedure.make("get_answer").param(name).output_param(answer)
result = yield client.call(get_answer.compile(name("Tim")))
result.output[answer] # an int
result.rows # the rows it selectedA parameter added again under the same name replaces the earlier one, as
in Effect's record of parameters. compile takes a value for each
input, and nothing else.
Classes#
Functions#
make#
make(name) -> ProcedureThe procedure name, without parameters.
| Parameter | Type | Description |
|---|---|---|
name | str |
Returns Procedure
def make(name: str) -> Procedure:
"""The procedure ``name``, without parameters."""
return Procedure(name)