public async Task TearDown() { if (await SqlTriggerCollection.ExistsAsync(_triggerName)) { var id = SqlTriggerCollection.Id; id = SqlTriggerResource.CreateResourceIdentifier(id.SubscriptionId, id.ResourceGroupName, id.Parent.Parent.Name, id.Parent.Name, id.Name, _triggerName); SqlTriggerResource trigger = this.ArmClient.GetSqlTriggerResource(id); await trigger.DeleteAsync(WaitUntil.Completed); } }
private void VerifySqlTriggers(SqlTriggerResource expectedValue, SqlTriggerResource 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); Assert.AreEqual(expectedValue.Data.Resource.TriggerType, actualValue.Data.Resource.TriggerType); Assert.AreEqual(expectedValue.Data.Resource.TriggerOperation, actualValue.Data.Resource.TriggerOperation); }
public async Task SqlTriggerListTest() { List <SqlTriggerResource> sqlTriggers = await CosmosDBManagementClient.SqlResources.ListSqlTriggersAsync( resourceGroupName, databaseAccountName, databaseName, containerName).ToEnumerableAsync(); Assert.NotNull(sqlTriggers); Assert.AreEqual(1, sqlTriggers.Count); SqlTriggerResource sqlTrigger = await CosmosDBManagementClient.SqlResources.GetSqlTriggerAsync( resourceGroupName, databaseAccountName, databaseName, containerName, triggerName); VerifySqlTriggers(sqlTrigger, sqlTriggers[0]); }
public SqlContainerImpl WithTrigger(string name, SqlTriggerResource resource = default(SqlTriggerResource), CreateUpdateOptions options = default(CreateUpdateOptions)) { var parameter = new SqlTriggerCreateUpdateParameters() { Location = this.Location, Resource = resource ?? new SqlTriggerResource(), Options = options ?? new CreateUpdateOptions(), }; parameter.Resource.Id = name; this.triggerToUpdate.Add(name, parameter); return(this); }
public async Task SqlTriggerCreateAndUpdateTest() { SqlTriggerCreateUpdateParameters sqlTriggerCreateUpdateParameters = new SqlTriggerCreateUpdateParameters( resource: new SqlTriggerResource(triggerName) { TriggerOperation = "All", TriggerType = "Pre", Body = "function () { var context = getContext(); " + "var response = context.getResponse();" + "response.setBody('First Hello World');" + "}" }, options: new CreateUpdateOptions() ); SqlTriggerResource sqlTrigger1 = await WaitForCompletionAsync( await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlTriggerAsync( resourceGroupName, databaseAccountName, databaseName, containerName, triggerName, sqlTriggerCreateUpdateParameters)); Assert.NotNull(sqlTrigger1); SqlTriggerResource sqlTrigger2 = await CosmosDBManagementClient.SqlResources.GetSqlTriggerAsync( resourceGroupName, databaseAccountName, databaseName, containerName, triggerName); Assert.NotNull(sqlTrigger2); VerifySqlTriggers(sqlTrigger1, sqlTrigger2); sqlTriggerCreateUpdateParameters = new SqlTriggerCreateUpdateParameters( resource: new SqlTriggerResource(triggerName) { TriggerOperation = "All", TriggerType = "Post", Body = "function () { var context = getContext(); " + "var response = context.getResponse();" + "response.setBody('Second Hello World');" + "}" }, options: new CreateUpdateOptions() ); SqlTriggerResource sqlTrigger3 = await WaitForCompletionAsync( await CosmosDBManagementClient.SqlResources.StartCreateUpdateSqlTriggerAsync( resourceGroupName, databaseAccountName, databaseName, containerName, triggerName, sqlTriggerCreateUpdateParameters)); Assert.NotNull(sqlTrigger3); SqlTriggerResource sqlTrigger4 = await CosmosDBManagementClient.SqlResources.GetSqlTriggerAsync( resourceGroupName, databaseAccountName, databaseName, containerName, triggerName); Assert.NotNull(sqlTrigger4); VerifySqlTriggers(sqlTrigger3, sqlTrigger4); }
public async Task SqlTriggerCreateAndUpdate() { var trigger = await CreateSqlTrigger(null); Assert.AreEqual(_triggerName, trigger.Data.Resource.Id); Assert.That(trigger.Data.Resource.Body, Contains.Substring("First Hello World")); Assert.AreEqual(trigger.Data.Resource.TriggerOperation, TriggerOperation.All); Assert.AreEqual(trigger.Data.Resource.TriggerType, TriggerType.Pre); // Seems bug in swagger definition //Assert.AreEqual(TestThroughput1, container.Data.Options.Throughput); bool ifExists = await SqlTriggerCollection.ExistsAsync(_triggerName); Assert.True(ifExists); SqlTriggerResource trigger2 = await SqlTriggerCollection.GetAsync(_triggerName); Assert.AreEqual(_triggerName, trigger2.Data.Resource.Id); VerifySqlTriggers(trigger, trigger2); SqlTriggerCreateUpdateData updateOptions = new SqlTriggerCreateUpdateData(trigger.Id, _triggerName, trigger.Data.ResourceType, null, new Dictionary <string, string>(),// TODO: use original tags see defect: https://github.com/Azure/autorest.csharp/issues/1590 AzureLocation.WestUS, trigger.Data.Resource, new CreateUpdateOptions()); updateOptions = new SqlTriggerCreateUpdateData(AzureLocation.WestUS, new Models.SqlTriggerResource(_triggerName) { TriggerOperation = TriggerOperation.Create, TriggerType = TriggerType.Post, Body = @"function () { var updatetext = getContext(); var response = context.getResponse(); response.setBody('Second Hello World'); }" }); trigger = (await SqlTriggerCollection.CreateOrUpdateAsync(WaitUntil.Completed, _triggerName, updateOptions)).Value; Assert.AreEqual(_triggerName, trigger.Data.Resource.Id); Assert.That(trigger.Data.Resource.Body, Contains.Substring("Second Hello World")); Assert.AreEqual(trigger.Data.Resource.TriggerOperation, TriggerOperation.Create); Assert.AreEqual(trigger.Data.Resource.TriggerType, TriggerType.Post); trigger2 = await SqlTriggerCollection.GetAsync(_triggerName); VerifySqlTriggers(trigger, trigger2); }
public async Task SqlTriggerCreateAndUpdate() { var trigger = await CreateSqlTrigger(null); Assert.AreEqual(_triggerName, trigger.Data.Resource.Id); Assert.That(trigger.Data.Resource.Body, Contains.Substring("First Hello World")); Assert.AreEqual(trigger.Data.Resource.TriggerOperation, TriggerOperation.All); Assert.AreEqual(trigger.Data.Resource.TriggerType, TriggerType.Pre); // Seems bug in swagger definition //Assert.AreEqual(TestThroughput1, container.Data.Options.Throughput); bool ifExists = await SqlTriggerCollection.ExistsAsync(_triggerName); Assert.True(ifExists); SqlTriggerResource trigger2 = await SqlTriggerCollection.GetAsync(_triggerName); Assert.AreEqual(_triggerName, trigger2.Data.Resource.Id); VerifySqlTriggers(trigger, trigger2); var updateOptions = new SqlTriggerCreateOrUpdateContent(AzureLocation.WestUS, new Models.SqlTriggerResource(_triggerName) { TriggerOperation = TriggerOperation.Create, TriggerType = TriggerType.Post, Body = @"function () { var updatetext = getContext(); var response = context.getResponse(); response.setBody('Second Hello World'); }" }); trigger = (await SqlTriggerCollection.CreateOrUpdateAsync(WaitUntil.Completed, _triggerName, updateOptions)).Value; Assert.AreEqual(_triggerName, trigger.Data.Resource.Id); Assert.That(trigger.Data.Resource.Body, Contains.Substring("Second Hello World")); Assert.AreEqual(trigger.Data.Resource.TriggerOperation, TriggerOperation.Create); Assert.AreEqual(trigger.Data.Resource.TriggerType, TriggerType.Post); trigger2 = await SqlTriggerCollection.GetAsync(_triggerName); VerifySqlTriggers(trigger, trigger2); }