public void ShouldSetPropertiesForRemoveExtendedProperty()
{
//For Schema
var op = new RemoveExtendedPropertyOperation(SchemaName, Name);
Assert.AreEqual(true, op.ForSchema);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(Name, op.Name);
Assert.That(op.TableViewObjectName, Is.Empty);
//For Table
op = new RemoveExtendedPropertyOperation(SchemaName, TableName, Name, false);
Assert.AreEqual(true, op.ForTable);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(TableName, op.TableViewName);
Assert.AreEqual(Name, op.Name);
Assert.That(op.TableViewObjectName, Is.EqualTo($"{SchemaName}.{TableName}"));
//For View
op = new RemoveExtendedPropertyOperation(SchemaName, ViewName, Name, true);
Assert.AreEqual(true, op.ForView);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(ViewName, op.TableViewName);
Assert.AreEqual(Name, op.Name);
Assert.That(op.TableViewObjectName, Is.EqualTo($"{SchemaName}.{ViewName}"));
//For Column
op = new RemoveExtendedPropertyOperation(SchemaName, TableName, ColumnName, Name, false);
Assert.AreEqual(true, op.ForColumn);
Assert.AreEqual(SchemaName, op.SchemaName);
Assert.AreEqual(TableName, op.TableViewName);
Assert.AreEqual(ColumnName, op.ColumnName);
Assert.AreEqual(Name, op.Name);
Assert.That(op.TableViewObjectName, Is.EqualTo($"{SchemaName}.{TableName}"));
}
private void GivenSchemaProperty()
{
var schemaName = Guid.NewGuid().ToString();
var name = Guid.NewGuid().ToString();
_op = new RemoveExtendedPropertyOperation(schemaName, name);
}
public void ShouldDisableAddSchemaPropertyIfRemovedByMerge()
{
var op = new AddExtendedPropertyOperation("schema", "name", "value");
var removeOp = new RemoveExtendedPropertyOperation("SCHEMA", "NAME");
op.Merge(removeOp);
Assert.That(op.Disabled, Is.True);
Assert.That(removeOp.Disabled, Is.True);
}
public void ShouldDisableAddViewOrTablePropertyIfRemovedByMerge(bool forView)
{
var op = new AddExtendedPropertyOperation("schema", "tableOrView", "name", "value", forView);
var removeOp = new RemoveExtendedPropertyOperation("SCHEMA", "TABLEORVIEW", "NAME", forView);
op.Merge(removeOp);
Assert.That(op.Disabled, Is.True);
Assert.That(removeOp.Disabled, Is.True);
}
public void ShouldRemoveIfRemovingSchemaPropertyAndSchemaGettingRemoved()
{
var op = new RemoveExtendedPropertyOperation("schema", "name");
var removeSchemaOp = new RemoveSchemaOperation("SCHEMA");
op.Merge(removeSchemaOp);
Assert.That(op.Disabled, Is.True);
Assert.That(removeSchemaOp.Disabled, Is.False);
}
private void GivenViewColumnProperty()
{
var schemaName = Guid.NewGuid().ToString();
var viewName = Guid.NewGuid().ToString();
var columnName = Guid.NewGuid().ToString();
var name = Guid.NewGuid().ToString();
_op = new RemoveExtendedPropertyOperation(schemaName, viewName, columnName, name, true);
}
private void GivenTableColumnProperty()
{
var schemaName = Guid.NewGuid().ToString();
var tableName = Guid.NewGuid().ToString();
var columnName = Guid.NewGuid().ToString();
var name = Guid.NewGuid().ToString();
_op = new RemoveExtendedPropertyOperation(schemaName, tableName, columnName, name, false);
}
private void Generate(RemoveExtendedPropertyOperation operation, MigrationCommandListBuilder builder)
{
builder.Append("EXEC sys.sp_dropextendedproperty");
builder.Append($" @name = N'{operation.ExtendedProperty.Key}'");
builder.Append(", @level0type = N'SCHEMA'");
builder.Append($", @level0name = N'{operation.SchemaTableColumn.Schema ?? "dbo"}'");
builder.Append(", @level1type = N'TABLE'");
builder.Append($", @level1name = N'{operation.SchemaTableColumn.Table}'");
if (!String.IsNullOrEmpty(operation.SchemaTableColumn.Column))
{
builder.Append($@",@level2type = 'COLUMN', @level2name = '{operation.SchemaTableColumn.Column}'");
}
builder.EndCommand();
}
