// ReSharper disable InconsistentNaming public void SqlDatabaseBroker_TestService_SqlUserWithInvalidUsername_ReturnsInvalidResult() // ReSharper restore InconsistentNaming { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(); dbSource.UserID = "Billy.Jane"; dbSource.Password = "******"; var serviceConn = new DbService { ResourceID = Guid.NewGuid(), ResourceName = "DatabaseService", ResourceType = "DbService", AuthorRoles = "", Dependencies = new List <IResourceForTree>(), FilePath = null, IsUpgraded = true, Method = new ServiceMethod("dbo.fn_diagramobjects", "\r\n\tCREATE FUNCTION dbo.fn_diagramobjects() \r\n\tRETURNS int\r\n\tWITH EXECUTE AS N'dbo'\r\n\tAS\r\n\tBEGIN\r\n\t\tdeclare @id_upgraddiagrams\t\tint\r\n\t\tdeclare @id_sysdiagrams\t\t\tint\r\n\t\tdeclare @id_helpdiagrams\t\tint\r\n\t\tdeclare @id_helpdiagramdefinition\tint\r\n\t\tdeclare @id_creatediagram\tint\r\n\t\tdeclare @id_renamediagram\tint\r\n\t\tdeclare @id_alterdiagram \tint \r\n\t\tdeclare @id_dropdiagram\t\tint\r\n\t\tdeclare @InstalledObjects\tint\r\n\r\n\t\tselect @InstalledObjects = 0\r\n\r\n\t\tselect \t@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),\r\n\t\t\t@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),\r\n\t\t\t@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),\r\n\t\t\t@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),\r\n\t\t\t@id_creatediagram = object_id(N'dbo.sp_creatediagram'),\r\n\t\t\t@id_renamediagram = object_id(N'dbo.sp_renamediagram'),\r\n\t\t\t@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), \r\n\t\t\t@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')\r\n\r\n\t\tif @id_upgraddiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 1\r\n\t\tif @id_sysdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 2\r\n\t\tif @id_helpdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 4\r\n\t\tif @id_helpdiagramdefinition is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 8\r\n\t\tif @id_creatediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 16\r\n\t\tif @id_renamediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 32\r\n\t\tif @id_alterdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 64\r\n\t\tif @id_dropdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 128\r\n\t\t\r\n\t\treturn @InstalledObjects \r\n\tEND\r\n\t", null, null, null, null), Recordset = new Recordset(), Source = dbSource }; var broker = new SqlDatabaseBroker(); broker.TestService(serviceConn); }
// ReSharper disable InconsistentNaming public void SqlDatabaseBroker_TestService_ValidDbServiceThatReturnsNull_RecordsetWithNullColumn() // ReSharper restore InconsistentNaming { var service = new DbService { ResourceID = Guid.NewGuid(), ResourceName = "NullService", ResourceType = "DbService", Method = new ServiceMethod { Name = "Pr_GeneralTestColumnData", Parameters = new List <MethodParameter>(), ExecuteAction = "Pr_GeneralTestColumnData" }, Recordset = new Recordset { Name = "Collections", }, Source = SqlServerTestUtils.CreateDev2TestingDbSource() }; var broker = new SqlDatabaseBroker(); IOutputDescription outputDescription = broker.TestService(service); Assert.AreEqual(1, outputDescription.DataSourceShapes.Count); IDataSourceShape dataSourceShape = outputDescription.DataSourceShapes[0]; Assert.IsNotNull(dataSourceShape); Assert.AreEqual(3, dataSourceShape.Paths.Count); StringAssert.Contains(dataSourceShape.Paths[2].DisplayPath, "TestTextNull"); //This is the field that contains a null value. Previously this column would not have been returned. }
// ReSharper disable InconsistentNaming public void SqlDatabaseBroker_TestService_WindowsUserWithDbAccess_ReturnsValidResult() // ReSharper restore InconsistentNaming { Impersonator.RunAs("IntegrationTester", "DEV2", "I73573r0", () => { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(AuthenticationType.Windows); var serviceConn = new DbService { ResourceID = Guid.NewGuid(), ResourceName = "DatabaseService", ResourceType = ResourceType.DbService, ResourcePath = "Test", AuthorRoles = "", Dependencies = new List <IResourceForTree>(), FilePath = null, IsUpgraded = true, Method = new ServiceMethod("dbo.fn_diagramobjects", "\r\n\tCREATE FUNCTION dbo.fn_diagramobjects() \r\n\tRETURNS int\r\n\tWITH EXECUTE AS N'dbo'\r\n\tAS\r\n\tBEGIN\r\n\t\tdeclare @id_upgraddiagrams\t\tint\r\n\t\tdeclare @id_sysdiagrams\t\t\tint\r\n\t\tdeclare @id_helpdiagrams\t\tint\r\n\t\tdeclare @id_helpdiagramdefinition\tint\r\n\t\tdeclare @id_creatediagram\tint\r\n\t\tdeclare @id_renamediagram\tint\r\n\t\tdeclare @id_alterdiagram \tint \r\n\t\tdeclare @id_dropdiagram\t\tint\r\n\t\tdeclare @InstalledObjects\tint\r\n\r\n\t\tselect @InstalledObjects = 0\r\n\r\n\t\tselect \t@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),\r\n\t\t\t@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),\r\n\t\t\t@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),\r\n\t\t\t@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),\r\n\t\t\t@id_creatediagram = object_id(N'dbo.sp_creatediagram'),\r\n\t\t\t@id_renamediagram = object_id(N'dbo.sp_renamediagram'),\r\n\t\t\t@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), \r\n\t\t\t@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')\r\n\r\n\t\tif @id_upgraddiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 1\r\n\t\tif @id_sysdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 2\r\n\t\tif @id_helpdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 4\r\n\t\tif @id_helpdiagramdefinition is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 8\r\n\t\tif @id_creatediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 16\r\n\t\tif @id_renamediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 32\r\n\t\tif @id_alterdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 64\r\n\t\tif @id_dropdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 128\r\n\t\t\r\n\t\treturn @InstalledObjects \r\n\tEND\r\n\t", null, null, null, "dbo.fn_diagramobjects"), Recordset = new Recordset(), Source = dbSource }; var broker = new SqlDatabaseBroker(); var result = broker.TestService(serviceConn); Assert.AreEqual(OutputFormats.ShapedXML, result.Format); }); }
public void SqlDatabaseBroker_GetServiceMethods_SqlUserWithValidUsername_GetsMethods() { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(); var broker = new SqlDatabaseBroker(); var result = broker.GetServiceMethods(dbSource); Assert.AreEqual(true, result.Count > 0); }
public void SqlDatabaseBroker_GetServiceMethods_WindowsUserWithDbAccess_GetsMethods() { RunAs("IntegrationTester", "DEV2", "I73573r0", () => { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(AuthenticationType.Windows); var broker = new SqlDatabaseBroker(); var result = broker.GetServiceMethods(dbSource); Assert.AreEqual(true, result.Count > 0); }); }
public void SqlDatabaseBroker_GetServiceMethods_WindowsUserWithDbAccess_GetsMethods() { RunAs("IntegrationTester", "dev2", () => { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(Depends.EnableDocker?Depends.RigOpsIP:Depends.SVRDEVIP, AuthenticationType.Windows); var broker = new SqlDatabaseBroker(); var result = broker.GetServiceMethods(dbSource); Assert.AreEqual(true, result.Count > 0); }); }
public void SqlDatabaseBroker_GetServiceMethods_SqlUserWithInvalidUsername_ThrowsLoginFailedException() { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(Depends.EnableDocker?Depends.RigOpsIP:Depends.SVRDEVIP); dbSource.UserID = "Billy.Jane"; dbSource.Password = "******"; var broker = new SqlDatabaseBroker(); broker.GetServiceMethods(dbSource); }
public void SqlDatabaseBroker_GetServiceMethods_SqlUserWithInvalidUsername_ThrowsLoginFailedException() { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(_containerOps.Container.IP, int.Parse(_containerOps.Container.Port)); dbSource.UserID = "Billy.Jane"; dbSource.Password = "******"; var broker = new SqlDatabaseBroker(); broker.GetServiceMethods(dbSource); }
// ReSharper disable InconsistentNaming public void SqlDatabaseBroker_GetServiceMethods_SqlUserWithInvalidUsername_ThrowsLoginFailedException() // ReSharper restore InconsistentNaming { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(); dbSource.UserID = "Billy.Jane"; dbSource.Password = "******"; var broker = new SqlDatabaseBroker(); broker.GetServiceMethods(dbSource); }
public void SqlDatabaseBroker_GetServiceMethods_WindowsUserWithoutDbAccess_ThrowsLoginFailedException() { RunAs("NoDBAccessTest", "DEV2", "One23456", () => { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(AuthenticationType.Windows); var broker = new SqlDatabaseBroker(); try { broker.GetServiceMethods(dbSource); Assert.Fail(); } catch (Exception ex) { Assert.IsNotNull(ex); Assert.IsInstanceOfType(ex, typeof(SqlException)); Assert.AreEqual("Login failed for user 'DEV2\\NoDBAccessTest'.", ex.Message); } }); }
public void SqlDatabaseBroker_TestService_SqlUserWithValidUsername_ReturnsValidResult() { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(); var serviceConn = new DbService { ResourceID = Guid.NewGuid(), ResourceName = "DatabaseService", ResourceType = "DbService", AuthorRoles = "", Dependencies = new List <IResourceForTree>(), FilePath = null, IsUpgraded = true, Method = new ServiceMethod("dbo.fn_diagramobjects", "\r\n\tCREATE FUNCTION dbo.fn_diagramobjects() \r\n\tRETURNS int\r\n\tAS\r\n\tBEGIN\r\n\t\tdeclare @id_upgraddiagrams\t\tint\r\n\t\tdeclare @id_sysdiagrams\t\t\tint\r\n\t\tdeclare @id_helpdiagrams\t\tint\r\n\t\tdeclare @id_helpdiagramdefinition\tint\r\n\t\tdeclare @id_creatediagram\tint\r\n\t\tdeclare @id_renamediagram\tint\r\n\t\tdeclare @id_alterdiagram \tint \r\n\t\tdeclare @id_dropdiagram\t\tint\r\n\t\tdeclare @InstalledObjects\tint\r\n\r\n\t\tselect @InstalledObjects = 0\r\n\r\n\t\tselect \t@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),\r\n\t\t\t@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),\r\n\t\t\t@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),\r\n\t\t\t@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),\r\n\t\t\t@id_creatediagram = object_id(N'dbo.sp_creatediagram'),\r\n\t\t\t@id_renamediagram = object_id(N'dbo.sp_renamediagram'),\r\n\t\t\t@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), \r\n\t\t\t@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')\r\n\r\n\t\tif @id_upgraddiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 1\r\n\t\tif @id_sysdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 2\r\n\t\tif @id_helpdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 4\r\n\t\tif @id_helpdiagramdefinition is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 8\r\n\t\tif @id_creatediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 16\r\n\t\tif @id_renamediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 32\r\n\t\tif @id_alterdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 64\r\n\t\tif @id_dropdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 128\r\n\t\t\r\n\t\treturn @InstalledObjects \r\n\tEND\r\n\t", null, null, null, "dbo.fn_diagramobjects"), Recordset = new Recordset(), Source = dbSource }; var broker = new SqlDatabaseBroker(); var result = broker.TestService(serviceConn); Assert.AreEqual(OutputFormats.ShapedXML, result.Format); }
// ReSharper disable InconsistentNaming public void SqlDatabaseBroker_TestService_WindowsUserWithoutDbAccess_ReturnsInvalidResult() // ReSharper restore InconsistentNaming { Exception exception = null; Impersonator.RunAs("NoDBAccessTest", "DEV2", "One23456", () => { var dbSource = SqlServerTestUtils.CreateDev2TestingDbSource(AuthenticationType.Windows); var serviceConn = new DbService { ResourceID = Guid.NewGuid(), ResourceName = "DatabaseService", ResourceType = ResourceType.DbService, ResourcePath = "Test", AuthorRoles = "", Dependencies = new List <IResourceForTree>(), FilePath = null, IsUpgraded = true, Method = new ServiceMethod("dbo.fn_diagramobjects", "\r\n\tCREATE FUNCTION dbo.fn_diagramobjects() \r\n\tRETURNS int\r\n\tWITH EXECUTE AS N'dbo'\r\n\tAS\r\n\tBEGIN\r\n\t\tdeclare @id_upgraddiagrams\t\tint\r\n\t\tdeclare @id_sysdiagrams\t\t\tint\r\n\t\tdeclare @id_helpdiagrams\t\tint\r\n\t\tdeclare @id_helpdiagramdefinition\tint\r\n\t\tdeclare @id_creatediagram\tint\r\n\t\tdeclare @id_renamediagram\tint\r\n\t\tdeclare @id_alterdiagram \tint \r\n\t\tdeclare @id_dropdiagram\t\tint\r\n\t\tdeclare @InstalledObjects\tint\r\n\r\n\t\tselect @InstalledObjects = 0\r\n\r\n\t\tselect \t@id_upgraddiagrams = object_id(N'dbo.sp_upgraddiagrams'),\r\n\t\t\t@id_sysdiagrams = object_id(N'dbo.sysdiagrams'),\r\n\t\t\t@id_helpdiagrams = object_id(N'dbo.sp_helpdiagrams'),\r\n\t\t\t@id_helpdiagramdefinition = object_id(N'dbo.sp_helpdiagramdefinition'),\r\n\t\t\t@id_creatediagram = object_id(N'dbo.sp_creatediagram'),\r\n\t\t\t@id_renamediagram = object_id(N'dbo.sp_renamediagram'),\r\n\t\t\t@id_alterdiagram = object_id(N'dbo.sp_alterdiagram'), \r\n\t\t\t@id_dropdiagram = object_id(N'dbo.sp_dropdiagram')\r\n\r\n\t\tif @id_upgraddiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 1\r\n\t\tif @id_sysdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 2\r\n\t\tif @id_helpdiagrams is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 4\r\n\t\tif @id_helpdiagramdefinition is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 8\r\n\t\tif @id_creatediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 16\r\n\t\tif @id_renamediagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 32\r\n\t\tif @id_alterdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 64\r\n\t\tif @id_dropdiagram is not null\r\n\t\t\tselect @InstalledObjects = @InstalledObjects + 128\r\n\t\t\r\n\t\treturn @InstalledObjects \r\n\tEND\r\n\t", null, null, null, null), Recordset = new Recordset(), Source = dbSource }; var broker = new SqlDatabaseBroker(); try { broker.TestService(serviceConn); } catch (Exception ex) { // Need to do this because exceptions get swallowed by impersonator exception = ex; } Assert.IsNotNull(exception); Assert.IsInstanceOfType(exception, typeof(SqlException)); Assert.AreEqual("Login failed for user 'DEV2\\NoDBAccessTest'.", exception.Message); }); }