GitHub

procedure

API reference for procedure.

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 selected

A 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) -> Procedure

The procedure name, without parameters.

ParameterTypeDescription
namestr

Returns Procedure

def make(name: str) -> Procedure:
    """The procedure ``name``, without parameters."""
    return Procedure(name)