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