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