public void CanAddCategoryToCategoryForDeletedColumn() { var diff = new DatabaseDiff(); var tableDiff = new TableDiff(); tableDiff.ColumnsDroped.Add(new Column { Type = "text" }); diff.TablesDiff.Add(tableDiff); var report = diff.GetDiffReport(); report.Categories[0].Entries.Count.Should().Be(1); report.Categories[0].Entries[0].Categories.Count.Should().Be(1); }
public void CanAddCategoryToCategoryForChangedColumn() { var diff = new DatabaseDiff(); var tableDiff = new TableDiff(); tableDiff.ColumnsDiff.Add(new ColumnDiff(new Column { Type = "text" }, new Column { Type = "text" }, new CompareConfig())); diff.TablesDiff.Add(tableDiff); var report = diff.GetDiffReport(); report.Categories[0].Entries.Count.Should().Be(1); report.Categories[0].Entries[0].Categories.Count.Should().Be(1); }
public void CanAddCategoryToCategoryForChangedConstraint() { var diff = new DatabaseDiff(); var tableDiff = new TableDiff(); tableDiff.ConstraintsChanged.Add(new Constraint("", "", "") { Table = new TableInfo("dbo", "myTable") }); diff.TablesDiff.Add(tableDiff); var report = diff.GetDiffReport(); report.Categories[0].Entries.Count.Should().Be(1); report.Categories[0].Entries[0].Categories.Count.Should().Be(1); }
public void CanAddCorrectEntryForDeletedTable() { var diff = new DatabaseDiff(); diff.TablesDeleted.Add(new Table("dbo", "MyTable")); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("MyTable"); entry.Type.Should().Be(DiffEntryType.Deleted); }
public void CanCreateDiffReport() { var databaseDiff = new DatabaseDiff(); var report = databaseDiff.GetDiffReport(); report.Should().NotBeNull(); }
public void CanAddCorrectEntryForDeletedConstraint() { var diff = new DatabaseDiff(); var tableDiff = new TableDiff(); tableDiff.ConstraintsDeleted.Add(new Constraint("MyConstraint", "", "") { Table = new TableInfo("dbo", "myTable") }); diff.TablesDiff.Add(tableDiff); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries[0].Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("MyConstraint"); entry.Type.Should().Be(DiffEntryType.Deleted); }
public void CanAddCorrectEntryForDeletedForeignKey() { var diff = new DatabaseDiff(); diff.ForeignKeysDeleted.Add(GetForeignKey()); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("My_FK"); entry.Type.Should().Be(DiffEntryType.Deleted); }
public void CanAddCorrectEntryForChangedRoutine() { var diff = new DatabaseDiff(); diff.RoutinesDiff.Add(new Routine("dbo","My_Routine")); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("My_Routine"); entry.Type.Should().Be(DiffEntryType.Changed); }
public void CanAddCorrectEntryForDeletedColumn() { var diff = new DatabaseDiff(); var tableDiff = new TableDiff(); tableDiff.ColumnsDroped.Add(new Column { Name = "MyColumn", Type = "text" }); diff.TablesDiff.Add(tableDiff); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries[0].Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("MyColumn"); entry.Type.Should().Be(DiffEntryType.Deleted); }
public void CanAddCorrectEntryForChangedColumn() { var diff = new DatabaseDiff(); var tableDiff = new TableDiff(); tableDiff.ColumnsDiff.Add(new ColumnDiff(new Column { Name = "TargetColumn", Type = "text" }, new Column { Name = "SourceColumn", Type = "text" }, new CompareConfig())); diff.TablesDiff.Add(tableDiff); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries[0].Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("SourceColumn"); entry.Type.Should().Be(DiffEntryType.Changed); }
public void CanAddCorrectEntryForChangedProperty() { var diff = new DatabaseDiff(); diff.PropsChanged.Add(new DbProp("prop", "value")); var report = diff.GetDiffReport(); DiffEntry entry; (entry = report.Categories[0].Entries.FirstOrDefault()).Should().NotBeNull(); entry.Name.Should().Be("prop"); entry.Type.Should().Be(DiffEntryType.Changed); }
public void CanAddCategoryWithDeletedTable() { var diff = new DatabaseDiff(); diff.TablesDeleted.Add(new Table("dbo", "MyTable")); var report = diff.GetDiffReport(); report.Categories.Count.Should().Be(1); }
public void CanAddCategoryWithDeletedForeinKey() { var diff = new DatabaseDiff(); diff.ForeignKeysDeleted.Add(GetForeignKey()); var report = diff.GetDiffReport(); report.Categories.Count.Should().Be(1); }
public void CanAddCategoryWithChangedTable() { var diff = new DatabaseDiff(); diff.TablesDiff.Add(new TableDiff()); var report = diff.GetDiffReport(); report.Categories.Count.Should().Be(1); }
public void CanAddCategoryWithChangedRoutine() { var diff = new DatabaseDiff(); diff.RoutinesDiff.Add(new Routine("dbo", "MySP")); var report = diff.GetDiffReport(); report.Categories.Count.Should().Be(1); }
public void CanAddCategoryWithChangedProperty() { var diff = new DatabaseDiff(); diff.PropsChanged.Add(new DbProp("prop", "value")); var report = diff.GetDiffReport(); report.Categories.Count.Should().Be(1); report.Categories[0].Name.Should().Be("Properties"); }