public virtual ServiceMethodList FetchMethods(DbSource dbSource)
{
switch (dbSource.ServerType)
{
case enSourceType.MySqlDatabase:
{
var broker = new MySqlDatabaseBroker();
return(broker.GetServiceMethods(dbSource));
}
case enSourceType.PostgreSQL:
{
var broker = new PostgreSqlDataBaseBroker();
return(broker.GetServiceMethods(dbSource));
}
case enSourceType.Oracle:
{
var broker = new OracleDatabaseBroker();
return(broker.GetServiceMethods(dbSource));
}
case enSourceType.SQLiteDatabase:
{
var broker = new SqliteDatabaseBroker();
return(broker.GetServiceMethods(dbSource));
}
default:
{
var broker = new SqlDatabaseBroker();
return(broker.GetServiceMethods(dbSource));
}
}
}
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);
}
// ReSharper disable InconsistentNaming
public void SqlDatabaseBroker_GetServiceMethods_SqlUserWithInvalidUsername_ThrowsLoginFailedException()
// ReSharper restore InconsistentNaming
{
var dbSource = SqlServerTests.CreateDev2TestingDbSource();
dbSource.UserID = "Billy.Jane";
dbSource.Password = "******";
var broker = new SqlDatabaseBroker();
broker.GetServiceMethods(dbSource);
}
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);
});
}
// ReSharper disable InconsistentNaming
public void SqlDatabaseBroker_GetServiceMethods_WindowsUserWithDbAccess_GetsMethods()
// ReSharper restore InconsistentNaming
{
Impersonator.RunAs("IntegrationTester", "DEV2", "I73573r0", () =>
{
var dbSource = SqlServerTests.CreateDev2TestingDbSource(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 = SqlServerTests.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);
}
});
}
// ReSharper disable InconsistentNaming
public void SqlDatabaseBroker_GetServiceMethods_WindowsUserWithoutDbAccess_ThrowsLoginFailedException()
// ReSharper restore InconsistentNaming
{
Impersonator.RunAs("NoDBAccessTest", "DEV2", "One23456", () =>
{
var dbSource = SqlServerTests.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);
}
});
}
// ReSharper disable InconsistentNaming
public void SqlDatabaseBroker_GetServiceMethods_SqlUserWithValidUsername_GetsMethods()
// ReSharper restore InconsistentNaming
{
var dbSource = SqlServerTests.CreateDev2TestingDbSource();
var broker = new SqlDatabaseBroker();
var result = broker.GetServiceMethods(dbSource);
Assert.AreEqual(true, result.Count > 0);
}
