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); }