public void Getforeignkeyconnections_should_return_table_tablesconnections_as_jason()
{
var foreignKeyColumn = new ForeignKeyColumn {Name = "foreignKeyColumn"};
var primaryKeyColumn = new PrimaryKeyColumn { Name = "primaryKeyColumn" };
var foreignKeys = new List<ForeignKey>
{
new ForeignKey
{
ForeignKeyTableName = "ForeignKeyTableName",
PrimaryKeyTableName = "PrimaryKeyTableName",
ForeignKeyColumns = new List<ForeignKeyColumn> { foreignKeyColumn },
PrimaryKeysColumns = new List<PrimaryKeyColumn>{ primaryKeyColumn}
}
};
_schemaReader.Expect(sr => sr.GetForeignKeys(Connectionstring)).Return(foreignKeys);
_connectionstringArgumentsMapperFactory = new ConnectionstringArgumentsMapperFactory();
_databaseExplorerController = new DatabaseExplorerController(_schemaReader, _connectionstringBuilder, _connectionstringArgumentsMapperFactory);
_databaseExplorerController.ControllerContext = new ControllerContext(_context, new RouteData(), _databaseExplorerController);
var result = _databaseExplorerController.GetForeignKeyConnections() as JsonResult;
Assert.IsNotNull(result);
var serializer = new JavaScriptSerializer();
var output = serializer.Serialize(result.Data);
Console.WriteLine(output);
Assert.AreEqual("[{\"Name\":null,\"OriginalName\":null,\"ForeignKeyTableName\":\"ForeignKeyTableName\",\"ForeignKeyTableSchema\":null,\"ForeignKeyColumns\":[{\"Name\":\"foreignKeyColumn\"}],\"PrimaryKeyTableName\":\"PrimaryKeyTableName\",\"PrimaryKeyTableSchema\":null,\"PrimaryKeysColumns\":[{\"Name\":\"primaryKeyColumn\"}]}]", output);
}
public DatabaseExplorerController(ISchemaReader schemaReader,
IConnectionstringBuilder connectionstringBuilder,
IConnectionstringArgumentsMapperFactory connectionstringArgumentsMapperFactory)
{
_schemaReader = schemaReader;
_connectionstringBuilder = connectionstringBuilder;
_connectionstringArgumentsMapperFactory = connectionstringArgumentsMapperFactory;
}
public void SetUp()
{
_session = MockRepository.GenerateStrictMock<HttpSessionStateBase>();
_session.Stub(s => s["Connectionstring"]).Return(Connectionstring);
_context = MockRepository.GenerateStrictMock<HttpContextBase>();
_context.Stub(c => c.Session).Return(_session);
_connectionstringBuilder = MockRepository.GenerateStub<IConnectionstringBuilder>();
_connectionstringBuilder.Expect(cb => cb.BuildConnectionString(Arg<IConnectionstringArguments>.Is.Anything)).Return(Connectionstring);
var sqlServerConnectionstringArgumentsMapper = new SqlServerConnectionstringArgumentsMapper();
_connectionstringArgumentsMapperFactory = MockRepository.GenerateStrictMock<IConnectionstringArgumentsMapperFactory>();
_connectionstringArgumentsMapperFactory.Expect(factory => factory.Make(Arg<string>.Is.Anything)).Return(sqlServerConnectionstringArgumentsMapper);
_schemaReader = MockRepository.GenerateStub<ISchemaReader>();
}
public void SetUp()
{
_connectionstringArgumentsMapperFactory = new ConnectionstringArgumentsMapperFactory();
}
