public void AlterIndexRebuild()
{
var statement = Sql.AlterIndex("if", "foo.bar").Rebuild();
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("REINDEX \"foo\".\"if\";", text);
}
public void AlterIndexReorg()
{
var statement = Sql.AlterIndex("if", "foo.bar").Reorganize();
var command = Utilities.GetCommand(statement);
Assert.IsNotNull(command);
Assert.AreEqual("ALTER INDEX [if] ON [foo].[bar] REORGANIZE;", command.CommandText);
}
public void AlterIndexDisable()
{
var statement = Sql.AlterIndex("if", "foo.bar").Disable();
var command = Utilities.GetCommand(statement);
Assert.IsNotNull(command);
Assert.AreEqual("ALTER INDEX [if] ON [foo].[bar] DISABLE;", command.CommandText);
}
public void AlterIndexRebuild()
{
var statement = Sql.AlterIndex("if", "foo.bar").Rebuild();
var command = Utilities.GetCommand(statement);
Assert.NotNull(command);
Assert.Equal("ALTER INDEX [if] ON [foo].[bar] REBUILD;", command.CommandText);
}
public void AlterIndex()
{
var statement = Sql.AlterIndex("if", "foo.bar")
.OnColumn("col1")
.OnColumn(Sql.Name("col2"), Direction.Desc)
;
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("DROP INDEX IF EXISTS \"if\";\r\nCREATE INDEX \"if\" ON \"foo\".\"bar\" ( \"col1\" ASC, \"col2\" DESC );", text);
}
public void AlterIndex()
{
var statement = Sql.AlterIndex("if", "test_db.test_select_tbl")
.OnColumn("number_value")
.OnColumn(Sql.Name("text_value"), Direction.Desc)
;
var text = Provider.GenerateStatement(statement);
Assert.IsNotNull(text);
Assert.AreEqual("DROP INDEX `if` ON `test_db`.`test_select_tbl`;\r\nCREATE INDEX `if` ON `test_db`.`test_select_tbl` ( `number_value` ASC, `text_value` DESC );", text);
}
