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