public void FixtureSetup()
{
var connection = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
var allSqlInfo = SqlAllInfo.SqlAllInfoFactory(connection);
_sqlInfos = allSqlInfo.TableInfos;
}
public void Test10CreateNewEfDatabase()
{
//SETUP
//EXECUTE
DatabaseCreators.DeleteAndCreateEfDatabase <TestEf6SchemaCompareDb>(MiscConstants.GetEfDatabaseConfigName(), true);
//VERIFY
}
public void Test30GetNonPrimaryKeyIndexesOk()
{
//SETUP
var connection = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
//EXECUTE
var result = SqlIndex.GetAllIndexes(connection);
//VERIFY
result.Count.ShouldBeGreaterThan(8);
}
public void Test20GetPrimaryKeysNamesOk()
{
//SETUP
var connection = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
//EXECUTE
var result = SqlPrimaryKey.GetPrimaryKeysNames(connection, typeof(DataManyCompKey).Name);
//VERIFY
result.Count.ShouldEqual(2);
}
public void Test10GetForeignKeysOk()
{
//SETUP
var connection = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
//EXECUTE
var result = SqlForeignKey.GetForeignKeys(connection);
//VERIFY
result.Count.ShouldBeGreaterThan(3);
}
public void Test01SqlTableAndColumnDataOk()
{
//SETUP
var connection = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
//EXECUTE
var result = SqlTableAndColumnData.GetSqlTablesAndColumns(connection);
//VERIFY
result.Count.ShouldBeGreaterThan(3);
}
public void Test01CheckDatabaseString()
{
//SETUP
//EXECUTE
var conStr =
MiscConstants.GetEfDatabaseConfigName().GetConnectionStringAndCheckValid();
//VERIFY
conStr.ShouldNotEqualNull();
}
public void Test20CompareSqlToSqlDbUpWithConfigLookupOk()
{
//SETUP
var comparer = new CompareSqlSql();
//EXECUTE
var status = comparer.CompareSqlToSql(MiscConstants.GetEfDatabaseConfigName(), MiscConstants.DbUpDatabaseConfigName);
//VERIFY
status.ShouldBeValid();
status.HasWarnings.ShouldEqual(false, string.Join("\n", status.Warnings));
}
public void Test01CompareSqlToSqlSelfOk()
{
//SETUP
var connection = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
var comparer = new CompareSqlSql();
//EXECUTE
var status = comparer.CompareSqlToSql(connection, connection);
//VERIFY
status.ShouldBeValid();
status.HasWarnings.ShouldEqual(false, string.Join("\n", status.Warnings));
}
public void Test10CompareSqlToSqlDbUpIndexAsWarningsOk()
{
//SETUP
var connection1 = ConfigurationManager.ConnectionStrings[MiscConstants.GetEfDatabaseConfigName()].ConnectionString;
var connection2 = ConfigurationManager.ConnectionStrings[MiscConstants.DbUpDatabaseConfigName].ConnectionString;
var comparer = new CompareSqlSql(false);
//EXECUTE
var status = comparer.CompareSqlToSql(connection1, connection2);
//VERIFY
status.ShouldBeValid();
foreach (var warning in status.Warnings)
{
Console.WriteLine(warning);
}
//status.HasWarnings.ShouldEqual(false, string.Join("\n", status.Warnings));
}
public void Test60EfCreatedDatabaseExists()
{
//SETUP
//EXECUTE
var ex =
Assert.Throws <InvalidOperationException>(
() =>
DatabaseCreators.DeleteAndCreateEfDatabase <TestEf6SchemaCompareDb>(MiscConstants.GetEfDatabaseConfigName()));
//VERIFY
ex.Message.ShouldEqual(
"You attempted to wipe the main database that your DbContext points to. To do this you must set the second parameter to this method to true.");
}
