public void ShouldWriteQueryForAddStoredProcedure() { var op = new AddStoredProcedureOperation(SchemaName, ProcedureName, Definition); const string expectedQuery = "create procedure [schemaName].[procedureName] as definition"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldDisableWhenMergedWithRemoveOperation() { var op = new AddStoredProcedureOperation("schema", "name", "definition"); var removeOp = new RemoveStoredProcedureOperation("SCHEMA", "NAME"); op.Merge(removeOp); Assert.That(op.Disabled, Is.True); Assert.That(removeOp.Disabled, Is.True); }
public void ShouldSetPropertiesForAddStoredProcedure() { var op = new AddStoredProcedureOperation(SchemaName, ProcedureName, Definition); Assert.AreEqual(SchemaName, op.SchemaName); Assert.AreEqual(ProcedureName, op.Name); Assert.AreEqual(Definition, op.Definition); Assert.That(op.ObjectName, Is.EqualTo(string.Format("{0}.{1}", SchemaName, ProcedureName))); }
public void ShouldNotRenameObjectIfDifferentObject() { var op = new AddStoredProcedureOperation("schema", "name", "definition"); var renameOp = new RenameObjectOperation("SCHEMA", "another_object", "newname"); op.Merge(renameOp); Assert.That(op.Disabled, Is.False); Assert.That(renameOp.Disabled, Is.False); Assert.That(op.Name, Is.EqualTo("name")); }