public void FailIfWrongFieldLabeled()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Categories>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False);
}
public void SucceedIfEverythingMatches()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Suppliers>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.True);
}
public void FailIfIncrementDoesNotMatch()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Shippers>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False);
}
public void FailIfSeedDoesNotMatch()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Employees>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False);
}
public void ShouldSatisfyWhenClassRepresentsTablePresent()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Categories>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.True, "database did not satisfy dataspec");
}
public void ShouldSatisfyIfColumnAllowNullsDoesMatch()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Shippers>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.True, "database didn't satisfy dataspec, when should've, due to correct AllowNulls");
}
public void ShouldNotSatisfyWhenClassRepresentsTableNotPresent()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<DummyClass>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False, "database satisfied dataspec, when shouldn't");
}
public void ShouldNotSatisfyIfColumnAllowNullsDoesNotMatch()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Categories>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False, "database satisfied dataspec, when shouldn't, due to incorrect AllowNulls");
}
public void ShouldSatisfyIfAllColumnsPresentInDb()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Region>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.True, "database didn't satisfy dataspec, all column names present");
}
public void ShouldNotSatisfyIfColumnNotPresentInDb()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<Categories>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False, "database satisfied dataspec, when shouldn't, due to incorrect column names");
}
public void WhenMultipleTablesAddedIfOneNotPresentInDBTestShouldFail()
{
var dataspec = new DatabaseSpec();
dataspec.AddSchema<DummyClass>();
dataspec.AddSchema<Categories>();
var database = new Database(ConnectionString);
Assert.That(database.Satisfies(dataspec), Is.False, "database satisfied dataspec, when shouldn't");
}
public bool Satisfies(DatabaseSpec dataspec)
{
GetSchemaInformation();
return VerifySchema(dataspec);
}
private bool VerifySchema(DatabaseSpec dataspec)
{
foreach (Table specifiedTable in dataspec.Tables)
{
//var existingTable = _otherTables.SingleOrDefault(x=> x.Key == specifiedTable.Name);
if (!_otherTables.ContainsKey(specifiedTable.Name)) return false;
if (!VerifyColumns(specifiedTable, _otherTables[specifiedTable.Name])) return false;
}
return true;
}
