public StoredProcedureInfo CloneStoredProcedure(DatabaseInfo ownerDb = null)
{
var res = new StoredProcedureInfo(ownerDb ?? OwnerDatabase);
res.Assign(this);
return(res);
}
public void ChangeStoredProcedureSchema(StoredProcedureInfo obj, string newschema)
{
var oldObj = _database.FindStoredProcedure(obj);
if (oldObj != null)
{
oldObj.FullName = new NameWithSchema(newschema, oldObj.FullName.Name);
}
}
public void AlterStoredProcedure(StoredProcedureInfo obj)
{
var oldObj = _database.FindStoredProcedure(obj);
if (oldObj != null)
{
string gid = oldObj.GroupId;
oldObj.Assign(obj);
oldObj.GroupId = gid;
}
}
public StoredProcedureInfo FindStoredProcedure(StoredProcedureInfo obj)
{
return(FindStoredProcedure(obj.FullName));
}
public StoredProcedureInfo CloneStoredProcedure(DatabaseInfo ownerDb = null)
{
var res = new StoredProcedureInfo(ownerDb ?? OwnerDatabase);
res.Assign(this);
return res;
}
public override void ChangeStoredProcedureSchema(StoredProcedureInfo obj, string newschema)
{
ChangeObjectSchema(obj, newschema);
}
public override void RenameStoredProcedure(StoredProcedureInfo obj, string newname)
{
RenameObject(obj, newname);
}
public virtual void RenameStoredProcedure(StoredProcedureInfo obj, string newname)
{
throw new System.NotImplementedException();
}
public virtual void ChangeStoredProcedureSchema(StoredProcedureInfo obj, string newschema)
{
throw new System.NotImplementedException();
}
public virtual void AlterStoredProcedure(StoredProcedureInfo obj)
{
WriteRaw(Regex.Replace(obj.CreateSql, @"create\s+procedure", "ALTER PROCEDURE", RegexOptions.IgnoreCase));
EndCommand();
}
public virtual void DropStoredProcedure(StoredProcedureInfo obj, bool testIfExists)
{
PutCmd("^drop ^procedure %f", obj.FullName);
}
public virtual void CreateStoredProcedure(StoredProcedureInfo obj)
{
WriteRaw(obj.CreateSql);
EndCommand();
}
public void RenameStoredProcedure(StoredProcedureInfo obj, string newname)
{
var oldObj = _database.FindStoredProcedure(obj);
if (oldObj != null)
{
oldObj.FullName = new NameWithSchema(oldObj.FullName.Schema, newname);
}
}
public void DropStoredProcedure(StoredProcedureInfo obj, bool testIfExists)
{
_database.StoredProcedures.RemoveAll(v => v.FullName == obj.FullName);
}
public void CreateStoredProcedure(StoredProcedureInfo obj)
{
_database.StoredProcedures.Add(obj.CloneStoredProcedure(_database));
}
