public void Upsert_OnSameManagerInstanceWhenClassHasOneNewMember_ColumnIsNotAddedToIndexesTable()
{
var hashForColumn = SisoDbEnvironment.MemberNameGenerator.Generate("IndexableMember2");
var manager = new SqlDbSchemaManager(_sqlDb.ConnectionInfo);
manager.UpsertStructureSet(_structureSchema);
DbHelper.DropColumns(_indexesTableName, hashForColumn);
manager.UpsertStructureSet(_structureSchema);
var columnExists = DbHelper.ColumnsExist(_indexesTableName, hashForColumn);
Assert.IsFalse(columnExists);
}
public void DropStructureSet_WhenTablesExists_AllTablesAreDropped()
{
var manager = new SqlDbSchemaManager(_sqlDb.ConnectionInfo);
manager.UpsertStructureSet(_structureSchema);
manager.DropStructureSet(_structureSchema);
var structureTableExists = DbHelper.TableExists(_structureTableName);
var indexesTableExists = DbHelper.TableExists(_indexesTableName);
Assert.IsFalse(structureTableExists);
Assert.IsFalse(indexesTableExists);
}
public void Upsert_OnNewManagerInstanceWhenDbHasOneObsoleteMember_ColumnIsDroppedFromIndexesTable()
{
var manager = new SqlDbSchemaManager(_sqlDb.ConnectionInfo);
manager.UpsertStructureSet(_structureSchema);
var hashForObsoleteColumn = SisoDbEnvironment.MemberNameGenerator.Generate("ExtraColumn");
var obsoleteColumnDefinition = string.Format("[{0}] [int] sparse null", hashForObsoleteColumn);
DbHelper.AddColumns(_indexesTableName, obsoleteColumnDefinition);
var manager2 = new SqlDbSchemaManager(_sqlDb.ConnectionInfo);
manager2.UpsertStructureSet(_structureSchema);
var columnExists = DbHelper.ColumnsExist(_indexesTableName, hashForObsoleteColumn);
Assert.IsFalse(columnExists);
}
public void Upsert_WhenNoSetExists_TablesAreCreated()
{
var manager = new SqlDbSchemaManager(_sqlDb.ConnectionInfo);
manager.UpsertStructureSet(_structureSchema);
var structureTableExists = DbHelper.TableExists(_structureTableName);
var indexesTableExists = DbHelper.TableExists(_indexesTableName);
Assert.IsTrue(structureTableExists);
Assert.IsTrue(indexesTableExists);
}
private void CreateStructureSet()
{
var manager = new SqlDbSchemaManager(_sqlDb.ConnectionInfo);
manager.UpsertStructureSet(_structureSchema);
}
