StoredProcedures class

Paket:

@azure/cosmos

Operasi untuk membuat, meningkatkan, atau membaca/mengkueri semua Prosedur Tersimpan.

Agar operasi membaca, mengganti, menghapus, atau menjalankan prosedur tersimpan tertentu yang ada menurut id, lihat container.storedProcedure().

Properti

container

Metode

create(StoredProcedureDefinition, RequestOptions)	Buat StoredProcedure. Azure Cosmos DB memungkinkan prosedur tersimpan dijalankan di tingkat penyimpanan, langsung terhadap kontainer item. Skrip dijalankan di bawah transaksi ACID pada partisi penyimpanan utama kontainer yang ditentukan. Untuk detail tambahan, lihat dokumentasi JAVAScript API sisi server. Contoh import { CosmosClient, StoredProcedureDefinition } from "@azure/cosmos"; const endpoint = "https://your-account.documents.azure.com"; const key = "<database account masterkey>"; const client = new CosmosClient({ endpoint, key }); const { database } = await client.databases.createIfNotExists({ id: "Test Database" }); const { container } = await database.containers.createIfNotExists({ id: "Test Container" }); const sprocDefinition: StoredProcedureDefinition = { id: "sample sproc", body: "function () { const x = 10; }", }; const { resource: sproc } = await container.scripts.storedProcedures.create(sprocDefinition);
query(SqlQuerySpec, FeedOptions)	Kueri semua Prosedur Tersimpan. Contoh Baca semua prosedur tersimpan untuk array. import { CosmosClient, SqlQuerySpec } from "@azure/cosmos"; const endpoint = "https://your-account.documents.azure.com"; const key = "<database account masterkey>"; const client = new CosmosClient({ endpoint, key }); const { database } = await client.databases.createIfNotExists({ id: "Test Database" }); const { container } = await database.containers.createIfNotExists({ id: "Test Container" }); const querySpec: SqlQuerySpec = { query: `SELECT * FROM root r WHERE r.id = @sproc`, parameters: [{ name: "@sproc", value: "Todo" }], }; const { resources: storedProceduresList } = await container.scripts.storedProcedures .query(querySpec) .fetchAll();
query<T>(SqlQuerySpec, FeedOptions)	Kueri semua Prosedur Tersimpan. Contoh Baca semua prosedur tersimpan untuk array. import { CosmosClient, SqlQuerySpec } from "@azure/cosmos"; const endpoint = "https://your-account.documents.azure.com"; const key = "<database account masterkey>"; const client = new CosmosClient({ endpoint, key }); const { database } = await client.databases.createIfNotExists({ id: "Test Database" }); const { container } = await database.containers.createIfNotExists({ id: "Test Container" }); const querySpec: SqlQuerySpec = { query: `SELECT * FROM root r WHERE r.id = @sproc`, parameters: [{ name: "@sproc", value: "Todo" }], }; const { resources: storedProceduresList } = await container.scripts.storedProcedures .query(querySpec) .fetchAll();
readAll(FeedOptions)	Baca semua prosedur tersimpan. Contoh Baca semua prosedur tersimpan untuk array. import { CosmosClient } from "@azure/cosmos"; const endpoint = "https://your-account.documents.azure.com"; const key = "<database account masterkey>"; const client = new CosmosClient({ endpoint, key }); const { database } = await client.databases.createIfNotExists({ id: "Test Database" }); const { container } = await database.containers.createIfNotExists({ id: "Test Container" }); const { resources: storedProceduresList } = await container.scripts.storedProcedures .readAll() .fetchAll();

Detail Properti

container

container: Container

Nilai Properti

Container

Detail Metode

create(StoredProcedureDefinition, RequestOptions)

Buat StoredProcedure.

Azure Cosmos DB memungkinkan prosedur tersimpan dijalankan di tingkat penyimpanan, langsung terhadap kontainer item. Skrip dijalankan di bawah transaksi ACID pada partisi penyimpanan utama kontainer yang ditentukan. Untuk detail tambahan, lihat dokumentasi JAVAScript API sisi server.

Contoh

import { CosmosClient, StoredProcedureDefinition } from "@azure/cosmos";

const endpoint = "https://your-account.documents.azure.com";
const key = "<database account masterkey>";
const client = new CosmosClient({ endpoint, key });
const { database } = await client.databases.createIfNotExists({ id: "Test Database" });
const { container } = await database.containers.createIfNotExists({ id: "Test Container" });

const sprocDefinition: StoredProcedureDefinition = {
  id: "sample sproc",
  body: "function () { const x = 10; }",
};

const { resource: sproc } = await container.scripts.storedProcedures.create(sprocDefinition);

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

Parameter

body

StoredProcedureDefinition

options

RequestOptions

Mengembalikan

Promise<StoredProcedureResponse>

query(SqlQuerySpec, FeedOptions)

Kueri semua Prosedur Tersimpan.

Contoh

Baca semua prosedur tersimpan untuk array.

import { CosmosClient, SqlQuerySpec } from "@azure/cosmos";

const endpoint = "https://your-account.documents.azure.com";
const key = "<database account masterkey>";
const client = new CosmosClient({ endpoint, key });

const { database } = await client.databases.createIfNotExists({ id: "Test Database" });

const { container } = await database.containers.createIfNotExists({ id: "Test Container" });

const querySpec: SqlQuerySpec = {
  query: `SELECT * FROM root r WHERE r.id = @sproc`,
  parameters: [{ name: "@sproc", value: "Todo" }],
};
const { resources: storedProceduresList } = await container.scripts.storedProcedures
  .query(querySpec)
  .fetchAll();

function query(query: SqlQuerySpec, options?: FeedOptions): QueryIterator<any>

Parameter

query

SqlQuerySpec

Konfigurasi kueri untuk operasi. Lihat SqlQuerySpec untuk informasi selengkapnya tentang cara mengonfigurasi kueri.

options

FeedOptions

Mengembalikan

QueryIterator<any>

query<T>(SqlQuerySpec, FeedOptions)

Kueri semua Prosedur Tersimpan.

Contoh

Baca semua prosedur tersimpan untuk array.

import { CosmosClient, SqlQuerySpec } from "@azure/cosmos";

const endpoint = "https://your-account.documents.azure.com";
const key = "<database account masterkey>";
const client = new CosmosClient({ endpoint, key });

const { database } = await client.databases.createIfNotExists({ id: "Test Database" });

const { container } = await database.containers.createIfNotExists({ id: "Test Container" });

const querySpec: SqlQuerySpec = {
  query: `SELECT * FROM root r WHERE r.id = @sproc`,
  parameters: [{ name: "@sproc", value: "Todo" }],
};
const { resources: storedProceduresList } = await container.scripts.storedProcedures
  .query(querySpec)
  .fetchAll();

function query<T>(query: SqlQuerySpec, options?: FeedOptions): QueryIterator<T>

Parameter

query

SqlQuerySpec

Konfigurasi kueri untuk operasi. Lihat SqlQuerySpec untuk informasi selengkapnya tentang cara mengonfigurasi kueri.

options

FeedOptions

Mengembalikan

QueryIterator<T>

readAll(FeedOptions)

Baca semua prosedur tersimpan.

Contoh

Baca semua prosedur tersimpan untuk array.

import { CosmosClient } from "@azure/cosmos";

const endpoint = "https://your-account.documents.azure.com";
const key = "<database account masterkey>";
const client = new CosmosClient({ endpoint, key });

const { database } = await client.databases.createIfNotExists({ id: "Test Database" });

const { container } = await database.containers.createIfNotExists({ id: "Test Container" });

const { resources: storedProceduresList } = await container.scripts.storedProcedures
  .readAll()
  .fetchAll();

function readAll(options?: FeedOptions): QueryIterator<StoredProcedureDefinition & Resource>

Parameter

options

FeedOptions

Mengembalikan

QueryIterator<StoredProcedureDefinition & Resource>