public SQLScript(string sqlScript, int dependenciesCount, Enums.ScripActionType action)
{
SQL = sqlScript;
Dependencies = dependenciesCount;
Status = action;
//childs = new SQLScriptList();
}
public SQLScript(int deepvalue, string sqlScript, int dependenciesCount, Enums.ScripActionType action)
{
sql = sqlScript;
dependencies = dependenciesCount;
status = action;
deep = deepvalue;
//childs = new SQLScriptList();
}
public SQLScriptList Alter(Enums.ScripActionType typeStatus)
{
SQLScriptList list = new SQLScriptList();
string sql = "ALTER TABLE " + Parent.FullName + " ALTER COLUMN " + this.ToSql(false) + "\r\nGO\r\n";
list.Add(sql, 0, typeStatus);
return(list);
}
public void Add(string SQL, int dependencies, Enums.ScripActionType type)
{
if (list == null)
{
list = new List <SQLScript>();
}
list.Add(new SQLScript(SQL, dependencies, type));
}
public override SQLScript Drop()
{
Enums.ScripActionType action = Enums.ScripActionType.DropIndex;
if (!GetWasInsertInDiffList(action))
{
SetWasInsertInDiffList(action);
return(new SQLScript(ToSqlDrop(), Parent.DependenciesCount, action));
}
return(null);
}
public override SQLScript Drop()
{
const Enums.ScripActionType action = Enums.ScripActionType.DropUserDataType;
if (!GetWasInsertInDiffList(action))
{
SetWasInsertInDiffList(action);
return(new SQLScript(ToSqlDrop(), 0, action));
}
return(null);
}
/// <summary>
/// Setea que el objeto ya fue insertado en la lista de script con diferencias.
/// </summary>
public void SetWasInsertInDiffList(Enums.ScripActionType action)
{
if (wasInsertInDiffList == null)
{
wasInsertInDiffList = new Hashtable();
}
if (!wasInsertInDiffList.ContainsKey(action))
{
wasInsertInDiffList.Add(action, true);
}
}
/// <summary>
/// Devuelve si el objeto ya fue insertado en la lista de script con diferencias.
/// </summary>
/// <param name="action"></param>
/// <returns></returns>
public Boolean GetWasInsertInDiffList(Enums.ScripActionType action)
{
if (wasInsertInDiffList != null)
{
return(wasInsertInDiffList.ContainsKey(action));
}
else
{
return(false);
}
}
public override SQLScript Create()
{
Enums.ScripActionType action = Enums.ScripActionType.AddConstraint;
if (!GetWasInsertInDiffList(action))
{
SetWasInsertInDiffList(action);
return(new SQLScript(this.ToSqlAdd(), 0, action));
}
else
{
return(null);
}
}
public override SQLScript Create()
{
Enums.ScripActionType action = Enums.ScripActionType.AddFullTextIndex;
if (!GetWasInsertInDiffList(action))
{
SetWasInsertInDiffList(action);
return(new SQLScript(this.ToSqlAdd(), Parent.DependenciesCount, action));
}
else
{
return(null);
}
}
public override SQLScript Drop()
{
Enums.ScripActionType action = Enums.ScripActionType.DropTableType;
if (!GetWasInsertInDiffList(action))
{
SetWasInsertInDiffList(action);
return(new SQLScript(this.ToSqlDrop(), 0, action));
}
else
{
return(null);
}
}
public Code(ISchemaBase parent, Enums.ObjectType type, Enums.ScripActionType addAction, Enums.ScripActionType dropAction)
: base(parent, type)
{
dependenciesIn = new List<String>();
dependenciesOut = new List<String>();
typeName = GetObjectTypeName(ObjectType);
/*Por el momento, solo los Assemblys manejan deep de dependencias*/
if (this.ObjectType == Enums.ObjectType.Assembly)
{
deepMax = 501;
deepMin = 500;
}
this.addAction = addAction;
this.dropAction = dropAction;
}
public Code(ISchemaBase parent, Enums.ObjectType type, Enums.ScripActionType addAction, Enums.ScripActionType dropAction)
: base(parent, type)
{
dependenciesIn = new List <String>();
dependenciesOut = new List <String>();
typeName = GetObjectTypeName(ObjectType);
/*Por el momento, solo los Assemblys manejan deep de dependencias*/
if (this.ObjectType == Enums.ObjectType.Assembly)
{
deepMax = 501;
deepMin = 500;
}
this.addAction = addAction;
this.dropAction = dropAction;
}
public override SQLScript Drop()
{
Enums.ScripActionType action = Enums.ScripActionType.DropConstraint;
if (this.Type == ConstraintType.ForeignKey)
{
action = Enums.ScripActionType.DropConstraintFK;
}
if (this.Type == ConstraintType.PrimaryKey)
{
action = Enums.ScripActionType.DropConstraintPK;
}
if (!GetWasInsertInDiffList(action))
{
SetWasInsertInDiffList(action);
return(new SQLScript(this.ToSqlDrop(), ((Table)Parent).DependenciesCount, action));
}
else
{
return(null);
}
}
public CLRCode(ISchemaBase parent, Enums.ObjectType type, Enums.ScripActionType addAction, Enums.ScripActionType dropAction)
: base(parent, type, addAction, dropAction)
{
}
public override SQLScript Drop()
{
Enums.ScripActionType action = Enums.ScripActionType.DropExtendedProperty;
return(new SQLScript(this.ToSqlDrop(), 0, action));
}
public override SQLScript Create()
{
Enums.ScripActionType action = Enums.ScripActionType.AddExtendedProperty;
return(new SQLScript(this.ToSqlAdd(), 0, action));
}
