public void TestPauseResumeDatabase()
{
using (SqlManagementTestContext context = new SqlManagementTestContext(this))
{
ResourceGroup resourceGroup = context.CreateResourceGroup();
Server server = context.CreateServer(resourceGroup);
SqlManagementClient sqlClient = context.GetClient <SqlManagementClient>();
// Create data warehouse
string dbName = SqlManagementTestUtilities.GenerateName();
var db1 = sqlClient.Databases.CreateOrUpdate(resourceGroup.Name, server.Name, dbName, new Database()
{
Location = server.Location,
Sku = SqlTestConstants.DefaultDataWarehouseSku()
});
Assert.NotNull(db1);
// Pause
sqlClient.Databases.Pause(resourceGroup.Name, server.Name, dbName);
// TODO: Get result and verify that status is now resumed - blocked by https://github.com/Azure/autorest/issues/2295
// Resume
sqlClient.Databases.Resume(resourceGroup.Name, server.Name, dbName);
// TODO: Get result and verify that status is now resumed - blocked by https://github.com/Azure/autorest/issues/2295
}
}
public void TestUpdateGetListGeoBackupPolicy()
{
using (SqlManagementTestContext context = new SqlManagementTestContext(this))
{
ResourceGroup resourceGroup = context.CreateResourceGroup();
Server server = context.CreateServer(resourceGroup);
SqlManagementClient sqlClient = context.GetClient <SqlManagementClient>();
// Create data warehouse
string dbName = SqlManagementTestUtilities.GenerateName();
var db1 = sqlClient.Databases.CreateOrUpdate(resourceGroup.Name, server.Name, dbName, new Database()
{
Location = server.Location,
Sku = SqlTestConstants.DefaultDataWarehouseSku()
});
Assert.NotNull(db1);
// List Geo Backup Policy
IEnumerable <GeoBackupPolicy> policies = sqlClient.GeoBackupPolicies.ListByDatabase(resourceGroup.Name, server.Name, dbName);
Assert.Equal(1, policies.Count());
GeoBackupPolicy policy = policies.First();
Assert.Equal("Default", policy.Name);
Assert.Equal(GeoBackupPolicyState.Enabled, policy.State);
Assert.Equal("Premium", policy.StorageType);
// Get Geo Backup Policy
policy = sqlClient.GeoBackupPolicies.Get(resourceGroup.Name, server.Name, dbName);
Assert.Equal("Default", policy.Name);
Assert.Equal(GeoBackupPolicyState.Enabled, policy.State);
Assert.Equal("Premium", policy.StorageType);
// Update policy
sqlClient.GeoBackupPolicies.CreateOrUpdate(resourceGroup.Name, server.Name, dbName, new GeoBackupPolicy
{
State = GeoBackupPolicyState.Disabled
});
// List Geo Backup Policy
policies = sqlClient.GeoBackupPolicies.ListByDatabase(resourceGroup.Name, server.Name, dbName);
Assert.Equal(1, policies.Count());
policy = policies.First();
Assert.Equal("Default", policy.Name);
Assert.Equal(GeoBackupPolicyState.Disabled, policy.State);
Assert.Equal("Premium", policy.StorageType);
// Get Geo Backup Policy
policy = sqlClient.GeoBackupPolicies.Get(resourceGroup.Name, server.Name, dbName);
Assert.Equal("Default", policy.Name);
Assert.Equal(GeoBackupPolicyState.Disabled, policy.State);
Assert.Equal("Premium", policy.StorageType);
}
}