public void When_TableExists_is_executed_and_table_does_notexists_Should_return_false()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
target.BuildStructure();
// act
var tableExists = client.TableExists("Test666");
// assert
tableExists.Should().BeFalse();
}
public void BuildStructureWithDifferentConnectionNameTest()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "SchemaDatabaseDevelopment";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.Should().HaveCount(8); // TestClassGenerator heeft nu 6 tabellen
target.Tables.First(x => x.Name == "Test6").PrimaryKey.Should().Be("Test6Id");
}
public void When_GetTypedCommaFields_executed_on_table_Should_return_a_string_with_all_ColumnNames_concatenated()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "SchemaDatabaseDevelopment";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
target.BuildStructure();
var table = target.Tables.First(x => x.Name == "Test5");
var columnNameList = new List <string> {
"naam", "Omschrijving"
};
// act
var columnString = table.ColumnDataItems.GetFieldNamesAsParameters(columnNameList);
// assert
columnString.Should().Be("string naam, string omschrijving");
}
public void BuildStructureTest()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.Should().HaveCount(8); // TestClassGenerator has 7 tables
}
public void When_BuildStructure_of_hMailServer_Should_generate_structure()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "hMailServer";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.Should().HaveCount(34); // hmailserver contains 34 tables
}
public void BuildStructureWithDBMenuConnectionName()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "TestClassGenerator";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.First(x => x.Name == "TestInt").HasGuidId.Should().BeTrue();
}
public void BuildStructureWithBlockedHackersConnectionName()
{
// arrange
var di = DependencyInjectionFactory.ConfigureDependencyInjection();
var clientConfig = di.GetService <IClientConfig>();
if (!clientConfig.IsAssigned())
{
throw new Exception("clientconfig not returned by dependency injection");
}
clientConfig.DefaultDatabase = "BlockedHackers";
var client = new SqlClient(new SqlClientRepository(clientConfig));
IDatabaseStructure target = new DatabaseStructure(client);
// act
target.BuildStructure();
// assert
target.Tables.First(x => x.Name == "Blocked").PrimaryKey.Should().Be("BlockedId");
}
