public void Session_GetWithoutcredentials_Fails() { var session = new HttpSession(); Assert.That(() => session.Get(BasicAuthUrl), Throws.TypeOf<WebException>().With.Message.StringContaining("401")); }
static object GetJavaSessionLock (HttpSession javaSession) { lock (SessionLock) { object sessionLock = javaSession.getAttribute (SessionLock); if (sessionLock == null) { sessionLock = String.Copy (SessionLock); javaSession.setAttribute (SessionLock, sessionLock); } return sessionLock; } }
public virtual void updateSessionVisitor(HttpSession session, Visitor visitor) { if (visitor != null) { // 更新 session.setAttribute(UserConstant.USER_KEY, visitor); } else { // 删除 session.removeAttribute(UserConstant.USER_KEY); } ThreadContext.putSessionVisitor(visitor); }
public bool IsAuthenticated(HttpSession session) { bool isAuthenticated = this.context.Sessions.Any(s => s.SessionId == session.Id && s.IsActive); return(isAuthenticated); }
async Task HandleSession(HttpSession session) { var closeSessionOnReturn = true; try { var continueRequestLoop = true; while (continueRequestLoop && !session.IsDisconnected()) // request loop { try { TrackSessionRead(session.Id); if (await session.ReadToBufferAsync().ConfigureAwait(false) == 0) // 0 => client clean disconnect { break; } } finally { UntrackSessionRead(session.Id); } int responseBytesWritten; while (continueRequestLoop && session.TryParseNextRequestFromBuffer(out int requestBytesParsed, out HttpRequest request)) { Router.HandleResult result = await router.HandleRequest(request, DateTime.UtcNow).ConfigureAwait(false); HttpResponse response = result.HttpResponse; if (response is WebSocketUpgradeResponse) { continueRequestLoop = false; if (response is WebSocketUpgradeResponse.AcceptUpgradeResponse acceptUpgrade) { responseBytesWritten = await AcceptWebSocketUpgrade(session, result.MatchedRouteTableIndex, result.MatchedEndpointIndex, acceptUpgrade).ConfigureAwait(false); closeSessionOnReturn = false; } else { var rejectUpgrade = (WebSocketUpgradeResponse.RejectUpgradeResponse)response; responseBytesWritten = await rejectUpgrade.WriteToAsync(session.Stream, 0, sessionReadTimeout).ConfigureAwait(false); } } else { responseBytesWritten = await response.WriteToAsync(session.Stream, request.IsKeepAlive?session.KeepAlivesRemaining : 0, sessionReadTimeout).ConfigureAwait(false); continueRequestLoop = request.IsKeepAlive && session.KeepAlivesRemaining > 0; } if (result.MatchedRouteTableIndex >= 0 && result.MatchedEndpointIndex >= 0) { router.Metrics.CountBytes(result.MatchedRouteTableIndex, result.MatchedEndpointIndex, requestBytesParsed, responseBytesWritten); } } } } catch (RequestException e) { sessionExceptionCounters.Count(e.GetType()); logger.Warn("Error parsing or bad request - {0}", e.Message); } catch (SessionStreamException e) { sessionExceptionCounters.Count(e.GetType()); } catch (Exception e) { sessionExceptionCounters.Count(e.GetType()); logger.Fatal("Error handling session - {0}", e.ToString()); } finally { UntrackSession(session.Id); if (closeSessionOnReturn) { session.CloseQuiety(); } } }
public void Logout(HttpSession session, HttpResponse response) { this.securityService.HasLogout(session); this.Redirect(response, "/home/index"); }
public void GetAzureSqlDatabaseServerQuotaSqlAuthTest() { using (System.Management.Automation.PowerShell powershell = System.Management.Automation.PowerShell.Create()) { // Create a context NewAzureSqlDatabaseServerContextTests.CreateServerContextSqlAuth( powershell, "$context"); // Issue another create testdb1, causing a failure HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.GetAzureSqlDatabaseServerQuotaSqlAuthTest"); DatabaseTestHelper.SetDefaultTestSessionSettings(testSession); testSession.RequestValidator = new Action <HttpMessage, HttpMessage.Request>( (expected, actual) => { Assert.AreEqual(expected.RequestInfo.Method, actual.Method); Assert.AreEqual(expected.RequestInfo.UserAgent, actual.UserAgent); switch (expected.Index) { // Request 0-1: Create testdb1 case 0: case 1: DatabaseTestHelper.ValidateHeadersForODataRequest( expected.RequestInfo, actual); break; default: Assert.Fail("No more requests expected."); break; } }); using (AsyncExceptionManager exceptionManager = new AsyncExceptionManager()) { Services.Server.ServerDataServiceSqlAuth context; using (new MockHttpServer( exceptionManager, MockHttpServer.DefaultServerPrefixUri, testSession)) { Collection <PSObject> ctxPsObject = powershell.InvokeBatchScript("$context"); context = (Services.Server.ServerDataServiceSqlAuth)ctxPsObject.First().BaseObject; Collection <PSObject> q1, q2; q1 = powershell.InvokeBatchScript( @"$context | Get-AzureSqlDatabaseServerQuota"); q2 = powershell.InvokeBatchScript( @"$context | Get-AzureSqlDatabaseServerQuota -QuotaName ""Premium_Databases"""); ServerQuota quota1 = q1.FirstOrDefault().BaseObject as ServerQuota; ServerQuota quota2 = q2.FirstOrDefault().BaseObject as ServerQuota; Assert.AreEqual( "premium_databases", quota1.Name, "Unexpected quota name"); Assert.AreEqual( "premium_databases", quota2.Name, "Unexpected quota name"); } } Assert.AreEqual(0, powershell.Streams.Error.Count, "There were errors while running the tests!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "There were warnings while running the tests!"); } }
public IActionResult Signout(HttpResponse response, HttpSession session) { UserService.SignOut(session); Redirect(response, "/home/index"); return(null); }
public bool IsAdmin(HttpSession session) { User currentUser = this.GetCurrentlyLoggedUser(session); return(currentUser != null && currentUser.IsAdministrator); }
public User GetCurrentUser(HttpSession session) { User user = this.unitOfWork.Sessions.SingleOrDefault(s => s.SessionId == session.Id).User; return(user); }
public void NewAzureSqlDatabaseServerContextWithSqlAuthNegativeCases() { HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTests.NewAzureSqlDatabaseServerContextWithSqlAuthNegativeCases"); using (System.Management.Automation.PowerShell powershell = System.Management.Automation.PowerShell.Create()) { UnitTestHelper.ImportAzureModule(powershell); UnitTestHelper.CreateTestCredential(powershell); using (AsyncExceptionManager exceptionManager = new AsyncExceptionManager()) { // Test warning when different $metadata is received. Collection <PSObject> serverContext; using (new MockHttpServer( exceptionManager, MockHttpServer.DefaultServerPrefixUri, testSession)) { serverContext = powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"$context = New-AzureSqlDatabaseServerContext " + @"-ServerName testserver " + @"-ManageUrl {0} " + @"-Credential $credential", MockHttpServer.DefaultServerPrefixUri.AbsoluteUri), @"$context"); } Assert.AreEqual(0, powershell.Streams.Error.Count, "Errors during run!"); Assert.AreEqual(1, powershell.Streams.Warning.Count, "Should have warning!"); Assert.AreEqual( Resources.WarningModelOutOfDate, powershell.Streams.Warning.First().Message); powershell.Streams.ClearStreams(); PSObject contextPsObject = serverContext.Single(); Assert.IsTrue( contextPsObject.BaseObject is ServerDataServiceSqlAuth, "Expecting a ServerDataServiceSqlAuth object"); // Test error case using (new MockHttpServer( exceptionManager, MockHttpServer.DefaultServerPrefixUri, testSession)) { powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"$context = New-AzureSqlDatabaseServerContext " + @"-ServerName testserver " + @"-ManageUrl {0} " + @"-Credential $credential", MockHttpServer.DefaultServerPrefixUri.AbsoluteUri), @"$context"); } Assert.AreEqual(1, powershell.Streams.Error.Count, "Should have errors!"); Assert.AreEqual(2, powershell.Streams.Warning.Count, "Should have warning!"); Assert.AreEqual( "Test error message", powershell.Streams.Error.First().Exception.Message); Assert.IsTrue( powershell.Streams.Warning.Any( (w) => w.Message.StartsWith("Client Session Id:")), "Client session Id not written to warning"); Assert.IsTrue( powershell.Streams.Warning.Any( (w) => w.Message.StartsWith("Client Request Id:")), "Client request Id not written to warning"); powershell.Streams.ClearStreams(); } } }
internal static HttpSessionStateContainer CreateContainer (HttpSession session) { ServletSessionStateItemCollection sessionState = session.getAttribute (J2EEConsts.SESSION_STATE) as ServletSessionStateItemCollection; if (sessionState == null) //was not set sessionState = new ServletSessionStateItemCollection (null); return new HttpSessionStateContainer (session.getId (), sessionState, sessionState.StaticObjects, GetIntervalInMinutes (session.getMaxInactiveInterval ()), session.isNew (), HttpCookieMode.AutoDetect, SessionStateMode.Custom, true); }
protected override void Page_Load(object sender, EventArgs e) { RequireClientAuthentication(); if (phonebook == null) { Response.Redirect(UrlManager.Root); } session = HttpSession.CurrentSession(); phonebook.Employees.Reload(); ShowStatusMessageFromSessionIfExists(); SetSessionVariablesIfNull(); if (IsPostBack == false) { FieldLegalValueConfigurationFormLayout.DataSource = session.SessionOptionsFieldLegalValueTranslationSave.fieldLegalValueConfiguration; FieldLegalValueConfigurationFormLayout.DataSourceID = null; FieldLegalValueConfigurationFormLayout.DataBind(); } if (session.SessionOptionsFieldLegalValueTranslationSave.fieldLegalValueConfiguration.HasOid() == true) { SetHeadingControlText("Edit translation configuration"); } else { SetHeadingControlText("Add translation configuration"); } SetupRibbon(); RemoveAllAutoCorrectionsForSelectedLegalValue.Image.IconID = IconImage.Delete_Small; RemoveAllLegalValuesForSelectedAvailableFieldButton.Image.IconID = IconImage.Delete_Small; MaintainScrollPositionOnPostBack = true; base.Page_Load(sender, e); // to trigger PageDidPostBackWithArguments PopulatePageData(); }
public void Setup() { session = new HttpSession(); }
public IActionResult New(NewCategoryBindingModel catModel, HttpResponse response, HttpSession session) { if (!AuthenticationManager.IsAuthenticated(session)) { this.Redirect(response, "/forum/login"); return(null); } var user = AuthenticationManager.GetAuthenticatedUser(session.Id); if (user.IsAdmin == false) { this.Redirect(response, "/home/topics"); return(null); } this.service.AddNewCategoryFromBind(catModel); this.Redirect(response, "/categories/all"); return(null); }
public bool IsAuthenticated(HttpSession session) { bool isAuthenticated = this.unitOfWork.Sessions.FindAll(s => s.SessionId == session.Id && s.IsActive).Any(); return(isAuthenticated); }
/// <summary> /// Common helper method for other tests to create a context. /// </summary> /// <param name="contextVariable">The variable name that will hold the new context.</param> public static void CreateServerContextSqlAuth( System.Management.Automation.PowerShell powershell, string contextVariable) { HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.Common.NewAzureSqlDatabaseServerContextWithSqlAuth"); DatabaseTestHelper.SetDefaultTestSessionSettings(testSession); testSession.RequestValidator = new Action <HttpMessage, HttpMessage.Request>( (expected, actual) => { Assert.AreEqual(expected.RequestInfo.Method, actual.Method); Assert.AreEqual(expected.RequestInfo.UserAgent, actual.UserAgent); switch (expected.Index) { // Request 0-2: Create context with both ManageUrl and ServerName overriden case 0: // GetAccessToken call DatabaseTestHelper.ValidateGetAccessTokenRequest( expected.RequestInfo, actual); break; case 1: // Get server call DatabaseTestHelper.ValidateHeadersForODataRequest( expected.RequestInfo, actual); break; case 2: // $metadata call Assert.IsTrue( actual.RequestUri.AbsoluteUri.EndsWith("$metadata"), "Incorrect Uri specified for $metadata"); DatabaseTestHelper.ValidateHeadersForServiceRequest( expected.RequestInfo, actual); Assert.AreEqual( expected.RequestInfo.Headers[DataServiceConstants.AccessTokenHeader], actual.Headers[DataServiceConstants.AccessTokenHeader], "AccessToken header does not match"); Assert.AreEqual( expected.RequestInfo.Cookies[DataServiceConstants.AccessCookie], actual.Cookies[DataServiceConstants.AccessCookie], "AccessCookie does not match"); break; default: Assert.Fail("No more requests expected."); break; } }); UnitTestHelper.ImportAzureModule(powershell); UnitTestHelper.CreateTestCredential( powershell, testSession.SessionProperties["Username"], testSession.SessionProperties["Password"]); Collection <PSObject> serverContext; using (AsyncExceptionManager exceptionManager = new AsyncExceptionManager()) { using (new MockHttpServer( exceptionManager, MockHttpServer.DefaultServerPrefixUri, testSession)) { serverContext = powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"{1} = New-AzureSqlDatabaseServerContext " + @"-ServerName {2} " + @"-ManageUrl {0} " + @"-Credential $credential", MockHttpServer.DefaultServerPrefixUri.AbsoluteUri, contextVariable, testSession.SessionProperties["Servername"]), contextVariable); } } Assert.AreEqual(0, powershell.Streams.Error.Count, "Errors during run!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "Warnings during run!"); powershell.Streams.ClearStreams(); PSObject contextPsObject = serverContext.Single(); Assert.IsTrue( contextPsObject.BaseObject is ServerDataServiceSqlAuth, "Expecting a ServerDataServiceSqlAuth object"); }
public void Setup() { authenticatorFake = new AuthenticatorFake(); navigatorFake = new NavigatorFake(); httpSession = new HttpSession(authenticatorFake, navigatorFake, new DefaultSerializeBuilder()); }
public void AzureSqlDatabaseCertTests() { // 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); powershell.Runspace.SessionStateProxy.SetVariable( "serverName", SqlDatabaseTestSettings.Instance.ServerName); // Create a new server HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.AzureSqlDatabaseCertTests"); 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."); }); Collection <PSObject> newDatabaseResult1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert1")); }); Collection <PSObject> newDatabaseResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert2" + @" -Edition Business" + @" -MaxSizeGB 10" + @" -Collation Japanese_CI_AS")); }); // Create a database of size 100MB Default Edition (Standard) Collection <PSObject> newDatabaseResult3 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert4" + @" -MaxSizeBytes 104857600")); }); Collection <PSObject> getDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName")); }); Collection <PSObject> getSingleDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName" + @" -DatabaseName testdbcert1")); }); Collection <PSObject> getSingleDatabaseResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName" + @" -DatabaseName testdbcert4")); }); Collection <PSObject> setDatabaseNameResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db", newDatabaseResult1.FirstOrDefault()); return(powershell.InvokeBatchScript( @"$db | Set-AzureSqlDatabase" + @" -NewDatabaseName testdbcert3" + @" -PassThru")); }); Collection <PSObject> setDatabaseSizeResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db", newDatabaseResult1.FirstOrDefault()); return(powershell.InvokeBatchScript( @"$db | Set-AzureSqlDatabase" + @" -MaxSizeGB 5" + @" -PassThru")); }); Collection <PSObject> setDatabaseSizeResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Set-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert4" + @" -MaxSizeBytes 1073741824" + @" -passthru")); }); Collection <PSObject> P1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"$P1 = Get-AzureSqlDatabaseServiceObjective" + @" -Server $serverName" + @" -ServiceObjectiveName ""P1""", @"$P1")); }); Collection <PSObject> P2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.InvokeBatchScript( @"$SLO = Get-AzureSqlDatabaseServiceObjective" + @" -Server $serverName"); return(powershell.InvokeBatchScript( @"$P2 = Get-AzureSqlDatabaseServiceObjective" + @" -Server $serverName" + @" -ServiceObjective ($slo | where-object { $_.name -match ""P2"" })", @"$P2")); }); Collection <PSObject> setDatabaseSlo = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Set-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert4" + @" -Edition Premium" + @" -MaxSizeGb 10" + @" -ServiceObjective $P2" + @" -passthru" + @" -Force")); }); Collection <PSObject> removeDatabaseResult1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db1", newDatabaseResult1.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db2", newDatabaseResult2.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db3", newDatabaseResult3.FirstOrDefault()); powershell.InvokeBatchScript(@"$db1 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$db2 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$db3 | Remove-AzureSqlDatabase -Force"); return(powershell.InvokeBatchScript(@"Get-AzureSqlDatabase $serverName")); }); Collection <PSObject> newPremiumP1DatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName ""testdbcertPremiumDBP1""" + @" -Edition Premium" + @" -ServiceObjective $P1" + @" -MaxSizeGb 10")); }); Collection <PSObject> newPremiumP2DatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName ""testdbcertPremiumDBP2""" + @" -Edition Premium" + @" -ServiceObjective $P2" + @" -MaxSizeGb 10")); }); // There is a known issue about the Get-AzureSqlDatabaseOperation that it returns all // operations which has the required database name no matter it's been deleted and recreated. // So when run it against the mock session, please use the hard coded testsDBName. // Run against onebox, please use the one with NewGuid(). // This unit test should be updated once that behavior get changed which was already been // created as a task. string getOperationDbName = null; if (testSession.ServiceBaseUri == null) { getOperationDbName = "testdbcertGetOperationDbName_08abc738-1381-4164-ae5e-03a4fe59b6d2"; } else { getOperationDbName = "testdbcertGetOperationDbName_" + Guid.NewGuid().ToString(); } Collection <PSObject> newOperationDbResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"$getOperationDb = New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName ""{0}""", getOperationDbName), @"$getOperationDb")); }); Collection <PSObject> getDatabaseOperationByDbResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"Get-AzureSqlDatabaseOperation" + @" -ServerName $serverName" + @" -Database $getOperationDb"))); }); Collection <PSObject> getDatabaseOperationByNameResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"$getOperation = Get-AzureSqlDatabaseOperation" + @" -ServerName $serverName" + @" -DatabaseName ""{0}""", getOperationDbName), @"$getOperation")); }); Collection <PSObject> getDatabaseOperationByIdResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"Get-AzureSqlDatabaseOperation" + @" -ServerName $serverName" + @" -OperationGuid $getOperation[0].Id"))); }); Collection <PSObject> removeDatabaseResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("premiumP1", newPremiumP1DatabaseResult.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("premiumP2", newPremiumP2DatabaseResult.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("operationDb", newOperationDbResult.FirstOrDefault()); powershell.InvokeBatchScript(@"$premiumP1 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$premiumP2 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$operationDb | Remove-AzureSqlDatabase -Force"); return(powershell.InvokeBatchScript(@"Get-AzureSqlDatabase $serverName")); }); Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!"); // Validate New-AzureSqlDatabase Services.Server.Database[] databases = new Services.Server.Database[] { newDatabaseResult1.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); // Note: Because the object is piped, this is the final state of the // database object, after all the Set- cmdlet has run. DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert3", "Standard", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { newDatabaseResult2.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); //TODO: change below to business DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert2", "Business", 10, 10737418240L, "Japanese_CI_AS", "Business", false, DatabaseTestHelper.BusinessSloGuid); databases = new Services.Server.Database[] { newDatabaseResult3.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert4", "Standard", 0, 104857600L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); // Validate Get-AzureSqlDatabase databases = getDatabaseResult.Select(r => r.BaseObject as Services.Server.Database).ToArray(); Assert.AreEqual(4, databases.Length, "Expecting 4 databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.IsNotNull(databases[1], "Expecting a Database object."); Assert.IsNotNull(databases[2], "Expecting a Database object."); Assert.IsNotNull(databases[3], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[1], "master", "System", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "System2", true, DatabaseTestHelper.System2SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[3], "testdbcert1", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[2], "testdbcert2", "Business", 10, 10737418240L, "Japanese_CI_AS", "Business", false, DatabaseTestHelper.BusinessSloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert4", "Standard", 0, 104857600L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { getSingleDatabaseResult.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert1", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { getSingleDatabaseResult2.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert4", "Standard", 0, 104857600L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); // Validate Set-AzureSqlDatabase databases = new Services.Server.Database[] { setDatabaseNameResult.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert3", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { setDatabaseSizeResult.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert3", "Standard", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { setDatabaseSizeResult2.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert4", "Standard", 1, 1073741824L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { setDatabaseSlo.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbcert4", "Standard", 1, 1073741824L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.PremiumP2SloGuid); // Validate New-AzureSqlDatabase for Premium Edition Database VerifyCreatePremiumDb(newPremiumP1DatabaseResult, "testdbcertPremiumDBP1", (P1.Single().BaseObject as ServiceObjective).Id.ToString()); VerifyCreatePremiumDb(newPremiumP2DatabaseResult, "testdbcertPremiumDBP2", (P2.Single().BaseObject as ServiceObjective).Id.ToString()); // Validate Get-AzureSqlDatabaseServiceObjective var SLOP1 = P1.Single().BaseObject as ServiceObjective; Assert.AreEqual("P1", SLOP1.Name); Assert.IsNotNull(SLOP1.DimensionSettings, "Expecting some Dimension Setting objects."); Assert.AreEqual(1, SLOP1.DimensionSettings.Count(), "Expecting 1 Dimension Setting."); Assert.AreEqual("Premium P1 resource allocation.", SLOP1.DimensionSettings[0].Description, "Expecting Dimension Setting description as Resource capacity is reserved."); var SLOP2 = P2.Single().BaseObject as ServiceObjective; Assert.AreEqual("P2", SLOP2.Name); Assert.IsNotNull(SLOP2.DimensionSettings, "Expecting some Dimension Setting objects."); Assert.AreEqual(1, SLOP2.DimensionSettings.Count(), "Expecting 1 Dimension Setting."); Assert.AreEqual("Premium P2 resource allocation.", SLOP2.DimensionSettings[0].Description, "Expecting Dimension Setting description as Resource capacity is reserved."); // Validate Get-AzureSqlDatabaseOperation VerifyGetAzureSqlDatabaseOperation(getOperationDbName, getDatabaseOperationByDbResult); VerifyGetAzureSqlDatabaseOperation(getOperationDbName, getDatabaseOperationByNameResult); VerifyGetAzureSqlDatabaseOperation(getOperationDbName, getDatabaseOperationByIdResult); // Validate Remove-AzureSqlDatabase databases = new Services.Server.Database[] { removeDatabaseResult1.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting no databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "master", "System", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "System2", true, DatabaseTestHelper.System2SloGuid); databases = new Services.Server.Database[] { removeDatabaseResult2.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting no databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "master", "System", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "System2", true, DatabaseTestHelper.System2SloGuid); } }
public User GetCurrentlyLoggedUser(HttpSession session) { return(this.loginRepository.Get(l => l.SessionId == session.Id).Select(l => l.User).FirstOrDefault()); }
public void AzureSqlDatabaseEditionsTests() { // 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); powershell.Runspace.SessionStateProxy.SetVariable( "serverName", SqlDatabaseTestSettings.Instance.ServerV2); // Create a new server HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.AzureSqlDatabaseEditionsTests"); 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."); }); Collection <PSObject> newDatabaseResult1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"($db = New-AzureSqlDatabase -ServerName $serverName -DatabaseName testdbeditions1)")); }); Collection <PSObject> newDatabaseResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbeditions2" + @" -Edition Standard")); }); Collection <PSObject> newDatabaseResult3 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"($db3 = New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbeditions3" + @" -Edition Basic)")); }); Collection <PSObject> newDatabaseResult4 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbeditions4" + @" -Edition Premium")); }); Collection <PSObject> serviceObjectives = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"($so = Get-AzureSqlDatabaseServiceObjective -Server $serverName)")); }); Collection <PSObject> newDatabaseResult5 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbeditions5" + @" -Edition Standard" + @" -ServiceObjective ($so | where-object { $_.name -match ""S2"" })")); }); Collection <PSObject> getSingleDatabaseResult1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase $serverName -DatabaseName testdbeditions1")); }); Collection <PSObject> getSingleDatabaseResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"$db | Get-AzureSqlDatabase")); }); Collection <PSObject> setDatabaseObjective1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Set-AzureSqlDatabase -ServerName $serverName -DatabaseName testdbeditions2 -ServiceObjective ($so | where-object { $_.name -match ""S2"" }) -Force")); }); Collection <PSObject> setDatabaseObjective2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Set-AzureSqlDatabase -ServerName $serverName -DatabaseName $db3.Name -Edition Standard -MaxSizeGB 1 -ServiceObjective ($so | where-object { $_.name -match ""S1"" }) -Force")); }); Collection <PSObject> getDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName")); }); Collection <PSObject> removeDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db1", newDatabaseResult1.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db2", newDatabaseResult2.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db3", newDatabaseResult3.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db4", newDatabaseResult4.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db5", newDatabaseResult5.FirstOrDefault()); powershell.InvokeBatchScript(@"$db1 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$db2 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$db3 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$db4 | Remove-AzureSqlDatabase -Force"); powershell.InvokeBatchScript(@"$db5 | Remove-AzureSqlDatabase -Force"); return(powershell.InvokeBatchScript(@"Get-AzureSqlDatabase $serverName")); }); Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!"); // Validate New-AzureSqlDatabase Services.Server.Database[] databases = new Services.Server.Database[] { newDatabaseResult1.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbeditions1", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { newDatabaseResult2.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbeditions2", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); databases = new Services.Server.Database[] { newDatabaseResult3.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbeditions3", "Basic", 2, 2147483648L, "SQL_Latin1_General_CP1_CI_AS", "Basic", false, DatabaseTestHelper.BasicSloGuid); databases = new Services.Server.Database[] { newDatabaseResult4.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbeditions4", "Premium", 500, 536870912000L, "SQL_Latin1_General_CP1_CI_AS", "P1", false, DatabaseTestHelper.PremiumP1SloGuid); databases = new Services.Server.Database[] { newDatabaseResult5.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbeditions5", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S2", false, DatabaseTestHelper.StandardS2SloGuid); // Validate Get-AzureSqlDatabase databases = getDatabaseResult.Select(r => r.BaseObject as Services.Server.Database).ToArray(); Assert.AreEqual(6, databases.Length, "Expecting 3 databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.IsNotNull(databases[1], "Expecting a Database object."); Assert.IsNotNull(databases[2], "Expecting a Database object."); Assert.IsNotNull(databases[3], "Expecting a Database object."); Assert.IsNotNull(databases[4], "Expecting a Database object."); Assert.IsNotNull(databases[5], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[1], "master", "System", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "System2", true, DatabaseTestHelper.System2SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[3], "testdbeditions1", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS0SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[4], "testdbeditions2", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S0", false, DatabaseTestHelper.StandardS2SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[5], "testdbeditions3", "Basic", 2, 2147483648L, "SQL_Latin1_General_CP1_CI_AS", "Basic", false, DatabaseTestHelper.StandardS1SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[2], "testdbeditions4", "Premium", 500, 536870912000L, "SQL_Latin1_General_CP1_CI_AS", "P1", false, DatabaseTestHelper.PremiumP1SloGuid); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "testdbeditions5", "Standard", 250, 268435456000L, "SQL_Latin1_General_CP1_CI_AS", "S2", false, DatabaseTestHelper.StandardS2SloGuid); // Validate Get-AzureSqlDatabaseServiceObjective var sos = serviceObjectives.Select(x => x.BaseObject as ServiceObjective).ToArray(); Assert.AreEqual(10, sos.Count()); ValidateServiceObjectiveProperties(sos[0], "System", "", 1, "Used for master database only."); ValidateServiceObjectiveProperties(sos[1], "System2", "", 1, ""); ValidateServiceObjectiveProperties(sos[2], "Basic", "", 1, "Basic resource allocation."); ValidateServiceObjectiveProperties(sos[3], "S0", "", 1, "Standard S0 resource allocation."); ValidateServiceObjectiveProperties(sos[4], "S1", "", 1, "Standard S1 resource allocation."); ValidateServiceObjectiveProperties(sos[5], "S2", "", 1, "Standard S2 resource allocation."); ValidateServiceObjectiveProperties(sos[6], "S3", "", 1, "Standard S3 resource allocation."); ValidateServiceObjectiveProperties(sos[7], "P1", "", 1, "Premium P1 resource allocation."); ValidateServiceObjectiveProperties(sos[8], "P2", "", 1, "Premium P2 resource allocation."); ValidateServiceObjectiveProperties(sos[9], "P3", "", 1, "Premium P3 resource allocation."); // Validate Remove-AzureSqlDatabase databases = new Services.Server.Database[] { removeDatabaseResult.Single().BaseObject as Services.Server.Database }; Assert.AreEqual(1, databases.Length, "Expecting no databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); DatabaseTestHelper.ValidateDatabaseProperties(databases[0], "master", "System", 5, 5368709120L, "SQL_Latin1_General_CP1_CI_AS", "System2", true, DatabaseTestHelper.System2SloGuid); } }
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 AzureSqlDatabaseServerQuotaCertAuthTest() { // 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); powershell.Runspace.SessionStateProxy.SetVariable( "serverName", SqlDatabaseTestSettings.Instance.ServerV2); // Create a new server HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.AzureSqlDatabaseServerQuotaCertAuthTest"); 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."); }); Collection <PSObject> getQuota1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabaseServerQuota -ServerName $serverName")); }); Collection <PSObject> getQuota2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabaseServerQuota -ServerName $serverName -QuotaName premium_databases")); }); Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!"); // Validate Get-AzureSqlDatabaseServerQuota var quotas = getQuota1.Select(x => ((IEnumerable)x.BaseObject).Cast <Model.SqlDatabaseServerQuotaContext>().Single()).ToArray(); Assert.AreEqual(1, quotas.Length, "Expecting one server quota"); Assert.IsNotNull(quotas[0], "Expecting a server quota."); Assert.AreEqual("premium_databases", quotas[0].Name); Assert.AreEqual(SqlDatabaseTestSettings.Instance.ServerV2, quotas[0].ServerName); Assert.AreEqual("Microsoft.SqlAzure.ServerQuota", quotas[0].Type); Assert.AreEqual("100", quotas[0].Value); Assert.AreEqual("Normal", quotas[0].State); quotas = getQuota2.Select(x => ((IEnumerable)x.BaseObject).Cast <Model.SqlDatabaseServerQuotaContext>().Single()).ToArray(); Assert.AreEqual(1, quotas.Length, "Expecting server quota"); Assert.IsNotNull(quotas[0], "Expecting a server quota."); Assert.AreEqual("premium_databases", quotas[0].Name); Assert.AreEqual(SqlDatabaseTestSettings.Instance.ServerV2, quotas[0].ServerName); Assert.AreEqual("Microsoft.SqlAzure.ServerQuota", quotas[0].Type); Assert.AreEqual("100", quotas[0].Value); Assert.AreEqual("Normal", quotas[0].State); } }
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 IActionResult Register(RegisterUserBindingModel rubm, HttpResponse response, HttpSession session) { if (AuthenticationManager.IsAuthenticated(session.Id)) { Redirect(response, "/home/homepage"); return(null); } if (service.IsRegisterModelValid(rubm)) { User user = service.GetUserFromRegisterBind(rubm); service.RegisterUser(user); Redirect(response, "/home/homepage"); return(null); } Redirect(response, "/authentication/register"); return(null); }
public bool IsAuthenticated(HttpSession session) { return(this.context.Logins.Any(l => l.IsActive && l.SessionId == session.Id)); }
private void ConfigureMapper(HttpSession session, PizzaMoreMVCContext context) { Mapper.Initialize(e => e.CreateMap <AddPizzaBindingModel, Pizza>() .ForMember(p => p.Owner, config => config .MapFrom(u => context.Sessions.First(s => s.SessionId == session.Id).User))); }
public void AzureSqlDatabaseCertTests() { // 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); powershell.Runspace.SessionStateProxy.SetVariable( "serverName", SqlDatabaseTestSettings.Instance.ServerName); // Create a new server HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.AzureSqlDatabaseCertTests"); ServerTestHelper.SetDefaultTestSessionSettings(testSession); // Uncomment one of these two when testing against onebox or production // When testing production use RDFE // testSession.ServiceBaseUri = new Uri("https://management.core.windows.net"); // When testing onebox use Mock RDFE // testSession.ServiceBaseUri = new Uri("https://management.dev.mscds.com:12346/MockRDFE/"); 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"); }); Collection <PSObject> newDatabaseResult1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert1")); }); Collection <PSObject> newDatabaseResult2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"New-AzureSqlDatabase" + @" -ServerName $serverName" + @" -DatabaseName testdbcert2" + @" -Edition Business" + @" -MaxSizeGB 10" + @" -Collation Japanese_CI_AS")); }); Collection <PSObject> getDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName")); }); Collection <PSObject> getSingleDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName" + @" -DatabaseName testdbcert1")); }); Collection <PSObject> setDatabaseNameResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db", newDatabaseResult1.FirstOrDefault()); return(powershell.InvokeBatchScript( @"$db | Set-AzureSqlDatabase" + @" -NewDatabaseName testdbcert3" + @" -PassThru")); }); Collection <PSObject> setDatabaseSizeResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db", newDatabaseResult1.FirstOrDefault()); return(powershell.InvokeBatchScript( @"$db | Set-AzureSqlDatabase" + @" -MaxSizeGB 5" + @" -PassThru")); }); Collection <PSObject> P1 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( @"$P1 = Get-AzureSqlDatabaseServiceObjective" + @" -Server $serverName" + @" -ServiceObjectiveName ""Reserved P1""", @"$P1")); }); Collection <PSObject> P2 = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.InvokeBatchScript( @"$SLO = Get-AzureSqlDatabaseServiceObjective" + @" -Server $serverName"); return(powershell.InvokeBatchScript( @"$P2 = Get-AzureSqlDatabaseServiceObjective" + @" -Server $serverName" + @" -ServiceObjective $SLO[1]", @"$P2")); }); Collection <PSObject> newPremiumP1DatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"New-AzureSqlDatabase" + @" -ServerName {0}" + @" -DatabaseName ""testdbcertPremiumDBP1""" + @" -Edition Premium" + @" -ServiceObjective $P1", "testserver"))); }); Collection <PSObject> newPremiumP2DatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"New-AzureSqlDatabase" + @" -ServerName {0}" + @" -DatabaseName ""testdbcertPremiumDBP2""" + @" -Edition Premium" + @" -ServiceObjective $P2", "testserver"))); }); // There is a known issue about the Get-AzureSqlDatabaseOperation that it returns all // operations which has the required database name no matter it's been deleted and recreated. // So when run it against the mock session, please use the hard coded testsDBName. // Run against onebox, please use the one with NewGuid(). // This unit test should be updated once that behavior get changed which was already been // created as a task. //string getOperationDbName = "testdbcertGetOperationDbName_" + Guid.NewGuid().ToString(); string getOperationDbName = "testdbcertGetOperationDbName_5d8b5785-0490-402c-b42f-6a5f5d6fbed8"; Collection <PSObject> newOperationDbResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"$getOperationDb = New-AzureSqlDatabase" + @" -ServerName testserver" + @" -DatabaseName ""{0}""", getOperationDbName), @"$getOperationDb")); }); Collection <PSObject> getDatabaseOperationByDbResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"Get-AzureSqlDatabaseOperation" + @" -ServerName testserver" + @" -Database $getOperationDb"))); }); Collection <PSObject> getDatabaseOperationByNameResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"$getOperation = Get-AzureSqlDatabaseOperation" + @" -ServerName testserver" + @" -DatabaseName ""{0}""", getOperationDbName), @"$getOperation")); }); Collection <PSObject> getDatabaseOperationByIdResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { return(powershell.InvokeBatchScript( string.Format( CultureInfo.InvariantCulture, @"Get-AzureSqlDatabaseOperation" + @" -ServerName testserver" + @" -OperationGuid $getOperation[0].Id"))); }); Collection <PSObject> removeDatabaseResult = MockServerHelper.ExecuteWithMock( testSession, MockHttpServer.DefaultHttpsServerPrefixUri, () => { powershell.Runspace.SessionStateProxy.SetVariable("db1", newDatabaseResult1.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("db2", newDatabaseResult2.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("premiumP1", newPremiumP1DatabaseResult.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("premiumP2", newPremiumP2DatabaseResult.FirstOrDefault()); powershell.Runspace.SessionStateProxy.SetVariable("operationDb", newOperationDbResult.FirstOrDefault()); powershell.InvokeBatchScript( @"$db1 | Remove-AzureSqlDatabase" + @" -Force"); powershell.InvokeBatchScript( @"$db2 | Remove-AzureSqlDatabase" + @" -Force"); powershell.InvokeBatchScript( @"$premiumP1 | Remove-AzureSqlDatabase" + @" -Force"); powershell.InvokeBatchScript( @"$premiumP2 | Remove-AzureSqlDatabase" + @" -Force"); powershell.InvokeBatchScript( @"$operationDb | Remove-AzureSqlDatabase" + @" -Force"); return(powershell.InvokeBatchScript( @"Get-AzureSqlDatabase" + @" $serverName")); }); Assert.AreEqual(0, powershell.Streams.Error.Count, "Unexpected Errors during run!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "Unexpected Warnings during run!"); // Validate New-AzureSqlDatabase Database[] databases = new Database[] { newDatabaseResult1.Single().BaseObject as Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); // Note: Because the object is piped, this is the final state of the // database object, after all the Set- cmdlet has run. Assert.AreEqual("testdbcert3", databases[0].Name); Assert.AreEqual("Web", databases[0].Edition); Assert.AreEqual(5, databases[0].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[0].CollationName); databases = new Database[] { newDatabaseResult2.Single().BaseObject as Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.AreEqual("testdbcert2", databases[0].Name); Assert.AreEqual("Business", databases[0].Edition); Assert.AreEqual(10, databases[0].MaxSizeGB); Assert.AreEqual("Japanese_CI_AS", databases[0].CollationName); // Validate Get-AzureSqlDatabase databases = getDatabaseResult.Select(r => r.BaseObject as Database).ToArray(); Assert.AreEqual(3, databases.Length, "Expecting 3 databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.IsNotNull(databases[1], "Expecting a Database object."); Assert.IsNotNull(databases[2], "Expecting a Database object."); Assert.AreEqual("master", databases[0].Name); Assert.AreEqual("Web", databases[0].Edition); Assert.AreEqual(5, databases[0].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[0].CollationName); Assert.AreEqual(true, databases[0].IsSystemObject); Assert.AreEqual("testdbcert1", databases[1].Name); Assert.AreEqual("Web", databases[1].Edition); Assert.AreEqual(1, databases[1].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[1].CollationName); Assert.AreEqual(false, databases[1].IsSystemObject); Assert.AreEqual("testdbcert2", databases[2].Name); Assert.AreEqual("Business", databases[2].Edition); Assert.AreEqual(10, databases[2].MaxSizeGB); Assert.AreEqual("Japanese_CI_AS", databases[2].CollationName); Assert.AreEqual(false, databases[2].IsSystemObject); databases = new Database[] { getSingleDatabaseResult.Single().BaseObject as Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.AreEqual("testdbcert1", databases[0].Name); Assert.AreEqual("Web", databases[0].Edition); Assert.AreEqual(1, databases[0].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[0].CollationName); // Validate Set-AzureSqlDatabase databases = new Database[] { setDatabaseNameResult.Single().BaseObject as Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.AreEqual("testdbcert3", databases[0].Name); Assert.AreEqual("Web", databases[0].Edition); Assert.AreEqual(1, databases[0].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[0].CollationName); databases = new Database[] { setDatabaseSizeResult.Single().BaseObject as Database }; Assert.AreEqual(1, databases.Length, "Expecting one database"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.AreEqual("testdbcert3", databases[0].Name); Assert.AreEqual("Web", databases[0].Edition); Assert.AreEqual(5, databases[0].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[0].CollationName); // Validate New-AzureSqlDatabase for Premium Edition Database VerifyCreatePremiumDb(newPremiumP1DatabaseResult, "testdbcertPremiumDBP1", (P1.Single().BaseObject as ServiceObjective).Id.ToString()); VerifyCreatePremiumDb(newPremiumP2DatabaseResult, "testdbcertPremiumDBP2", (P2.Single().BaseObject as ServiceObjective).Id.ToString()); // Validate Get-AzureSqlDatabaseServiceObjective var SLOP1 = P1.Single().BaseObject as ServiceObjective; Assert.AreEqual(SLOP1.Name, "Reserved P1"); Assert.AreEqual(SLOP1.Description, "Resource capacity is reserved."); Assert.IsNotNull(SLOP1.DimensionSettings, "Expecting some Dimension Setting objects."); Assert.AreEqual(SLOP1.DimensionSettings.Count(), 1, "Expecting 1 Dimension Setting."); Assert.AreEqual(SLOP1.DimensionSettings[0].Description, "Resource capacity is reserved.", "Expecting Dimension Setting description as Resource capacity is reserved."); var SLOP2 = P2.Single().BaseObject as ServiceObjective; Assert.AreEqual(SLOP2.Name, "Reserved P2"); Assert.AreEqual(SLOP2.Description, "Resource capacity is reserved."); Assert.IsNotNull(SLOP2.DimensionSettings, "Expecting some Dimension Setting objects."); Assert.AreEqual(SLOP2.DimensionSettings.Count(), 1, "Expecting 1 Dimension Setting."); Assert.AreEqual(SLOP2.DimensionSettings[0].Description, "Resource capacity is reserved.", "Expecting Dimension Setting description as Resource capacity is reserved."); // Validate Get-AzureSqlDatabaseOperation VerifyGetAzureSqlDatabaseOperation(getOperationDbName, getDatabaseOperationByDbResult); VerifyGetAzureSqlDatabaseOperation(getOperationDbName, getDatabaseOperationByNameResult); VerifyGetAzureSqlDatabaseOperation(getOperationDbName, getDatabaseOperationByIdResult); // Validate Remove-AzureSqlDatabase databases = new Database[] { removeDatabaseResult.Single().BaseObject as Database }; Assert.AreEqual(1, databases.Length, "Expecting no databases"); Assert.IsNotNull(databases[0], "Expecting a Database object."); Assert.AreEqual("master", databases[0].Name); Assert.AreEqual("Web", databases[0].Edition); Assert.AreEqual(5, databases[0].MaxSizeGB); Assert.AreEqual("SQL_Latin1_General_CP1_CI_AS", databases[0].CollationName); } }
public void CreatePremiumDatabasesWithSqlAuth() { using (System.Management.Automation.PowerShell powershell = System.Management.Automation.PowerShell.Create()) { NewAzureSqlDatabaseServerContextTests.CreateServerContextSqlAuth( powershell, "$context"); HttpSession testSession = MockServerHelper.DefaultSessionCollection.GetSession( "UnitTest.Common.CreatePremiumDatabasesWithSqlAuth"); DatabaseTestHelper.SetDefaultTestSessionSettings(testSession); testSession.RequestValidator = new Action <HttpMessage, HttpMessage.Request>( (expected, actual) => { Assert.AreEqual(expected.RequestInfo.Method, actual.Method); Assert.AreEqual(expected.RequestInfo.UserAgent, actual.UserAgent); }); using (AsyncExceptionManager exceptionManager = new AsyncExceptionManager()) { Collection <PSObject> premiumDB_P1, PremiumDB_P2; using (new MockHttpServer( exceptionManager, MockHttpServer.DefaultServerPrefixUri, testSession)) { powershell.InvokeBatchScript( @"$P1 = Get-AzureSqlDatabaseServiceObjective" + @" -Context $context" + @" -ServiceObjectiveName ""P1"""); powershell.InvokeBatchScript( @"$P2 = Get-AzureSqlDatabaseServiceObjective " + @"-Context $context" + @" -ServiceObjectiveName ""P2"""); premiumDB_P1 = powershell.InvokeBatchScript( @"$premiumDB_P1 = New-AzureSqlDatabase " + @"-Context $context " + @"-DatabaseName NewAzureSqlPremiumDatabaseTests_P1 " + @"-Edition Premium " + @"-ServiceObjective $P1 "); premiumDB_P1 = powershell.InvokeBatchScript("$PremiumDB_P1"); powershell.InvokeBatchScript( @"$PremiumDB_P2 = New-AzureSqlDatabase " + @"-Context $context " + @"-DatabaseName NewAzureSqlPremiumDatabaseTests_P2 " + @"-Collation Japanese_CI_AS " + @"-Edition Premium " + @"-ServiceObjective $P2 " + @"-MaxSizeGB 10 " + @"-Force"); PremiumDB_P2 = powershell.InvokeBatchScript("$PremiumDB_P2"); } Assert.AreEqual(0, powershell.Streams.Error.Count, "Errors during run!"); Assert.AreEqual(0, powershell.Streams.Warning.Count, "Warnings during run!"); powershell.Streams.ClearStreams(); Assert.IsTrue( premiumDB_P1.Single().BaseObject is Services.Server.Database, "Expecting a Database object"); Services.Server.Database databaseP1 = (Services.Server.Database)premiumDB_P1.Single().BaseObject; Assert.AreEqual("NewAzureSqlPremiumDatabaseTests_P1", databaseP1.Name, "Expected db name to be NewAzureSqlPremiumDatabaseTests_P1"); Assert.IsTrue( PremiumDB_P2.Single().BaseObject is Services.Server.Database, "Expecting a Database object"); Services.Server.Database databaseP2 = (Services.Server.Database)PremiumDB_P2.Single().BaseObject; Assert.AreEqual("NewAzureSqlPremiumDatabaseTests_P2", databaseP2.Name, "Expected db name to be NewAzureSqlPremiumDatabaseTests_P2"); Assert.AreEqual( "Japanese_CI_AS", databaseP2.CollationName, "Expected collation to be Japanese_CI_AS"); Assert.AreEqual("Premium", databaseP2.Edition, "Expected edition to be Premium"); Assert.AreEqual(10, databaseP2.MaxSizeGB, "Expected max size to be 10 GB"); } } }
public IActionResult Edit(EditCategoryBindingModel ecbm, HttpResponse response, HttpSession session) { if (!AuthenticationManager.IsAuthenticated(session)) { this.Redirect(response, "/forum/login"); return(null); } var user = AuthenticationManager.GetAuthenticatedUser(session.Id); if (user.IsAdmin == false) { this.Redirect(response, "/home/topics"); return(null); } this.service.EditCategoryName(ecbm); this.Redirect(response, "/categories/all"); return(null); }
public IActionResult Register(UserRegisterBindingModel bindingModel, HttpResponse response, HttpSession currentSession) { if (this.loginManager.IsAuthenticated(currentSession)) { this.Redirect(response, "/users/feed"); return(null); } if (!this.userService.IsValidRegisterInput(bindingModel)) { this.Redirect(response, "/users/register"); return(null); } this.userService.RegisterUser(bindingModel); this.Redirect(response, "/users/login"); return(null); }
public IActionResult <EditCategoryViewModel> Edit(int id, HttpResponse response, HttpSession session) { if (!AuthenticationManager.IsAuthenticated(session)) { this.Redirect(response, "/forum/login"); return(null); } var user = AuthenticationManager.GetAuthenticatedUser(session.Id); if (user.IsAdmin == false) { this.Redirect(response, "/home/topics"); return(null); } var viewModel = service.GetEditCategoryViewModel(id); return(this.View(viewModel)); }
public IActionResult Login(UserLoginBindingModel bindingModel, HttpResponse response, HttpSession currentSession) { if (this.loginManager.IsAuthenticated(currentSession)) { this.Redirect(response, "/users/feed"); return(null); } if (!this.userService.IsValidLoginInput(bindingModel)) { this.Redirect(response, "/users/login"); return(null); } User currentUser = this.userService.GetCurrentUser(bindingModel); this.userService.LoginUser(bindingModel, currentUser, currentSession); this.Redirect(response, "/users/feed"); return(null); }
public bool IsAdmin(HttpSession session) { bool isAdmin = this.unitOfWork.Sessions.SingleOrDefault(s => s.SessionId == session.Id).User.IsAdmin; return(isAdmin); }
public IActionResult Feed(HttpResponse response, HttpSession session) { return(View()); }
public IActionResult <List <ShoutViewModel> > FeedSigned(HttpResponse response, HttpSession session) { if (this.signInManager.IsAuthenticated(session)) { var shouts = this.data.ShoutRepository.UpdateAndGetAllShouts(); var shoutViewModels = new List <ShoutViewModel>(); foreach (var shout in shouts) { var shoutViewModel = new ShoutViewModel() { Author = shout.Author, Content = shout.Content, PostedForTime = Extensions.CalculateTimeSincePost(shout.PostedOn) }; shoutViewModels.Add(shoutViewModel); } this.data.SaveChanges(); return(this.View(shoutViewModels)); } else { this.Redirect(response, "/home/feed"); return(null); } }
public bool IsAuthenticated(HttpSession session) { return(this.GetCurrentlyLoggedUser(session) != null); }