public static void AddIndex(this TransformationProvider database, string indexName, string tableName, params string[] columns)
{
ICreateIndexOnColumnSyntax builder = new CreateExpressionRoot(database.Context).Index(indexName)
.OnTable(tableName);
foreach (var column in columns)
{
builder = builder.OnColumn(column).Ascending();
}
}
public static void AddTable(this TransformationProvider database, string name, params Column[] columns)
{
var tableBuilder = new CreateExpressionRoot(database.Context).Table(name);
foreach (var column in columns)
{
var builder = tableBuilder.WithColumn(column.Name, column.Type, column.Size);
ColumnExtensions.ApplyColumnOptions(builder, column.ColumnProperty, column.DefaultValue);
}
}
public void CallingColumnReturnsCreateColumnExpression()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
var root = new CreateExpressionRoot(contextMock.Object);
var builder = root.Column("Bacon");
builder.ShouldBeOfType<CreateColumnExpressionBuilder>();
contextMock.VerifyGet(x => x.Expressions);
}
public void CallingForeignKeyCreatesCreateForeignKeyExpression()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.SetupGet(x => x.Expressions).Returns(collectionMock.Object).AtMostOnce();
var root = new CreateExpressionRoot(contextMock.Object);
var builder = root.ForeignKey("FK_Bacon");
builder.ShouldBeOfType<CreateForeignKeyExpressionBuilder>();
contextMock.VerifyAll();
}
public static void AddUniqueConstraint(this TransformationProvider database, string name, string table, params string[] columns)
{
var indexBuilder = new CreateExpressionRoot(database.Context).Index(name);
var tabledIndexBuilder = indexBuilder.OnTable(table);
foreach (string column in columns)
{
tabledIndexBuilder.OnColumn(column).Ascending();
}
tabledIndexBuilder.WithOptions().Unique();
}
public void CallingForeignKeyAddsCreateForeignKeyExpressionToContextWithSpecifiedNameSet()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
var root = new CreateExpressionRoot(contextMock.Object);
root.ForeignKey("FK_Bacon");
collectionMock.Verify(x => x.Add(It.Is<CreateForeignKeyExpression>(e => e.ForeignKey.Name.Equals("FK_Bacon"))));
contextMock.VerifyGet(x => x.Expressions);
}
public void CallingColumnAddsCreateColumnExpressionToContextWithSpecifiedNameSet()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
collectionMock.Setup(x => x.Add(It.Is<CreateColumnExpression>(e => e.Column.Name.Equals("Bacon")))).AtMostOnce();
var contextMock = new Mock<IMigrationContext>();
contextMock.SetupGet(x => x.Expressions).Returns(collectionMock.Object).AtMostOnce();
var root = new CreateExpressionRoot(contextMock.Object);
root.Column("Bacon");
collectionMock.VerifyAll();
contextMock.VerifyAll();
}
public void CallingIndexWithoutNameAddsCreateIndexExpressionToContext()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
var root = new CreateExpressionRoot(contextMock.Object);
root.Index();
collectionMock.Verify(x => x.Add(It.IsAny<CreateIndexExpression>()));
contextMock.VerifyGet(x => x.Expressions);
}
public void CallingForeignKeyWithoutNameReturnsCreateForeignKeyExpression()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
var root = new CreateExpressionRoot(contextMock.Object);
var builder = root.ForeignKey();
builder.ShouldBeOfType<CreateForeignKeyExpressionBuilder>();
contextMock.VerifyGet(x => x.Expressions);
}
public void CallingForeignKeyWithoutNameAddsCreateForeignKeyExpressionToContext()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
collectionMock.Setup(x => x.Add(It.IsAny<CreateForeignKeyExpression>())).AtMostOnce();
var contextMock = new Mock<IMigrationContext>();
contextMock.SetupGet(x => x.Expressions).Returns(collectionMock.Object).AtMostOnce();
var root = new CreateExpressionRoot(contextMock.Object);
root.ForeignKey();
collectionMock.VerifyAll();
contextMock.VerifyAll();
}
public void CallingIndexWithoutNameReturnsCreateIndexExpression()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.SetupGet(x => x.Expressions).Returns(collectionMock.Object).AtMostOnce();
var root = new CreateExpressionRoot(contextMock.Object);
var builder = root.Index();
builder.ShouldBeOfType<CreateIndexExpressionBuilder>();
contextMock.VerifyAll();
}
public void CallingUniqueConstraintShouldCreateAConstraintExpressionWithATypeOfUnique()
{
var contextMock = new Mock<IMigrationContext>();
var root = new CreateExpressionRoot(contextMock.Object);
var builder = root.UniqueConstraint();
builder.ShouldBeOfType<CreateConstraintExpression>();
}
public void CallingTableReturnsCreateTableExpressionBuilder()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
contextMock.VerifyGet(x => x.Expressions, Times.AtMostOnce());
var root = new CreateExpressionRoot(contextMock.Object);
var builder = root.Table("Bacon");
builder.ShouldBeOfType<CreateTableExpressionBuilder>();
contextMock.VerifyAll();
}
public void CallingIndexAddsCreateIndexExpressionToContextWithSpecifiedNameSet()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
collectionMock.Verify(x => x.Add(It.Is<CreateIndexExpression>(e => e.Index.Name.Equals("IX_Bacon"))), Times.AtMostOnce());
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
contextMock.VerifyGet(x => x.Expressions, Times.AtMostOnce());
var root = new CreateExpressionRoot(contextMock.Object);
root.Index("IX_Bacon");
collectionMock.VerifyAll();
contextMock.VerifyAll();
}
public void CallingUniqueConstraintCreateColumnExpressionToContextWithSpecifiedNameSet()
{
var collectionMock = new Mock<ICollection<IMigrationExpression>>();
var contextMock = new Mock<IMigrationContext>();
contextMock.Setup(x => x.Expressions).Returns(collectionMock.Object);
var root = new CreateExpressionRoot(contextMock.Object);
root.UniqueConstraint("UC_Bacon");
collectionMock.Verify(x => x.Add(It.Is<CreateConstraintExpression>(
e => e.Constraint.ConstraintName.Equals("UC_Bacon")
&& e.Constraint.IsUniqueConstraint
)));
contextMock.VerifyGet(x => x.Expressions);
}
