public override void DropTable(ITableStructure table, DropFlags flags) { bool testIfExist = (flags & DropFlags.TestIfExist) != 0; DropTableReferences(table, flags); PutCmd("^drop ^table%k %f", testIfExist ? " if exists" : "", table.FullName); }
public override void DropSpecificObject(ISpecificObjectStructure obj, DropFlags flags) { bool testIfExist = (flags & DropFlags.TestIfExist) != 0; switch (obj.ObjectType) { case "view": PutCmdTest("50010", "^drop ^view%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; case "procedure": PutCmdTest("50010", "^drop ^procedure%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; case "function": PutCmdTest("50010", "^drop ^function%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; case "trigger": PutCmdTest("50017", "^drop ^trigger%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; case "mysql.event": PutCmdTest("51000", "^drop ^event%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; default: throw new NotImplementedError("DAE-00145"); } }
public override void DropConstraint(IConstraint constraint, DropFlags flags) { if (constraint is IIndex) { PutCmd("^drop ^index %i", constraint.Name); } }
public virtual void DropConstraint(IConstraint constraint, DropFlags flags) { if (constraint.Type == ConstraintType.Index) { PutCmd("^drop ^index %i on %f", constraint.Name, constraint.Table); } else { if (m_dialect.DialectCaps.ExplicitDropConstraint) { if (constraint.Type == ConstraintType.PrimaryKey) { PutCmd("^alter ^table %f ^drop ^primary ^key", constraint.Table); } else { PutCmd("^alter ^table %f ^drop %k %i", constraint.Table, constraint.Type.GetSqlName(), constraint.Name); } } else { if (constraint != null) { PutCmd("^alter ^table %f ^drop ^constraint %i", constraint.Table, constraint.Name); } } } }
public virtual void DropDomain(IDomainStructure domain, DropFlags flags) { if (m_dialect.DialectCaps.Domains) { PutCmd("^drop ^domain %f", domain.FullName); } }
protected void DropTableReferences(ITableStructure table, DropFlags flags) { bool refs = (flags & DropFlags.DropReferences) != 0; if (refs) { this.DropConstraints(table.GetReferencedFrom(), flags); } }
public override void DropConstraint(IConstraint constraint, DropFlags flags) { if (constraint.Type == ConstraintType.Index) { PutCmd("^drop ^index %i", constraint.Name); } else { base.DropConstraint(constraint, flags); } }
public override void DropTable(ITableStructure table, DropFlags flags) { bool testIfExist = (flags & DropFlags.TestIfExist) != 0; DropTableReferences(table, flags); if (testIfExist) { Put("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'%f') AND type in (N'U'))&n", table.FullName); } PutCmd("^drop ^table %f", table.FullName); }
public override void DropConstraint(IConstraint constraint, DropFlags flags) { if (constraint.Type == ConstraintType.Index) { PutCmd("^drop ^index %i", constraint.Name); } else { PutCmd("^alter ^table %f ^drop ^constraint %i", constraint.Table, constraint.Name); } }
public override void DropSpecificObject(ISpecificObjectStructure obj, DropFlags flags) { bool testIfExist = (flags & DropFlags.TestIfExist) != 0; switch (obj.ObjectType) { case "view": PutCmd("^drop ^view%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; case "sequence": PutCmd("^drop ^sequence%k %f", testIfExist ? " if exists" : "", obj.ObjectName); break; default: throw new NotImplementedError("DAE-00147"); } }
public override void DropSpecificObject(ISpecificObjectStructure obj, DropFlags flags) { bool testIfExist = (flags & DropFlags.TestIfExist) != 0; switch (obj.ObjectType) { case "view": if (testIfExist) { Put("IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'%f'))&n", obj.ObjectName); } PutCmd("^drop ^view %f", obj.ObjectName); break; case "procedure": if (testIfExist) { Put("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'%f') AND type in (N'P', N'PC'))&n", obj.ObjectName); } PutCmd("^drop ^procedure %f", obj.ObjectName); break; case "function": if (testIfExist) { Put("IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'%f') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT'))&n", obj.ObjectName); } PutCmd("^drop ^function %f", obj.ObjectName); break; case "trigger": if (testIfExist) { Put("IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'%f'))&n", obj.ObjectName); } PutCmd("^drop ^trigger %f", obj.ObjectName); break; default: throw new NotImplementedError("DAE-00333"); } }
//public static void DropConstraint(this ISqlDumper fmt, IConstraint cnt, DropFlags flags) //{ // fmt.DropConstraint(cnt.Table, cnt.Name, cnt.SqlTypeName, flags); //} //public static void DropConstraint(this ISqlDumper fmt, IConstraint cnt) //{ // fmt.DropConstraint(cnt.Table, cnt.Name, cnt.SqlTypeName, DropFlags.None); //} public static void DropConstraints(this ISqlDumper fmt, IEnumerable constraints, DropFlags flags) { foreach (IConstraint cnt in constraints) { fmt.DropConstraint(cnt, flags); } }
protected void DropConstraints(IEnumerable constraints, DropFlags flags) { SqlDumperExtension.DropConstraints(this, constraints, flags); }
public virtual void DropSpecificObject(ISpecificObjectStructure obj, DropFlags flags) { PutCmd("^drop ^" + obj.ObjectType + " %f", obj.ObjectName); }
public virtual void DropTable(ITableStructure table, DropFlags flags) { DropTableReferences(table, flags); PutCmd("^drop ^table %f", table.FullName); }