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