/// <summary> /// The non-boilerplated test code of the APIs for managing the lifecycle of a given database's secure connection policy. /// It is meant to be called with a name of an already exisiting database (and therefore already existing server and resource group). /// </summary> private void TestSecureConnectionAPIs(SqlManagementClient sqlClient, string resourceGroupName, Server server, Database database) { DatabaseSecureConnectionPolicyGetResponse getDefaultSecureConnectionPolicyResponse = sqlClient.SecureConnection.GetDatabasePolicy(resourceGroupName, server.Name, database.Name); DatabaseSecureConnectionPolicyProperties properties = getDefaultSecureConnectionPolicyResponse.SecureConnectionPolicy.Properties; // Verify that the initial Get request contains the default policy. TestUtilities.ValidateOperationResponse(getDefaultSecureConnectionPolicyResponse, HttpStatusCode.OK); VerifySecureConnectionPolicyInformation(getDefaultSecureConnectionPolicyProperties(server.Name), properties); // Modify the policy properties, send and receive, see it its still ok properties.SecurityEnabledAccess = "Required"; DatabaseSecureConnectionPolicyCreateOrUpdateParameters updateParams = new DatabaseSecureConnectionPolicyCreateOrUpdateParameters(); updateParams.Properties = ConvertToSecureConnectionPolicyCreateProperties(properties); var updateResponse = sqlClient.SecureConnection.CreateOrUpdateDatabasePolicy(resourceGroupName, server.Name, database.Name, updateParams); // Verify that the initial Get request of contains the default policy. TestUtilities.ValidateOperationResponse(updateResponse, HttpStatusCode.OK); DatabaseSecureConnectionPolicyGetResponse getUpdatedPolicyResponse = sqlClient.SecureConnection.GetDatabasePolicy(resourceGroupName, server.Name, database.Name); DatabaseSecureConnectionPolicyProperties updatedProperties = getUpdatedPolicyResponse.SecureConnectionPolicy.Properties; // Verify that the Get request contains the updated policy. TestUtilities.ValidateOperationResponse(getUpdatedPolicyResponse, HttpStatusCode.OK); VerifySecureConnectionPolicyInformation(properties, updatedProperties); }
/// <summary> /// Creates and returns a DatabaseAuditingPolicyProperties object that holds the default settings for a a database auditing policy /// </summary> /// <returns>A DatabaseAuditingPolicyProperties object with the default audit policy settings</returns> private DatabaseSecureConnectionPolicyProperties getDefaultSecureConnectionPolicyProperties(string serverName) { DatabaseSecureConnectionPolicyProperties props = new DatabaseSecureConnectionPolicyProperties(); props.SecurityEnabledAccess = "Optional"; props.ProxyPort = "1433"; props.ProxyDnsName = serverName + ".database.secure.windows.net"; return(props); }
/// <summary> /// Transforms a secure connection policy object to its cmdlet model representation /// </summary> private DatabaseSecureConnectionPolicyModel ModelizeDatabaseSecureConnectionPolicy(DatabaseSecureConnectionPolicy policy) { DatabaseSecureConnectionPolicyModel dbPolicyModel = new DatabaseSecureConnectionPolicyModel(); DatabaseSecureConnectionPolicyProperties properties = policy.Properties; dbPolicyModel.ProxyDnsName = properties.ProxyDnsName; dbPolicyModel.ProxyPort = properties.ProxyPort; dbPolicyModel.SecureConnectionState = properties.SecurityEnabledAccess == SecurityConstants.SecureConnectionEndpoint.Required ? SecureConnectionStateType.Required : SecureConnectionStateType.Optional; return(dbPolicyModel); }
/// <summary> /// Returns an Azure SQL Database secure connection policy. /// </summary> /// <param name='resourceGroupName'> /// Required. The name of the Resource Group to which the server /// belongs. /// </param> /// <param name='serverName'> /// Required. The name of the Azure SQL Database Server on which the /// database is hosted. /// </param> /// <param name='databaseName'> /// Required. The name of the Azure SQL Database for which the secure /// connection policy applies. /// </param> /// <param name='cancellationToken'> /// Cancellation token. /// </param> /// <returns> /// Represents the response to a Get database secure connection request. /// </returns> public async Task <DatabaseSecureConnectionPolicyGetResponse> GetDatabasePolicyAsync(string resourceGroupName, string serverName, string databaseName, CancellationToken cancellationToken) { // Validate if (resourceGroupName == null) { throw new ArgumentNullException("resourceGroupName"); } if (serverName == null) { throw new ArgumentNullException("serverName"); } if (databaseName == null) { throw new ArgumentNullException("databaseName"); } // Tracing bool shouldTrace = TracingAdapter.IsEnabled; string invocationId = null; if (shouldTrace) { invocationId = TracingAdapter.NextInvocationId.ToString(); Dictionary <string, object> tracingParameters = new Dictionary <string, object>(); tracingParameters.Add("resourceGroupName", resourceGroupName); tracingParameters.Add("serverName", serverName); tracingParameters.Add("databaseName", databaseName); TracingAdapter.Enter(invocationId, this, "GetDatabasePolicyAsync", tracingParameters); } // Construct URL string url = ""; url = url + "/subscriptions/"; if (this.Client.Credentials.SubscriptionId != null) { url = url + Uri.EscapeDataString(this.Client.Credentials.SubscriptionId); } url = url + "/resourceGroups/"; url = url + Uri.EscapeDataString(resourceGroupName); url = url + "/providers/"; url = url + "Microsoft.Sql"; url = url + "/servers/"; url = url + Uri.EscapeDataString(serverName); url = url + "/databases/"; url = url + Uri.EscapeDataString(databaseName); url = url + "/connectionPolicies/Default"; List <string> queryParameters = new List <string>(); queryParameters.Add("api-version=2014-04-01"); if (queryParameters.Count > 0) { url = url + "?" + string.Join("&", queryParameters); } 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 // Set Credentials cancellationToken.ThrowIfCancellationRequested(); await this.Client.Credentials.ProcessHttpRequestAsync(httpRequest, cancellationToken).ConfigureAwait(false); // Send Request HttpResponseMessage httpResponse = null; try { if (shouldTrace) { TracingAdapter.SendRequest(invocationId, httpRequest); } cancellationToken.ThrowIfCancellationRequested(); httpResponse = await this.Client.HttpClient.SendAsync(httpRequest, cancellationToken).ConfigureAwait(false); if (shouldTrace) { TracingAdapter.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) { TracingAdapter.Error(invocationId, ex); } throw ex; } // Create Result DatabaseSecureConnectionPolicyGetResponse result = null; // Deserialize Response if (statusCode == HttpStatusCode.OK) { cancellationToken.ThrowIfCancellationRequested(); string responseContent = await httpResponse.Content.ReadAsStringAsync().ConfigureAwait(false); result = new DatabaseSecureConnectionPolicyGetResponse(); JToken responseDoc = null; if (string.IsNullOrEmpty(responseContent) == false) { responseDoc = JToken.Parse(responseContent); } if (responseDoc != null && responseDoc.Type != JTokenType.Null) { DatabaseSecureConnectionPolicy secureConnectionPolicyInstance = new DatabaseSecureConnectionPolicy(); result.SecureConnectionPolicy = secureConnectionPolicyInstance; JToken propertiesValue = responseDoc["properties"]; if (propertiesValue != null && propertiesValue.Type != JTokenType.Null) { DatabaseSecureConnectionPolicyProperties propertiesInstance = new DatabaseSecureConnectionPolicyProperties(); secureConnectionPolicyInstance.Properties = propertiesInstance; JToken proxyDnsNameValue = propertiesValue["proxyDnsName"]; if (proxyDnsNameValue != null && proxyDnsNameValue.Type != JTokenType.Null) { string proxyDnsNameInstance = ((string)proxyDnsNameValue); propertiesInstance.ProxyDnsName = proxyDnsNameInstance; } JToken proxyPortValue = propertiesValue["proxyPort"]; if (proxyPortValue != null && proxyPortValue.Type != JTokenType.Null) { string proxyPortInstance = ((string)proxyPortValue); propertiesInstance.ProxyPort = proxyPortInstance; } JToken securityEnabledAccessValue = propertiesValue["securityEnabledAccess"]; if (securityEnabledAccessValue != null && securityEnabledAccessValue.Type != JTokenType.Null) { string securityEnabledAccessInstance = ((string)securityEnabledAccessValue); propertiesInstance.SecurityEnabledAccess = securityEnabledAccessInstance; } } JToken idValue = responseDoc["id"]; if (idValue != null && idValue.Type != JTokenType.Null) { string idInstance = ((string)idValue); secureConnectionPolicyInstance.Id = idInstance; } JToken nameValue = responseDoc["name"]; if (nameValue != null && nameValue.Type != JTokenType.Null) { string nameInstance = ((string)nameValue); secureConnectionPolicyInstance.Name = nameInstance; } JToken typeValue = responseDoc["type"]; if (typeValue != null && typeValue.Type != JTokenType.Null) { string typeInstance = ((string)typeValue); secureConnectionPolicyInstance.Type = typeInstance; } JToken locationValue = responseDoc["location"]; if (locationValue != null && locationValue.Type != JTokenType.Null) { string locationInstance = ((string)locationValue); secureConnectionPolicyInstance.Location = locationInstance; } JToken tagsSequenceElement = ((JToken)responseDoc["tags"]); if (tagsSequenceElement != null && tagsSequenceElement.Type != JTokenType.Null) { foreach (JProperty property in tagsSequenceElement) { string tagsKey = ((string)property.Name); string tagsValue = ((string)property.Value); secureConnectionPolicyInstance.Tags.Add(tagsKey, tagsValue); } } } } result.StatusCode = statusCode; if (httpResponse.Headers.Contains("x-ms-request-id")) { result.RequestId = httpResponse.Headers.GetValues("x-ms-request-id").FirstOrDefault(); } if (shouldTrace) { TracingAdapter.Exit(invocationId, result); } return(result); } finally { if (httpResponse != null) { httpResponse.Dispose(); } } } finally { if (httpRequest != null) { httpRequest.Dispose(); } } }
/// <summary> /// Verify that the received properties match their expected values /// </summary> /// <param name="actual">The properties object that needs to be checked</param> /// <param name="expected">The expected value of the properties object</param> private static void VerifySecureConnectionPolicyInformation(DatabaseSecureConnectionPolicyProperties actual, DatabaseSecureConnectionPolicyProperties expected) { Assert.Equal(expected.SecurityEnabledAccess, actual.SecurityEnabledAccess); Assert.Equal(expected.ProxyDnsName, actual.ProxyDnsName); Assert.Equal(expected.ProxyPort, actual.ProxyPort); }
/// <summary> /// Converts the given SecureConnectionPolicyProperties to a SecureConnectionPolicyCreateOrUpdateProperties that has the same values for the properties /// </summary> /// <param name="properties">The properties to be used for creating the returned value</param> /// <returns>A SecureConnectionPolicyCreateOrUpdateProperties which reflected the given properties</returns> private DatabaseSecureConnectionPolicyCreateOrUpdateProperties ConvertToSecureConnectionPolicyCreateProperties(DatabaseSecureConnectionPolicyProperties properties) { DatabaseSecureConnectionPolicyCreateOrUpdateProperties createProps = new DatabaseSecureConnectionPolicyCreateOrUpdateProperties(); createProps.SecurityEnabledAccess = properties.SecurityEnabledAccess; return(createProps); }