public void TestDatabaseGeoRecovery()
{
// There can be a delay of several hours before the fist geo recoverable database backup
// is available, which is not appropriate for a scenario test. Therefore this test
// must run against a pre-created server that should have at least one database that
// was created a few hours ago.
// Pre-created database info
string resourceGroupName = "jaredmoo_cli";
string serverName = "jaredmoocli";
using (SqlManagementTestContext context = new SqlManagementTestContext(this))
{
SqlManagementClient sqlClient = context.GetClient <SqlManagementClient>();
// List geo recoverable database backups
IEnumerable <RecoverableDatabase> recoverableDatabases =
sqlClient.RecoverableDatabases.ListByServer(resourceGroupName, serverName);
Assert.True(recoverableDatabases.Any(), "No recoverable databases found.");
// Get geo recoverable database backup
RecoverableDatabase recoverableDatabase = sqlClient.RecoverableDatabases.Get(
resourceGroupName, serverName, recoverableDatabases.First().Name);
// Create database from geo recoverable database backup
Server server = sqlClient.Servers.Get(resourceGroupName, serverName);
Database newDatabase = sqlClient.Databases.CreateOrUpdate(
resourceGroupName, serverName, databaseName: SqlManagementTestUtilities.GenerateName(),
parameters: new Database
{
Location = server.Location,
CreateMode = CreateMode.Recovery,
SourceDatabaseId = recoverableDatabase.Id
});
}
}
/// <summary>
/// Returns information about a recoverable Azure SQL Database.
/// </summary>
/// <param name='serverName'>
/// Required. The name of the Azure SQL Database Server on which the
/// database was hosted.
/// </param>
/// <param name='databaseName'>
/// Required. The name of the recoverable Azure SQL Database to be
/// obtained.
/// </param>
/// <param name='cancellationToken'>
/// Cancellation token.
/// </param>
/// <returns>
/// Contains the response to the Get Recoverable Database request.
/// </returns>
public async System.Threading.Tasks.Task <Microsoft.WindowsAzure.Management.Sql.Models.RecoverableDatabaseGetResponse> GetAsync(string serverName, string databaseName, CancellationToken cancellationToken)
{
// Validate
if (serverName == null)
{
throw new ArgumentNullException("serverName");
}
if (databaseName == null)
{
throw new ArgumentNullException("databaseName");
}
// Tracing
bool shouldTrace = CloudContext.Configuration.Tracing.IsEnabled;
string invocationId = null;
if (shouldTrace)
{
invocationId = Tracing.NextInvocationId.ToString();
Dictionary <string, object> tracingParameters = new Dictionary <string, object>();
tracingParameters.Add("serverName", serverName);
tracingParameters.Add("databaseName", databaseName);
Tracing.Enter(invocationId, this, "GetAsync", tracingParameters);
}
// Construct URL
string url = "/" + (this.Client.Credentials.SubscriptionId != null ? this.Client.Credentials.SubscriptionId.Trim() : "") + "/services/sqlservers/servers/" + serverName.Trim() + "/recoverabledatabases/" + databaseName.Trim();
string baseUrl = this.Client.BaseUri.AbsoluteUri;
// Trim '/' character from the end of baseUrl and beginning of url.
if (baseUrl[baseUrl.Length - 1] == '/')
{
baseUrl = baseUrl.Substring(0, baseUrl.Length - 1);
}
if (url[0] == '/')
{
url = url.Substring(1);
}
url = baseUrl + "/" + url;
url = url.Replace(" ", "%20");
// Create HTTP transport objects
HttpRequestMessage httpRequest = null;
try
{
httpRequest = new HttpRequestMessage();
httpRequest.Method = HttpMethod.Get;
httpRequest.RequestUri = new Uri(url);
// Set Headers
httpRequest.Headers.Add("x-ms-version", "2012-03-01");
// Set Credentials
cancellationToken.ThrowIfCancellationRequested();
await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false);
// Send Request
HttpResponseMessage httpResponse = null;
try
{
if (shouldTrace)
{
Tracing.SendRequest(invocationId, httpRequest);
}
cancellationToken.ThrowIfCancellationRequested();
httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false);
if (shouldTrace)
{
Tracing.ReceiveResponse(invocationId, httpResponse);
}
HttpStatusCode statusCode = httpResponse.StatusCode;
if (statusCode != HttpStatusCode.OK)
{
cancellationToken.ThrowIfCancellationRequested();
CloudException ex = CloudException.Create(httpRequest, null, httpResponse, await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false));
if (shouldTrace)
{
Tracing.Error(invocationId, ex);
}
throw ex;
}
// Create Result
RecoverableDatabaseGetResponse result = null;
// Deserialize Response
cancellationToken.ThrowIfCancellationRequested();
string responseContent = await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false);
result = new RecoverableDatabaseGetResponse();
XDocument responseDoc = XDocument.Parse(responseContent);
XElement serviceResourceElement = responseDoc.Element(XName.Get("ServiceResource", "http://schemas.microsoft.com/windowsazure"));
if (serviceResourceElement != null)
{
RecoverableDatabase serviceResourceInstance = new RecoverableDatabase();
result.Database = serviceResourceInstance;
XElement entityIdElement = serviceResourceElement.Element(XName.Get("EntityId", "http://schemas.microsoft.com/windowsazure"));
if (entityIdElement != null)
{
string entityIdInstance = entityIdElement.Value;
serviceResourceInstance.EntityId = entityIdInstance;
}
XElement serverNameElement = serviceResourceElement.Element(XName.Get("ServerName", "http://schemas.microsoft.com/windowsazure"));
if (serverNameElement != null)
{
string serverNameInstance = serverNameElement.Value;
serviceResourceInstance.ServerName = serverNameInstance;
}
XElement editionElement = serviceResourceElement.Element(XName.Get("Edition", "http://schemas.microsoft.com/windowsazure"));
if (editionElement != null)
{
string editionInstance = editionElement.Value;
serviceResourceInstance.Edition = editionInstance;
}
XElement lastAvailableBackupDateElement = serviceResourceElement.Element(XName.Get("LastAvailableBackupDate", "http://schemas.microsoft.com/windowsazure"));
if (lastAvailableBackupDateElement != null)
{
DateTime lastAvailableBackupDateInstance = DateTime.Parse(lastAvailableBackupDateElement.Value, CultureInfo.InvariantCulture);
serviceResourceInstance.LastAvailableBackupDate = lastAvailableBackupDateInstance;
}
XElement nameElement = serviceResourceElement.Element(XName.Get("Name", "http://schemas.microsoft.com/windowsazure"));
if (nameElement != null)
{
string nameInstance = nameElement.Value;
serviceResourceInstance.Name = nameInstance;
}
XElement typeElement = serviceResourceElement.Element(XName.Get("Type", "http://schemas.microsoft.com/windowsazure"));
if (typeElement != null)
{
string typeInstance = typeElement.Value;
serviceResourceInstance.Type = typeInstance;
}
XElement stateElement = serviceResourceElement.Element(XName.Get("State", "http://schemas.microsoft.com/windowsazure"));
if (stateElement != null)
{
string stateInstance = stateElement.Value;
serviceResourceInstance.State = stateInstance;
}
}
result.StatusCode = statusCode;
if (httpResponse.Headers.Contains("x-ms-request-id"))
{
result.RequestId = httpResponse.Headers.GetValues("x-ms-request-id").FirstOrDefault();
}
if (shouldTrace)
{
Tracing.Exit(invocationId, result);
}
return(result);
}
finally
{
if (httpResponse != null)
{
httpResponse.Dispose();
}
}
}
finally
{
if (httpRequest != null)
{
httpRequest.Dispose();
}
}
}
public void AddToRecoverableDatabases(RecoverableDatabase recoverableDatabase)
{
base.AddObject("RecoverableDatabases", recoverableDatabase);
}
public static RecoverableDatabase CreateRecoverableDatabase(string entityId, global::System.DateTime lastAvailableBackupDate)
{
RecoverableDatabase recoverableDatabase = new RecoverableDatabase();
recoverableDatabase.EntityId = entityId;
recoverableDatabase.LastAvailableBackupDate = lastAvailableBackupDate;
return recoverableDatabase;
}
/// <summary>
/// Ensures any extra property on the given <paramref name="database"/> is loaded.
/// </summary>
/// <param name="database">The database that needs the extra properties.</param>
private void LoadExtraProperties(RecoverableDatabase database)
{
// Fill in the context property
database.Context = this;
}
/// <summary>
/// Given a set of restorable dropped database properties this will create and return a <see cref="RecoverableDatabase"/>
/// object with the fields filled in.
/// </summary>
/// <param name="entityId">The entity ID of the database.</param>
/// <param name="name">The name of the database.</param>
/// <param name="serverName">The name of the server that contained the database.</param>
/// <param name="edition">The edition of the database.</param>
/// <param name="lastAvailableBackupDate">The date of the last available backup of this database.</param>
/// <returns>A <see cref="RecoverableDatabase"/> object.</returns>
private RecoverableDatabase CreateRecoverableDatabaseFromResponse(
string entityId,
string name,
string serverName,
string edition,
DateTime lastAvailableBackupDate)
{
var result = new RecoverableDatabase()
{
EntityId = entityId,
Name = name,
ServerName = serverName,
Edition = edition,
LastAvailableBackupDate = lastAvailableBackupDate,
};
this.LoadExtraProperties(result);
return result;
}
