Files
azure-sdk-for-js/sdk/sql/arm-sql/samples/v11/javascript/dataMaskingRulesCreateOrUpdateSample.js

117 lines
3.7 KiB
JavaScript

// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");
/**
* This sample demonstrates how to creates or updates a database data masking rule.
*
* @summary creates or updates a database data masking rule.
* x-ms-original-file: 2025-01-01/DataMaskingRuleCreateOrUpdateDefaultMax.json
*/
async function createOrUpdateDataMaskingRuleForDefaultMax() {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.dataMaskingRules.createOrUpdate(
"sqlcrudtest-6852",
"sqlcrudtest-2080",
"sqlcrudtest-331",
"rule1",
{
aliasName: "nickname",
columnName: "test1",
maskingFunction: "Default",
ruleState: "Enabled",
schemaName: "dbo",
tableName: "Table_1",
},
);
console.log(result);
}
/**
* This sample demonstrates how to creates or updates a database data masking rule.
*
* @summary creates or updates a database data masking rule.
* x-ms-original-file: 2025-01-01/DataMaskingRuleCreateOrUpdateDefaultMin.json
*/
async function createOrUpdateDataMaskingRuleForDefaultMin() {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.dataMaskingRules.createOrUpdate(
"sqlcrudtest-6852",
"sqlcrudtest-2080",
"sqlcrudtest-331",
"rule1",
{ columnName: "test1", maskingFunction: "Default", schemaName: "dbo", tableName: "Table_1" },
);
console.log(result);
}
/**
* This sample demonstrates how to creates or updates a database data masking rule.
*
* @summary creates or updates a database data masking rule.
* x-ms-original-file: 2025-01-01/DataMaskingRuleCreateOrUpdateNumber.json
*/
async function createOrUpdateDataMaskingRuleForNumbers() {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.dataMaskingRules.createOrUpdate(
"sqlcrudtest-6852",
"sqlcrudtest-2080",
"sqlcrudtest-331",
"rule1",
{
columnName: "test1",
maskingFunction: "Number",
numberFrom: "0",
numberTo: "2",
schemaName: "dbo",
tableName: "Table_1",
},
);
console.log(result);
}
/**
* This sample demonstrates how to creates or updates a database data masking rule.
*
* @summary creates or updates a database data masking rule.
* x-ms-original-file: 2025-01-01/DataMaskingRuleCreateOrUpdateText.json
*/
async function createOrUpdateDataMaskingRuleForText() {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.dataMaskingRules.createOrUpdate(
"sqlcrudtest-6852",
"sqlcrudtest-2080",
"sqlcrudtest-331",
"rule1",
{
columnName: "test1",
maskingFunction: "Text",
prefixSize: "1",
replacementString: "asdf",
schemaName: "dbo",
suffixSize: "0",
tableName: "Table_1",
},
);
console.log(result);
}
async function main() {
await createOrUpdateDataMaskingRuleForDefaultMax();
await createOrUpdateDataMaskingRuleForDefaultMin();
await createOrUpdateDataMaskingRuleForNumbers();
await createOrUpdateDataMaskingRuleForText();
}
main().catch(console.error);