public void TestMultiDeleteEntity() { int empKey = -1; int ordKey = -1; CustomerGroup custGroup = new CustomerGroup(); custGroup.es.Connection.Name = "ForeignKeyTest"; EmployeeCollection empColl = new EmployeeCollection(); empColl.es.Connection.Name = "ForeignKeyTest"; Employee emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; Employee testEmp = new Employee(); testEmp.es.Connection.Name = "ForeignKeyTest"; Customer cust = new Customer(); cust.es.Connection.Name = "ForeignKeyTest"; Order ord = new Order(); ord.es.Connection.Name = "ForeignKeyTest"; try { using (esTransactionScope scope = new esTransactionScope()) { // Setup custGroup.GroupID = "YYYYY"; custGroup.GroupName = "Test"; custGroup.Save(); emp = empColl.AddNew(); emp.LastName = "LastName"; emp.FirstName = "FirstName"; cust = emp.CustomerCollectionByStaffAssigned.AddNew(); cust.CustomerID = "YYYYY"; cust.CustomerSub = "YYY"; cust.CustomerName = "Test"; cust.str().DateAdded = "2007-01-01 00:00:00"; cust.Active = true; cust.Manager = 1; ord = emp.OrderCollectionByEmployeeID.AddNew(); ord.CustID = "YYYYY"; ord.CustSub = "YYY"; ord.str().OrderDate = "2007-01-01"; empColl.Save(); empKey = emp.EmployeeID.Value; ordKey = ord.OrderID.Value; Assert.AreEqual(1, emp.CustomerCollectionByStaffAssigned.Count); Assert.AreEqual(1, emp.OrderCollectionByEmployeeID.Count); Assert.AreEqual(emp.EmployeeID.Value, cust.StaffAssigned.Value); Assert.AreEqual(emp.EmployeeID.Value, ord.EmployeeID.Value); // Test testEmp.LoadByPrimaryKey(empKey); testEmp.OrderCollectionByEmployeeID.MarkAllAsDeleted(); testEmp.CustomerCollectionByStaffAssigned.MarkAllAsDeleted(); testEmp.MarkAsDeleted(); testEmp.Save(); emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; Assert.IsFalse(emp.LoadByPrimaryKey(empKey)); ord = new Order(); ord.es.Connection.Name = "ForeignKeyTest"; Assert.IsFalse(ord.LoadByPrimaryKey(ordKey)); cust = new Customer(); cust.es.Connection.Name = "ForeignKeyTest"; Assert.IsFalse(cust.LoadByPrimaryKey("YYYYY", "YYY")); } } finally { // Clean up ord = new Order(); ord.es.Connection.Name = "ForeignKeyTest"; if (ord.LoadByPrimaryKey(ordKey)) { ord.MarkAsDeleted(); ord.Save(); } cust = new Customer(); cust.es.Connection.Name = "ForeignKeyTest"; if (cust.LoadByPrimaryKey("YYYYY", "YYY")) { cust.MarkAsDeleted(); cust.Save(); } emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; if (emp.LoadByPrimaryKey(empKey)) { emp.MarkAsDeleted(); emp.Save(); } custGroup = new CustomerGroup(); custGroup.es.Connection.Name = "ForeignKeyTest"; if (custGroup.LoadByPrimaryKey("YYYYY")) { custGroup.MarkAsDeleted(); custGroup.Save(); } } }
public void TestProxiesDirtyRowsOnly() { EmployeeCollection coll = new EmployeeCollection(); Employee e = coll.AddNew(); e.EmployeeID = 1; e.FirstName = "unchanged"; e.LastName = "unchanged"; e = coll.AddNew(); e.EmployeeID = 2; e.FirstName = "unchanged"; e.LastName = "unchanged"; e = coll.AddNew(); e.EmployeeID = 3; e.FirstName = "deleted"; e.LastName = "deleted"; coll.AcceptChanges(); coll[2].MarkAsDeleted(); e = coll.AddNew(); e.EmployeeID = 4; e.FirstName = "Added"; e.LastName = "Added"; EmployeeCollectionProxyStub proxy = new EmployeeCollectionProxyStub(coll); string qq = esDataContractSerializer.ToXml(proxy); }
public void TestSaveFromCollection() { int empKey = -1; CustomerGroup custGroup = new CustomerGroup(); custGroup.es.Connection.Name = "ForeignKeyTest"; EmployeeCollection empColl = new EmployeeCollection(); empColl.es.Connection.Name = "ForeignKeyTest"; Employee emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; Customer cust = new Customer(); cust.es.Connection.Name = "ForeignKeyTest"; try { using (esTransactionScope scope = new esTransactionScope()) { custGroup.GroupID = "XXXXX"; custGroup.GroupName = "Test"; custGroup.Save(); emp = empColl.AddNew(); emp.LastName = "LastName"; emp.FirstName = "FirstName"; cust = emp.CustomerCollectionByStaffAssigned.AddNew(); cust.CustomerID = "XXXXX"; cust.CustomerSub = "XXX"; cust.CustomerName = "Test"; cust.str().DateAdded = "2007-01-01 00:00:00"; cust.Active = true; cust.Manager = 1; empColl.Save(); empKey = emp.EmployeeID.Value; Assert.AreEqual(1, emp.CustomerCollectionByStaffAssigned.Count); Assert.AreEqual(emp.EmployeeID.Value, cust.StaffAssigned.Value); } } finally { // Clean up emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; if (emp.LoadByPrimaryKey(empKey)) { CustomerCollection custColl = emp.CustomerCollectionByStaffAssigned; custColl.MarkAllAsDeleted(); emp.MarkAsDeleted(); emp.Save(); } custGroup = new CustomerGroup(); custGroup.es.Connection.Name = "ForeignKeyTest"; if (custGroup.LoadByPrimaryKey("XXXXX")) { custGroup.MarkAsDeleted(); custGroup.Save(); } } }
public void TestSaveSimpleCollection() { int empKey = -1; EmployeeCollection empColl = new EmployeeCollection(); empColl.es.Connection.Name = "ForeignKeyTest"; Employee emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; try { using (esTransactionScope scope = new esTransactionScope()) { empColl.LoadAll(); emp = empColl.AddNew(); emp.LastName = "LastName"; emp.FirstName = "FirstName"; Order ord = emp.OrderCollectionByEmployeeID.AddNew(); ord.CustID = "10001"; ord.CustSub = "001"; ord.str().OrderDate = "2007-01-01 00:00:00"; empColl.Save(); empKey = emp.EmployeeID.Value; Assert.AreEqual(1, emp.OrderCollectionByEmployeeID.Count); Assert.AreEqual(emp.EmployeeID.Value, ord.EmployeeID.Value); } } finally { // Clean up emp = new Employee(); emp.es.Connection.Name = "ForeignKeyTest"; if (emp.LoadByPrimaryKey(empKey)) { OrderCollection ordColl = emp.OrderCollectionByEmployeeID; ordColl.MarkAllAsDeleted(); emp.MarkAsDeleted(); emp.Save(); } } }
public void ErrorsWithContinueTrueNoFailures() { EmployeeCollection coll = new EmployeeCollection(); coll.es.Connection.Name = "ForeignKeyTest"; coll.LoadAll(); Assert.AreEqual(5, coll.Count, "Initial Load"); using (esTransactionScope scope = new esTransactionScope()) { // INSERT will succeed Employee emp5 = coll.AddNew(); emp5.FirstName = "First5"; emp5.LastName = "Last5"; coll.Save(true); Assert.AreEqual(0, coll.Errors.Count(), "ErrorsCount"); Assert.IsNull(coll.es.DeletedEntities, "DeletedErrors"); // Confirm only 1 row got INSERTed EmployeeCollection coll2 = new EmployeeCollection(); coll2.es.Connection.Name = "ForeignKeyTest"; coll2.LoadAll(); Assert.AreEqual(6, coll2.Count, "Load"); // Confirm auto-incremeting PKs are brought back // and delete the successfully inserted row int emp5Id = emp5.EmployeeID.Value; Employee emp5Ins = new Employee(); emp5Ins.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(emp5Ins.LoadByPrimaryKey(emp5Id), "LoadByPK2"); emp5Ins.MarkAsDeleted(); emp5Ins.Save(); } }
public void ErrorsWithContinueTrueInsUpdDel() { EmployeeCollection coll = new EmployeeCollection(); coll.es.Connection.Name = "ForeignKeyTest"; coll.LoadAll(); Assert.AreEqual(5, coll.Count, "Initial Load"); using (esTransactionScope scope = new esTransactionScope()) { // SQLite does not enforce FK constraints // So force a concurrency failure instead if (coll.es.Connection.ProviderSignature.DataProviderName == "EntitySpaces.SQLiteProvider") { Employee empConcurr = new Employee(); empConcurr.es.Connection.Name = "ForeignKeyTest"; empConcurr.LoadByPrimaryKey(2); empConcurr.MarkAsDeleted(); empConcurr.Save(); } // INSERT will succeed Employee emp1 = coll.AddNew(); emp1.FirstName = "First1"; emp1.LastName = "Last1"; // INSERT will fail - LastName required Employee emp2 = coll.AddNew(); // UPDATE will fail - LastName required Employee emp3 = coll.FindByPrimaryKey(1); emp3.LastName = null; // DELETE will fail - FK constraint Employee emp4 = coll.FindByPrimaryKey(2); emp4.MarkAsDeleted(); // INSERT will succeed Employee emp5 = coll.AddNew(); emp5.FirstName = "First5"; emp5.LastName = "Last5"; coll.Save(true); Assert.AreEqual(3, coll.Errors.Count(), "ErrorsCount"); Assert.IsNotNull(coll.es.DeletedEntities, "DeletedErrors"); foreach (Employee e in coll.Errors) { Assert.IsTrue(e.es.RowError.Length > 0); } // Confirm only 2 rows got INSERTed EmployeeCollection coll2 = new EmployeeCollection(); coll2.es.Connection.Name = "ForeignKeyTest"; coll2.LoadAll(); if (coll.es.Connection.ProviderSignature.DataProviderName == "EntitySpaces.SQLiteProvider") { Assert.AreEqual(6, coll2.Count, "Load"); } else { Assert.AreEqual(7, coll2.Count, "Load"); // Confirm nothing got DELETEd Employee empDel = new Employee(); empDel.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(empDel.LoadByPrimaryKey(2), "Delete"); } // Confirm nothing got UPDATEd Employee empUpd = new Employee(); empUpd.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(empUpd.LoadByPrimaryKey(1)); Assert.AreEqual("Smith", empUpd.LastName, "Update"); // Confirm auto-incremeting PKs are brought back // and delete the 2 successfully inserted rows int emp1Id = emp1.EmployeeID.Value; Employee emp1Ins = new Employee(); emp1Ins.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(emp1Ins.LoadByPrimaryKey(emp1Id), "LoadByPK1"); emp1Ins.MarkAsDeleted(); emp1Ins.Save(); int emp5Id = emp5.EmployeeID.Value; Employee emp5Ins = new Employee(); emp5Ins.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(emp5Ins.LoadByPrimaryKey(emp5Id), "LoadByPK2"); emp5Ins.MarkAsDeleted(); emp5Ins.Save(); } }
public void ErrorsWithContinueTrueInsUpd() { using (esTransactionScope scope = new esTransactionScope()) { EmployeeCollection coll = new EmployeeCollection(); coll.es.Connection.Name = "ForeignKeyTest"; // This employee should save fine Employee e = coll.AddNew(); e.FirstName = "Test1"; e.LastName = "K98700"; // Should fail, missing LastName e = coll.AddNew(); e.FirstName = "Joe"; // Should fail, missing FirstName e = coll.AddNew(); e.LastName = "Kokomo"; // This employee should save fine e = coll.AddNew(); e.FirstName = "Test4"; e.LastName = "K98700"; try { coll.Save(true); // ContinueUpdateOnError } catch { Assert.Fail("1. We shouldn't get here"); } Assert.IsTrue(coll.Errors.Count() == 2, "Count"); Assert.IsTrue(coll[0].es.RowState == esDataRowState.Unchanged, "Unchanged0"); Assert.IsTrue(coll[1].es.RowState == esDataRowState.Added, "Added1"); Assert.IsTrue(coll[2].es.RowState == esDataRowState.Added, "Added2"); Assert.IsTrue(coll[3].es.RowState == esDataRowState.Unchanged, "Unchanged3"); Assert.IsTrue(coll[0].EmployeeID != null, "Id0"); Assert.IsTrue(coll[1].EmployeeID == null, "Id1"); Assert.IsTrue(coll[2].EmployeeID == null, "Id2"); Assert.IsTrue(coll[3].EmployeeID != null, "Id3"); foreach (Employee emp in coll.Errors) { Assert.IsTrue(emp.es.RowState == esDataRowState.Added, "ForeachRowSate"); Assert.IsTrue(emp.es.RowError != null, "ForeachRowError"); Assert.IsTrue(emp.es.RowError.Length > 0, "ForeachLength"); } // Call Save again with the 2 bad records just for kicks try { coll.Save(true); // ContinueUpdateOnError } catch { Assert.Fail("2. We shouldn't get here, either"); } Assert.IsTrue(coll.Errors.Count() == 2); // Fix our two bad records and call Save again coll[1].LastName = "LastName"; coll[2].FirstName = "FirstName"; try { coll.Save(true); // ContinueUpdateOnError } catch { Assert.Fail("3. We shouldn't get here, either"); } Assert.IsTrue(coll.Errors.Count() == 0); // Load the two original records and see if they were saved even though during the // save there were two bad records coll = new EmployeeCollection(); coll.es.Connection.Name = "ForeignKeyTest"; coll.Query.Where(coll.Query.LastName == "K98700"); coll.Query.Load(); Assert.IsTrue(coll.Count() == 2, "FinalCount"); } }
public void ErrorsWithContinueDefaultFalse() { EmployeeCollection coll = new EmployeeCollection(); coll.es.Connection.Name = "ForeignKeyTest"; coll.LoadAll(); Assert.AreEqual(5, coll.Count, "Initial Load"); using (esTransactionScope scope = new esTransactionScope()) { try { // INSERT would succeed // but should rollback by default Employee emp1 = coll.AddNew(); emp1.FirstName = "asdf"; emp1.LastName = "adf"; // INSERT will fail - LastName required Employee emp2 = coll.AddNew(); // UPDATE will fail - LastName required Employee emp3 = coll.FindByPrimaryKey(1); emp3.LastName = null; // DELETE will fail - FK constraint Employee emp4 = coll.FindByPrimaryKey(2); emp4.MarkAsDeleted(); coll.Save(false); } catch (Exception ex) { // Save() throws exception on first error encountered Assert.AreEqual(1, coll.Errors.Count(), "ExceptionCount"); Assert.IsTrue(ex.ToString().Length > 0, "ExceptionLength"); } finally { // Confirm nothing got INSERTed EmployeeCollection coll2 = new EmployeeCollection(); coll2.es.Connection.Name = "ForeignKeyTest"; coll2.LoadAll(); Assert.AreEqual(5, coll2.Count, "LoadInFinally"); // Confirm nothing got UPDATEd Employee empUpd = coll2.FindByPrimaryKey(1); Assert.AreEqual("Smith", empUpd.LastName, "Update"); // Confirm nothing got DELETEd Employee empDel = new Employee(); empDel.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(empDel.LoadByPrimaryKey(2), "Delete"); } } }
public void CollectionMixedInsUpdDel() { using (esTransactionScope scope = new esTransactionScope()) { // Setup Employee newEmp = new Employee(); newEmp.es.Connection.Name = "ForeignKeyTest"; newEmp.LastName = "new"; newEmp.FirstName = "new"; newEmp.Save(); EmployeeCollection coll = new EmployeeCollection(); coll.es.Connection.Name = "ForeignKeyTest"; coll.LoadAll(); Assert.AreEqual(6, coll.Count, "Initial Load"); // Insert Employee emp1 = coll.AddNew(); emp1.FirstName = "emp1"; emp1.LastName = "emp1"; // Update Employee emp3 = coll.FindByPrimaryKey(1); emp3.LastName = "emp3"; // Delete Employee emp4 = coll.FindByPrimaryKey(newEmp.EmployeeID.Value); emp4.MarkAsDeleted(); coll.Save(); // Confirm INSERT Employee empIns = new Employee(); empIns.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(empIns.LoadByPrimaryKey(emp1.EmployeeID.Value), "Insert"); // Confirm UPDATE Employee empUpd = new Employee(); empUpd.es.Connection.Name = "ForeignKeyTest"; Assert.IsTrue(empUpd.LoadByPrimaryKey(1), "Update"); Assert.AreEqual("emp3", empUpd.LastName, "UpdateValue"); // Confirm DELETE Employee empDel = new Employee(); empDel.es.Connection.Name = "ForeignKeyTest"; Assert.IsFalse(empDel.LoadByPrimaryKey(newEmp.EmployeeID.Value), "Delete"); } }