public override void CanAlterSchema()
{
var expression = new AlterSchemaExpression();
var result = _generator.Generate(expression);
result.ShouldBe(string.Empty);
}
public override string Generate(AlterSchemaExpression expression)
{
return(string.Format(
"ALTER TABLE {0} SET SCHEMA {1};",
Quoter.QuoteTableName(expression.TableName, expression.SourceSchemaName),
Quoter.QuoteSchemaName(expression.DestinationSchemaName)));
}
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 void ToSchema(string schemaName)
{
var alterSchema = new AlterSchemaExpression
{
SourceSchemaName = Expression.SchemaName,
TableName = Expression.TableName,
DestinationSchemaName = schemaName
};
_context.Expressions.Add(alterSchema);
}
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 TABLE \"SOURCE\".\"TABLE\" SET SCHEMA \"DEST\"");
}
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(compatabilityMode.HandleCompatabilty("AlterSchema is not supported in SqlAnywhere"));
}
public void Truncate(AlterSchemaExpression expression)
{
}
public override string Generate(AlterSchemaExpression expression)
{
return(String.Format(AlterSchema, Quoter.QuoteSchemaName(expression.DestinationSchemaName), Quoter.QuoteSchemaName(expression.SourceSchemaName), Quoter.QuoteTableName(expression.TableName)));
}
public override void Process(AlterSchemaExpression expression)
{
truncator.Truncate(expression);
RegisterExpression <AlterSchemaExpression>(expression);
InternalProcess(Generator.Generate(expression));
}
public abstract string Generate(AlterSchemaExpression expression);
public override string Generate(AlterSchemaExpression expression)
{
return(CompatibilityMode.HandleCompatibilty("Schemas are not supported"));
}
public override string Generate(AlterSchemaExpression expression)
{
throw new DatabaseOperationNotSupportedException();
}
public override string Generate(AlterSchemaExpression expression)
{
return(string.Format("ALTER TABLE {0}.{1} SET SCHEMA {2}", FormatSchema(expression.SourceSchemaName), FormatIdentifier(expression.TableName), FormatSchema(expression.DestinationSchemaName)));
}
public virtual void Process(AlterSchemaExpression expression)
{
Process(Generator.Generate(expression));
}
public override string Generate(AlterSchemaExpression expression)
{
throw new NotImplementedException();
}
