Scripts: Stream API for storedProcedure and trigger CRUD

[kirankumarkolli]

Scripts: Stream API for storedProcedure and trigger CRUD

ref: https://github.com/Azure/azure-cosmos-dotnet-v3/blob/master/Microsoft.Azure.Cosmos/src/Resource/Scripts/Scripts.cs

[NaluTripician]

Stream APIs for StoredProcedure and Trigger CRUD

Introduction

This document describes the design of the Stream APIs for StoredProcedure and Trigger CRUD. The Stream APIs are used to create, read, update, and delete stored procedures and triggers in a Cosmos DB account. This will also include user-defined functions.

APIs to Be Implemented

The following APIs will be implemented:

• CreateStoredProcedureStreamAsync
• ReadStoredProcedureStreamAsync
• ReplaceStoredProcedureStreamAsync
• DeleteStoredProcedureStreamAsync
• CreateTriggerStreamAsync
• ReadTriggerStreamAsync
• ReplaceTriggerStreamAsync
• DeleteTriggerStreamAsync
• CreateUserDefinedFunctionStreamAsync
• ReadUserDefinedFunctionStreamAsync
• ReplaceUserDefinedFunctionStreamAsync
• DeleteUserDefinedFunctionStreamAsync

Testing

To test the Stream APIs, we will create a test suite that covers all the scenarios of the exisiting non-stream APIs. We will also test the Stream APIs with different types of stored procedures, triggers, and user-defined functions.