public void ShouldGenerateValidSqlForIndex()
{
var index = IndexBuilder.Create("IX_Category_ParentId")
.WithTable("Category")
.WithColumn("ParentId")
.Build();
var translator = new SqlGenerator();
translator.IndentSize = 2;
var actual = translator.Generate(index);
var expected =
"CREATE INDEX [IX_Category_ParentId] ON [Category] (" + Environment.NewLine +
" ParentId" + Environment.NewLine +
");";
Assert.Equal(expected, actual);
}
public void ShouldGenerateValidSqlForMultipleColumnsIndex()
{
var index = IndexBuilder.Create("UQ_Account_Name")
.WithTable("Account")
.WithColumn("Firstname")
.WithColumn("Lastname")
.Build();
var translator = new SqlGenerator();
translator.IndentSize = 2;
var actual = translator.Generate(index);
var expected =
"CREATE INDEX [UQ_Account_Name] ON [Account] (" + Environment.NewLine +
" Firstname," + Environment.NewLine +
" Lastname" + Environment.NewLine +
");";
Assert.Equal(expected, actual);
}
public void ShouldGenerateValidSqlForIndexWithExistsCheck()
{
var index = IndexBuilder.Create("IX_Category_Name")
.WithExistsCheck()
.Unique()
.WithTable("Category")
.WithColumn("Name")
.Build();
var translator = new SqlGenerator();
translator.IndentSize = 2;
var actual = translator.Generate(index);
var expected =
"CREATE UNIQUE INDEX IF NOT EXISTS [IX_Category_Name] ON [Category] (" + Environment.NewLine +
" Name" + Environment.NewLine +
");";
Assert.Equal(expected, actual);
}
