public override void WriteColumnChanges(ColumnModifications col) { Builder.AppendFormat("alter table {0} alter column {1} ", SqlServerProvider.EscapeIdentifier(col.TableName), SqlServerProvider.EscapeIdentifier(col.Current.Name)); _writer.Write(col); Builder.AppendLine(";"); }
public virtual void Write(ColumnModifications item) { _item = item; _item.Options.Use(Engine); Builder.AppendFormat("alter table {0} drop column {1}", Escape(item.TableName), Escape(item.Name)); WriteEndOptions(); Builder.AppendLine(";"); }
public override void WriteDropDefault(ColumnModifications col) { if (!col.Current.DefaultConstraintName.IsNullOrEmpty()) { Builder.AppendFormat("alter table {0} drop constraint {1};\n", SqlServerProvider.EscapeIdentifier(col.TableName), col.Current.DefaultConstraintName); } }
public virtual void Write(ColumnModifications col) { if (col.Type != null) { Builder.Append(GetType(col.Type.Value, col.Size)); } else { Builder.Append(col.Current.Type); } WriteCollation(col.Collation); if (col.Nullable != null) { WriteNullable(col.Nullable.Value); } WriteEndColumnOptions(col.Options); }
public ColumnEditor(string columnName, string table) { _columnName = columnName; _data = new ColumnModifications(columnName, table); }
protected override void WriteRenameColumn(ColumnModifications col) { throw new System.NotImplementedException(); }
public override void WriteSetDefault(ColumnModifications col) { Builder.AppendFormat("alter table {0} alter {1} set default '{2}';", MySqlProvider.EscapeIdentifier(col.TableName), MySqlProvider.EscapeIdentifier(col.Name), col.DefaultValue); }
public override void WriteDropDefault(ColumnModifications col) { Builder.AppendFormat("alter table {0} alter {1} drop default;", MySqlProvider.EscapeIdentifier(col.TableName), MySqlProvider.EscapeIdentifier(col.Name)); }
/// <summary> /// type, size,collate, null /// </summary> public override void WriteColumnChanges(ColumnModifications col) { throw new System.NotImplementedException(); }
public abstract void WriteSetDefault(ColumnModifications col);
/// <summary> /// type, size,collate, null /// </summary> public abstract void WriteColumnChanges(ColumnModifications col);
protected virtual bool ShouldDropDefault(ColumnModifications col) { return col.DefaultDropped; }
protected abstract void WriteRenameColumn(ColumnModifications col);
public IModifyTable WithoutOptions() { _dropped = null; return(_parent); }
public ISupportOptionsForDrop <IModifyColumns> Drop(string name) { _dropped = _table.ModifiedColumns[name].Modifications; _dropped.IsDropped = true; return(this); }
public override void WriteSetDefault(ColumnModifications col) { Builder.AppendFormat("alter table {0} add constraint {1} default ('{2}') for {3};\n", SqlServerProvider.EscapeIdentifier(col.TableName), string.Format("DF_{0}_{1}", col.TableName, col.Name), col.DefaultValue, col.Name); }
protected override bool ShouldDropDefault(ColumnModifications col) { return base.ShouldDropDefault(col) || col.HasChangedStructure || col.IsDropped; }
protected override void WriteRenameColumn(ColumnModifications col) { Builder.AppendFormat("exec sp_rename '{2}.{0}','{1}','COLUMN';\n", col.Current.Name, col.NewName, Table.Name); }
public override void WriteSetDefault(ColumnModifications col) { throw new System.NotImplementedException(); }
public ColumnEditor(string columnName,string table) { _columnName = columnName; _data = new ColumnModifications(columnName,table); }
public override void Write(ColumnModifications col) { col.Collation = null; base.Write(col); }
public override void WriteDropDefault(ColumnModifications col) { Builder.AppendFormat("alter table {0} alter {1} drop default;\n\r", col.TableName, col.Name); }
/// <summary> /// type, size,collate, null /// </summary> public override void WriteColumnChanges(ColumnModifications col) { var w = new MySqlColumnWriter(Builder); Builder.AppendFormat("alter table {0} modify ", MySqlProvider.EscapeIdentifier(col.Name)); w.Write(col); }
/// <summary> /// type, size,collate, null /// </summary> public override void WriteColumnChanges(ColumnModifications col) { var w = new PostgresColumnWriter(Builder); w.Write(col); }
protected override void WriteRenameColumn(ColumnModifications col) { Builder.AppendFormat("alter table {0} rename {1} to {2};\n\r",Escape(col.TableName),Escape(col.Current.Name),Escape(col.NewName)); }
public override void WriteSetDefault(ColumnModifications col) { Builder.AppendFormat("alter table {0} alter {1} set default {2};\n\r", col.TableName, col.Name, col.DefaultValue); }
protected override void WriteRenameColumn(ColumnModifications col) { Builder.AppendFormat("ALTER TABLE {0} CHANGE {1} {2}",Escape(col.TableName),Escape(col.Current.Name),col.Current.Definition.Replace(col.Current.Name,col.NewName)); Builder.AppendLine(";"); }
public override void WriteDropDefault(ColumnModifications col) { throw new NotImplementedException(); }