public async Task Test_CheckCreateDatabase_WithNewDatabase()
{
const int dbSize = 5;
const string dbCollation = "SQL_Latin1_General_CP1_CI_AS";
var dbEdition = SqlAzureEdition.Standard.GetEnumDescription();
using (var client = ManagementClient.CreateSqlClient())
{
var dbName = "fct-" + Guid.NewGuid().ToString().Split('-').Last();
var chooser = new DefaultAzureSqlServerChooser();
var server = await chooser.Choose(client, SystemLocation.WestEurope.GetEnumDescription());
Assert.IsFalse(string.IsNullOrWhiteSpace(server));
try
{
await client.CreateDatabaseIfNotExistsAsync(server, dbName, dbEdition, dbCollation, dbSize, true);
var webSite = await client.Databases.GetAsync(server, dbName, new CancellationToken());
Assert.IsNotNull(webSite);
}
finally
{
client.Databases.Delete(server, dbName);
}
}
}
public async Task Test_Choose_WithValidServer()
{
using (var client = ManagementClient.CreateSqlClient())
{
var chooser = new DefaultAzureSqlServerChooser();
var server = await chooser.Choose(client, _regionWithSqlServers);
Assert.IsFalse(string.IsNullOrWhiteSpace(server));
}
}
public async Task Test_Choose_WithNoValidServer()
{
using (var client = ManagementClient.CreateSqlClient())
{
var chooser = new DefaultAzureSqlServerChooser();
var server = await chooser.Choose(client, _regionWithoutSqlServers);
Assert.IsNull(server);
}
}
public async Task Test_SqlAzureDb_ProvisionAll_End2End()
{
FlexDataConfiguration.Branch = "Main";
FlexDataConfiguration.Configuration = "djfr";
using (var client = ManagementClient.CreateSqlClient())
using (var context = new DevOpsFlexDbContext())
{
await context.Components.OfType <SqlAzureDb>().ProvisionAllAsync(client);
}
}
public async Task Test_SqlFirewallRule_ProvisionAll_End2End()
{
FlexDataConfiguration.Branch = "Main";
FlexDataConfiguration.Configuration = "MO";
using (var client = ManagementClient.CreateSqlClient())
using (var context = new DevOpsFlexDbContext())
{
await context.SqlFirewallRules.ProvisionAllAsync(client);
}
}
public void Test_SqlAzureDb_ProvisionAll_End2End()
{
FlexDataConfiguration.Branch = "Main";
FlexDataConfiguration.Configuration = "djfr";
using (var client = ManagementClient.CreateSqlClient())
using (var context = new DevOpsFlexDbContext())
{
var tasks = context.Components.OfType <SqlAzureDb>().ProvisionAllAsync(client);
Task.WaitAll(tasks.ToArray());
}
}
public void Test_SqlFirewallRule_ProvisionAll_End2End()
{
FlexDataConfiguration.Branch = "Main";
FlexDataConfiguration.Configuration = "MO";
using (var client = ManagementClient.CreateSqlClient())
using (var context = new DevOpsFlexDbContext())
{
var tasks = context.SqlFirewallRules.ProvisionAllAsync(client);
Task.WaitAll(tasks.ToArray());
}
}
public async Task Test_CheckCreateFirewallRule_WithExistingFirewallRule()
{
const string startIp = "111.111.111.111";
const string endIp = "111.111.111.111";
using (var client = ManagementClient.CreateSqlClient())
{
var ruleName = "fct-" + Guid.NewGuid().ToString().Split('-').Last();
var chooser = new DefaultAzureSqlServerChooser();
var server = await chooser.Choose(client, SystemLocation.WestEurope.GetEnumDescription());
Assert.IsFalse(string.IsNullOrWhiteSpace(server));
try
{
await client.FirewallRules.CreateAsync(
server,
new FirewallRuleCreateParameters
{
Name = ruleName,
StartIPAddress = startIp,
EndIPAddress = endIp
});
await client.CreateFirewallRuleIfNotExistsAsync(
server,
new FirewallRuleCreateParameters
{
Name = ruleName,
StartIPAddress = startIp,
EndIPAddress = endIp
});
}
finally
{
client.FirewallRules.Delete(server, ruleName);
}
}
}
