public virtual void Test2() { DeleteBase("t2.ndb"); var odb = Open("t2.ndb"); var query8 = odb.Query<User>(); var nbUsers = query8.Execute<User>().Count; var query = odb.Query<Profile>(); var nbProfiles = query.Execute<Profile>(true).Count; var query1 = odb.Query<VO.Login.Function>(); var nbFunctions = query1.Execute<VO.Login.Function>(true).Count; var login = new VO.Login.Function("login"); var logout = new VO.Login.Function("logout"); IList<VO.Login.Function> list = new List<VO.Login.Function>(); list.Add(login); list.Add(logout); var profile = new Profile("operator", list); var olivier = new User("olivier smadja", "*****@*****.**", profile); var aisa = new User("Aísa Galvão Smadja", "*****@*****.**", profile); odb.Store(olivier); odb.Store(aisa); odb.Commit(); var query2 = odb.Query<User>(); var users = query2.Execute<User>(true); var query3 = odb.Query<Profile>(); var profiles = query3.Execute<Profile>(true); var query4 = odb.Query<VO.Login.Function>(); var functions = query4.Execute<VO.Login.Function>(true); odb.Close(); // println("Users:"+users); Println("Profiles:" + profiles); Println("Functions:" + functions); odb = Open("t2.ndb"); var query5 = odb.Query<User>(); var l = query5.Execute<User>(true); odb.Close(); AssertEquals(nbUsers + 2, users.Count); var user2 = users.GetFirst(); AssertEquals(olivier.ToString(), user2.ToString()); AssertEquals(nbProfiles + 1, profiles.Count); AssertEquals(nbFunctions + 2, functions.Count); var odb2 = Open("t2.ndb"); var query6 = odb2.Query<VO.Login.Function>(); var l2 = query6.Execute<VO.Login.Function>(true); var function = l2.GetFirst(); function.SetName("login function"); odb2.Store(function); odb2.Close(); var odb3 = Open("t2.ndb"); var query7 = odb3.Query<User>(); var l3 = query7.Execute<User>(true); var i = 0; while (l3.HasNext() && i < Math.Min(2, l3.Count)) { var user = l3.Next(); AssertEquals("login function", string.Empty + user.GetProfile().GetFunctions()[0]); i++; } odb3.Close(); DeleteBase("t2.ndb"); }
public virtual void Test8() { DeleteBase(Name); var odb = Open(Name); var user = new User("name", "email", new Profile("p1", new VO.Login.Function("function"))); odb.Store(user); odb.Close(); odb = Open(Name); var query = odb.Query<Profile>(); var p = query.Execute<Profile>().GetFirst(); odb.Delete(p); odb.Close(); odb = Open(Name); var query1 = odb.Query<User>(); var user3 = query1.Execute<User>().GetFirst(); AssertNull(user3.GetProfile()); user3.SetProfile(new Profile("new profile", new VO.Login.Function("f1"))); user3.SetEmail("email2"); user3.SetName("name2"); odb.Store(user3); odb.Close(); odb = Open(Name); var query2 = odb.Query<User>(); var user4 = query2.Execute<User>().GetFirst(); odb.Close(); DeleteBase(Name); AssertEquals("new profile", user4.GetProfile().GetName()); AssertEquals("email2", user4.GetEmail()); AssertEquals("name2", user4.GetName()); }
public virtual void TestSelectTrigger() { IOdb odb = null; DeleteBase("trigger.ndb"); var myTrigger = new MySelectTrigger(); try { odb = Open("trigger.ndb"); var f1 = new VO.Login.Function("function1"); var f2 = new VO.Login.Function("function2"); var profile = new Profile("profile1", f1); var user = new User("oli", "*****@*****.**", profile); odb.Store(user); odb.Store(f2); } finally { if (odb != null) odb.Close(); } odb = Open("trigger.ndb"); odb.TriggerManagerFor<VO.Login.Function>().AddSelectTrigger(myTrigger); var query = odb.Query<VO.Login.Function>(); var functions = query.Execute<VO.Login.Function>(); odb.Close(); DeleteBase("trigger.ndb"); AssertEquals(2, functions.Count); AssertEquals(2, myTrigger.nbCalls); }
public virtual void TestComplexInstance() { DeleteBase("t-complex-instance.ndb"); var odb = Open("t-complex-instance.ndb"); var login = new VO.Login.Function("login"); var logout = new VO.Login.Function("logout"); var functions = new List<VO.Login.Function>(); functions.Add(login); functions.Add(logout); var profile = new Profile("profile1", functions); var user = new User("oliver", "*****@*****.**", profile); var user22 = new User("oliver2", "*****@*****.**", profile); odb.Store(user); odb.Store(user22); odb.Close(); odb = Open("t-complex-instance.ndb"); var query = odb.Query<User>(); var l = query.Execute<User>(true); var user2 = l.GetFirst(); // println("#### " + l.size() + " : " + l); AssertEquals(user.GetName(), user2.GetName()); AssertEquals(user.GetEmail(), user2.GetEmail()); AssertEquals(user.GetProfile().GetName(), user2.GetProfile().GetName()); AssertEquals(user.GetProfile().GetFunctions()[0].ToString(), user2.GetProfile().GetFunctions()[0].ToString()); odb.Close(); DeleteBase("t-complex-instance.ndb"); }
public virtual void Test1() { DeleteBase("null.ndb"); var odb = Open("null.ndb"); var user1 = new User("oli", "oli@sdsadf", null); var user2 = new User("karine", "karine@sdsadf", null); var user3 = new User(null, null, null); odb.Store(user1); odb.Store(user2); odb.Store(user3); odb.Close(); odb = Open("null.ndb"); var query = odb.Query<User>(); var l = query.Execute<User>(true); AssertEquals(3, l.Count); user1 = l.Next(); AssertEquals("oli", user1.GetName()); AssertEquals("oli@sdsadf", user1.GetEmail()); AssertEquals(null, user1.GetProfile()); user2 = l.Next(); AssertEquals("karine", user2.GetName()); AssertEquals("karine@sdsadf", user2.GetEmail()); AssertEquals(null, user2.GetProfile()); user3 = l.Next(); AssertEquals(null, user3.GetName()); AssertEquals(null, user3.GetEmail()); AssertEquals(null, user3.GetProfile()); odb.Close(); DeleteBase("null.ndb"); }
public virtual void TestCriteriaQueryQueryWithValueInList() { var baseName = GetBaseName(); Init(baseName); var odb = Open(baseName); var p0 = new Profile("profile0"); p0.AddFunction(null); p0.AddFunction(new VO.Login.Function("f1")); p0.AddFunction(new VO.Login.Function("f2")); var p1 = new Profile("profile1"); p1.AddFunction(null); p1.AddFunction(new VO.Login.Function("f12")); p1.AddFunction(new VO.Login.Function("f22")); var user = new User("The user", "themail", p0); var user2 = new User("The user2", "themail2", p1); odb.Store(user); odb.Store(user2); odb.Close(); odb = Open(baseName); var criteriaQuery = odb.Query<VO.Login.Function>(); criteriaQuery.Descend("name").Constrain((object) "f2").Equal(); var f2bis = criteriaQuery.Execute<VO.Login.Function>().GetFirst(); var query = odb.Query<User>(); query.Descend("profile.functions").Constrain(f2bis).Contains(); var l = query.Execute<User>(); AssertEquals(1, l.Count()); user = l.GetFirst(); AssertEquals("The user", user.GetName()); odb.Close(); }
public virtual void Test2() { IOdb odb = null; DeleteBase("trigger.ndb"); var myTrigger = new MyTrigger(); try { odb = Open("trigger.ndb"); odb.TriggerManagerFor<VO.Login.Function>().AddInsertTrigger(myTrigger); var f1 = new VO.Login.Function("function1"); var f2 = new VO.Login.Function("function2"); var profile = new Profile("profile1", f1); var user = new User("oli", "*****@*****.**", profile); odb.Store(user); odb.Store(f2); } finally { if (odb != null) odb.Close(); } odb = Open("trigger.ndb"); odb.Close(); DeleteBase("trigger.ndb"); AssertEquals(2, myTrigger.nbInsertsBefore); AssertEquals(2, myTrigger.nbInsertsAfter); }
public void TestClassInfo() { var user = new User("olivier smadja", "*****@*****.**", new Profile("operator", new VO.Login.Function("login"))); var classInfoList = ClassIntrospector.Introspect(user.GetType(), true); AssertEquals(OdbClassNameResolver.GetFullName(user.GetType()), classInfoList.GetMainClassInfo().FullClassName); AssertEquals(3, classInfoList.GetMainClassInfo().Attributes.Count); AssertEquals(3, classInfoList.GetClassInfos().Count); }
private object GetUserInstance() { var login = new VO.Login.Function("login"); var logout = new VO.Login.Function("logout"); IList<VO.Login.Function> list = new List<VO.Login.Function>(); list.Add(login); list.Add(logout); var profile = new Profile("operator", list); var user = new User("olivier smadja", "*****@*****.**", profile); return user; }
private object GetInstance(int i) { var login = new VO.Login.Function("login " + i); var logout = new VO.Login.Function("logout" + i); IList<VO.Login.Function> list = new List<VO.Login.Function>(); list.Add(login); list.Add(logout); var profile = new Profile("operator" + i, list); var user = new User("kiko" + i, "*****@*****.**" + i, profile); return user; }
public void TestCompareCollection1() { const string dbName = "introspectortest1.odb"; DeleteBase(dbName); var odb = OdbFactory.Open(dbName); var user = new User("olivier smadja", "*****@*****.**", new Profile("operator", new VO.Login.Function("login"))); IObjectInfoComparator comparator = new ObjectInfoComparator(); var storageEngine = ((global::NDatabase.Odb)odb).GetStorageEngine(); var instanceInfo = (NonNativeObjectInfo) new ObjectIntrospector(storageEngine.GetClassInfoProvider()).GetMetaRepresentation(user, true, null, new InstrumentationCallbackForStore(null, false)); // Sets attributes offsets - this is normally done by reading then from // disk, but in this junit, // we must set them manually var offsets = new[] {1L, 2L, 3L}; var ids = new[] {1, 2, 3}; instanceInfo.GetHeader().SetAttributesIdentification(offsets); instanceInfo.GetHeader().SetAttributesIds(ids); instanceInfo.GetHeader().SetOid(OIDFactory.BuildObjectOID(1)); var nnoiProfile = (NonNativeObjectInfo) instanceInfo.GetAttributeValueFromId(3); nnoiProfile.SetOid(OIDFactory.BuildObjectOID(2)); var nnoiFunctions = (NonNativeObjectInfo) nnoiProfile.GetAttributeValueFromId(1); nnoiFunctions.SetOid(OIDFactory.BuildObjectOID(3)); user.SetName("Olivier Smadja"); var instanceInfo3 = (NonNativeObjectInfo) new ObjectIntrospector(storageEngine.GetClassInfoProvider()).GetMetaRepresentation(user, true, null, new InstrumentationCallbackForStore(null, false)); instanceInfo3.GetHeader().SetOid(OIDFactory.BuildObjectOID(1)); nnoiProfile = (NonNativeObjectInfo) instanceInfo3.GetAttributeValueFromId(3); nnoiProfile.SetOid(OIDFactory.BuildObjectOID(2)); nnoiFunctions = (NonNativeObjectInfo)nnoiProfile.GetAttributeValueFromId(1); nnoiFunctions.SetOid(OIDFactory.BuildObjectOID(3)); AssertTrue(comparator.HasChanged(instanceInfo, instanceInfo3)); AssertEquals(1, comparator.GetNbChanges()); odb.Close(); }
public virtual void Test3() { DeleteBase(OdbFileName1); DeleteBase(OdbFileName2); var odb = Open(OdbFileName1); for (var i = 0; i < 1500; i++) { var user = new User("olivier " + i, "[email protected] " + i, new Profile("profile" + i)); odb.Store(user); } odb.Close(); odb = Open(OdbFileName1); odb.DefragmentTo(OdbFileName2); var newOdb = Open(OdbFileName2); AssertEquals(odb.Query<User>().Count(), odb.Query<User>().Count()); odb.Close(); newOdb.Close(); DeleteBase(OdbFileName1); DeleteBase(OdbFileName2); }
private void Init(string baseName) { DeleteBase(baseName); var odb = Open(baseName); var start = OdbTime.GetCurrentTimeInTicks(); var size = 10; for (var i = 0; i < size; i++) { var u = new User("user" + i, "email" + i, new Profile("profile" + i, new VO.Login.Function("function " + i))); odb.Store(u); } var user = new User("big user", "big email", new Profile("big profile", new VO.Login.Function("big function 1"))); user.GetProfile().AddFunction(new VO.Login.Function("big function 2")); user.GetProfile().AddFunction(new VO.Login.Function("big function 3")); user.GetProfile().AddFunction(new VO.Login.Function("big function 4")); odb.Store(user); user = new User("user no function", "email no function", new Profile("profile no function")); odb.Store(user); odb.Close(); }
public virtual void Test1() { DeleteBase("t1.ndb"); // LogUtil.allOn(true); var odb = Open("t1.ndb"); // LogUtil.objectWriterOn(true); var login = new VO.Login.Function("login"); IList<VO.Login.Function> list = new List<VO.Login.Function>(); list.Add(login); var profile1 = new Profile("operator 1", list); var user = new User("olivier smadja", "*****@*****.**", profile1); odb.Store(user); odb.Close(); odb = Open("t1.ndb"); var query = odb.Query<User>(); var users = query.Execute<User>(true); // assertEquals(nbUsers+2,users.size()); var user2 = users.GetFirst(); odb.Close(); AssertEquals(user.ToString(), user2.ToString()); DeleteBase("t1.ndb"); }
public void TestInstanceInfo2() { const string dbName = "TestInstanceInfo2.odb"; DeleteBase(dbName); var odb = OdbFactory.Open(dbName); var user = new User("olivier smadja", "*****@*****.**", new Profile("operator", new VO.Login.Function("login"))); var ci = ClassIntrospector.Introspect(user.GetType(), true).GetMainClassInfo(); var storageEngine = ((global::NDatabase.Odb)odb).GetStorageEngine(); var instanceInfo = (NonNativeObjectInfo) new ObjectIntrospector(storageEngine.GetClassInfoProvider()).GetMetaRepresentation(user, true, null, new InstrumentationCallbackForStore(null, false)); AssertEquals(instanceInfo.GetClassInfo().FullClassName, OdbClassNameResolver.GetFullName(user.GetType())); AssertEquals(instanceInfo.GetAttributeValueFromId(ci.GetAttributeId("name")).ToString(), "olivier smadja"); odb.Close(); }
public virtual void Test1() { DeleteBase(OdbFileName1); DeleteBase(OdbFileName2); var odb = Open(OdbFileName1); var user = new User("olivier", "*****@*****.**", null); odb.Store(user); odb.Close(); odb = Open(OdbFileName1); odb.DefragmentTo(OdbFileName2); var newOdb = Open(OdbFileName2); Decimal nbUser = odb.Query<User>().Count(); Decimal nbNewUser = odb.Query<User>().Count(); AssertEquals(nbUser, nbNewUser); AssertEquals(odb.Query<Profile>().Count(), odb.Query<Profile>().Count()); odb.Close(); newOdb.Close(); DeleteBase(OdbFileName1); DeleteBase(OdbFileName2); }
public virtual void Test1WithCommit3() { var stopWatch = new StopWatch(); stopWatch.Start(); DeleteBase(FileName); var odb = Open(FileName); var f1 = new VO.Login.Function("function 1"); Println(odb.Query<User>().Count()); var p = new Profile("profile number 0", f1); p.AddFunction(new VO.Login.Function("f1")); var user = new User("user name 0", "user email 0", p); odb.Store(user); var p2 = new Profile("profile number 0", f1); p2.AddFunction(new VO.Login.Function("f2")); var user2 = new User("user name 0", "user email 0", p2); odb.Store(user2); odb.Close(); odb = Open(FileName); IObjectSet<User> objectSet = null; for (var k = 0; k < 2; k++) { Console.Out.WriteLine(":" + k); var query = odb.Query<User>(); objectSet = query.Execute<User>(); while (objectSet.HasNext()) { user = objectSet.Next(); user.GetProfile().SetName(user.GetProfile().GetName() + "-updated"); Println(user.GetProfile().GetName()); odb.Store(user); } } odb.Close(); odb = Open(FileName); var query1 = odb.Query<User>(); objectSet = query1.Execute<User>(); AssertEquals(2, objectSet.Count); odb.Close(); }
public void TestCopy() { const string dbName = "introspectortest2.odb"; DeleteBase(dbName); var odb = OdbFactory.Open(dbName); var function = new VO.Login.Function("login"); var profile = new Profile("operator", function); var user = new User("olivier smadja", "*****@*****.**", profile); var storageEngine = ((global::NDatabase.Odb)odb).GetStorageEngine(); var instanceInfo = (NonNativeObjectInfo) new ObjectIntrospector(storageEngine.GetClassInfoProvider()).GetMetaRepresentation(user, true, null, new InstrumentationCallbackForStore(null, false)); var copy = (NonNativeObjectInfo) instanceInfo.CreateCopy(new OdbHashMap<OID, AbstractObjectInfo>(), true); AssertEquals(3, copy.GetAttributeValues().Length); var aois = copy.GetAttributeValues(); for (var i = 0; i < aois.Length; i++) { var aoi = aois[i]; AssertEquals(instanceInfo.GetAttributeValues()[i].GetOdbTypeId(), aoi.GetOdbTypeId()); } odb.Close(); }
public virtual void Test7() { DeleteBase(FileName); var odb = Open(FileName); var function = new VO.Login.Function("login"); var profile = new Profile("operator", function); var user = new User("olivier smadja", "*****@*****.**", profile); odb.Store(user); odb.Close(); odb = Open(FileName); var query = odb.Query<User>(); var user2 = query.Execute<User>().GetFirst(); user2.GetProfile().AddFunction(new VO.Login.Function("new Function")); odb.Store(user2); odb.Close(); odb = Open(FileName); var query1 = odb.Query<User>(); var user3 = query1.Execute<User>().GetFirst(); AssertEquals(2, user3.GetProfile().GetFunctions().Count); var f1 = user3.GetProfile().GetFunctions()[0]; var f2 = user3.GetProfile().GetFunctions()[1]; AssertEquals("login", f1.GetName()); AssertEquals("new Function", f2.GetName()); odb.Close(); }
public virtual void Test8() { DeleteBase(FileName); var odb = Open(FileName); var function = new VO.Login.Function("login"); var profile = new Profile("operator", function); var user = new User("olivier smadja", "*****@*****.**", profile); odb.Store(user); odb.Close(); odb = Open(FileName); var query = odb.Query<User>(); var user2 = query.Execute<User>().GetFirst(); user2.SetProfile(null); odb.Store(user2); odb.Close(); odb = Open(FileName); var query1 = odb.Query<User>(); var user3 = query1.Execute<User>().GetFirst(); AssertNull(user3.GetProfile()); odb.Close(); }
public virtual void TestCompositeCollection4() { DeleteBase("t5.ndb"); var odb = Open("t5.ndb"); var query = odb.Query<User>(); var nbUsers = query.Execute<User>(true).Count; var query1 = odb.Query<Profile>(); var nbProfiles = query1.Execute<Profile>(true).Count; var query2 = odb.Query<VO.Login.Function>(); var nbFunctions = query2.Execute<VO.Login.Function>(true).Count; var login = new VO.Login.Function("login"); var logout = new VO.Login.Function("logout"); IList<VO.Login.Function> list = new List<VO.Login.Function>(); list.Add(login); list.Add(logout); var profile1 = new Profile("operator 1", list); var user = new User("olivier smadja", "*****@*****.**", profile1); var userB = new User("Aísa Galvão Smadja", "*****@*****.**", profile1); odb.Store(user); odb.Store(userB); odb.Commit(); var query3 = odb.Query<User>(); var users = query3.Execute<User>(true); var query4 = odb.Query<Profile>(); var profiles = query4.Execute<Profile>(true); var query5 = odb.Query<VO.Login.Function>(); var functions = query5.Execute<VO.Login.Function>(true); odb.Close(); // assertEquals(nbUsers+2,users.size()); var user2 = users.GetFirst(); AssertEquals(user.ToString(), user2.ToString()); AssertEquals(nbProfiles + 1, profiles.Count); AssertEquals(nbFunctions + 2, functions.Count); }
public virtual void TestUpdateObjectReference4() { DeleteBase(FileName); var odb = Open(FileName); var function = new VO.Login.Function("login"); var user = new User("olivier smadja", "*****@*****.**", null); odb.Store(user); odb.Close(); var profile2 = new Profile("new operator", function); odb = Open(FileName); odb.Store(profile2); var query = odb.Query<User>(); var user2 = query.Execute<User>().GetFirst(); user2.SetProfile(profile2); odb.Store(user2); odb.Close(); odb = Open(FileName); var query1 = odb.Query<User>(); user2 = query1.Execute<User>().GetFirst(); AssertEquals("new operator", user2.GetProfile().GetName()); var query2 = odb.Query<Profile>(); AssertEquals(1, query2.Execute<Profile>().Count); odb.Close(); }
public virtual void TestCriteriaQueryQueryWithValueInList2_with_null_object() { var baseName = GetBaseName(); Init(baseName); var odb = Open(baseName); var p0 = new Profile("profile0"); p0.AddFunction(new VO.Login.Function("f1")); p0.AddFunction(new VO.Login.Function("f2")); p0.AddFunction(new VO.Login.Function("f12")); p0.AddFunction(new VO.Login.Function("f22")); var p1 = new Profile("profile1"); var user = new User("The user", "themail", p0); var user2 = new User("The user2", "themail2", p1); odb.Store(user); odb.Store(user2); odb.Close(); odb = Open(baseName); var f2bis = new VO.Login.Function("f2"); var query = odb.Query<Profile>(); query.Descend("functions").Constrain(null).Contains(); var l = query.Execute<Profile>(); //One from test, one from init AssertEquals(2, l.Count()); p1 = l.First(x => x.GetName().Equals("profile1")); AssertEquals("profile1", p1.GetName()); odb.Close(); }
public void Test4() { DeleteBase(SublistDbName); int i; using (var odb = Open(SublistDbName)) { IList<VO.Login.Function> functions1 = new List<VO.Login.Function>(); for (i = 0; i < 30; i++) functions1.Add(new VO.Login.Function("f1-" + i)); IList<VO.Login.Function> functions2 = new List<VO.Login.Function>(); for (i = 0; i < 60; i++) functions2.Add(new VO.Login.Function("f2-" + i)); IList<VO.Login.Function> functions3 = new List<VO.Login.Function>(); for (i = 0; i < 90; i++) functions3.Add(new VO.Login.Function("f3-" + i)); var user1 = new User("User1", "*****@*****.**", new Profile("profile1", functions1)); var user2 = new User("User2", "*****@*****.**", new Profile("profile2", functions2)); var user3 = new User("User3", "*****@*****.**", new Profile("profile3", functions3)); odb.Store(user1); odb.Store(user2); odb.Store(user3); } using (var odb = Open(SublistDbName)) { var query = odb.Query<User>(); var u = query.Execute<User>().GetFirst(); Console.WriteLine(u); var q = odb.ValuesQuery<Profile>().Field("name").Sublist("functions", 1, 2, false).Size( "functions", "fsize"); var v = q.Execute(); i = 0; while (v.HasNext()) { var ov = v.NextValues(); var profileName = (string) ov.GetByAlias("name"); Println(profileName); AssertEquals("profile" + (i + 1), profileName); AssertEquals(Convert.ToInt64(30 * (i + 1)), ov.GetByAlias("fsize")); var l = (IList) ov.GetByAlias("functions"); Println(l); AssertEquals(2, l.Count); i++; } } }
public virtual void Test1WithCommit() { var stopWatch = new StopWatch(); stopWatch.Start(); var size = 10000; var size2 = 5000; var nbFunctions = 2; DeleteBase(FileName); var odb = Open(FileName); var f1 = new VO.Login.Function("function 1"); // Create Objects for (var i = 0; i < size; i++) { var p = new Profile("profile number " + i, f1); for (var j = 0; j < nbFunctions; j++) p.AddFunction(new VO.Login.Function(" inner function of profile : number " + i + " - " + j)); var user = new User("user name " + i, "user email " + i, p); odb.Store(user); if (i % 100 == 0) { } } // println("insert " + i); odb.Close(); Println("created"); // Updates 10 times the objects odb = Open(FileName); var query = odb.Query<User>(); var objects = query.Execute<User>(); Println("got the object " + objects.Count); for (var k = 0; k < 10; k++) { objects.Reset(); var start = OdbTime.GetCurrentTimeInMs(); for (var i = 0; i < size2; i++) { var user = objects.Next(); user.GetProfile().SetName(user.GetProfile().GetName() + "-updated"); odb.Store(user); if (i % 100 == 0) { } } // println("update " + i + " - " + k); Println("Update " + k + " - " + (OdbTime.GetCurrentTimeInMs() - start) + " ms"); } Println("updated"); // Delete the rest of the objects for (var i = size2; i < size; i++) { odb.Delete(objects.Next()); if (i % 100 == 0) Println("delete " + i); } Println("deleted"); odb.Close(); // Check object count odb = Open(FileName); var query1 = odb.Query<User>(); objects = query1.Execute<User>(); AssertEquals(size2, objects.Count); // Check data of the objects var a = 0; while (objects.HasNext()) { var user = objects.Next(); AssertEquals("user name " + a, user.GetName()); AssertEquals("user email " + a, user.GetEmail()); AssertEquals( "profile number " + a + "-updated-updated-updated-updated-updated-updated-updated-updated-updated-updated", user.GetProfile().GetName()); a++; } Println("checked"); for (var k = 0; k < 10; k++) { objects.Reset(); for (var i = 0; i < size2; i++) { var user = objects.Next(); user.GetProfile().SetName(user.GetProfile().GetName() + "-updated" + "-"); odb.Store(user); } } Println("re-updated"); odb.Close(); // delete objects odb = Open(FileName); var query2 = odb.Query<User>(); objects = query2.Execute<User>(); a = 0; while (objects.HasNext()) { odb.Delete(objects.Next()); a++; } AssertEquals(size2, a); odb.Close(); odb = Open(FileName); var query3 = odb.Query<User>(); AssertEquals(0, query3.Execute<User>().Count); AssertEquals(0, odb.Query<User>().Count()); Println("deleted"); odb.Close(); stopWatch.End(); Println("Total time 1 = " + stopWatch.GetDurationInMiliseconds()); if (stopWatch.GetDurationInMiliseconds() > 90700) Fail("time is > than " + 90700 + " = " + stopWatch.GetDurationInMiliseconds()); }
public virtual void Test1WithoutCommit() { var stopWatch = new StopWatch(); stopWatch.Start(); var size = 10000; var size2 = 5000; var nbFunctions = 10; DeleteBase(FileName); var odb = Open(FileName); var f1 = new VO.Login.Function("function 1"); // Create Objects for (var i = 0; i < size; i++) { var p = new Profile("profile number " + i, f1); for (var j = 0; j < nbFunctions; j++) p.AddFunction(new VO.Login.Function(" inner function of profile : number " + i + " - " + j)); var user = new User("user name " + i, "user email " + i, p); odb.Store(user); } Println("created"); // Updates 10 times the objects var query = odb.Query<User>(); var objects = query.Execute<User>(); for (var k = 0; k < 10; k++) { objects.Reset(); for (var i = 0; i < size2; i++) { var user = objects.Next(); user.GetProfile().SetName(user.GetProfile().GetName() + "-updated"); odb.Store(user); } } Println("updated"); // Delete the rest of the objects for (var i = size2; i < size; i++) odb.Delete(objects.Next()); Println("deleted"); // Check object count var query1 = odb.Query<User>(); objects = query1.Execute<User>(); AssertEquals(size2, objects.Count); // Check data of the objects var a = 0; while (objects.HasNext()) { var user = objects.Next(); AssertEquals("user name " + a, user.GetName()); AssertEquals("user email " + a, user.GetEmail()); AssertEquals( "profile number " + a + "-updated-updated-updated-updated-updated-updated-updated-updated-updated-updated", user.GetProfile().GetName()); a++; } Println("checked"); for (var k = 0; k < 10; k++) { objects.Reset(); for (var i = 0; i < size2; i++) { var user = objects.Next(); user.GetProfile().SetName(user.GetProfile().GetName() + "-updated" + "-"); odb.Store(user); } } Println("re-updated"); var query2 = odb.Query<User>(); objects = query2.Execute<User>(); var engine = ((global::NDatabase.Odb)odb).GetStorageEngine(); var uncommited = engine.GetSession().GetMetaModel().GetClassInfo(typeof (User).FullName, true).UncommittedZoneInfo; CIZoneInfo commited = engine.GetSession().GetMetaModel().GetClassInfo(typeof (User).FullName, true).CommitedZoneInfo; Println("Before commit : uncommited=" + uncommited); Println("Before commit : commited=" + commited); a = 0; while (objects.HasNext()) { // println("a="+a); odb.Delete(objects.Next()); a++; } AssertEquals(size2, a); var query3 = odb.Query<User>(); AssertEquals(0, query3.Execute<User>().Count); AssertEquals(0, odb.Query<User>().Count()); Println("deleted"); odb.Close(); stopWatch.End(); Println("Total time 2 = " + stopWatch.GetDurationInMiliseconds()); if (stopWatch.GetDurationInMiliseconds() > 108438) Fail("time is > than " + 108438 + " = " + stopWatch.GetDurationInMiliseconds()); }
public virtual void Test5() { DeleteBase("t5.ndb"); var odb = Open("t5.ndb"); var nbFunctions = odb.Query<VO.Login.Function>().Count(); var nbProfiles = odb.Query<Profile>().Count(); var nbUsers = odb.Query<User>().Count(); var login = new VO.Login.Function("login"); var logout = new VO.Login.Function("logout"); var list = new List<VO.Login.Function>(); list.Add(login); list.Add(logout); var profile = new Profile("operator", list); var olivier = new User("olivier smadja", "*****@*****.**", profile); var aisa = new User("Aísa Galvão Smadja", "*****@*****.**", profile); odb.Store(olivier); odb.Store(profile); odb.Commit(); odb.Close(); odb = Open("t5.ndb"); var query = odb.Query<User>(); var users = query.Execute<User>(true); var query1 = odb.Query<Profile>(); var profiles = query1.Execute<Profile>(true); var query2 = odb.Query<VO.Login.Function>(); var functions = query2.Execute<VO.Login.Function>(true); odb.Close(); AssertEquals(nbUsers + 1, users.Count); AssertEquals(nbProfiles + 1, profiles.Count); AssertEquals(nbFunctions + 2, functions.Count); }
public virtual void Test9() { DeleteBase(Name); var odb = Open(Name); var user = new User("name", "email", new Profile("p1", new VO.Login.Function("function"))); odb.Store(user); odb.Store(new Profile("new profile")); odb.Close(); odb = Open(Name); var query = odb.Query<Profile>(); query.Descend("name").Constrain((object) "new profile").Equal(); var p = query.Execute<Profile>().GetFirst(); p.SetName("new profile2"); var query2 = odb.Query<User>(); var user2 = query2.Execute<User>().GetFirst(); user2.SetProfile(p); odb.Store(user2); odb.Close(); odb = Open(Name); var query1 = odb.Query<User>(); var user3 = query1.Execute<User>().GetFirst(); AssertNotNull(user3.GetProfile()); odb.Close(); DeleteBase(Name); AssertEquals("new profile2", user3.GetProfile().GetName()); }
public virtual void Test6() { // LogUtil.objectWriterOn(true); DeleteBase("t6.ndb"); var odb = Open("t6.ndb"); var login = new VO.Login.Function("login"); var logout = new VO.Login.Function("logout"); var list = new List<VO.Login.Function>(); list.Add(login); list.Add(logout); var profile = new Profile("operator", list); var olivier = new User("olivier smadja", "*****@*****.**", profile); odb.Store(olivier); odb.Close(); Println("----------"); odb = Open("t6.ndb"); var query = odb.Query<User>(); var users = query.Execute<User>(true); var u1 = users.GetFirst(); u1.GetProfile().SetName("operator 234567891011121314"); odb.Store(u1); odb.Close(); odb = Open("t6.ndb"); var query1 = odb.Query<Profile>(); var profiles = query1.Execute<Profile>(true); AssertEquals(1, profiles.Count); var p1 = profiles.GetFirst(); AssertEquals(u1.GetProfile().GetName(), p1.GetName()); }