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 void Displaytable_should_return_table_partial_view() { const string tableName = "tableName"; var table = new Table(tableName); _schemaReader.Expect(sr => sr.GetTable(Arg<string>.Is.Anything, Arg<string>.Is.Anything)).Return(table); _databaseExplorerController = new DatabaseExplorerController(_schemaReader, _connectionstringBuilder, _connectionstringArgumentsMapperFactory); _databaseExplorerController.ControllerContext = new ControllerContext(_context, new RouteData(),_databaseExplorerController ); var result = _databaseExplorerController.DisplayTable(tableName); Assert.IsNotNull(result); Assert.AreEqual("Table", result.ViewName); Assert.IsInstanceOf<Table>(result.ViewData.Model); Assert.AreEqual(table.Name, ((Table)result.ViewData.Model).Name); }
public void Should_use_connectionstringargumentsmapperfactory_to_make_aconnectionstringargumentmapper() { const string databaseType = "Access"; _databaseExplorerController = new DatabaseExplorerController(_schemaReader, _connectionstringBuilder, _connectionstringArgumentsMapperFactory); _databaseExplorerController.GetTablesList(new DatabaseConnection{ DatabaseType = databaseType}); _connectionstringArgumentsMapperFactory.AssertWasCalled(factory => factory.Make(databaseType)); }