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