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 void Populate()
{
DeleteBase(DbName);
using (var odb = Open(DbName))
{
var atts = new[] {"name"};
odb.IndexManagerFor<User2>().AddUniqueIndexOn("Index", atts);
const int nbProfiles = 200;
const int nbUsers = 500;
var profiles = new Profile[nbProfiles];
var users = new User2[nbUsers];
const int userStart = 1500;
const int profileStart = 600;
// First creates profiles
for (var i = 0; i < nbProfiles; i++)
{
profiles[i] = new Profile("profile " + (i + profileStart),
new VO.Login.Function("function Profile" + i));
odb.Store(profiles[i]);
}
// Then creates users
for (var i = 0; i < nbUsers; i++)
{
users[i] = new User2("user" + (i + userStart), "user mail" + i,
profiles[GetProfileIndex(nbProfiles)], i);
odb.Store(users[i]);
if (i%100 == 0)
Println(i);
}
}
}
public virtual void TestDeleteListElements()
{
var baseName = GetBaseName();
DeleteBase(baseName);
var odb = Open(baseName);
var p = new Profile("name");
p.AddFunction(new VO.Login.Function("f1"));
p.AddFunction(new VO.Login.Function("f2"));
p.AddFunction(new VO.Login.Function("3"));
odb.Store(p);
odb.Close();
odb = Open(baseName);
var query = odb.Query<Profile>();
var objects = query.Execute<Profile>();
while (objects.HasNext())
{
var profile = objects.Next();
var functions = profile.GetFunctions();
for (var j = 0; j < functions.Count; j++)
odb.Delete(functions[j]);
odb.Delete(profile);
}
odb.Close();
}
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 Populate()
{
OdbFactory.Delete(DbName);
using (var odb = Open(DbName))
{
const int nbProfiles = 20;
const int nbUsers = 50;
var profiles = new Profile[nbProfiles];
var users = new User2[nbUsers];
// First creates profiles
for (var i = 0; i < nbProfiles; i++)
{
profiles[i] = new Profile("profile " + i, new VO.Login.Function("function Profile" + i));
odb.Store(profiles[i]);
}
// Then creates users
for (var i = 0; i < nbUsers; i++)
{
users[i] = new User2("user" + i, "user mail" + i, profiles[GetProfileIndex(nbProfiles)], i);
odb.Store(users[i]);
if (i%10 == 0)
Println(i);
}
}
}
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 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);
}
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 virtual void Test1()
{
var baseName = GetBaseName();
var odb = Open(baseName);
IList<Profile> profiles = new List<Profile>();
profiles.Add(new Profile("p1", new VO.Login.Function("f1")));
profiles.Add(new Profile("p2", new VO.Login.Function("f2")));
var cb = new ClassB("name", profiles);
odb.Store(cb);
odb.Close();
odb = Open(baseName);
// this object is not known y NDatabase so the query will not return anything
var p = new Profile("p1", (IList<VO.Login.Function>) null);
var query = odb.Query<ClassB>();
query.Descend("profiles").Constrain(p).Contains();
var l = query.Execute<ClassB>();
odb.Close();
AssertEquals(0, l.Count);
}
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 virtual void Test2()
{
DeleteBase(OdbFileName1);
DeleteBase(OdbFileName2);
var odb = Open(OdbFileName1);
var p = new Profile("profile");
for (var i = 0; i < 500; i++)
{
var user = new User("olivier " + i, "[email protected] " + i, p);
odb.Store(user);
}
odb.Close();
odb = Open(OdbFileName1);
odb.DefragmentTo(OdbFileName2);
var newOdb = Open(OdbFileName2);
AssertEquals(odb.Query<User>().Count(), odb.Query<User>().Count());
AssertEquals(odb.Query<Profile>().Count(),
odb.Query<Profile>().Count());
odb.Close();
newOdb.Close();
DeleteBase(OdbFileName1);
DeleteBase(OdbFileName2);
}
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 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 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 void TestCompareCollection9()
{
const string dbName = "introspectortest9.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);
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("Kiko");
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 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 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 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 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 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 TestUpdateRelation()
{
var baseName = GetBaseName();
var odb = Open(baseName);
// first create a function
var f = new VO.Login.Function("f1");
odb.Store(f);
odb.Close();
odb = Open(baseName);
// reloads the function
var query = odb.Query<VO.Login.Function>();
query.Descend("name").Constrain((object) "f1").Equal();
var functions = query.Execute<VO.Login.Function>();
var f1 = functions.GetFirst();
// Create a profile with the loaded function
var profile = new Profile("test", f1);
odb.Store(profile);
odb.Close();
odb = Open(baseName);
var query1 = odb.Query<Profile>();
var profiles = query1.Execute<Profile>();
var query2 = odb.Query<VO.Login.Function>();
functions = query2.Execute<VO.Login.Function>();
odb.Close();
DeleteBase(baseName);
AssertEquals(1, functions.Count);
AssertEquals(1, profiles.Count);
}
private object GetInstance(string @string)
{
if (simpleObject)
return new VO.Login.Function(@string);
var p = new Profile(@string);
p.AddFunction(new VO.Login.Function("function " + @string + "1"));
p.AddFunction(new VO.Login.Function("function " + @string + "2"));
return new User(@string, "email" + @string, p);
}
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());
}
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 Test3()
{
DeleteBase(DbName3);
using (var odb = Open(DbName3))
{
var p1 = new Profile("profile1", new VO.Login.Function("f1"));
var p2 = new Profile("profile2", new VO.Login.Function("f2"));
User u1 = new User2("user1", "*****@*****.**", p1, 1);
User u2 = new User2("user2", "*****@*****.**", p1, 2);
User u3 = new User2("user3", "*****@*****.**", p1, 3);
User u4 = new User2("user4", "*****@*****.**", p2, 4);
User u5 = new User2("user5", "*****@*****.**", p2, 5);
odb.Store(u1);
odb.Store(u2);
odb.Store(u3);
odb.Store(u4);
odb.Store(u5);
}
IValues values;
using (var odb = Open(DbName3))
{
var q =
odb.ValuesQuery<User2>().Field("profile.name").Count("count").Avg("nbLogins", "avg").
GroupBy("profile.name");
q.Descend("name").OrderAscending();
values = q.Execute();
Println(values);
var ov = values.NextValues();
AssertEquals(2, values.Count());
AssertEquals("profile1", ov.GetByAlias("profile.name"));
AssertEquals(Convert.ToDecimal("3"), ov.GetByAlias("count"));
AssertEquals(Convert.ToDecimal("2.00", CultureInfo.InvariantCulture), ov.GetByAlias("avg"));
}
AssertEquals(2, values.Count());
}
public virtual void Test2()
{
var baseName = GetBaseName();
DeleteBase(baseName);
long nbFunctions;
using (var odb = Open(baseName))
{
nbFunctions = odb.Query<VO.Login.Function>().Count();
decimal nbProfiles = odb.Query<Profile>().Count();
var function1 = new VO.Login.Function("function1");
var function2 = new VO.Login.Function("function2");
var function3 = new VO.Login.Function("function3");
var functions = new List<VO.Login.Function>();
functions.Add(function1);
functions.Add(function2);
functions.Add(function3);
var profile1 = new Profile("profile1", functions);
var profile2 = new Profile("profile2", function1);
odb.Store(profile1);
odb.Store(profile2);
}
using (var odb = Open(baseName))
{
var query1 = odb.Query<VO.Login.Function>();
var lfunctions = query1.Execute<VO.Login.Function>(true);
AssertEquals(nbFunctions + 3, lfunctions.Count);
var query = odb.Query<VO.Login.Function>();
query.Descend("name").Constrain("function2").Equal();
var l = query.Execute<VO.Login.Function>();
var function = l.GetFirst();
odb.Delete(function);
}
using (var odb = Open(baseName))
{
AssertEquals(nbFunctions + 2, odb.Query<VO.Login.Function>().Count());
var query3 = odb.Query<VO.Login.Function>();
var l2 = query3.Execute<VO.Login.Function>(true);
// check Profile 1
var query2 = odb.Query<Profile>();
query2.Descend("name").Constrain("profile1").Equal();
var lprofile = query2.Execute<Profile>();
var p1 = lprofile.GetFirst();
AssertEquals(3, p1.GetFunctions().Count);
Assert.That(p1.GetFunctions(), Contains.Item(null));
}
}
