Share via

StoredProcedures class

  • Reference
Package:
@azure/cosmos

Operations for creating, upserting, or reading/querying all Stored Procedures.

For operations to read, replace, delete, or execute a specific, existing stored procedure by id, see container.storedProcedure().

Properties

container

Methods

create(StoredProcedureDefinition, RequestOptions)

Create a StoredProcedure.

Azure Cosmos DB allows stored procedures to be executed in the storage tier, directly against an item container. The script gets executed under ACID transactions on the primary storage partition of the specified container. For additional details, refer to the server-side JavaScript API documentation.
query(SqlQuerySpec, FeedOptions)

Query all Stored Procedures.

Example

Read all stored procedures to array.

TypeScript 
const querySpec: SqlQuerySpec = {
  query: "SELECT * FROM root r WHERE r.id = @sproc",
  parameters: [
    {name: "@sproc", value: "Todo"}
  ]
};
const {body: sprocList} = await containers.storedProcedures.query(querySpec).fetchAll();
query<T>(SqlQuerySpec, FeedOptions)

Query all Stored Procedures.

Example

Read all stored procedures to array.

TypeScript 
const querySpec: SqlQuerySpec = {
  query: "SELECT * FROM root r WHERE r.id = @sproc",
  parameters: [
    {name: "@sproc", value: "Todo"}
  ]
};
const {body: sprocList} = await containers.storedProcedures.query(querySpec).fetchAll();
readAll(FeedOptions)

Read all stored procedures.

Example

Read all stored procedures to array.

TypeScript 
const {body: sprocList} = await containers.storedProcedures.readAll().fetchAll();

Property Details

container

TypeScript 
container: Container

Property Value

Container

Method Details

create(StoredProcedureDefinition, RequestOptions)

Create a StoredProcedure.

Azure Cosmos DB allows stored procedures to be executed in the storage tier, directly against an item container. The script gets executed under ACID transactions on the primary storage partition of the specified container. For additional details, refer to the server-side JavaScript API documentation.

TypeScript 
function create(body: StoredProcedureDefinition, options?: RequestOptions): Promise<StoredProcedureResponse>

Parameters

body
StoredProcedureDefinition
options
RequestOptions

Returns

Promise<StoredProcedureResponse>

query(SqlQuerySpec, FeedOptions)

Query all Stored Procedures.

Example

Read all stored procedures to array.

TypeScript 
const querySpec: SqlQuerySpec = {
  query: "SELECT * FROM root r WHERE r.id = @sproc",
  parameters: [
    {name: "@sproc", value: "Todo"}
  ]
};
const {body: sprocList} = await containers.storedProcedures.query(querySpec).fetchAll();
TypeScript 
function query(query: SqlQuerySpec, options?: FeedOptions): QueryIterator<any>

Parameters

query
SqlQuerySpec

Query configuration for the operation. See SqlQuerySpec for more info on how to configure a query.

options
FeedOptions

Returns

QueryIterator<any>

query<T>(SqlQuerySpec, FeedOptions)

Query all Stored Procedures.

Example

Read all stored procedures to array.

TypeScript 
const querySpec: SqlQuerySpec = {
  query: "SELECT * FROM root r WHERE r.id = @sproc",
  parameters: [
    {name: "@sproc", value: "Todo"}
  ]
};
const {body: sprocList} = await containers.storedProcedures.query(querySpec).fetchAll();
TypeScript 
function query<T>(query: SqlQuerySpec, options?: FeedOptions): QueryIterator<T>

Parameters

query
SqlQuerySpec

Query configuration for the operation. See SqlQuerySpec for more info on how to configure a query.

options
FeedOptions

Returns

QueryIterator<T>

readAll(FeedOptions)

Read all stored procedures.

Example

Read all stored procedures to array.

TypeScript 
const {body: sprocList} = await containers.storedProcedures.readAll().fetchAll();
TypeScript 
function readAll(options?: FeedOptions): QueryIterator<StoredProcedureDefinition & Resource>

Parameters

options
FeedOptions

Returns

QueryIterator<StoredProcedureDefinition & Resource>