public void AzureSqlDatabaseServerV2Tests()
{
// This test uses the https endpoint, setup the certificates.
MockHttpServer.SetupCertificates();
using (System.Management.Automation.PowerShell powershell = System.Management.Automation.PowerShell.Create())
{
// Setup the subscription used for the test
AzureSubscription subscription =
UnitTestHelper.SetupUnitTestSubscription(powershell);
// Create a new V2 server
HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession(
"UnitTest.AzureSqlDatabaseServerV2Tests");
ServerTestHelper.SetDefaultTestSessionSettings(testSession);
testSession.RequestValidator =
new Action <HttpMessage, HttpMessage.Request>(
(expected, actual) =>
{
Assert.AreEqual(expected.RequestInfo.Method, actual.Method);
Assert.IsTrue(
actual.UserAgent.Contains(ApiConstants.UserAgentHeaderValue),
"Missing proper UserAgent string.");
});
powershell.Runspace.SessionStateProxy.SetVariable("login", "mylogin");
powershell.Runspace.SessionStateProxy.SetVariable("password", "Pa$$w0rd!");
powershell.Runspace.SessionStateProxy.SetVariable("location", "East Asia");
Collection <PSObject> newServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
return(powershell.InvokeBatchScript(
@"New-AzureSqlDatabaseServer" +
@" -AdministratorLogin $login" +
@" -AdministratorLoginPassword $password" +
@" -Location $location" +
@" -Version 2"));
});
Collection <PSObject> getServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer $server.ServerName"));
});
Collection <PSObject> removeServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
powershell.InvokeBatchScript(
@"$server | Remove-AzureSqlDatabaseServer" +
@" -Force");
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer"));
});
Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!");
Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!");
// Validate New-AzureSqlDatabaseServer results
SqlDatabaseServerContext server =
newServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion2,
"Ready");
// Validate Get-AzureSqlDatabaseServer results
server = getServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion2,
"Ready");
powershell.Streams.ClearStreams();
}
}
public void AzureSqlDatabaseServerTests()
{
// This test uses the https endpoint, setup the certificates.
MockHttpServer.SetupCertificates();
SqlTestPsHost host = new SqlTestPsHost();
SqlCustomPsHostUserInterface ui = host.UI as SqlCustomPsHostUserInterface;
using (Runspace space = RunspaceFactory.CreateRunspace(host))
{
space.Open();
using (System.Management.Automation.PowerShell powershell = System.Management.Automation.PowerShell.Create())
{
powershell.Runspace = space;
// Setup the subscription used for the test
AzureSubscription subscription =
UnitTestHelper.SetupUnitTestSubscription(powershell);
// Create a new server
HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession(
"UnitTest.AzureSqlDatabaseServerTests");
ServerTestHelper.SetDefaultTestSessionSettings(testSession);
testSession.RequestValidator =
new Action <HttpMessage, HttpMessage.Request>(
(expected, actual) =>
{
Assert.AreEqual(expected.RequestInfo.Method, actual.Method);
Assert.IsTrue(
actual.UserAgent.Contains(ApiConstants.UserAgentHeaderValue),
"Missing proper UserAgent string.");
});
powershell.Runspace.SessionStateProxy.SetVariable("login", "mylogin");
powershell.Runspace.SessionStateProxy.SetVariable("password", "Pa$$w0rd!");
powershell.Runspace.SessionStateProxy.SetVariable("location", "East Asia");
Collection <PSObject> newServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
return(powershell.InvokeBatchScript(
@"New-AzureSqlDatabaseServer" +
@" -AdministratorLogin $login" +
@" -AdministratorLoginPassword $password" +
@" -Location $location"));
});
ui.PromptInputs = new PSObject[] { "mylogin", "Pa$$w0rd", "East Asia" };
Collection <PSObject> newServerResult2 = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
return(powershell.InvokeBatchScript(@"New-AzureSqlDatabaseServer"));
});
ui.PromptInputs = null;
Collection <PSObject> getServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer $server.ServerName"));
});
Collection <PSObject> setServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
powershell.Runspace.SessionStateProxy.SetVariable("password", "Pa$$w0rd2");
powershell.InvokeBatchScript(
@"$server | Set-AzureSqlDatabaseServer" +
@" -AdminPassword $password" +
@" -Force");
return(powershell.InvokeBatchScript(
@"$server | Get-AzureSqlDatabaseServer"));
});
ui.PromptInputs = new PSObject[] { "Pa$$w0rd2" };
Collection <PSObject> setServerResult2 = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult2);
powershell.InvokeBatchScript(@"$server | Set-AzureSqlDatabaseServer");
return(powershell.InvokeBatchScript(@"$server | Get-AzureSqlDatabaseServer"));
});
ui.PromptInputs = null;
Collection <PSObject> removeServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
powershell.InvokeBatchScript(
@"$server | Remove-AzureSqlDatabaseServer" +
@" -Force");
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer"));
});
ui.PromptInputs = new PSObject[] { ((SqlDatabaseServerContext)newServerResult2[0].BaseObject).ServerName };
ui.PromptForChoiceInputIndex = 0; //answer yes to delete database prompt
Collection <PSObject> removeServerResult2 = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.InvokeBatchScript(@"Remove-AzureSqlDatabaseServer");
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer"));
});
ui.PromptForChoiceInputIndex = -1;
ui.PromptInputs = null;
Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!");
Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!");
// Validate New-AzureSqlDatabaseServer results
SqlDatabaseServerContext server =
newServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion12,
"Ready");
SqlDatabaseServerContext server2 = newServerResult2.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server2, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion12,
"Ready");
// Validate Get-AzureSqlDatabaseServer results
server = getServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion12,
"Ready");
server = setServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion12,
"Ready");
server2 = setServerResult2.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
VerifyServer(
server2,
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
ServerVersion12,
"Ready");
// Validate Remove-AzureSqlDatabaseServer results
Assert.IsFalse(
removeServerResult.Any((o) => o.GetVariableValue <string>("ServerName") == server.ServerName),
"Server should have been removed.");
Assert.IsFalse(
removeServerResult2.Any((o) => o.GetVariableValue <string>("ServerName") == server2.ServerName),
"Server 2 should have been removed.");
powershell.Streams.ClearStreams();
}
space.Close();
}
}
public void AzureSqlDatabaseServerTests()
{
// This test uses the https endpoint, setup the certificates.
MockHttpServer.SetupCertificates();
using (PowerShell powershell = PowerShell.Create())
{
// Setup the subscription used for the test
WindowsAzureSubscription subscription =
UnitTestHelper.SetupUnitTestSubscription(powershell);
// Create a new server
HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession(
"UnitTest.AzureSqlDatabaseServerTests");
ServerTestHelper.SetDefaultTestSessionSettings(testSession);
testSession.RequestValidator =
new Action <HttpMessage, HttpMessage.Request>(
(expected, actual) =>
{
Assert.AreEqual(expected.RequestInfo.Method, actual.Method);
Assert.IsTrue(
actual.UserAgent.Contains(ApiConstants.UserAgentHeaderValue),
"Missing proper UserAgent string.");
Assert.IsTrue(
UnitTestHelper.GetUnitTestClientCertificate().Equals(actual.Certificate),
"Expected correct client certificate");
});
powershell.Runspace.SessionStateProxy.SetVariable("login", "mylogin");
powershell.Runspace.SessionStateProxy.SetVariable("password", "Pa$$w0rd!");
powershell.Runspace.SessionStateProxy.SetVariable("location", "East Asia");
Collection <PSObject> newServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
return(powershell.InvokeBatchScript(
@"New-AzureSqlDatabaseServer" +
@" -AdministratorLogin $login" +
@" -AdministratorLoginPassword $password" +
@" -Location $location"));
});
Collection <PSObject> getServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer $server.ServerName"));
});
Collection <PSObject> setServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
powershell.Runspace.SessionStateProxy.SetVariable("password", "Pa$$w0rd2");
powershell.InvokeBatchScript(
@"$server | Set-AzureSqlDatabaseServer" +
@" -AdminPassword $password" +
@" -Force");
return(powershell.InvokeBatchScript(
@"$server | Get-AzureSqlDatabaseServer"));
});
Collection <PSObject> removeServerResult = MockServerHelper.ExecuteWithMock(
testSession,
MockHttpServer.DefaultHttpsServerPrefixUri,
() =>
{
powershell.Runspace.SessionStateProxy.SetVariable("server", newServerResult);
powershell.InvokeBatchScript(
@"$server | Remove-AzureSqlDatabaseServer" +
@" -Force");
return(powershell.InvokeBatchScript(
@"Get-AzureSqlDatabaseServer"));
});
Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!");
Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!");
// Validate New-AzureSqlDatabaseServer results
SqlDatabaseServerContext server =
newServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
Assert.AreEqual(
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
server.AdministratorLogin,
ignoreCase: true,
message: "Expecting matching login.");
Assert.AreEqual(
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
server.Location,
ignoreCase: true,
message: "Expecting matching location.");
Assert.AreEqual(10, server.ServerName.Length, "Expecting a valid server name.");
// Validate Get-AzureSqlDatabaseServer results
server = getServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
Assert.AreEqual(
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
server.AdministratorLogin,
ignoreCase: true,
message: "Expecting matching login.");
Assert.AreEqual(
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
server.Location,
ignoreCase: true,
message: "Expecting matching location.");
Assert.AreEqual(10, server.ServerName.Length, "Expecting a valid server name.");
server = setServerResult.Single().BaseObject as SqlDatabaseServerContext;
Assert.IsNotNull(server, "Expecting a SqlDatabaseServerContext object");
Assert.AreEqual(
(string)powershell.Runspace.SessionStateProxy.GetVariable("login"),
server.AdministratorLogin,
ignoreCase: true,
message: "Expecting matching login.");
Assert.AreEqual(
(string)powershell.Runspace.SessionStateProxy.GetVariable("location"),
server.Location,
ignoreCase: true,
message: "Expecting matching location.");
Assert.AreEqual(10, server.ServerName.Length, "Expecting a valid server name.");
// Validate Remove-AzureSqlDatabaseServer results
Assert.IsFalse(
removeServerResult.Any((o) => o.GetVariableValue <string>("ServerName") == server.ServerName),
"Server should have been removed.");
powershell.Streams.ClearStreams();
}
}
