mirror of
https://github.com/hanzoai/azure-sdk-for-js.git
synced 2026-10-30 19:51:51 +00:00
Configurations: 'specification/sql/resource-manager/Microsoft.Sql/SQL/tspconfig.yaml', API Version: 2025-01-01, SDK Release Type: stable, and CommitSHA: '41784cfad64229e05cb37b1532a686a0cc3a60a9` in SpecRepo: 'https://github.com/Azure/azure-rest-api-specs' Pipeline run: https://dev.azure.com/azure-sdk/internal/_build/results?buildId=6276195 Refer to https://eng.ms/docs/products/azure-developer-experience/develop/sdk-release/sdk-release-prerequisites to prepare for SDK release. Release plan link: [https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu](https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu.westus-01.azurewebsites.net/?releasePlan=2227).[westus-01.azurewebsites.net/?releasePlan=2227](https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu.westus-01.azurewebsites.net/?releasePlan=2227) Submitted by: [[email protected]](mailto:[email protected]) ### Release Plan Details Release Plan: https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu.westus-01.azurewebsites.net/?releasePlan=2227 Spec pull request: [Azure/azure-rest-api-specs#41520](https://github.com/Azure/azure-rest-api-specs/pull/41520) Spec API version: --------- Co-authored-by: kazrael2119 <[email protected]>
185 lines
5.2 KiB
TypeScript
185 lines
5.2 KiB
TypeScript
/*
|
|
* Copyright (c) Microsoft Corporation.
|
|
* Licensed under the MIT License.
|
|
*
|
|
* Code generated by Microsoft (R) AutoRest Code Generator.
|
|
* Changes may cause incorrect behavior and will be lost if the code is regenerated.
|
|
*/
|
|
|
|
import type { RecorderStartOptions } from "@azure-tools/test-recorder";
|
|
import { env, Recorder, isPlaybackMode } from "@azure-tools/test-recorder";
|
|
import { createTestCredential } from "@azure-tools/test-credential";
|
|
import { SqlManagementClient } from "../src/sqlManagementClient.js";
|
|
import { describe, it, assert, beforeEach, afterEach } from "vitest";
|
|
|
|
const replaceableVariables: Record<string, string> = {
|
|
SUBSCRIPTION_ID: "azure_subscription_id",
|
|
};
|
|
|
|
const recorderOptions: RecorderStartOptions = {
|
|
envSetupForPlayback: replaceableVariables,
|
|
removeCentralSanitizers: [
|
|
"AZSDK3493", // .name in the body is not a secret and is listed below in the beforeEach section
|
|
"AZSDK3430", // .id in the body is not a secret and is listed below in the beforeEach section
|
|
],
|
|
};
|
|
|
|
export const testPollingOptions = {
|
|
updateIntervalInMs: isPlaybackMode() ? 0 : undefined,
|
|
};
|
|
|
|
describe.skip("Sql test", () => {
|
|
let recorder: Recorder;
|
|
let subscriptionId: string;
|
|
let client: SqlManagementClient;
|
|
let location: string;
|
|
let resourceGroup: string;
|
|
let serverName: string;
|
|
let databaseName: string;
|
|
|
|
beforeEach(async (ctx) => {
|
|
recorder = new Recorder(ctx);
|
|
await recorder.start(recorderOptions);
|
|
subscriptionId = env.SUBSCRIPTION_ID || "";
|
|
// This is an example of how the environment variables are used
|
|
const credential = createTestCredential();
|
|
client = new SqlManagementClient(
|
|
credential,
|
|
subscriptionId,
|
|
recorder.configureClientOptions({}),
|
|
);
|
|
location = "eastus2";
|
|
resourceGroup = "SSS3PT_myjstest";
|
|
databaseName = "mydatabasezzzz";
|
|
serverName = "myserverppp";
|
|
});
|
|
|
|
afterEach(async () => {
|
|
await recorder.stop();
|
|
});
|
|
|
|
it("servers create test", async () => {
|
|
const res = await client.servers.beginCreateOrUpdateAndWait(
|
|
resourceGroup,
|
|
serverName,
|
|
{
|
|
location,
|
|
administratorLogin: "dummylogin",
|
|
administratorLoginPassword: "Placeholder123",
|
|
version: "12.0",
|
|
},
|
|
testPollingOptions,
|
|
);
|
|
assert.equal(res.name, serverName);
|
|
});
|
|
|
|
it("databases create test", async () => {
|
|
const res = await client.databases.beginCreateOrUpdateAndWait(
|
|
resourceGroup,
|
|
serverName,
|
|
databaseName,
|
|
{
|
|
location,
|
|
readScale: "Disabled",
|
|
},
|
|
testPollingOptions,
|
|
);
|
|
assert.equal(res.name, databaseName);
|
|
});
|
|
|
|
it("databaseSecurityAlertPolicies create test", async () => {
|
|
const res = await client.databaseSecurityAlertPolicies.createOrUpdate(
|
|
resourceGroup,
|
|
serverName,
|
|
databaseName,
|
|
"Default",
|
|
{
|
|
disabledAlerts: ["Sql_Injection", "Access_Anomaly"],
|
|
state: "Enabled",
|
|
},
|
|
);
|
|
assert.equal(res.name, "Default");
|
|
});
|
|
|
|
it("servers get test", async () => {
|
|
const res = await client.servers.get(resourceGroup, serverName);
|
|
assert.equal(res.name, serverName);
|
|
});
|
|
|
|
it("databases get test", async () => {
|
|
const res = await client.databases.get(resourceGroup, serverName, databaseName);
|
|
assert.equal(res.name, databaseName);
|
|
});
|
|
|
|
it("servers list test", async () => {
|
|
const resArray = new Array();
|
|
for await (const item of client.servers.listByResourceGroup(resourceGroup)) {
|
|
resArray.push(item);
|
|
}
|
|
assert.equal(resArray.length, 1);
|
|
});
|
|
|
|
it("databases list test", async () => {
|
|
const resArray = new Array();
|
|
for await (const item of client.databases.listByServer(resourceGroup, serverName)) {
|
|
resArray.push(item);
|
|
}
|
|
assert.equal(resArray.length, 2);
|
|
});
|
|
|
|
it("servers update test", async () => {
|
|
const res = await client.servers.beginUpdateAndWait(
|
|
resourceGroup,
|
|
serverName,
|
|
{
|
|
tags: {
|
|
tag1: "value1",
|
|
},
|
|
},
|
|
testPollingOptions,
|
|
);
|
|
assert.equal(res.type, "Microsoft.Sql/servers");
|
|
});
|
|
|
|
it("databases update test", async () => {
|
|
const res = await client.databases.beginUpdateAndWait(
|
|
resourceGroup,
|
|
serverName,
|
|
databaseName,
|
|
{
|
|
sku: {
|
|
name: "S1",
|
|
tier: "Standard",
|
|
},
|
|
collation: "SQL_Latin1_General_CP1_CI_AS",
|
|
maxLogSizeBytes: 1073741824,
|
|
},
|
|
testPollingOptions,
|
|
);
|
|
assert.equal(res.type, "Microsoft.Sql/servers/databases");
|
|
});
|
|
|
|
it("databases delete test", async () => {
|
|
const resArray = new Array();
|
|
await client.databases.beginDeleteAndWait(
|
|
resourceGroup,
|
|
serverName,
|
|
databaseName,
|
|
testPollingOptions,
|
|
);
|
|
for await (const item of client.databases.listByServer(resourceGroup, serverName)) {
|
|
resArray.push(item);
|
|
}
|
|
assert.equal(resArray.length, 1);
|
|
});
|
|
|
|
it("servers delete test", async () => {
|
|
const resArray = new Array();
|
|
await client.servers.beginDeleteAndWait(resourceGroup, serverName, testPollingOptions);
|
|
for await (const item of client.servers.listByResourceGroup(resourceGroup)) {
|
|
resArray.push(item);
|
|
}
|
|
assert.equal(resArray.length, 0);
|
|
});
|
|
});
|