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)); }