public void CreateDropIndexOperation_creates_operation_and_its_inverse()
{
var index = new ConsolidatedIndex("raS", "tut1", new IndexAttribute("pong", 0)
{
IsClustered = true, IsUnique = true
});
index.Add("tut2", new IndexAttribute("pong", 1));
var operation = index.CreateDropIndexOperation();
Assert.Equal("raS", operation.Table);
Assert.Equal("pong", operation.Name);
Assert.Equal(new List <string> {
"tut1", "tut2"
}, operation.Columns);
var inverse = (CreateIndexOperation)operation.Inverse;
Assert.Equal("raS", inverse.Table);
Assert.Equal("pong", inverse.Name);
Assert.Equal(new List <string> {
"tut1", "tut2"
}, inverse.Columns);
Assert.True(inverse.IsUnique);
Assert.True(inverse.IsClustered);
}
public void CreateDropIndexOperation_creates_operation_and_its_inverse_for_unnamed_index()
{
var index = new ConsolidatedIndex("raS", "tut", new IndexAttribute());
var operation = index.CreateDropIndexOperation();
Assert.Equal("raS", operation.Table);
Assert.Equal("IX_tut", operation.Name);
Assert.Equal(new List <string> {
"tut"
}, operation.Columns);
var inverse = (CreateIndexOperation)operation.Inverse;
Assert.Equal("raS", inverse.Table);
Assert.Equal("IX_tut", inverse.Name);
Assert.Equal(new List <string> {
"tut"
}, inverse.Columns);
Assert.False(inverse.IsUnique);
Assert.False(inverse.IsClustered);
}
public void CreateDropIndexOperation_creates_operation_and_its_inverse_for_unnamed_index()
{
var index = new ConsolidatedIndex("raS", "tut", new IndexAttribute());
var operation = index.CreateDropIndexOperation();
Assert.Equal("raS", operation.Table);
Assert.Equal("IX_tut", operation.Name);
Assert.Equal(new List<string> { "tut" }, operation.Columns);
var inverse = (CreateIndexOperation)operation.Inverse;
Assert.Equal("raS", inverse.Table);
Assert.Equal("IX_tut", inverse.Name);
Assert.Equal(new List<string> { "tut" }, inverse.Columns);
Assert.False(inverse.IsUnique);
Assert.False(inverse.IsClustered);
}
public void CreateDropIndexOperation_creates_operation_and_its_inverse()
{
var index = new ConsolidatedIndex("raS", "tut1", new IndexAttribute("pong", 0) { IsClustered = true, IsUnique = true });
index.Add("tut2", new IndexAttribute("pong", 1));
var operation = index.CreateDropIndexOperation();
Assert.Equal("raS", operation.Table);
Assert.Equal("pong", operation.Name);
Assert.Equal(new List<string> { "tut1", "tut2" }, operation.Columns);
var inverse = (CreateIndexOperation)operation.Inverse;
Assert.Equal("raS", inverse.Table);
Assert.Equal("pong", inverse.Name);
Assert.Equal(new List<string> { "tut1", "tut2" }, inverse.Columns);
Assert.True(inverse.IsUnique);
Assert.True(inverse.IsClustered);
}
