| public static AreEqual ( object one, object two ) : bool | ||
| one | object | |
| two | object | |
| return | bool | |
bool ITablePart.HasChanges()
{
if (!ObjectHelper.AreEqual(this, oldIndex))
{
return(true);
}
if (Columns.Count != oldIndex.Columns.Count)
{
return(true);
}
foreach (IndexColumn ic in Columns)
{
int i = 0;
for (; i < oldIndex.Columns.Count; i++)
{
IndexColumn oic = oldIndex.Columns[i];
if (oic.ColumnName == ic.ColumnName && oic.SortOrder == ic.SortOrder)
{
break;
}
}
if (i == oldIndex.Columns.Count)
{
return(true);
}
}
return(false);
}
bool ITablePart.HasChanges()
{
if (!ObjectHelper.AreEqual(this, oldFk))
{
return(true);
}
if (Columns.Count != oldFk.Columns.Count)
{
return(true);
}
foreach (FKColumnPair fc in Columns)
{
int i = 0;
for (; i < oldFk.Columns.Count; i++)
{
FKColumnPair ofc = oldFk.Columns[i];
if (ofc.ReferencedColumn == fc.ReferencedColumn &&
ofc.Column == fc.Column)
{
break;
}
}
if (i == oldFk.Columns.Count)
{
return(true);
}
}
return(false);
}
public bool HasChanges()
{
// first compare our top level properties
if (!ObjectHelper.AreEqual(this, OldTable))
{
return(true);
}
if (Columns.HasChanges())
{
return(true);
}
if (Indexes.HasChanges())
{
return(true);
}
if (ForeignKeys.HasChanges())
{
return(true);
}
return(false);
}
string ITablePart.GetSql(bool newTable)
{
if (OldColumn != null &&
OldColumn.ColumnName != null &&
ObjectHelper.AreEqual(this, OldColumn))
{
return(null);
}
if (String.IsNullOrEmpty(ColumnName))
{
return(null);
}
StringBuilder props = new StringBuilder();
props.AppendFormat(" {0}", DataType);
if (!String.IsNullOrEmpty(CharacterSet))
{
props.AppendFormat(" CHARACTER SET '{0}'", CharacterSet);
}
if (!String.IsNullOrEmpty(Collation))
{
props.AppendFormat(" COLLATE '{0}'", Collation);
}
if (!String.IsNullOrEmpty(Comment))
{
props.AppendFormat(" COMMENT '{0}'", Comment);
}
if (IsZerofill)
{
props.Append(" ZEROFILL");
}
if (IsUnsigned)
{
props.Append(" UNSIGNED");
}
if (!AllowNull)
{
props.Append(" NOT NULL");
}
if (AutoIncrement)
{
props.Append(" AUTO_INCREMENT");
}
if (!String.IsNullOrEmpty(DefaultValue))
{
if (DataType.IndexOf("char") >= 0)
{
props.AppendFormat(" DEFAULT '{0}'", DefaultValue);
}
else
{
props.AppendFormat(" DEFAULT {0}", DefaultValue);
}
}
ColumnName = ColumnName.Trim();
if (newTable)
{
return(String.Format("`{0}`{1}", ColumnName, props.ToString()));
}
if (isNew)
{
return(String.Format("ADD `{0}`{1}", ColumnName, props.ToString()));
}
return(String.Format("CHANGE `{0}` `{1}` {2}",
OldColumn.ColumnName, ColumnName, props.ToString()));
}
bool ITablePart.HasChanges()
{
return(!ObjectHelper.AreEqual(this, OldColumn));
}
