/// <summary> /// Get the data masking policy for a specific database /// </summary> public DataMaskingPolicy GetDatabaseDataMaskingPolicy(string resourceGroupName, string serverName, string databaseName, string clientRequestId) { IDataMaskingOperations operations = GetCurrentSqlClient(clientRequestId).DataMasking; DataMaskingPolicyGetResponse response = operations.GetPolicy(resourceGroupName, serverName, databaseName); return(response.DataMaskingPolicy); }
/// <summary> /// The non-boilerplated test code of the APIs for managing the lifecycle of a given database's data masking policy. It is meant to be called with a name of an already exisiting database (and therefore already existing /// server and resource group). This test does not create these resources and does not remove them. /// </summary> private void TestDataMaskingPolicyAPIs(SqlManagementClient sqlClient, string resourceGroupName, Server server, Database database) { DataMaskingPolicyGetResponse getDefaultPolicyResponse = sqlClient.DataMasking.GetPolicy(resourceGroupName, server.Name, database.Name); DataMaskingPolicyProperties properties = getDefaultPolicyResponse.DataMaskingPolicy.Properties; // Verify that the initial Get request contains the default policy. TestUtilities.ValidateOperationResponse(getDefaultPolicyResponse, HttpStatusCode.OK); VerifyDataMaskingPolicyInformation(MakeDefaultDataMaskingPolicyProperties(), properties); // Modify the policy properties, send and receive, see it its still ok properties.DataMaskingState = "Enabled"; properties.ExemptPrincipals = "principal1;principal2"; DataMaskingPolicyCreateOrUpdateParameters updateParams = new DataMaskingPolicyCreateOrUpdateParameters(); updateParams.Properties = properties; var updateResponse = sqlClient.DataMasking.CreateOrUpdatePolicy(resourceGroupName, server.Name, database.Name, updateParams); // Verify that the initial Get request of contains the default policy. TestUtilities.ValidateOperationResponse(updateResponse, HttpStatusCode.OK); DataMaskingPolicyGetResponse getUpdatedPolicyResponse = sqlClient.DataMasking.GetPolicy(resourceGroupName, server.Name, database.Name); DataMaskingPolicyProperties updatedProperties = getUpdatedPolicyResponse.DataMaskingPolicy.Properties; // Verify that the Get request contains the updated policy. TestUtilities.ValidateOperationResponse(getUpdatedPolicyResponse, HttpStatusCode.OK); VerifyDataMaskingPolicyInformation(properties, updatedProperties); }