Ejemplo n.º 1
0
		public void TestTableRelation()
		{
			// Prepare and Cleanup
			Database.RegisterDataObject(typeof(TestTableRelation));
			Database.RegisterDataObject(typeof(TestTableRelationEntry));
			
			var all = Database.SelectAllObjects<TestTableRelationEntry>();
			
			foreach(var obj in all)
				Database.DeleteObject(obj);
			
			var none = Database.SelectAllObjects<TestTableRelationEntry>();
			
			Assert.IsEmpty(none, "Database shouldn't have any record For TestTableRelationEntry.");
			
			var allrel = Database.SelectAllObjects<TestTableRelation>();
			
			foreach(var obj in allrel)
				Database.DeleteObject(obj);
			
			var nonerel = Database.SelectAllObjects<TestTableRelation>();
			
			Assert.IsEmpty(nonerel, "Database shouldn't have any record For TestTableRelation.");
			
			// Try Add with no Relation
			var noRelObj = new TestTableRelation() { TestField = "RelationTestValue" };
			
			var inserted = Database.AddObject(noRelObj);
			
			Assert.IsTrue(inserted, "Test Table Relation could not insert object with no relation.");
			Assert.IsNull(noRelObj.Entry, "Test Table Relation object with no relation should have null Entry.");
			
			// Try Select
			var selectInserted = Database.SelectAllObjects<TestTableRelation>();
			CollectionAssert.IsNotEmpty(selectInserted, "Test Table Relation could not retrieve objects without relation.");
			
			// Try Adding Relation
			var relObj = new TestTableRelationEntry() { TestField = "RelationEntryTestValue", ObjectId = noRelObj.ObjectId };
			
			var relInserted = Database.AddObject(relObj);
			
			Assert.IsTrue(relInserted, "Test Table Relation Entry could not be inserted.");
			
			noRelObj.Entry = relObj;
			
			var saved = Database.SaveObject(noRelObj);
			
			Assert.IsTrue(saved, "Test Table Relation could not save Object with a new relation Added.");
			
			// Try Retrieving Relation
			var retrieve = Database.FindObjectByKey<TestTableRelation>(noRelObj.ObjectId);
			
			Assert.IsNotNull(retrieve, "Test Table Relation could not retrieve relation object by ObjectId.");
			Assert.IsNotNull(retrieve.Entry, "Test Table Relation retrieved object have no entry object.");
			Assert.AreEqual(relObj.TestField, retrieve.Entry.TestField, "Test Table Relation retrieved object Entry Relation is different from created object.");
			
			// Try Deleting Relation
			var deleted = Database.DeleteObject(noRelObj);
			
			Assert.IsTrue(deleted, "Test Table Relation could not delete object with relation.");
			Assert.IsTrue(noRelObj.IsDeleted, "Test Table Relation deleted object should have deleted flag set.");
			Assert.IsTrue(noRelObj.Entry.IsDeleted, "Test Table Relation deleted object Entry should have deleted flag set.");
			
			// Check that Relation was deleted
			var relRetrieve = Database.FindObjectByKey<TestTableRelationEntry>(relObj.ObjectId);
			
			Assert.IsNull(relRetrieve, "Test Table Relation Entry was not auto deleted with relation object.");
			Assert.IsTrue(relObj.IsDeleted, "Test Table Relation Entry should have deleted flag set after auto delete.");
			
			// Check Null Relation
			var nullObj = new TestTableRelation() { TestField = "RelationNullTestValue" };
			
			var nullAdded = Database.AddObject(nullObj);
			
			Assert.IsTrue(nullAdded, "Test Table Relation need an object for the Null Relation Test.");
			
			nullObj.ObjectId = null;
			nullObj.Entry = new TestTableRelationEntry() { TestField = "RelationEntryNullTestValue" };
			
			Database.FillObjectRelations(nullObj);

			Assert.IsNull(nullObj.Entry, "Test Table Relation should not have entry with null local value.");
			
			// Check Allow Add Restriction
			var allowAddRestriction =  new TestTableRelation() { TestField = "RelationTestValueAllowAddRestriction" };
			
			allowAddRestriction.Entry = new TestTableRelationEntry() { TestField = "RelationEntryTestValueAllowAddRestriction", ObjectId = allowAddRestriction.ObjectId, AllowAdd = false };
			
			var restrictionAdded = Database.AddObject(allowAddRestriction);
			
			Assert.IsFalse(restrictionAdded, "Test Table Relation should return error when relation failed saving.");
			Assert.IsTrue(allowAddRestriction.IsPersisted, "Test Table Relation should be persisted in database.");			
			Assert.IsFalse(allowAddRestriction.Entry.IsPersisted, "Test Table Relation Entry should not be persisted if AllowAdd Restriction is in place.");
			
			// Check Dirty Restriction
			allowAddRestriction.Entry.AllowAdd = true;
			
			var restrictionSaved = Database.SaveObject(allowAddRestriction);
			
			Assert.IsTrue(restrictionSaved, "Test Table Relation restriction test should have the restricted object seved to database.");
			Assert.IsTrue(allowAddRestriction.Entry.IsPersisted, "Test Table Relation Entry restriction test should be persisted.");
			
			Assert.IsFalse(allowAddRestriction.Dirty, "Test Table Relation restriction object should not have Dirty flag after saving.");
			
			var modifiedText = "RelationEntryTestValueAllowAddRestrictionModified";
			allowAddRestriction.Entry.TestField = modifiedText;
			allowAddRestriction.Entry.Dirty = false;
			
			Assert.IsFalse(allowAddRestriction.Entry.Dirty, "Test Table Relation Entry need to have its Dirty flag off for this Test.");
			
			var modifySaved = Database.SaveObject(allowAddRestriction);
			
			Assert.IsTrue(modifySaved, "Test Table Relation should be saved correctly with Dirty flag off.");
			
			Database.FillObjectRelations(allowAddRestriction);
			
			Assert.AreNotEqual(modifiedText, allowAddRestriction.Entry.TestField, "Test Table Relation Entry should not have been saved with modified text.");
			
			// Check Allow Delete Restriction
			var restrictionEntry = allowAddRestriction.Entry;
			allowAddRestriction.Entry.AllowDelete = false;
			
			var restrictionDeleted = Database.DeleteObject(allowAddRestriction);
			
			Assert.IsFalse(restrictionDeleted, "Test Table Relation should not be deleted correctly.");
			Assert.IsTrue(restrictionEntry.IsPersisted, "Test Table Relation Entry should still be Persisted.");
			Assert.IsFalse(restrictionEntry.IsDeleted, "Test Table Relation Entry should not be deleted.");
			Assert.IsFalse(allowAddRestriction.IsPersisted, "Test Table Relation object should not be persisted.");
		}
Ejemplo n.º 2
0
		public void TestTableRelation()
		{
			// Prepare and Cleanup
			DatabaseSetUp.Database.RegisterDataObject(typeof(TestTableRelation));
			DatabaseSetUp.Database.RegisterDataObject(typeof(TestTableRelationEntry));
			
			var all = DatabaseSetUp.Database.SelectAllObjects<TestTableRelationEntry>();
			
			foreach(var obj in all)
				DatabaseSetUp.Database.DeleteObject(obj);
			
			var none = DatabaseSetUp.Database.SelectAllObjects<TestTableRelationEntry>();
			
			Assert.IsEmpty(none, "Database shouldn't have any record For TestTableRelationEntry.");
			
			var allrel = DatabaseSetUp.Database.SelectAllObjects<TestTableRelation>();
			
			foreach(var obj in allrel)
				DatabaseSetUp.Database.DeleteObject(obj);
			
			var nonerel = DatabaseSetUp.Database.SelectAllObjects<TestTableRelation>();
			
			Assert.IsEmpty(nonerel, "Database shouldn't have any record For TestTableRelation.");
			
			// Try Add with no Relation
			var noRelObj = new TestTableRelation() { TestField = "RelationTestValue" };
			
			var inserted = DatabaseSetUp.Database.AddObject(noRelObj);
			
			Assert.IsTrue(inserted, "Test Table Relation could not insert object with no relation.");
			Assert.IsNull(noRelObj.Entry, "Test Table Relation object with no relation should have null Entry.");
			
			// Try Adding Relation
			var relObj = new TestTableRelationEntry() { TestField = "RelationEntryTestValue", ObjectId = noRelObj.ObjectId };
			
			var relInserted = DatabaseSetUp.Database.AddObject(relObj);
			
			Assert.IsTrue(relInserted, "Test Table Relation Entry could not be inserted.");
			
			noRelObj.Entry = relObj;
			
			var saved = DatabaseSetUp.Database.SaveObject(noRelObj);
			
			Assert.IsTrue(saved, "Test Table Relation could not save Object with a new relation Added.");
			
			// Try Retrieving Relation
			var retrieve = DatabaseSetUp.Database.FindObjectByKey<TestTableRelation>(noRelObj.ObjectId);
			
			Assert.IsNotNull(retrieve, "Test Table Relation could not retrieve relation object by ObjectId.");
			Assert.IsNotNull(retrieve.Entry, "Test Table Relation retrieved object have no entry object.");
			Assert.AreEqual(relObj.TestField, retrieve.Entry.TestField, "Test Table Relation retrieved object Entry Relation is different from created object.");
			
			// Try Deleting Relation
			var deleted = DatabaseSetUp.Database.DeleteObject(noRelObj);
			
			Assert.IsTrue(deleted, "Test Table Relation could not delete object with relation.");
			Assert.IsTrue(noRelObj.IsDeleted, "Test Table Relation deleted object should have deleted flag set.");
			
			// Check that Relation was deleted
			var relRetrieve = DatabaseSetUp.Database.FindObjectByKey<TestTableRelationEntry>(relObj.ObjectId);
			
			Assert.IsNull(relRetrieve, "Test Table Relation Entry was not auto deleted with relation object.");
			Assert.IsTrue(relObj.IsDeleted, "Test Table Relation Entry should have deleted flag set after auto delete.");
		}