public static bool EqualsColumns(ColumnInfo a, ColumnInfo b, bool checkName, bool checkDefault, DbDiffOptions opts, DbObjectPairing pairing) { if (checkName && !DbDiffTool.EqualNames(a.Name, b.Name, opts)) { opts.DiffLogger.Trace("Column, different name: {0}; {1}", a, b); return false; } //if (!DbDiffTool.EqualFullNames(a.Domain, b.Domain, opts)) //{ // opts.DiffLogger.Trace("Column {0}, {1}: different domain: {2}; {3}", a, b, a.Domain, b.Domain); // return false; //} if (a.ComputedExpression != b.ComputedExpression) { opts.DiffLogger.Trace("Column {0}, {1}: different computed expression: {2}; {3}", a, b, a.ComputedExpression, b.ComputedExpression); return false; } if (a.ComputedExpression != null) { return true; } if (checkDefault) { if (a.DefaultValue == null) { if (a.DefaultValue != b.DefaultValue) { opts.DiffLogger.Trace("Column {0}, {1}: different default values: {2}; {3}", a, b, a.DefaultValue, b.DefaultValue); return false; } } else { if (!a.DefaultValue.Equals(b.DefaultValue)) { opts.DiffLogger.Trace("Column {0}, {1}: different default values: {2}; {3}", a, b, a.DefaultValue, b.DefaultValue); return false; } } if (a.DefaultConstraint != b.DefaultConstraint) { opts.DiffLogger.Trace("Column {0}, {1}: different default constraint names: {2}; {3}", a, b, a.DefaultConstraint, b.DefaultConstraint); return false; } } if (a.NotNull != b.NotNull) { opts.DiffLogger.Trace("Column {0}, {1}: different nullable: {2}; {3}", a, b, a.NotNull, b.NotNull); return false; } if (a.AutoIncrement != b.AutoIncrement) { opts.DiffLogger.Trace("Column {0}, {1}: different autoincrement: {2}; {3}", a, b, a.AutoIncrement, b.AutoIncrement); return false; } if (a.IsSparse != b.IsSparse) { opts.DiffLogger.Trace("Column {0}, {1}: different is_sparse: {2}; {3}", a, b, a.IsSparse, b.IsSparse); return false; } if (!EqualTypes(a, b, opts)) { return false; } //var btype = b.DataType; //var atype = a.DataType; //if (pairing != null && pairing.Target != null && pairing.Source.Dialect != null) //{ // btype = pairing.Source.Dialect.MigrateDataType(b, btype, pairing.Source.Dialect.GetDefaultMigrationProfile(), null); // btype = pairing.Source.Dialect.GenericTypeToSpecific(btype).ToGenericType(); // // normalize type // atype = pairing.Source.Dialect.GenericTypeToSpecific(atype).ToGenericType(); //} //if (!EqualTypes(atype, btype, opts)) //{ // opts.DiffLogger.Trace("Column {0}, {1}: different types: {2}; {3}", a, b, a.DataType, b.DataType); // return false; //} //if (!opts.IgnoreColumnCollation && a.Collation != b.Collation) //{ // opts.DiffLogger.Trace("Column {0}, {1}: different collations: {2}; {3}", a, b, a.Collation, b.Collation); // return false; //} //if (!opts.IgnoreColumnCharacterSet && a.CharacterSet != b.CharacterSet) //{ // opts.DiffLogger.Trace("Column {0}, {1}: different character sets: {2}; {3}", a, b, a.CharacterSet, b.CharacterSet); // return false; //} return true; }
public static bool EqualTables(TableInfo tsrc, TableInfo tdst, DbDiffOptions options, DbObjectPairing pairing, bool testNames) { if (options.IgnoreColumnOrder) { if (tsrc.Columns.Count != tdst.Columns.Count) return false; foreach (var scol in tsrc.Columns) { var dcol = (from c in tdst.Columns where c.GroupId == scol.GroupId select c).FirstOrDefault(); if (dcol == null) return false; using (var ctx = new DbDiffChangeLoggerContext(options, NopMessageLogger.Instance, DbDiffOptsLogger.DiffLogger)) { if (!EqualsColumns(scol, dcol, true, true, options, pairing)) return false; } } } else { using (var ctx = new DbDiffChangeLoggerContext(options, NopMessageLogger.Instance, DbDiffOptsLogger.DiffLogger)) { if (!tsrc.Columns.EqualSequence(tdst.Columns, (c1, c2) => EqualsColumns(c1, c2, true, true, options, pairing))) return false; } } var csrc = new List<ConstraintInfo>(tsrc.Constraints); var cdst = new List<ConstraintInfo>(tdst.Constraints); csrc.Sort(CompareConstraints); cdst.Sort(CompareConstraints); if (!csrc.EqualSequence(cdst, (c1, c2) => EqualsConstraints(c1, c2, options, true, pairing))) return false; if (testNames && !EqualFullNames(tsrc.FullName, tdst.FullName, options)) return false; if (GetTableAlteredOptions(tsrc, tdst, options).Count > 0) return false; return true; }
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; }
//public static bool EqualTypes(DbTypeBase t1, DbTypeBase t2, DbDiffOptions opts) //{ // if (!opts.IgnoreSpecificData && !t1.SpecificData.EqualsDictionary(t2.SpecificData, opts.IgnoreDataTypeProperties)) // { // opts.DiffLogger.Trace("Types {0}, {1}: different specific data: {2}; {3}", t1, t2, t1.SpecificData.Format(), t2.SpecificData.Format()); // return false; // } // if (t1.Code != t2.Code) // { // opts.DiffLogger.Trace("Types {0}, {1}: different type code: {2}; {3}", t1, t2, t1.Code, t2.Code); // return false; // } // if (!XmlTool.PropertiesEquals(t1, t2, opts.DiffLogger)) return false; // return true; //} public static bool EqualTables(TableInfo tsrc, TableInfo tdst, DbDiffOptions options, DbObjectPairing pairing) { return EqualTables(tsrc, tdst, options, pairing, true); }
public static DbObjectPairing CreateTablePairing(TableInfo oldTable, TableInfo newTable) { var src = new DatabaseInfo(); var dst = src.CloneDatabase(); src.AddObject(oldTable, true); dst.AddObject(newTable, true); DbObjectPairing pairing = new DbObjectPairing(src, dst); return pairing; }
public static void AlterSpecificObject(SpecificObjectInfo osrc, SpecificObjectInfo odst, AlterPlan plan, DbDiffOptions opts, DbObjectPairing pairing) { //bool altered = false; if (osrc.CreateSql == odst.CreateSql) { plan.RenameSpecificObject(osrc, odst.FullName); //altered = GenerateRename(osrc.ObjectName, odst.ObjectName, // (old, sch) => // { // var o2 = new SpecificObjectStructure(osrc); // o2.ObjectName = old; // proc.ChangeSpecificObjectSchema(o2, sch); // }, // (old, nam) => // { // var o2 = new SpecificObjectStructure(osrc); // o2.ObjectName = old; // proc.RenameSpecificObject(o2, nam); // }, caps[osrc.ObjectType].ChangeSchema, caps[osrc.ObjectType].Rename, opts); } else { plan.ChangeSpecificObject(osrc, odst); } //if (!altered) //{ // proc.DropSpecificObject(osrc); // SpecificObjectStructure odst2 = new SpecificObjectStructure(odst); // odst2.ObjectName = GenerateNewName(osrc.ObjectName, odst.ObjectName, opts); // proc.CreateSpecificObject(odst); //} }
public static void AlterDatabase(AlterPlan plan, DbObjectPairing pairing, DbDiffOptions opts) { var src = pairing.Source; var dst = pairing.Target; //var caps = proc.AlterCaps; //// domains //foreach (IDomainStructure dsrc in src.Domains) //{ // IDomainStructure ddst = pairing.FindPair(dsrc); // if (ddst == null) // { // plan.DropDomain(dsrc); // } // else if (!DbDiffTool.EqualDomains(dsrc, ddst, opts, true)) // { // if (DbDiffTool.EqualDomains(dsrc, ddst, opts, false)) // { // plan.RenameDomain(dsrc, ddst.FullName); // } // else // { // plan.ChangeDomain(dsrc, ddst); // } // } //} //foreach (IDomainStructure ddst in dst.Domains) //{ // if (!pairing.IsPaired(ddst)) plan.CreateDomain(ddst); //} // drop tables foreach (TableInfo tsrc in new List<TableInfo>(src.Tables)) { TableInfo tdst = pairing.FindPair(tsrc); if (tdst == null) { plan.DropTable(tsrc); } } // change tables foreach (TableInfo tsrc in new List<TableInfo>(src.Tables)) { TableInfo tdst = pairing.FindPair(tsrc); if (tdst == null) continue; if (!DbDiffTool.EqualTables(tsrc, tdst, opts, pairing)) { DbDiffTool.AlterTable(plan, tsrc, tdst, opts, pairing); } //else //{ // DbDiffTool.AlterFixedData(plan, tsrc, tdst, opts); //} } // create tables foreach (TableInfo tdst in dst.Tables) { if (!pairing.IsPaired(tdst)) { //var script = DbDiffTool.AlterFixedData(null, tdst.FixedData, null, opts); plan.CreateTable(tdst); //if (script != null) plan.UpdateData(tdst.FullName, script); } } // specific objects foreach (var osrc in src.GetAllSpecificObjects()) { //var repr = SpecificRepresentationAddonType.Instance.FindRepresentation(osrc.ObjectType); //if (!repr.UseInSynchronization) continue; var odst = pairing.FindPair(osrc); if (odst == null) { plan.DropSpecificObject(osrc); //proc.DropSpecificObject(osrc); } else if (!DbDiffTool.EqualsSpecificObjects(osrc, odst, opts)) { DbDiffTool.AlterSpecificObject(osrc, odst, plan, opts, pairing); } } foreach (var odst in dst.GetAllSpecificObjects()) { //var repr = SpecificRepresentationAddonType.Instance.FindRepresentation(odst.ObjectType); //if (!repr.UseInSynchronization) continue; if (!pairing.IsPaired(odst)) { plan.CreateSpecificObject(odst); //proc.CreateSpecificObject(odst); } } //foreach (ISchemaStructure ssrc in src.Schemata) //{ // ISchemaStructure sdst = pairing.FindPair(ssrc); // if (sdst == null) // { // plan.DropSchema(ssrc); // } // else if (ssrc.SchemaName != sdst.SchemaName) // { // plan.RenameSchema(ssrc, sdst.SchemaName); // //if (caps.RenameSchema) proc.RenameSchema(ssrc, sdst.SchemaName); // //else // //{ // // proc.DropSchema(ssrc); // // proc.CreateSchema(sdst); // //} // } //} //foreach (ISchemaStructure sdst in dst.Schemata) //{ // if (!pairing.IsPaired(sdst)) plan.CreateSchema(sdst); //} //var alteredOptions = GetDatabaseAlteredOptions(src, dst, opts); //if (alteredOptions.Count > 0) plan.ChangeDatabaseOptions(null, alteredOptions); //if (opts.SchemaMode == DbDiffSchemaMode.Ignore) //{ // plan.RunNameTransformation(new SetSchemaNameTransformation(null)); //} }
public static void AlterTable(AlterPlan plan, TableInfo oldTable, TableInfo newTable, DbDiffOptions opts, DbObjectPairing pairing) { //plan.BeginFixedOrder(); if (oldTable == null) throw new ArgumentNullException("oldTable", "DBSH-00141 oldTable is null"); if (newTable == null) throw new ArgumentNullException("newTable", "DBSH-00142 newTable is null"); //bool processed; //proc.AlterTable(oldTable, newTable, out processed); //if (processed) return; //InMemoryTableOperation dataOps = null; //if (oldTable.FixedData != null) dataOps = new InMemoryTableOperation(oldTable.FixedData.Structure); NameWithSchema newTableName = GenerateNewName(oldTable.FullName, newTable.FullName, opts); bool permuteColumns = false; bool insertColumns = false; //bool renameColumns = false; List<int> columnMap = new List<int>(); List<int> constraintMap = new List<int>(); foreach (var col in newTable.Columns) { columnMap.Add(oldTable.Columns.IndexOfIf(c => c.GroupId == col.GroupId)); } foreach (var cnt in newTable.Constraints) { int cindex = oldTable.Constraints.IndexOfIf(c => c.GroupId == cnt.GroupId); if (cindex < 0 && cnt is PrimaryKeyInfo) { // primary keys for one table are equal cindex = oldTable.Constraints.IndexOfIf(c => c is PrimaryKeyInfo); } constraintMap.Add(cindex); } if (!opts.IgnoreColumnOrder) { // count alter requests int lastcol = -1; foreach (int col in columnMap) { if (col < 0) continue; if (col < lastcol) permuteColumns = true; lastcol = col; } bool wasins = false; foreach (int col in columnMap) { if (col < 0) wasins = true; if (col >= 0 && wasins) insertColumns = true; } } int index; // drop constraints index = 0; foreach (var cnt in oldTable.Constraints) { if (constraintMap.IndexOf(index) < 0) plan.DropConstraint(cnt); index++; } // drop columns index = 0; foreach (var col in oldTable.Columns) { if (columnMap.IndexOf(index) < 0) { plan.DropColumn(col); //if (dataOps != null) dataOps.DropColumn(col.ColumnName); } index++; } if (!DbDiffTool.EqualFullNames(oldTable.FullName, newTable.FullName, opts)) { plan.RenameTable(oldTable, newTable.FullName); } // create columns index = 0; foreach (var col in newTable.Columns) { if (columnMap[index] < 0) { var newcol = col.CloneColumn(); plan.CreateColumn(oldTable, newcol); //if (dataOps != null) dataOps.CreateColumn(newcol); } index++; } // change columns index = 0; foreach (var col in newTable.Columns) { if (columnMap[index] >= 0) { var src = oldTable.Columns[columnMap[index]]; if (!DbDiffTool.EqualsColumns(src, col, true, true, opts, pairing)) { using (var ctx = new DbDiffChangeLoggerContext(opts, NopMessageLogger.Instance, DbDiffOptsLogger.DiffLogger)) { if (DbDiffTool.EqualsColumns(src, col, false, true, opts, pairing)) { plan.RenameColumn(src, col.Name); } else { plan.ChangeColumn(src, col); } //if (dataOps != null && src.ColumnName != col.ColumnName) dataOps.RenameColumn(src.ColumnName, col.ColumnName); } } } index++; } //// create fixed data script //var script = AlterFixedData(oldTable.FixedData, newTable.FixedData, dataOps, opts); //if (script != null) plan.UpdateData(oldTable.FullName, script); // change constraints index = 0; foreach (var cnt in newTable.Constraints) { if (constraintMap[index] >= 0) { var src = oldTable.Constraints[constraintMap[index]]; if (DbDiffTool.EqualsConstraints(src, cnt, opts, false, pairing) && src.ConstraintName != cnt.ConstraintName) { //if (cnt is IPrimaryKey && (pairing.Source.Dialect.DialectCaps.AnonymousPrimaryKey || pairing.Target.Dialect.DialectCaps.AnonymousPrimaryKey)) //{ // // do nothing //} //else //{ plan.RenameConstraint(src, cnt.ConstraintName); //} } else { if (!DbDiffTool.EqualsConstraints(src, cnt, opts, true, pairing)) { plan.ChangeConstraint(src, cnt); } } } index++; } // create constraints index = 0; foreach (var cnt in newTable.Constraints) { if (constraintMap[index] < 0) { plan.CreateConstraint(oldTable, cnt); } index++; ; } if (permuteColumns || insertColumns) { plan.ReorderColumns(oldTable, new List<string>((from c in newTable.Columns select c.Name))); } var alteredOptions = GetTableAlteredOptions(oldTable, newTable, opts); if (alteredOptions.Count > 0) plan.ChangeTableOptions(oldTable, alteredOptions); //plan.EndFixedOrder(); }