private ChangeStoredProcedureCommand(int num, XElement inner) : base(num, inner)
{
this.body = new StoredProcedureBody(
inner.Element("declarations") != null ? inner.Element("declarations").Value : "",
inner.Element("body").Value
);
}
public override IEnumerable <XElement> Apply(Transaction transaction, bool forceIntegrity)
{
if (!forceIntegrity)
{
throw new NotImplementedException("Safe stored procedure removal is not implemented yet");
}
StoredProcedureBody body = transaction.GetStoredProcedureBody(this.procedure);
transaction.RemoveStoredProcedure(this.procedure);
return(new[]
{
new XElement("declarations", body.declarations),
new XElement("body", body.body),
});
}
public override IEnumerable <XElement> Apply(Transaction transaction, bool forceIntegrity)
{
if (!forceIntegrity)
{
throw new NotImplementedException("Safe stored procedure change is not implemented yet");
}
StoredProcedureBody oldBody = transaction.GetStoredProcedureBody(this.procedure);
/*Console.WriteLine();
* Console.WriteLine("===OLD DECLARATIONS===");
* Console.WriteLine(oldBody.declarations);
* Console.WriteLine("===OLD BODY===");
* Console.WriteLine(oldBody.body);
* Console.WriteLine("===END===");*/
transaction.ReplaceStoredProcedureBody(this.procedure, this.body);
return(new[]
{
new XElement("oldDeclarations", oldBody.declarations),
new XElement("oldBody", oldBody.body),
});
}
