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);
}
