public virtual IReadOnlyList<IRelationalCommand> Generate(
IReadOnlyList<MigrationOperation> operations,
IModel model = null)
{
Check.NotNull(operations, nameof(operations));
var builder = new RelationalCommandListBuilder(_commandBuilderFactory);
foreach (var operation in operations)
{
Generate(operation, model, builder);
builder
.AppendLine(SqlGenerator.BatchCommandSeparator)
.EndCommand();
}
return builder.GetCommands();
}
protected override void Generate(
AlterColumnOperation operation,
IModel model,
RelationalCommandListBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
DropDefaultConstraint(operation.Schema, operation.Table, operation.Name, builder);
builder
.Append("ALTER TABLE ")
.Append(SqlGenerator.DelimitIdentifier(operation.Table, operation.Schema))
.Append(" ALTER COLUMN ");
ColumnDefinition(
operation.Schema,
operation.Table,
operation.Name,
operation.ClrType,
operation.ColumnType,
operation.IsNullable,
/*defaultValue:*/ null,
/*defaultValueSql:*/ null,
operation.ComputedColumnSql,
/*identity:*/ false,
operation,
model,
builder);
if (operation.DefaultValue != null
|| operation.DefaultValueSql != null)
{
builder
.AppendLine(";")
.Append("ALTER TABLE ")
.Append(SqlGenerator.DelimitIdentifier(operation.Table, operation.Schema))
.Append(" ADD");
DefaultValue(operation.DefaultValue, operation.DefaultValueSql, builder);
builder
.Append(" FOR ")
.Append(SqlGenerator.DelimitIdentifier(operation.Name));
}
}
protected override void Generate(
RenameTableOperation operation,
IModel model,
RelationalCommandListBuilder builder)
{
Check.NotNull(operation, nameof(operation));
Check.NotNull(builder, nameof(builder));
var separate = false;
var name = operation.Name;
if (operation.NewName != null)
{
var qualifiedName = new StringBuilder();
if (operation.Schema != null)
{
qualifiedName
.Append(operation.Schema)
.Append(".");
}
qualifiedName.Append(operation.Name);
Rename(qualifiedName.ToString(), operation.NewName, builder);
separate = true;
name = operation.NewName;
}
if (operation.NewSchema != null)
{
if (separate)
{
builder.AppendLine(SqlGenerator.BatchCommandSeparator);
}
Transfer(operation.NewSchema, operation.Schema, name, builder);
}
}