public void CanRenameTable()
{
var expression = new RenameTableExpression();
expression.SchemaName = "dbo";
expression.OldName = "Table1";
expression.NewName = "Table2";
var sql = generator.Generate( expression );
sql.ShouldBe( "sp_rename '[dbo].[Table1]', 'Table2'" );
}
public IRenameTableToOrInSchemaSyntax Table(string oldName)
{
var expression = new RenameTableExpression { OldName = oldName };
_context.Expressions.Add(expression);
return new RenameTableExpressionBuilder(expression);
}
public override string Generate(RenameTableExpression expression)
{
truncator.Truncate(expression);
return compatabilityMode.HandleCompatabilty("Rename table is not supported");
}
public override string Generate(RenameTableExpression expression)
{
return String.Format(RenameTable, Quoter.QuoteTableName(expression.OldName), Quoter.QuoteTableName(expression.NewName));
}
public override string Generate(RenameTableExpression expression)
{
return string.Format("ALTER TABLE {0}.{1} RENAME TO {2}", Quoter.QuoteSchemaName(expression.SchemaName), Quoter.QuoteTableName(expression.OldName), Quoter.QuoteTableName(expression.NewName));
}
public virtual void Process(RenameTableExpression expression)
{
Process(Generator.Generate(expression));
}
public void Truncate(RenameTableExpression expression)
{
expression.OldName = Truncate(expression.OldName);
expression.NewName = Truncate(expression.NewName);
}
public abstract string Generate(RenameTableExpression expression);
public void ErrorIsReturnedWhenNewNameIsEmptyString()
{
var expression = new RenameTableExpression { NewName = String.Empty };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.NewTableNameCannotBeNullOrEmpty);
}
public void ErrorIsNotReturnedWhenOldNameIsNotNullEmptyString()
{
var expression = new RenameTableExpression { OldName = "Bacon" };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldNotContain(ErrorMessages.OldTableNameCannotBeNullOrEmpty);
}
public void ToStringIsDescriptive()
{
var expression = new RenameTableExpression { OldName = "Bacon", NewName = "ChunkyBacon" };
expression.ToString().ShouldBe("RenameTable Bacon ChunkyBacon");
}
public override string Generate(RenameTableExpression expression)
{
return String.Format("sp_rename '{0}[{1}]', '{2}'", FormatSchema( expression.SchemaName ), expression.OldName, FormatSqlEscape(expression.NewName));
}
public override string Generate(RenameTableExpression expression)
{
return String.Format("sp_rename {0}, {1}", Quoter.QuoteValue(expression.OldName), Quoter.QuoteValue(expression.NewName));
}
public override string Generate(RenameTableExpression expression)
{
return FormatExpression("sp_rename [{0}], [{1}]", expression.OldName, expression.NewName);
}
public override string Generate(RenameTableExpression expression)
{
return String.Format("RENAME TABLE `{0}` TO `{1}`", expression.OldName, expression.NewName);
}
public void CanRenameTable()
{
var expression = new RenameTableExpression();
expression.OldName = "Table1";
expression.NewName = "Table2";
var sql = generator.Generate(expression);
sql.ShouldBe("sp_rename [Table1], [Table2]");
}
public void CanRenameTable()
{
RenameTableExpression expression = new RenameTableExpression { OldName = oldTable, NewName = newTable };
string sql = generator.Generate(expression);
sql.ShouldBe(string.Format("ALTER TABLE [{0}] RENAME TO [{1}]", oldTable, newTable));
}
public void ErrorIsReturnedWhenOldNameIsNull()
{
var expression = new RenameTableExpression { OldName = null };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.OldTableNameCannotBeNullOrEmpty);
}
public void CanRenameTable()
{
var expression = new RenameTableExpression();
expression.OldName = "Table1";
expression.NewName = "Table2";
string sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE \"public\".\"Table1\" RENAME TO \"Table2\"");
}
public void ReverseReturnsRenameTableExpression()
{
var expression = new RenameTableExpression { OldName = "Bacon", NewName = "ChunkyBacon" };
var reverse = expression.Reverse();
reverse.ShouldBeOfType<RenameTableExpression>();
}
public static RenameTableExpression GetRenameTableExpression()
{
var expression = new RenameTableExpression();
expression.OldName = TestTableName1;
expression.NewName = TestTableName2;
return expression;
}
public void ReverseSetsOldNameAndNewNameOnGeneratedExpression()
{
var expression = new RenameTableExpression { OldName = "Bacon", NewName = "ChunkyBacon" };
var reverse = expression.Reverse() as RenameTableExpression;
reverse.OldName.ShouldBe("ChunkyBacon");
reverse.NewName.ShouldBe("Bacon");
}
public override string Generate(RenameTableExpression expression)
{
return FormatExpression("sp_rename '{0}[{1}]', '[{2}]'", FormatSchema( expression.SchemaName ), expression.OldName, expression.NewName);
}
public void CanRenameTable()
{
var expression = new RenameTableExpression();
expression.OldName = "Table1";
expression.NewName = "Table2";
string sql = generator.Generate(expression);
sql.ShouldBe(String.Empty);
}
public override string Generate(RenameTableExpression expression)
{
return String.Format("ALTER TABLE {0} RENAME TO {1}", expression.OldName, expression.NewName);
}
public override string Generate(RenameTableExpression expression)
{
return FormatExpression("RENAME TABLE {0} TO {1}", expression.OldName, expression.NewName);
}
public override string Generate(RenameTableExpression expression)
{
return string.Format("sp_rename '{0}.{1}", Quoter.QuoteSchemaName(expression.SchemaName), base.Generate(expression));
}
public override string Generate(RenameTableExpression expression)
{
return compatabilityMode.HandleCompatabilty("Renaming of tables is not supporteed for MySql");
}
public void CanRenameTable()
{
var expression = new RenameTableExpression();
expression.OldName = "Table1";
expression.NewName = "Table2";
var sql = generator.Generate(expression);
sql.ShouldBe("RENAME TABLE `Table1` TO `Table2`");
}
public override string Generate(RenameTableExpression expression)
{
return string.Format("ALTER TABLE {0}.{1} RENAME TO {2}", FormatSchema(expression.SchemaName), FormatIdentifier(expression.OldName), FormatIdentifier(expression.NewName));
}