public void StartStorageService()
{
var testSchema = DataSetStorageContext.CreateTestSchema();
Func <DataSchema> getTestSchema = () => { return(testSchema); };
objPersisterContext = new DataSetStorageContext(getTestSchema);
storageDalc = new StorageDalc(
objPersisterContext.StorageDbMgr.Dalc,
objPersisterContext.ObjectContainerStorage,
getTestSchema);
DataSetStorageContext.AddTestData(testSchema, objPersisterContext.ObjectContainerStorage);
var storageService = new StorageService(
objPersisterContext.ObjectContainerStorage,
storageDalc,
getTestSchema);
serviceHost = new WebServiceHost(storageService, new[] { new Uri(baseUrl) });
serviceHost.Description.Behaviors.Find <ServiceDebugBehavior>().IncludeExceptionDetailInFaults = true;
serviceHost.Description.Behaviors.Find <ServiceBehaviorAttribute>().InstanceContextMode = InstanceContextMode.Single;
serviceHost.Open();
var endPoint = (WebHttpEndpoint)serviceHost.Description.Endpoints.First();
endPoint.AutomaticFormatSelectionEnabled = true;
((WebHttpBehavior)endPoint.EndpointBehaviors.First()).AutomaticFormatSelectionEnabled = true;
((WebHttpBehavior)endPoint.EndpointBehaviors.First()).DefaultOutgoingResponseFormat = WebMessageFormat.Json;
}
public void createTestStorageDalc()
{
testSchema = DataSetStorageContext.CreateTestSchema();
Func <DataSchema> getTestSchema = () => { return(testSchema); };
objContext = new DataSetStorageContext(getTestSchema);
storageDalc = new StorageDalc(objContext.StorageDbMgr.Dalc, objContext.ObjectContainerStorage, getTestSchema);
}
public void RelationAddRemoveConstraint()
{
var o = DataSetStorageContext.CreateTestSchema();
var objPersisterContext = new DataSetStorageContext(() => { return(o); });
// add one company and one contact
var googCompany = new ObjectContainer(o.FindClassByID("companies"));
googCompany["title"] = "Google";
objPersisterContext.ObjectContainerStorage.Insert(googCompany);
var johnContact = new ObjectContainer(o.FindClassByID("contacts"));
johnContact["name"] = "John";
objPersisterContext.ObjectContainerStorage.Insert(johnContact);
// set relation
var rel = o.FindClassByID("contacts").FindRelationship(o.FindClassByID("contactCompany"), o.FindClassByID("companies"));
objPersisterContext.ObjectContainerStorage.AddRelation(
new ObjectRelation(johnContact.ID.Value, rel, googCompany.ID.Value));
// test relation
var johnRelations = objPersisterContext.ObjectContainerStorage.LoadRelations(johnContact,
new[] { rel });
Assert.AreEqual(1, johnRelations.Count());
Assert.AreEqual(false, johnRelations.First().Relation.Reversed);
Assert.AreEqual(johnContact.ID.Value, johnRelations.First().SubjectID);
Assert.AreEqual(googCompany.ID.Value, johnRelations.First().ObjectID);
var googRelations = objPersisterContext.ObjectContainerStorage.LoadRelations(googCompany,
new[] { o.FindClassByID("companies").FindRelationship(o.FindClassByID("contactCompany"), o.FindClassByID("contacts")) });
Assert.AreEqual(1, googRelations.Count());
Assert.AreEqual(true, googRelations.First().Relation.Reversed);
Assert.AreEqual(johnContact.ID.Value, googRelations.First().ObjectID);
Assert.AreEqual(googCompany.ID.Value, googRelations.First().SubjectID);
// constraint
var msCompany = new ObjectContainer(o.FindClassByID("companies"));
msCompany["title"] = "Microsoft";
objPersisterContext.ObjectContainerStorage.Insert(msCompany);
// try to add one more company for John
Assert.Throws <ConstraintException>(() => {
objPersisterContext.ObjectContainerStorage.AddRelation(
new ObjectRelation(johnContact.ID.Value, rel, msCompany.ID.Value));
});
}
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());
}