public override string Generate(RenameColumnExpression expression) { // may need to add definition to end. blerg //return String.Format("ALTER TABLE `{0}` CHANGE COLUMN {1} {2}", expression.TableName, expression.OldName, expression.NewName); // NOTE: The above does not work, as the CHANGE COLUMN syntax in Mysql requires the column definition to be re-specified, // even if it has not changed; so marking this as not working for now return compatabilityMode.HandleCompatabilty("Renaming of columns is not supporteed for MySql"); }
public void ReverseSetsTableNameOldNameAndNewNameOnGeneratedExpression() { var expression = new RenameColumnExpression { TableName = "Bacon", OldName = "BaconId", NewName = "ChunkyBaconId" }; var reverse = expression.Reverse() as RenameColumnExpression; reverse.TableName.ShouldBe("Bacon"); reverse.OldName.ShouldBe("ChunkyBaconId"); reverse.NewName.ShouldBe("BaconId"); }
public override string Generate(RenameColumnExpression expression) { // may need to add definition to end. blerg return FormatExpression("ALTER TABLE {0} CHANGE COLUMN {1} {2}", expression.TableName, expression.OldName, expression.NewName); }
public override string Generate(RenameColumnExpression expression) { return string.Format("sp_rename '{0}", base.Generate(expression)); }
public void ReverseReturnsRenameColumnExpression() { var expression = new RenameColumnExpression { TableName = "Bacon", OldName = "BaconId", NewName = "ChunkyBaconId" }; var reverse = expression.Reverse(); reverse.ShouldBeOfType<RenameColumnExpression>(); }
public override string Generate(RenameColumnExpression expression) { return String.Format("ALTER TABLE {0} RENAME COLUMN {1} TO {2}", expression.TableName, expression.OldName, expression.NewName); }
public override string Generate(RenameColumnExpression expression) { truncator.Truncate(expression); return base.Generate(expression); }
public virtual void Process(RenameColumnExpression expression) { Process(Generator.Generate(expression)); }
public override string Generate(RenameColumnExpression expression) { return string.Format("ALTER TABLE {0}.{1} RENAME COLUMN {2} TO {3}", Quoter.QuoteSchemaName(expression.SchemaName), Quoter.QuoteTableName(expression.TableName), Quoter.QuoteColumnName(expression.OldName), Quoter.QuoteColumnName(expression.NewName)); }
public void ToStringIsDescriptive() { var expression = new RenameColumnExpression { TableName = "Bacon", OldName = "BaconId", NewName = "ChunkyBaconId" }; expression.ToString().ShouldBe("RenameColumn Bacon BaconId to ChunkyBaconId"); }
public void CanRenameColumn() { var expression = new RenameColumnExpression(); expression.TableName = "Table1"; expression.OldName = "Column1"; expression.NewName = "Column2"; string sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE \"public\".\"Table1\" RENAME COLUMN \"Column1\" TO \"Column2\""); }
public override string Generate(RenameColumnExpression expression) { throw new NotImplementedException("Sqlite does not support renaming of columns in a safe way"); }
public override string Generate(RenameColumnExpression expression) { return compatabilityMode.HandleCompatabilty("Sqlite does not support renaming of columns"); }
public override string Generate(RenameColumnExpression expression) { throw new DatabaseOperationNotSupportedException(); }
public override string Generate(RenameColumnExpression expression) { return FormatExpression("sp_rename '[{0}].[{1}]', [{2}]", expression.TableName, expression.OldName, expression.NewName); }
public override string Generate(RenameColumnExpression expression) { // may need to add definition to end. blerg //return String.Format("ALTER TABLE `{0}` CHANGE COLUMN {1} {2}", expression.TableName, expression.OldName, expression.NewName); // NOTE: The above does not work, as the CHANGE COLUMN syntax in Mysql requires the column definition to be re-specified, // even if it has not changed; so marking this as not working for now throw new NotImplementedException(); }
public IRenameColumnTableSyntax Column(string oldName) { var expression = new RenameColumnExpression { OldName = oldName }; _context.Expressions.Add(expression); return new RenameColumnExpressionBuilder(expression); }
public override string Generate(RenameColumnExpression expression) { return String.Format("sp_rename '{0}[{1}].[{2}]', '{3}'", FormatSchema(expression.SchemaName, false), FormatSqlEscape(expression.TableName), FormatSqlEscape(expression.OldName), FormatSqlEscape(expression.NewName)); }
public abstract string Generate(RenameColumnExpression expression);
public override string Generate(RenameColumnExpression expression) { return string.Format("sp_rename '{0}.{1}", Quoter.QuoteSchemaName(expression.SchemaName), base.Generate(expression)); }
public void Truncate(RenameColumnExpression expression) { expression.OldName = Truncate(expression.OldName); expression.NewName = Truncate(expression.NewName); expression.TableName = Truncate(expression.TableName); }
public override string Generate(RenameColumnExpression expression) { return compatabilityMode.HandleCompatabilty("Renaming of columns is not supporteed for MySql"); }
public override string Generate(RenameColumnExpression expression) { return String.Format(RenameColumn, Quoter.QuoteTableName(expression.TableName), Quoter.QuoteColumnName(Quoter.QuoteCommand(expression.OldName)), Quoter.QuoteCommand(expression.NewName)); }
public void CanRenameColumn() { var expression = new RenameColumnExpression(); expression.TableName = "Table1"; expression.OldName = "Column1"; expression.NewName = "Column2"; var sql = generator.Generate(expression); sql.ShouldBe("sp_rename '[Table1].[Column1]', [Column2]"); }
public override string Generate(RenameColumnExpression expression) { throw new System.NotImplementedException(); }
public void ErrorIsReturnedWhenNewNameIsEmptyString() { var expression = new RenameColumnExpression { NewName = String.Empty }; var errors = ValidationHelper.CollectErrors(expression); errors.ShouldContain(ErrorMessages.NewColumnNameCannotBeNullOrEmpty); }
public override string Generate(RenameColumnExpression expression) { return String.Format(RenameColumn, expression.TableName, expression.OldName, expression.NewName); }
public void ErrorIsReturnedWhenOldNameIsNull() { var expression = new RenameColumnExpression { OldName = null }; var errors = ValidationHelper.CollectErrors(expression); errors.ShouldContain(ErrorMessages.OldColumnNameCannotBeNullOrEmpty); }
public void CanRenameColumn() { var expression = new RenameColumnExpression(); expression.TableName = "Table1"; expression.OldName = "Column1"; expression.NewName = "Column2"; var sql = generator.Generate(expression); // MySql does not appear to have a way to change column without re-specifying the existing column definition sql.ShouldBe("ALTER TABLE `Table1` CHANGE COLUMN `Column1` `Column2` EXISTING_DEFINITION_HERE"); }
public override string Generate(RenameColumnExpression expression) { return FormatExpression("sp_rename '{0}[{1}].[{2}]', [{3}]", FormatSchema(expression.SchemaName, false), expression.TableName, expression.OldName, expression.NewName); }