public void Test11()
{
using (var odb = OdbFactory.Open(DbName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
handler.AddParameter(new Parameter("test " + i, "value " + i));
odb.Store(handler);
}
using (var odb = Open(DbName))
{
var valuesQuery =
odb.ValuesQuery<Handler>().Field("parameters").Sublist("parameters", "sub1", 1, 5, true).Sublist(
"parameters", "sub2", 1, 10).Size("parameters", "size");
var values = valuesQuery.Execute();
var ov = values.NextValues();
// Retrieve Result values
var fulllist = (IList) ov.GetByAlias("parameters");
Assert.That(fulllist, Has.Count.EqualTo(10));
var size = (long) ov.GetByAlias("size");
Assert.That(size, Is.EqualTo(10));
var sublist = (IList) ov.GetByAlias("sub1");
Assert.That(sublist, Has.Count.EqualTo(5));
}
}
public void Test11()
{
using (var odb = OdbFactory.Open(DbName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
{
handler.AddParameter(new Parameter("test " + i, "value " + i));
}
odb.Store(handler);
}
using (var odb = Open(DbName))
{
var valuesQuery =
odb.ValuesQuery <Handler>().Field("parameters").Sublist("parameters", "sub1", 1, 5, true).Sublist(
"parameters", "sub2", 1, 10).Size("parameters", "size");
var values = valuesQuery.Execute();
var ov = values.NextValues();
// Retrieve Result values
var fulllist = (IList)ov.GetByAlias("parameters");
Assert.That(fulllist, Has.Count.EqualTo(10));
var size = (long)ov.GetByAlias("size");
Assert.That(size, Is.EqualTo(10));
var sublist = (IList)ov.GetByAlias("sub1");
Assert.That(sublist, Has.Count.EqualTo(5));
}
}
public void Test2()
{
DeleteBase(DbName);
using (var odb = Open(DbName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
handler.AddParameter(new Parameter("test " + i, "value" + i));
odb.Store(handler);
}
using (var odb = Open(DbName))
{
try
{
odb.ValuesQuery<Handler>().Field("parameters").Execute<Handler>();
Fail("Should throw exception");
}
catch (Exception e)
{
Console.WriteLine(e);
Assert.Pass();
}
}
}
public void Test2()
{
DeleteBase(DbName);
using (var odb = Open(DbName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
{
handler.AddParameter(new Parameter("test " + i, "value" + i));
}
odb.Store(handler);
}
using (var odb = Open(DbName))
{
try
{
odb.ValuesQuery <Handler>().Field("parameters").Execute <Handler>();
Fail("Should throw exception");
}
catch (Exception e)
{
Console.WriteLine(e);
Assert.Pass();
}
}
}
public void Test1()
{
var baseName = GetBaseName();
DeleteBase(baseName);
OID oid;
using (var odb = Open(baseName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
{
handler.AddParameter(new Parameter("test " + i, "value " + i));
}
oid = odb.Store(handler);
}
using (var odb = Open(baseName))
{
var valuesQuery =
odb.ValuesQuery <Handler>(oid).Field("parameters").Sublist("parameters", "sub1", 1, 5, true).Sublist(
"parameters", "sub2", 1, 10).Size("parameters", "size");
var values = valuesQuery.Execute();
Println(values);
var ov = values.NextValues();
var fulllist = (IList)ov.GetByAlias("parameters");
AssertEquals(10, fulllist.Count);
var size = (long)ov.GetByAlias("size");
AssertEquals(10, size);
var p = (Parameter)fulllist[0];
AssertEquals("value 0", p.GetValue());
var p2 = (Parameter)fulllist[9];
AssertEquals("value 9", p2.GetValue());
var sublist = (IList)ov.GetByAlias("sub1");
AssertEquals(5, sublist.Count);
p = (Parameter)sublist[0];
AssertEquals("value 1", p.GetValue());
p2 = (Parameter)sublist[4];
AssertEquals("value 5", p2.GetValue());
var sublist2 = (IList)ov.GetByAlias("sub2");
AssertEquals(9, sublist2.Count);
}
}
public void Test1()
{
var baseName = GetBaseName();
DeleteBase(baseName);
OID oid;
using (var odb = Open(baseName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
handler.AddParameter(new Parameter("test " + i, "value " + i));
oid = odb.Store(handler);
}
using (var odb = Open(baseName))
{
var valuesQuery =
odb.ValuesQuery<Handler>(oid).Field("parameters").Sublist("parameters", "sub1", 1, 5, true).Sublist(
"parameters", "sub2", 1, 10).Size("parameters", "size");
var values = valuesQuery.Execute();
Println(values);
var ov = values.NextValues();
var fulllist = (IList) ov.GetByAlias("parameters");
AssertEquals(10, fulllist.Count);
var size = (long) ov.GetByAlias("size");
AssertEquals(10, size);
var p = (Parameter) fulllist[0];
AssertEquals("value 0", p.GetValue());
var p2 = (Parameter) fulllist[9];
AssertEquals("value 9", p2.GetValue());
var sublist = (IList) ov.GetByAlias("sub1");
AssertEquals(5, sublist.Count);
p = (Parameter) sublist[0];
AssertEquals("value 1", p.GetValue());
p2 = (Parameter) sublist[4];
AssertEquals("value 5", p2.GetValue());
var sublist2 = (IList) ov.GetByAlias("sub2");
AssertEquals(9, sublist2.Count);
}
}
public void Test2()
{
DeleteBase(DbName2);
OID oid;
using (var odb = Open(DbName2))
{
var handler = new Handler();
for (var i = 0; i < 500; i++)
{
handler.AddParameter(new Parameter("test " + i, "value " + i));
}
oid = odb.Store(handler);
}
using (var odb = Open(DbName2))
{
var h = (Handler)odb.GetObjectFromId(oid);
Println("size of list = " + h.GetListOfParameters().Count);
var start = OdbTime.GetCurrentTimeInMs();
var valuesQuery = odb.ValuesQuery <Handler>().Sublist("parameters", "sub", 490, 5, true).Size("parameters", "size");
var values = valuesQuery.Execute();
var end = OdbTime.GetCurrentTimeInMs();
Println("time to load sublist of 5 itens from 40000 : " + (end - start));
Println(values);
var ov = values.NextValues();
var sublist = (IList)ov.GetByAlias("sub");
AssertEquals(5, sublist.Count);
var size = (long)ov.GetByAlias("size");
AssertEquals(500, size);
var p = AsParameter(sublist[0]);
AssertEquals("value 490", p.GetValue());
var p2 = AsParameter(sublist[4]);
AssertEquals("value 494", p2.GetValue());
}
}
public void Test3_Using_Object_representation_instead_of_real_object()
{
const int sublistSize = 10000;
DeleteBase(DbName3);
using (var odb = Open(DbName3))
{
var handler = new Handler();
for (var i = 0; i < sublistSize; i++)
{
handler.AddParameter(new Parameter("test " + i, "value " + i));
}
odb.Store(handler);
}
using (var odb = Open(DbName3))
{
var start = OdbTime.GetCurrentTimeInMs();
var q = odb.ValuesQuery <Handler>().Sublist("parameters", "sub", 9990, 5, true);
q.SetReturnInstance(false);
var values = q.Execute();
var end = OdbTime.GetCurrentTimeInMs();
Println("time to load sublist of 5 itens from 40000 : " + (end - start));
Println(values);
var ov = values.NextValues();
var sublist = (IList)ov.GetByAlias("sub");
AssertEquals(5, sublist.Count);
var parameter = (Parameter)sublist[0];
AssertEquals("value 9990", parameter.GetValue());
var parameter1 = (Parameter)sublist[4];
AssertEquals("value 9994", parameter1.GetValue());
}
}
public void Test1()
{
DeleteBase(DbName);
using (var odb = Open(DbName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
handler.AddParameter(new Parameter("test " + i, "value" + i));
odb.Store(handler);
}
using (var odb = Open(DbName))
{
var values = odb.ValuesQuery<Handler>().Field("parameters").Execute();
Println(values);
var ov = values.NextValues();
var l = (IList) ov.GetByAlias("parameters");
AssertEquals(10, l.Count);
}
}
public void Test6_Check_if_objects_of_list_are_known_by_ODB()
{
const int sublistSize = 400;
var baseName = GetBaseName();
DeleteBase(baseName);
using (var odb = Open(baseName))
{
var handler = new Handler();
for (var i = 0; i < sublistSize; i++)
{
handler.AddParameter(new Parameter("test " + i, "value " + i));
}
odb.Store(handler);
}
using (var odb = Open(DbName3))
{
var start = OdbTime.GetCurrentTimeInMs();
var q = odb.Query <Handler>();
var objects = q.Execute <Handler>();
var end = OdbTime.GetCurrentTimeInMs();
Console.WriteLine("Query time: {0} ms", end - start);
var h = objects.GetFirst();
var parameter = (Parameter)h.GetListOfParameters()[0];
AssertEquals("value 0", parameter.GetValue());
var oid = odb.GetObjectId(parameter);
AssertNotNull(oid);
}
}
public void Test5_Using_Object_representation_instead_of_real_object()
{
const int sublistSize = 400;
var baseName = GetBaseName();
DeleteBase(baseName);
using (var odb = Open(baseName))
{
var handler = new Handler();
for (var i = 0; i < sublistSize; i++)
{
handler.AddParameter(new Parameter("test " + i, "value " + i));
}
odb.Store(handler);
}
using (var odb = Open(DbName3))
{
var start = OdbTime.GetCurrentTimeInMs();
var q = odb.ValuesQuery <Handler>().Sublist("parameters", "sub", 0, 2, true);
var values = q.Execute();
var end = OdbTime.GetCurrentTimeInMs();
Println("time to load sublist of 5 itens for " + sublistSize + " : " + (end - start));
Println(values);
var ov = values.NextValues();
var sublist = (IList)ov.GetByAlias("sub");
AssertEquals(2, sublist.Count);
var parameter = AsParameter(sublist[1]);
AssertEquals("value 1", parameter.GetValue());
var oid = odb.GetObjectId(parameter);
Println(oid);
}
}
public void Test1()
{
DeleteBase(DbName);
using (var odb = Open(DbName))
{
var handler = new Handler();
for (var i = 0; i < 10; i++)
{
handler.AddParameter(new Parameter("test " + i, "value" + i));
}
odb.Store(handler);
}
using (var odb = Open(DbName))
{
var values = odb.ValuesQuery <Handler>().Field("parameters").Execute();
Println(values);
var ov = values.NextValues();
var l = (IList)ov.GetByAlias("parameters");
AssertEquals(10, l.Count);
}
}
public void Test6_Check_if_objects_of_list_are_known_by_ODB()
{
const int sublistSize = 400;
var baseName = GetBaseName();
DeleteBase(baseName);
using (var odb = Open(baseName))
{
var handler = new Handler();
for (var i = 0; i < sublistSize; i++)
handler.AddParameter(new Parameter("test " + i, "value " + i));
odb.Store(handler);
}
using (var odb = Open(DbName3))
{
var start = OdbTime.GetCurrentTimeInMs();
var q = odb.Query<Handler>();
var objects = q.Execute<Handler>();
var end = OdbTime.GetCurrentTimeInMs();
Console.WriteLine("Query time: {0} ms", end - start);
var h = objects.GetFirst();
var parameter = (Parameter) h.GetListOfParameters()[0];
AssertEquals("value 0", parameter.GetValue());
var oid = odb.GetObjectId(parameter);
AssertNotNull(oid);
}
}
public void Test5_Using_Object_representation_instead_of_real_object()
{
const int sublistSize = 400;
var baseName = GetBaseName();
DeleteBase(baseName);
using (var odb = Open(baseName))
{
var handler = new Handler();
for (var i = 0; i < sublistSize; i++)
handler.AddParameter(new Parameter("test " + i, "value " + i));
odb.Store(handler);
}
using (var odb = Open(DbName3))
{
var start = OdbTime.GetCurrentTimeInMs();
var q = odb.ValuesQuery<Handler>().Sublist("parameters", "sub", 0, 2, true);
var values = q.Execute();
var end = OdbTime.GetCurrentTimeInMs();
Println("time to load sublist of 5 itens for " + sublistSize + " : " + (end - start));
Println(values);
var ov = values.NextValues();
var sublist = (IList) ov.GetByAlias("sub");
AssertEquals(2, sublist.Count);
var parameter = AsParameter(sublist[1]);
AssertEquals("value 1", parameter.GetValue());
var oid = odb.GetObjectId(parameter);
Println(oid);
}
}
public void Test3_Using_Object_representation_instead_of_real_object()
{
const int sublistSize = 10000;
DeleteBase(DbName3);
using (var odb = Open(DbName3))
{
var handler = new Handler();
for (var i = 0; i < sublistSize; i++)
handler.AddParameter(new Parameter("test " + i, "value " + i));
odb.Store(handler);
}
using (var odb = Open(DbName3))
{
var start = OdbTime.GetCurrentTimeInMs();
var q = odb.ValuesQuery<Handler>().Sublist("parameters", "sub", 9990, 5, true);
q.SetReturnInstance(false);
var values = q.Execute();
var end = OdbTime.GetCurrentTimeInMs();
Println("time to load sublist of 5 itens from 40000 : " + (end - start));
Println(values);
var ov = values.NextValues();
var sublist = (IList) ov.GetByAlias("sub");
AssertEquals(5, sublist.Count);
var parameter = (Parameter) sublist[0];
AssertEquals("value 9990", parameter.GetValue());
var parameter1 = (Parameter)sublist[4];
AssertEquals("value 9994", parameter1.GetValue());
}
}
public void Test2()
{
DeleteBase(DbName2);
OID oid;
using (var odb = Open(DbName2))
{
var handler = new Handler();
for (var i = 0; i < 500; i++)
handler.AddParameter(new Parameter("test " + i, "value " + i));
oid = odb.Store(handler);
}
using (var odb = Open(DbName2))
{
var h = (Handler) odb.GetObjectFromId(oid);
Println("size of list = " + h.GetListOfParameters().Count);
var start = OdbTime.GetCurrentTimeInMs();
var valuesQuery = odb.ValuesQuery<Handler>().Sublist("parameters", "sub", 490, 5, true).Size("parameters", "size");
var values = valuesQuery.Execute();
var end = OdbTime.GetCurrentTimeInMs();
Println("time to load sublist of 5 itens from 40000 : " + (end - start));
Println(values);
var ov = values.NextValues();
var sublist = (IList) ov.GetByAlias("sub");
AssertEquals(5, sublist.Count);
var size = (long) ov.GetByAlias("size");
AssertEquals(500, size);
var p = AsParameter(sublist[0]);
AssertEquals("value 490", p.GetValue());
var p2 = AsParameter(sublist[4]);
AssertEquals("value 494", p2.GetValue());
}
}