public void IgnoreRelationshipAdded_IsFalse()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Association_OneToMany_Lefts);
TestContext.DeleteAll(x => x.Association_OneToMany_Rights);
var audit = AuditHelper.AutoSaveAudit();
Assert.AreEqual(false, audit.Configuration.IgnoreRelationshipAdded);
using (var ctx = new TestContext())
{
var left = TestContext.Insert(ctx, x => x.Association_OneToMany_Lefts, 2).First();
var right = new Association_OneToMany_Right {ColumnInt = 0};
left.Rights = new List<Association_OneToMany_Right> {right};
ctx.SaveChanges();
}
using (var ctx = new TestContext())
{
var list = ctx.Association_OneToMany_Lefts.OrderBy(x => x.ID).ToList();
var right = ctx.Association_OneToMany_Rights.First();
// DELETE one
list[0].Rights.Clear();
// INSERT one
list[1].Rights = new List<Association_OneToMany_Right> {right};
ctx.SaveChanges(audit);
}
// UnitTest - Audit
{
var entries = audit.Entries;
// Entries
{
// Entries Count
Assert.AreEqual(2, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State);
}
}
// UnitTest - Audit (Database)
{
using (var ctx = new TestContext())
{
// ENSURE order
var entries = ctx.AuditEntries.OrderBy(x => x.AuditEntryID).ToList();
// Entries
{
// Entries Count
Assert.AreEqual(2, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State);
}
}
}
}
public void Association_OneToMany()
{
int leftID;
int rightID_0;
int rightID_1;
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Association_OneToMany_Lefts);
TestContext.DeleteAll(x => x.Association_OneToMany_Rights);
var audit = AuditHelper.AutoSaveAudit();
using (var ctx = new TestContext())
{
var left = TestContext.Insert(ctx, x => x.Association_OneToMany_Lefts, 1).First();
var right0 = new Association_OneToMany_Right {
ColumnInt = 0
};
var right1 = new Association_OneToMany_Right {
ColumnInt = 1
};
left.Rights = new List <Association_OneToMany_Right> {
right0, right1
};
ctx.SaveChanges(audit);
leftID = left.ID;
rightID_0 = right0.ID;
rightID_1 = right1.ID;
}
// UnitTest - Audit
{
var entries = audit.Entries;
// Entries
{
// Entries Count
Assert.AreEqual(5, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[1].State);
// Entries EntitySetName
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[0].EntitySetName);
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[1].EntitySetName);
// Entries TypeName
Assert.AreEqual(null, entries[0].EntityTypeName);
Assert.AreEqual(null, entries[1].EntityTypeName);
}
// Properties
{
var propertyIndex = -1;
// Properties Count
Assert.AreEqual(2, entries[0].Properties.Count);
Assert.AreEqual(2, entries[1].Properties.Count);
// Association_OneToMany_Left_Rights_Source;ID
propertyIndex = 0;
Assert.AreEqual("Association_OneToMany_Left_Rights_Source", entries[0].Properties[propertyIndex].RelationName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Source", entries[1].Properties[propertyIndex].RelationName);
Assert.AreEqual("ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(leftID, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(leftID, entries[1].Properties[propertyIndex].NewValue);
propertyIndex = 1;
Assert.AreEqual("Association_OneToMany_Left_Rights_Target", entries[0].Properties[propertyIndex].RelationName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Target", entries[1].Properties[propertyIndex].RelationName);
Assert.AreEqual("ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(rightID_0, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(rightID_1, entries[1].Properties[propertyIndex].NewValue);
}
}
// UnitTest - Audit (Database)
{
using (var ctx = new TestContext())
{
// ENSURE order
var entries = ctx.AuditEntries.OrderBy(x => x.AuditEntryID).Include(x => x.Properties).ToList();
entries.ForEach(x => x.Properties = x.Properties.OrderBy(y => y.AuditEntryPropertyID).ToList());
// Entries
{
// Entries Count
Assert.AreEqual(5, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[1].State);
// Entries EntitySetName
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[0].EntitySetName);
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[1].EntitySetName);
// Entries TypeName
Assert.AreEqual(null, entries[0].EntityTypeName);
Assert.AreEqual(null, entries[1].EntityTypeName);
}
// Properties
{
var propertyIndex = -1;
// Properties Count
Assert.AreEqual(2, entries[0].Properties.Count);
Assert.AreEqual(2, entries[1].Properties.Count);
// Association_OneToMany_Left_Rights_Source;ID
propertyIndex = 0;
Assert.AreEqual("Association_OneToMany_Left_Rights_Source", entries[0].Properties[propertyIndex].RelationName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Source", entries[1].Properties[propertyIndex].RelationName);
Assert.AreEqual("ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(leftID.ToString(), entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(leftID.ToString(), entries[1].Properties[propertyIndex].NewValue);
propertyIndex = 1;
Assert.AreEqual("Association_OneToMany_Left_Rights_Target", entries[0].Properties[propertyIndex].RelationName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Target", entries[1].Properties[propertyIndex].RelationName);
Assert.AreEqual("ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(rightID_0.ToString(), entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(rightID_1.ToString(), entries[1].Properties[propertyIndex].NewValue);
}
}
}
}
public void Association_OneToMany()
{
int leftID;
int rightID_0;
int rightID_1;
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Association_OneToMany_Lefts);
TestContext.DeleteAll(x => x.Association_OneToMany_Rights);
var audit = AuditHelper.AutoSaveAudit();
using (var ctx = new TestContext())
{
var left = TestContext.Insert(ctx, x => x.Association_OneToMany_Lefts, 1).First();
var right0 = new Association_OneToMany_Right() { ColumnInt = 0 };
var right1 = new Association_OneToMany_Right() { ColumnInt = 1 };
left.Rights = new List<Association_OneToMany_Right>() { right0, right1 };
ctx.SaveChanges();
leftID = left.ID;
rightID_0 = right0.ID;
rightID_1 = right1.ID;
}
using (var ctx = new TestContext())
{
TestContext.DeleteAll(ctx, x => x.Association_OneToMany_Rights);
ctx.SaveChanges(audit);
}
// UnitTest - Audit
{
var entries = audit.Entries;
// Entries
{
// Entries Count
Assert.AreEqual(4, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State);
// Entries EntitySetName
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[0].EntitySetName);
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[1].EntitySetName);
// Entries TypeName
Assert.AreEqual(null, entries[0].TypeName);
Assert.AreEqual(null, entries[1].TypeName);
}
// Properties
{
var propertyIndex = -1;
// Properties Count
Assert.AreEqual(2, entries[0].Properties.Count);
Assert.AreEqual(2, entries[1].Properties.Count);
// Association_OneToMany_Left_Rights_Source;ID
propertyIndex = 0;
Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(leftID, entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(leftID, entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue);
propertyIndex = 1;
Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(rightID_0, entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(rightID_1, entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue);
}
}
// UnitTest - Audit (Database)
{
using (var ctx = new TestContext())
{
// ENSURE order
var entries = ctx.AuditEntries.OrderBy(x => x.AuditEntryID).Include(x => x.Properties).ToList();
entries.ForEach(x => x.Properties = x.Properties.OrderBy(y => y.AuditEntryPropertyID).ToList());
// Entries
{
// Entries Count
Assert.AreEqual(4, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State);
// Entries EntitySetName
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[0].EntitySetName);
Assert.AreEqual("Association_OneToMany_Left_Rights", entries[1].EntitySetName);
// Entries TypeName
Assert.AreEqual(null, entries[0].TypeName);
Assert.AreEqual(null, entries[1].TypeName);
}
// Properties
{
var propertyIndex = -1;
// Properties Count
Assert.AreEqual(2, entries[0].Properties.Count);
Assert.AreEqual(2, entries[1].Properties.Count);
// Association_OneToMany_Left_Rights_Source;ID
propertyIndex = 0;
Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Source;ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(leftID.ToString(), entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(leftID.ToString(), entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue);
propertyIndex = 1;
Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[0].Properties[propertyIndex].PropertyName);
Assert.AreEqual("Association_OneToMany_Left_Rights_Target;ID", entries[1].Properties[propertyIndex].PropertyName);
Assert.AreEqual(rightID_0.ToString(), entries[0].Properties[propertyIndex].OldValue);
Assert.AreEqual(rightID_1.ToString(), entries[1].Properties[propertyIndex].OldValue);
Assert.AreEqual(null, entries[0].Properties[propertyIndex].NewValue);
Assert.AreEqual(null, entries[1].Properties[propertyIndex].NewValue);
}
}
}
}
public void IgnoreRelationshipDeleted_IsFalse()
{
TestContext.DeleteAll(x => x.AuditEntryProperties);
TestContext.DeleteAll(x => x.AuditEntries);
TestContext.DeleteAll(x => x.Association_OneToMany_Lefts);
TestContext.DeleteAll(x => x.Association_OneToMany_Rights);
var audit = AuditHelper.AutoSaveAudit();
Assert.AreEqual(false, audit.Configuration.IgnoreRelationshipDeleted);
using (var ctx = new TestContext())
{
var left = TestContext.Insert(ctx, x => x.Association_OneToMany_Lefts, 2).First();
var right = new Association_OneToMany_Right {
ColumnInt = 0
};
left.Rights = new List <Association_OneToMany_Right> {
right
};
ctx.SaveChanges();
}
using (var ctx = new TestContext())
{
var list = ctx.Association_OneToMany_Lefts.OrderBy(x => x.ID).ToList();
var right = ctx.Association_OneToMany_Rights.First();
// DELETE one
list[0].Rights.Clear();
// INSERT one
list[1].Rights = new List <Association_OneToMany_Right> {
right
};
ctx.SaveChanges(audit);
}
// UnitTest - Audit
{
var entries = audit.Entries;
// Entries
{
// Entries Count
Assert.AreEqual(2, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State);
}
}
// UnitTest - Audit (Database)
{
using (var ctx = new TestContext())
{
// ENSURE order
var entries = ctx.AuditEntries.OrderBy(x => x.AuditEntryID).ToList();
// Entries
{
// Entries Count
Assert.AreEqual(2, entries.Count);
// Entries State
Assert.AreEqual(AuditEntryState.RelationshipAdded, entries[0].State);
Assert.AreEqual(AuditEntryState.RelationshipDeleted, entries[1].State);
}
}
}
}
