public void AuditRulesTests_CheckValidation(string assemblyName, string dataSourceName)
{
var dataSource = DataSource(dataSourceName);
try
{
var currentUser = dataSource.From(EmployeeTableName).ToObject<Employee>(RowOptions.DiscardExtraRows).Execute();
var ds = AttachRules(dataSource).WithUser(currentUser);
var cust = new CustomerWithValidation();
try
{
ds.Insert(CustomerTableName, cust).Execute();
Assert.Fail("Expected a validation exception");
}
catch (ValidationException)
{
//expected
}
}
finally
{
Release(dataSource);
}
}
public void AuditRulesTests_InsertUpdateRules(string assemblyName, string dataSourceName)
{
var dataSource = DataSource(dataSourceName);
try
{
var key = Guid.NewGuid().ToString();
for (var i = 0; i < 2; i++)
dataSource.Insert(EmployeeTableName, new Employee() { FirstName = i.ToString("0000"), LastName = "Z" + (int.MaxValue - i), Title = key, MiddleName = i % 2 == 0 ? "A" + i : null }).ToObject<Employee>().Execute();
var users = dataSource.From(EmployeeTableName).ToCollection<Employee>().Execute();
var currentUser1 = users.First();
var currentUser2 = users.Skip(1).First();
var dsWithRules = AttachRules(dataSource);
var ds1 = dsWithRules.WithUser(currentUser1);
var ds2 = dsWithRules.WithUser(currentUser2);
var cust1 = new CustomerWithValidation() { FullName = "Test Customer " + DateTime.Now.Ticks, State = "CA" };
var cust2 = ds1.Insert(CustomerTableName, cust1).ToObject<CustomerWithValidation>().Execute();
Assert.AreEqual(cust1.FullName, cust2.FullName, "FullName was not set");
Assert.AreEqual(currentUser1.EmployeeKey, cust2.CreatedByKey, "CreatedBy was not set");
Assert.AreEqual(currentUser1.EmployeeKey, cust2.UpdatedByKey, "UpdatedBy was not set");
Assert.IsNotNull(cust2.CreatedDate, "CreatedDate was not set");
Assert.IsNotNull(cust2.UpdatedDate, "UpdatedDate was not set");
Thread.Sleep(100); //make sure the current time is different enough for the database to notice
cust2.State = "NV";
var cust3 = ds2.Update(CustomerTableName, cust2).ToObject<CustomerWithValidation>().Execute();
Assert.AreEqual(currentUser1.EmployeeKey, cust2.CreatedByKey, "CreatedBy was not set");
Assert.AreEqual(currentUser2.EmployeeKey, cust3.UpdatedByKey, "UpdatedBy was not changed");
Assert.AreEqual(cust2.CreatedDate, cust3.CreatedDate, "CreatedDate was not supposed to change");
Assert.AreNotEqual(cust2.UpdatedDate, cust3.UpdatedDate, "UpdatedDate was supposed to change");
}
finally
{
Release(dataSource);
}
}
public void AuditRulesTests_SoftDelete(string assemblyName, string dataSourceName)
{
var dataSource = DataSource(dataSourceName);
try
{
var key = Guid.NewGuid().ToString();
for (var i = 0; i < 2; i++)
dataSource.Insert(EmployeeTableName, new Employee() { FirstName = i.ToString("0000"), LastName = "Z" + (int.MaxValue - i), Title = key, MiddleName = i % 2 == 0 ? "A" + i : null }).ToObject<Employee>().Execute();
var users = dataSource.From(EmployeeTableName).ToCollection<Employee>().Execute();
var currentUser1 = users.First();
var currentUser2 = users.Skip(1).First();
var dsWithRules = dataSource.WithRules(
new SoftDeleteRule("DeletedFlag", true, OperationTypes.SelectOrDelete),
new UserDataRule("DeletedByKey", "EmployeeKey", OperationTypes.Delete),
new DateTimeRule("DeletedDate", DateTimeKind.Local, OperationTypes.Delete)
);
var ds1 = dsWithRules.WithUser(currentUser1);
var cust1 = new CustomerWithValidation() { FullName = "Test Customer " + DateTime.Now.Ticks, State = "CA" };
var cust2 = ds1.Insert(CustomerTableName, cust1).ToObject<CustomerWithValidation>().Execute();
var customerKey = cust2.CustomerKey;
Assert.False(cust2.DeletedFlag, "Deleted flag should be is clear");
Assert.IsNull(cust2.DeletedDate, "Deleted date should be null");
Assert.IsNull(cust2.DeletedByKey, "Deleted by key should be null");
ds1.Delete(CustomerTableName, new { CustomerKey = customerKey }).Execute();
var deletedRecord = dataSource.From(CustomerTableName, new { CustomerKey = customerKey }).ToObject<CustomerWithValidation>().Execute();
Assert.True(deletedRecord.DeletedFlag, "Deleted flag should be set");
Assert.IsNotNull(deletedRecord.DeletedDate, "Deleted date should be set");
Assert.AreEqual(currentUser1.EmployeeKey, deletedRecord.DeletedByKey, "Deleted by key should be set");
var misingRecord = ds1.From(CustomerTableName, new { CustomerKey = customerKey }).ToObject<CustomerWithValidation>(RowOptions.AllowEmptyResults).Execute();
Assert.IsNull(misingRecord, "The soft delete rule should prevent this record from being returned.");
#if OLE_SQL_SERVER
var misingRecord2 = ds1.From(CustomerTableName, "CustomerKey = ?", new { CustomerKey = customerKey }).ToObject<CustomerWithValidation>(RowOptions.AllowEmptyResults).Execute();
#else
var misingRecord2 = ds1.From(CustomerTableName, "CustomerKey = @CustomerKey", new { CustomerKey = customerKey }).ToObject<CustomerWithValidation>(RowOptions.AllowEmptyResults).Execute();
#endif
Assert.IsNull(misingRecord2, "The soft delete rule should prevent this record from being returned.");
var misingRecords = ds1.From(CustomerTableName).ToCollection<CustomerWithValidation>().Execute();
Assert.False(misingRecords.Any(r => r.CustomerKey == customerKey), "The soft delete rule should prevent this record from being returned.");
}
finally
{
Release(dataSource);
}
}
