public void InsertLoadUpdateDelete()
{
var o = DataSetStorageContext.CreateTestSchema();
var objPersisterContext = new DataSetStorageContext(() => { return(o); });
var googCompany = new ObjectContainer(o.FindClassByID("companies"));
googCompany["title"] = "Google";
Assert.Catch <ArgumentException>(new TestDelegate(() => {
googCompany["name"] = "ZZZ";
}));
googCompany["net_income"] = 999;
var yahooCompany = new ObjectContainer(o.FindClassByID("companies"));
yahooCompany["title"] = "Yahoo Inc";
var googleChildCompany = new ObjectContainer(o.FindClassByID("companies"));
googleChildCompany["title"] = "YouTube";
var johnContact = new ObjectContainer(o.FindClassByID("contacts"));
johnContact["name"] = "John";
johnContact["is_primary"] = true;
var maryContact = new ObjectContainer(o.FindClassByID("contacts"));
maryContact["name"] = "Mary";
maryContact["is_primary"] = false;
maryContact["birthday"] = new DateTime(1999, 5, 20);
var bobContact = new ObjectContainer(o.FindClassByID("contacts"));
bobContact["name"] = "Bob";
bobContact["is_primary"] = true;
var usaCountry = new ObjectContainer(o.FindClassByID("countries"));
usaCountry["title"] = "USA";
var canadaCountry = new ObjectContainer(o.FindClassByID("countries"));
canadaCountry["title"] = "Canada";
objPersisterContext.ObjectContainerStorage.Insert(googCompany);
Assert.True(googCompany.ID.HasValue);
AssertObjectLog(objPersisterContext.StorageDS, googCompany.ID.Value, "insert");
objPersisterContext.ObjectContainerStorage.Insert(yahooCompany);
objPersisterContext.ObjectContainerStorage.Insert(googleChildCompany);
objPersisterContext.ObjectContainerStorage.Insert(johnContact);
objPersisterContext.ObjectContainerStorage.Insert(maryContact);
objPersisterContext.ObjectContainerStorage.Insert(bobContact);
objPersisterContext.ObjectContainerStorage.Insert(usaCountry);
objPersisterContext.ObjectContainerStorage.Insert(canadaCountry);
// load test
var maryCopy = objPersisterContext.ObjectContainerStorage.Load(new[] { maryContact.ID.Value }).Values.FirstOrDefault();
Assert.NotNull(maryCopy, "Object Load failed");
Assert.AreEqual((string)maryContact["name"], (string)maryCopy["name"]);
Assert.AreEqual((bool)maryContact["is_primary"], (bool)maryCopy["is_primary"]);
Assert.AreEqual((DateTime)maryContact["birthday"], (DateTime)maryCopy["birthday"]);
var googCopy = objPersisterContext.ObjectContainerStorage.Load(new[] { googCompany.ID.Value }).Values.FirstOrDefault();
Assert.NotNull(googCopy, "Object Load failed");
Assert.AreEqual((string)googCompany["title"], (string)googCopy["title"]);
Assert.AreEqual((decimal)googCompany["net_income"], (decimal)googCopy["net_income"]);
// update test
maryCopy["name"] = "Mary Second";
maryCopy["birthday"] = new DateTime(1988, 2, 10);
maryCopy["is_primary"] = true;
objPersisterContext.ObjectContainerStorage.Update(maryCopy);
AssertObjectLog(objPersisterContext.StorageDS, maryCopy.ID.Value, "update");
// reload mary contact
maryContact = objPersisterContext.ObjectContainerStorage.Load(new[] { maryContact.ID.Value }).Values.FirstOrDefault();
Assert.AreEqual((string)maryContact["name"], "Mary Second");
Assert.AreEqual((bool)maryContact["is_primary"], true);
Assert.AreEqual((DateTime)maryContact["birthday"], (DateTime)maryCopy["birthday"]);
// test relations
var contactToCompanyRel = maryContact.GetClass().FindRelationship(
o.FindClassByID("contactCompany"), googCompany.GetClass()
);
var companyToParentCompanyRel = googleChildCompany.GetClass().FindRelationship(
o.FindClassByID("parentCompany"), googCompany.GetClass(), false
);
var companyToCountryRel = googCompany.GetClass().FindRelationship(
o.FindClassByID("companyCountry"), usaCountry.GetClass(), false
);
objPersisterContext.ObjectContainerStorage.AddRelation(
new ObjectRelation(maryContact.ID.Value, contactToCompanyRel, googCompany.ID.Value),
new ObjectRelation(johnContact.ID.Value, contactToCompanyRel, googCompany.ID.Value),
new ObjectRelation(bobContact.ID.Value, contactToCompanyRel, yahooCompany.ID.Value),
new ObjectRelation(googleChildCompany.ID.Value, companyToParentCompanyRel, googCompany.ID.Value),
new ObjectRelation(googCompany.ID.Value, companyToCountryRel, usaCountry.ID.Value),
new ObjectRelation(yahooCompany.ID.Value, companyToCountryRel, usaCountry.ID.Value),
new ObjectRelation(googleChildCompany.ID.Value, companyToCountryRel, canadaCountry.ID.Value)
);
var googCompanyRels = objPersisterContext.ObjectContainerStorage.LoadRelations(googCompany, null);
Assert.AreEqual(4, googCompanyRels.Count(), "Expected 3 relations for Google company");
var yahooCompanyRels = objPersisterContext.ObjectContainerStorage.LoadRelations(yahooCompany, null);
Assert.AreEqual(2, yahooCompanyRels.Count(), "Expected 1 relation for Yahoo company");
Assert.AreEqual(bobContact.ID.Value,
yahooCompanyRels.Where(r => r.Relation.Predicate.ID == "contactCompany").First().ObjectID,
"Bob should be a only contact of Yahoo");
// remove rel
var maryRel = googCompanyRels.Where(r => r.ObjectID == maryContact.ID.Value).First();
objPersisterContext.ObjectContainerStorage.RemoveRelation(
new ObjectRelation(
googCompany.ID.Value,
googCompany.GetClass().FindRelationship(o.FindClassByID("contactCompany"), maryContact.GetClass()),
maryContact.ID.Value)
);
Assert.AreEqual(1, objPersisterContext.ObjectContainerStorage.LoadRelations(googCompany,
new[] {
googCompany.GetClass().FindRelationship(o.FindClassByID("contactCompany"), maryContact.GetClass())
}).Count(),
"Expected 1 relation for Google company after Mary removal");
// test for inferred relation
var johnToCountryRels = objPersisterContext.ObjectContainerStorage.LoadRelations(johnContact, new[] {
new Relationship(
johnContact.GetClass(),
new [] { contactToCompanyRel, companyToCountryRel },
o.FindClassByID("countries"))
});
Assert.AreEqual(1, johnToCountryRels.Count());
Assert.AreEqual(usaCountry.ID.Value, johnToCountryRels.First().ObjectID);
//Console.WriteLine("DataSet after test:\n" + objPersisterContext.StorageDS.GetXml());
}