public void Should_throw_an_exception_when_databasetype_is_not_supported()
{
_connectionstringArgumentsMapper.Expect(cam => cam.Map(Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything))
.Throw(new DatabaseTypeException("DatabaseTypeException"));
_databaseSchemaExplorerController = new DatabaseSchemaExplorerController(_connectionstringArgumentsMapper, _databaseSchemaExplorer);
_databaseSchemaExplorerController.Tables("DatabaseType", "Provider", "DataSource", "DatabaseName", "TableName","Username", "Password");
}
public void Should_throw_an_exception_when_table_is_not_found()
{
const string tableName = "NotExsitingTable";
_connectionstringArgumentsMapper.Expect(csam => csam.Map(Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything, Arg<string>.Is.Anything)).Return(new SqlServerConnectionstringArguments());
_databaseSchemaExplorer.Expect(de => de.GetTable(Arg<IConnectionstringArguments>.Is.Anything, Arg<string>.Is.Anything)).Throw(new TableNotFoundException(tableName));
_databaseSchemaExplorerController = new DatabaseSchemaExplorerController(_connectionstringArgumentsMapper, _databaseSchemaExplorer);
_databaseSchemaExplorerController.Tables("DatabaseType", "Provider", "DataSource", "DatabaseName", tableName, "Username", "Password");
}
public void Should_be_able_to_get_a_list_of_tables_info()
{
var schemaReader = MockRepository.GenerateStub<ISchemaReader>();
schemaReader.Expect(sr => sr.GetTables(_connectionstring)).Return(new List<Table>());
var databaseSchemaExplorer = MockRepository.GenerateMock<IDatabaseSchemaExplorer>();
databaseSchemaExplorer.Expect(de => de.GetTables(Arg<IConnectionstringArguments>.Is.Anything)).Return(new List<Table>().AsQueryable());
_databaseSchemaExplorerController = new DatabaseSchemaExplorerController(_connectionstringArgumentsMapper, databaseSchemaExplorer);
var result = _databaseSchemaExplorerController.Tables("SqlServer", "Provider", "DataSource", "DatabaseName", "Username", "Password");
Assert.IsNotNull(result);
}
public void Should_be_able_to_get_a_table_info()
{
var schemaReader = MockRepository.GenerateStub<ISchemaReader>();
const string tableName = "tableName";
schemaReader.Expect(sr => sr.GetTable(_connectionstring, tableName)).Return(new Table(tableName));
var databaseSchemaExplorer = MockRepository.GenerateMock<IDatabaseSchemaExplorer>();
databaseSchemaExplorer.Expect(de => de.GetTable(Arg<IConnectionstringArguments>.Is.Anything, Arg<string>.Is.Anything)).Return(new Table("TableName"));
_databaseSchemaExplorerController = new DatabaseSchemaExplorerController(_connectionstringArgumentsMapper, databaseSchemaExplorer);
var table = _databaseSchemaExplorerController.Tables("SqlServer", "Provider", "DataSource", "DatabaseName", tableName, "Username", "Password");
Assert.IsNotNull(table);
}
