public async Task SqlStoredProcedureCreateAndUpdate() { var storedProcedure = await CreateSqlStoredProcedure(null); Assert.AreEqual(_storedProcedureName, storedProcedure.Data.Resource.Id); // Seems bug in swagger definition //Assert.AreEqual(TestThroughput1, container.Data.Options.Throughput); bool ifExists = await SqlStoredProcedureCollection.ExistsAsync(_storedProcedureName); Assert.True(ifExists); // NOT WORKING API //ThroughputSettingsData throughtput = await container.GetMongoDBCollectionThroughputAsync(); SqlStoredProcedureResource storedProcedure2 = await SqlStoredProcedureCollection.GetAsync(_storedProcedureName); Assert.AreEqual(_storedProcedureName, storedProcedure2.Data.Resource.Id); //Assert.AreEqual(TestThroughput1, container2.Data.Options.Throughput); VerifySqlStoredProcedures(storedProcedure, storedProcedure2); // TODO: use original tags see defect: https://github.com/Azure/autorest.csharp/issues/1590 var updateOptions = new SqlStoredProcedureCreateOrUpdateContent(AzureLocation.WestUS, storedProcedure.Data.Resource) { Options = new CreateUpdateOptions { Throughput = TestThroughput2 } }; storedProcedure = (await SqlStoredProcedureCollection.CreateOrUpdateAsync(WaitUntil.Completed, _storedProcedureName, updateOptions)).Value; Assert.AreEqual(_storedProcedureName, storedProcedure.Data.Resource.Id); storedProcedure2 = await SqlStoredProcedureCollection.GetAsync(_storedProcedureName); VerifySqlStoredProcedures(storedProcedure, storedProcedure2); }
public async Task TearDown() { if (await SqlStoredProcedureCollection.ExistsAsync(_storedProcedureName)) { var id = SqlStoredProcedureCollection.Id; id = SqlStoredProcedureResource.CreateResourceIdentifier(id.SubscriptionId, id.ResourceGroupName, id.Parent.Parent.Name, id.Parent.Name, id.Name, _storedProcedureName); SqlStoredProcedureResource storedProcedure = this.ArmClient.GetSqlStoredProcedureResource(id); await storedProcedure.DeleteAsync(WaitUntil.Completed); } }
private void VerifySqlStoredProcedures(SqlStoredProcedureResource expectedValue, SqlStoredProcedureResource actualValue) { Assert.AreEqual(expectedValue.Id, actualValue.Id); Assert.AreEqual(expectedValue.Data.Name, actualValue.Data.Name); Assert.AreEqual(expectedValue.Data.Resource.Id, actualValue.Data.Resource.Id); Assert.AreEqual(expectedValue.Data.Resource.Rid, actualValue.Data.Resource.Rid); Assert.AreEqual(expectedValue.Data.Resource.Ts, actualValue.Data.Resource.Ts); Assert.AreEqual(expectedValue.Data.Resource.Etag, actualValue.Data.Resource.Etag); Assert.AreEqual(expectedValue.Data.Resource.Body, actualValue.Data.Resource.Body); }
public SqlContainerImpl WithStoredProcedure(string name, SqlStoredProcedureResource resource = default(SqlStoredProcedureResource), CreateUpdateOptions options = default(CreateUpdateOptions)) { var parameter = new SqlStoredProcedureCreateUpdateParameters() { Location = this.Location, Resource = resource ?? new SqlStoredProcedureResource(), Options = options ?? new CreateUpdateOptions(), }; parameter.Resource.Id = name; this.storedProcedureToUpdate.Add(name, parameter); return(this); }
public async Task SqlStoredProcedureListTest() { List <SqlStoredProcedureResource> sqlStoredProcedures = await CosmosDBManagementClient.SqlResources.ListSqlStoredProceduresAsync( resourceGroupName, databaseAccountName, databaseName, containerName).ToEnumerableAsync(); Assert.NotNull(sqlStoredProcedures); Assert.AreEqual(1, sqlStoredProcedures.Count); SqlStoredProcedureResource sqlStoredProcedure = await CosmosDBManagementClient.SqlResources.GetSqlStoredProcedureAsync( resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName); Assert.NotNull(sqlStoredProcedure); VerifySqlStoredProcedures(sqlStoredProcedure, sqlStoredProcedures[0]); }
public async Task SqlStoredProcedureCreateAndUpdateTest() { SqlStoredProcedureCreateUpdateParameters sqlStoredProcedureCreateUpdateParameters = new SqlStoredProcedureCreateUpdateParameters( new SqlStoredProcedureResource(storedProcedureName) { Body = "function () { var updatetext = getContext(); " + "var response = context.getResponse();" + "response.setBody('First Hello World');" + "}" }, new CreateUpdateOptions() ); ; SqlStoredProcedureResource sqlStoredProcedure1 = await WaitForCompletionAsync( await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlStoredProcedureAsync( resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName, sqlStoredProcedureCreateUpdateParameters)); Assert.NotNull(sqlStoredProcedure1); SqlStoredProcedureResource sqlStoredProcedure2 = await CosmosDBManagementClient.SqlResources.GetSqlStoredProcedureAsync( resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName); Assert.NotNull(sqlStoredProcedure2); VerifySqlStoredProcedures(sqlStoredProcedure1, sqlStoredProcedure2); sqlStoredProcedureCreateUpdateParameters = new SqlStoredProcedureCreateUpdateParameters( new SqlStoredProcedureResource(storedProcedureName) { Body = "function () { var updatetext = getContext(); " + "var response = context.getResponse();" + "response.setBody('Second Hello World');" + "}" }, new CreateUpdateOptions() ); SqlStoredProcedureResource sqlStoredProcedure3 = await WaitForCompletionAsync( await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlStoredProcedureAsync( resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName, sqlStoredProcedureCreateUpdateParameters)); Assert.NotNull(sqlStoredProcedure3); SqlStoredProcedureResource sqlStoredProcedure4 = await CosmosDBManagementClient.SqlResources.GetSqlStoredProcedureAsync( resourceGroupName, databaseAccountName, databaseName, containerName, storedProcedureName); Assert.NotNull(sqlStoredProcedure4); VerifySqlStoredProcedures(sqlStoredProcedure3, sqlStoredProcedure4); }