public SqlDbSchemaUpserter(SqlDbClient dbClient)
{
_dbClient = dbClient;
_structuresDbSchemaBuilder = new SqlDbStructuresSchemaBuilder(_dbClient.SqlStrings);
_indexesDbSchemaBuilder = new SqlDbIndexesSchemaBuilder(_dbClient.SqlStrings, _dbClient.ProviderType);
_uniquesDbSchemaBuilder = new SqlDbUniquesSchemaBuilder(_dbClient.SqlStrings);
_indexesDbSchemaSynchronizer = new SqlDbIndexesSchemaSynchronizer(_dbClient);
_uniquesDbSchemaSynchronizer = new SqlDbUniquesSchemaSynchronizer(_dbClient);
}
public void Synhronize_WhenTableIsMissingColumn_ColumnIsAdded()
{
CreateStructureSet();
var hashForColumn = SisoDbEnvironment.MemberNameGenerator.Generate("IndexableMember2");
DbHelper.DropColumns(_indexesTableName, hashForColumn);
using (var dbClient = new SqlDbClient(_sqlDb.ConnectionInfo, false))
{
var synhronizer = new SqlDbIndexesSchemaSynchronizer(dbClient);
synhronizer.Synchronize(_structureSchema);
}
var columnExists = DbHelper.ColumnsExist(_indexesTableName, hashForColumn);
Assert.IsTrue(columnExists);
}
public void Synhronize_WhenTableHasObsoleteColumn_ColumnIsDropped()
{
CreateStructureSet();
var hashForObsoleteColumn = SisoDbEnvironment.HashService.GenerateHash("ExtraColumn");
var obsoleteColumnDefinition = string.Format("[{0}] [int] sparse null", hashForObsoleteColumn);
DbHelper.AddColumns(_indexesTableName, obsoleteColumnDefinition);
using (var dbClient = new SqlDbClient(_sqlDb.ConnectionInfo, false))
{
var synhronizer = new SqlDbIndexesSchemaSynchronizer(dbClient);
synhronizer.Synchronize(_structureSchema);
}
var columnExists = DbHelper.ColumnsExist(_indexesTableName, hashForObsoleteColumn);
Assert.IsFalse(columnExists);
}
