public void CanAlterSchema()
{
var expression = new AlterSchemaExpression
{
DestinationSchemaName = "DEST",
SourceSchemaName = "SOURCE",
TableName = "TABLE"
};
generator.Generate(expression);
}
public void CanAlterSchema()
{
var expression = new AlterSchemaExpression
{
DestinationSchemaName = "DEST",
SourceSchemaName = "SOURCE",
TableName = "TABLE"
};
var sql = generator.Generate( expression );
sql.ShouldBe(
"ALTER SCHEMA [DEST] TRANSFER [SOURCE].[TABLE]" );
}
public override string Generate(AlterSchemaExpression expression)
{
return string.Format("ALTER TABLE {0}.{1} SET SCHEMA {2}", Quoter.QuoteSchemaName(expression.SourceSchemaName), Quoter.QuoteTableName(expression.TableName), Quoter.QuoteSchemaName(expression.DestinationSchemaName));
}
public override string Generate(AlterSchemaExpression expression)
{
throw new DatabaseOperationNotSupportedExecption();
}
public void Process(AlterSchemaExpression expression)
{
Process(Generator.Generate(expression));
}
public override string Generate( AlterSchemaExpression expression )
{
throw new NotImplementedException();
}
public void Truncate(AlterSchemaExpression expression) { }
public void CanAlterSchema()
{
var expression = new AlterSchemaExpression
{
DestinationSchemaName = "DEST",
SourceSchemaName = "SOURCE",
TableName = "TABLE"
};
var sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE \"SOURCE\".\"TABLE\" SET SCHEMA \"DEST\"");
}
public override string Generate(AlterSchemaExpression expression)
{
return String.Format(AlterSchema, Quoter.QuoteSchemaName(expression.DestinationSchemaName), Quoter.QuoteSchemaName(expression.SourceSchemaName), Quoter.QuoteTableName(expression.TableName));
}
public void ToStringIsDescriptive()
{
var expression = new AlterSchemaExpression { TableName = "Test", DestinationSchemaName = "Bacon" };
expression.ToString().ShouldBe("AlterSchema Bacon Table Test");
}
public void ErrorIsNotReturnedWhenDestinationSchemaNameIsNotNullEmptyString()
{
var expression = new AlterSchemaExpression { DestinationSchemaName = "Bacon" };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldNotContain(ErrorMessages.DestinationSchemaCannotBeNull);
}
public void ErrorIsReturnedWhenDestinationSchemaNameIsNull()
{
var expression = new AlterSchemaExpression { DestinationSchemaName = null };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.DestinationSchemaCannotBeNull);
}
public void ErrorIsReturnedWhenTableNameIsEmptyString()
{
var expression = new AlterSchemaExpression { TableName = String.Empty };
var errors = ValidationHelper.CollectErrors(expression);
errors.ShouldContain(ErrorMessages.TableNameCannotBeNullOrEmpty);
}
public override string Generate( AlterSchemaExpression expression )
{
return String.Format("ALTER SCHEMA [{0}] TRANSFER {1}[{2}]", expression.DestinationSchemaName, FormatSchema(expression.SourceSchemaName), expression.TableName );
}
public override string Generate(AlterSchemaExpression expression)
{
return compatabilityMode.HandleCompatabilty("Schemas are not supported");
}
public override void CanAlterSchema()
{
var expression = new AlterSchemaExpression();
var result = generator.Generate(expression);
result.ShouldBe(string.Empty);
}
public abstract string Generate(AlterSchemaExpression expression);
