public void ShouldWriteQueryForRemoveViewOperation() { var op = new RemoveViewOperation(SchemaName, ViewName); const string expectedQuery = "drop view [schemaName].[viewName]"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldSetPropertiesForRemoveViewOperation() { var op = new RemoveViewOperation(SchemaName, ViewName); Assert.AreEqual(SchemaName, op.SchemaName); Assert.AreEqual(ViewName, op.Name); Assert.That(op.ObjectName, Is.EqualTo(string.Format("{0}.{1}", SchemaName, ViewName))); }
public void ShouldDisableViewColumnPropertyIfViewRemovedByMerge() { var op = new AddExtendedPropertyOperation("schema", "view", "column", "name", "value", true); var removeOp = new RemoveViewOperation("SCHEMA", "VIEW"); op.Merge(removeOp); Assert.That(op.Disabled, Is.True); Assert.That(removeOp.Disabled, Is.False); }
public void ShouldDisableWhenMergedWithRemoveOperation() { var op = new AddViewOperation("schema", "name", "definition"); var removeOp = new RemoveViewOperation("SCHEMA", "NAME"); op.Merge(removeOp); Assert.That(op.Disabled, Is.True); Assert.That(removeOp.Disabled, Is.True); }
public void ShouldNotDisableOperationWhenItIsForATableAndAViewWithTheSameNameIsRemoved() { var op = new AddExtendedPropertyOperation("schema", "table", "name", "value", false); var removeViewOp = new RemoveViewOperation("SCHEMA", "TABLE"); op.Merge(removeViewOp); Assert.That(op.Disabled, Is.False); Assert.That(removeViewOp.Disabled, Is.False); }