public static bool EqualsConstraints(ConstraintInfo csrc, ConstraintInfo cdst, DbDiffOptions options, bool checkNames, DbObjectPairing pairing)
{
if (checkNames && !options.IgnoreConstraintNames)
{
if (!EqualNames(csrc.ConstraintName, cdst.ConstraintName, options))
{
return false;
//if (csrc is PrimaryKeyInfo && cdst is PrimaryKeyInfo) // && (pairing.Source.Dialect.DialectCaps.AnonymousPrimaryKey || pairing.Target.Dialect.DialectCaps.AnonymousPrimaryKey))
//{
// // do nothing
//}
//else
//{
// return false;
//}
}
}
if (csrc.GetType() != cdst.GetType()) return false;
if (csrc is ColumnsConstraintInfo)
{
TableInfo tsrc = pairing.Source.FindTable(csrc.OwnerTable.FullName);
TableInfo tdst = pairing.Target.FindTable(cdst.OwnerTable.FullName);
if (!EqualsColumnRefs(tsrc, tdst, ((ColumnsConstraintInfo)csrc).Columns, ((ColumnsConstraintInfo)cdst).Columns)) return false;
//if (!((ColumnsConstraint)csrc).Columns.EqualSequence(((ColumnsConstraint)cdst).Columns)) return false;
if (csrc is ForeignKeyInfo)
{
var fsrc = (ForeignKeyInfo)csrc;
var fdst = (ForeignKeyInfo)cdst;
if (!EqualFullNames(fsrc.RefTableFullName, fdst.RefTableFullName, options)) return false;
TableInfo psrc = pairing.Source.FindTable(fsrc.RefTableFullName);
TableInfo pdst = pairing.Target.FindTable(fdst.RefTableFullName);
if (!EqualsColumnRefs(psrc, pdst, fsrc.RefColumns, fdst.RefColumns)) return false;
if (fsrc.OnDeleteAction != fdst.OnDeleteAction) return false;
if (fsrc.OnUpdateAction != fdst.OnUpdateAction) return false;
}
//if (csrc is IIndex)
//{
// var isrc = (IndexConstraint)csrc;
// var idst = (IndexConstraint)cdst;
// if (isrc.IsUnique != idst.IsUnique) return false;
//}
}
//if (csrc is CheckConstraint)
//{
// if (((CheckConstraint)csrc).Expression != ((CheckConstraint)cdst).Expression) return false;
//}
return true;
}
private static int CompareConstraints(ConstraintInfo lft, ConstraintInfo rgt)
{
var nl = lft.ConstraintName;
var nr = rgt.ConstraintName;
if (lft.GetType() != rgt.GetType()) return String.Compare(lft.GetType().FullName, rgt.GetType().FullName);
if (nl != null && nr != null) return String.Compare(nl, nr);
return 0;
}
