public virtual void Test1() { NeoDatis.Tool.IOUtil.DeleteFile("base1.neodatis"); NeoDatis.Odb.ODB odb = NeoDatis.Odb.ODBFactory.Open("base1.neodatis"); string[] fields = new string[] { "int1" }; odb.GetClassRepresentation(typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).AddUniqueIndexOn ("index1", fields, true); long start = NeoDatis.Tool.Wrappers.OdbTime.GetCurrentTimeInMs(); int size = 50; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass testClass = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); testClass.SetBigDecimal1(new System.Decimal(i)); testClass.SetBoolean1(i % 3 == 0); testClass.SetChar1((char)(i % 5)); testClass.SetDate1(new System.DateTime(start + i)); testClass.SetDouble1(((double)(i % 10)) / size); testClass.SetInt1(size - i); testClass.SetString1("test class " + i); odb.Store(testClass); } // println(testClass.getDouble1() + " | " + testClass.getString1() + // " | " + testClass.getInt1()); odb.Close(); }
public virtual void Test1() { DeleteBase("values2"); NeoDatis.Odb.ODB odb = Open("values2"); NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); NeoDatis.Odb.Test.VO.Attribute.TestClass tc2 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc2.SetInt1(45); odb.Store(tc2); NeoDatis.Odb.Test.VO.Attribute.TestClass tc3 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc3.SetInt1(46); odb.Store(tc3); odb.Close(); odb = Open("values2"); NeoDatis.Odb.Core.Query.IValuesQuery vq = new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Sum("int1", "sum of int1").GroupBy ("int1"); vq.OrderByAsc("int1"); NeoDatis.Odb.Values values = odb.GetValues(vq); AssertEquals(2, values.Count); Println(values); NeoDatis.Odb.ObjectValues ov = values.NextValues(); AssertEquals(System.Decimal.ValueOf(90), ov.GetByAlias("sum of int1")); ov = values.NextValues(); AssertEquals(System.Decimal.ValueOf(46), ov.GetByAlias("sum of int1")); odb.Close(); AssertEquals(2, values.Count); }
public virtual void Test1() { DeleteBase("values2"); NeoDatis.Odb.ODB odb = Open("values2"); NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); NeoDatis.Odb.Test.VO.Attribute.TestClass tc2 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc2.SetInt1(45); odb.Store(tc2); NeoDatis.Odb.Test.VO.Attribute.TestClass tc3 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc3.SetInt1(46); odb.Store(tc3); odb.Close(); odb = Open("values2"); NeoDatis.Odb.Core.Query.IValuesQuery vq = new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Sum("int1", "sum of int1").GroupBy ("int1"); vq.OrderByAsc("int1"); NeoDatis.Odb.Values values = odb.GetValues(vq); AssertEquals(2, values.Count); Println(values); NeoDatis.Odb.ObjectValues ov = values.NextValues(); AssertEquals(System.Decimal.ValueOf(90), ov.GetByAlias("sum of int1")); ov = values.NextValues(); AssertEquals(System.Decimal.ValueOf(46), ov.GetByAlias("sum of int1")); odb.Close(); AssertEquals(2, values.Count); }
public virtual void Test16() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = null; NeoDatis.Tool.StopWatch t = new NeoDatis.Tool.StopWatch(); int size = isLocal ? 10000 : 100; for (int j = 0; j < 10; j++) { t.Start(); odb = Open("valuesA2"); for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); } odb.Close(); t.End(); Println(" time for insert = " + t.GetDurationInMiliseconds()); } odb = Open("valuesA2"); t.Start(); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Count("nb objects")); t.End(); Println(values); Println(" time for count = " + t.GetDurationInMiliseconds()); NeoDatis.Odb.ObjectValues ov = values.NextValues(); odb.Close(); AssertEquals(size * 10, ov.GetByAlias("nb objects")); AssertEquals(1, values.Count); }
public virtual void Test1() { NeoDatis.Tool.IOUtil.DeleteFile("base1.neodatis"); NeoDatis.Odb.ODB odb = NeoDatis.Odb.ODBFactory.Open("base1.neodatis"); string[] fields = new string[] { "int1" }; odb.GetClassRepresentation(typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).AddUniqueIndexOn ("index1", fields, true); long start = NeoDatis.Tool.Wrappers.OdbTime.GetCurrentTimeInMs(); int size = 50; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass testClass = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); testClass.SetBigDecimal1(new System.Decimal(i)); testClass.SetBoolean1(i % 3 == 0); testClass.SetChar1((char)(i % 5)); testClass.SetDate1(new System.DateTime(start + i)); testClass.SetDouble1(((double)(i % 10)) / size); testClass.SetInt1(size - i); testClass.SetString1("test class " + i); odb.Store(testClass); } // println(testClass.getDouble1() + " | " + testClass.getString1() + // " | " + testClass.getInt1()); odb.Close(); }
public virtual void Test10() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); NeoDatis.Tool.StopWatch t = new NeoDatis.Tool.StopWatch(); t.Start(); int size = 1000; long sum = 0; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(i); odb.Store(tc1); sum += i; } odb.Close(); t.End(); Println(" time for insert = " + t.GetDurationInMiliseconds()); odb = Open("valuesA2"); t.Start(); NeoDatis.Odb.Core.Query.Values.ICustomQueryFieldAction custom = new NeoDatis.Odb.Test.Query.Values.TestCustomQueryFieldAction (); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Custom("int1", "custom of int1" , custom)); t.End(); NeoDatis.Odb.ObjectValues ov = values.NextValues(); System.Decimal c = (System.Decimal)ov.GetByAlias("custom of int1"); Println(c); Println(" time for count = " + t.GetDurationInMiliseconds()); odb.Close(); }
public virtual void Test9() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); int size = isLocal ? 100000 : 1000; long sum = 0; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(i); odb.Store(tc1); sum += i; } odb.Close(); odb = Open("valuesA2"); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Min("int1", "min of int1").Avg ("int1", "avg of int1").Sum("int1", "sum of int1")); NeoDatis.Odb.ObjectValues ov = values.NextValues(); System.Decimal min = (System.Decimal)ov.GetByAlias("min of int1"); System.Decimal avg = (System.Decimal)ov.GetByAlias("avg of int1"); System.Decimal bsum = (System.Decimal)ov.GetByAlias("sum of int1"); Println(min); Println(avg); Println(bsum); odb.Close(); AssertEquals(new System.Decimal(sum), bsum); AssertEquals(new System.Decimal(0), min); AssertEquals(bsum / 2, avg); }
private NeoDatis.Odb.Test.VO.Attribute.TestClass GetTestClassInstance() { NeoDatis.Odb.Test.VO.Attribute.TestClass tc = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc.SetBigDecimal1(new System.Decimal(1.123456789)); tc.SetBoolean1(true); tc.SetChar1('d'); tc.SetDouble1(154.78998989); tc.SetInt1(78964); tc.SetString1("Ola chico como vc est√° ???"); tc.SetDate1(new System.DateTime()); return tc; }
private NeoDatis.Odb.Test.VO.Attribute.TestClass GetTestClassInstance() { NeoDatis.Odb.Test.VO.Attribute.TestClass tc = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc.SetBigDecimal1(new System.Decimal(1.123456789)); tc.SetBoolean1(true); tc.SetChar1('d'); tc.SetDouble1(154.78998989); tc.SetInt1(78964); tc.SetString1("Ola chico como vc est√° ???"); tc.SetDate1(new System.DateTime()); return(tc); }
public virtual void Test5() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); int size = isLocal ? 100000 : 1000; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); } odb.Close(); odb = Open("valuesA2"); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Count("nb objects")); Println(values); NeoDatis.Odb.ObjectValues ov = values.NextValues(); odb.Close(); AssertEquals(size, ov.GetByAlias("nb objects")); AssertEquals(1, values.Count); }
public virtual void Test7() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); int size = isLocal ? 100000 : 1000; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(i); odb.Store(tc1); } odb.Close(); odb = Open("valuesA2"); decimal nb = odb.Count(new NeoDatis.Odb.Impl.Core.Query.Criteria.CriteriaQuery(typeof( NeoDatis.Odb.Test.VO.Attribute.TestClass), NeoDatis.Odb.Core.Query.Criteria.Where .Equal("int1", 2))); Println(nb); odb.Close(); AssertEquals(1, nb); }
/// <exception cref="System.IO.IOException"></exception> /// <exception cref="System.Exception"></exception> public virtual void Test4() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); NeoDatis.Odb.Test.VO.Attribute.TestClass tc2 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc2.SetInt1(5); odb.Store(tc2); odb.Close(); odb = Open("valuesA2"); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Sum("int1", "sum of int1").Count ("nb objects")); Println(values); NeoDatis.Odb.ObjectValues ov = values.NextValues(); odb.Close(); AssertEquals(50, ov.GetByAlias("sum of int1")); AssertEquals(2, ov.GetByAlias("nb objects")); AssertEquals(1, values.Count); }
public virtual void Test4() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); NeoDatis.Odb.Test.VO.Attribute.TestClass tc2 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc2.SetInt1(5); odb.Store(tc2); odb.Close(); odb = Open("valuesA2"); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Sum("int1", "sum of int1").Count ("nb objects")); Println(values); NeoDatis.Odb.ObjectValues ov = values.NextValues(); odb.Close(); AssertEquals(50, ov.GetByAlias("sum of int1")); AssertEquals(2, ov.GetByAlias("nb objects")); AssertEquals(1, values.Count); }
/// <exception cref="System.IO.IOException"></exception> /// <exception cref="System.Exception"></exception> public virtual void Test7() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); int size = isLocal ? 100000 : 1000; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(i); odb.Store(tc1); } odb.Close(); odb = Open("valuesA2"); decimal nb = odb.Count(new NeoDatis.Odb.Impl.Core.Query.Criteria.CriteriaQuery(typeof( NeoDatis.Odb.Test.VO.Attribute.TestClass), NeoDatis.Odb.Core.Query.Criteria.Where .Equal("int1", 2))); Println(nb); odb.Close(); AssertEquals(1, nb); }
/// <exception cref="System.IO.IOException"></exception> /// <exception cref="System.Exception"></exception> public virtual void Test5() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); int size = isLocal ? 100000 : 1000; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); } odb.Close(); odb = Open("valuesA2"); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Count("nb objects")); Println(values); NeoDatis.Odb.ObjectValues ov = values.NextValues(); odb.Close(); AssertEquals(size, ov.GetByAlias("nb objects")); AssertEquals(1, values.Count); }
// assertEquals(bsum.divide(new // BigDecimal(size),2,BigDecimal.ROUND_HALF_DOWN), avg); /// <exception cref="System.IO.IOException"></exception> /// <exception cref="System.Exception"></exception> public virtual void Test16() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = null; NeoDatis.Tool.StopWatch t = new NeoDatis.Tool.StopWatch(); int size = isLocal ? 10000 : 100; for (int j = 0; j < 10; j++) { t.Start(); odb = Open("valuesA2"); for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(45); odb.Store(tc1); } odb.Close(); t.End(); Println(" time for insert = " + t.GetDurationInMiliseconds()); } odb = Open("valuesA2"); t.Start(); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Count("nb objects")); t.End(); Println(values); Println(" time for count = " + t.GetDurationInMiliseconds()); NeoDatis.Odb.ObjectValues ov = values.NextValues(); odb.Close(); AssertEquals(size * 10, ov.GetByAlias("nb objects")); AssertEquals(1, values.Count); }
/// <summary>Custom</summary> /// <exception cref="System.IO.IOException"></exception> /// <exception cref="System.Exception"></exception> public virtual void Test10() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); NeoDatis.Tool.StopWatch t = new NeoDatis.Tool.StopWatch(); t.Start(); int size = 1000; long sum = 0; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(i); odb.Store(tc1); sum += i; } odb.Close(); t.End(); Println(" time for insert = " + t.GetDurationInMiliseconds()); odb = Open("valuesA2"); t.Start(); NeoDatis.Odb.Core.Query.Values.ICustomQueryFieldAction custom = new NeoDatis.Odb.Test.Query.Values.TestCustomQueryFieldAction (); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Custom("int1", "custom of int1" , custom)); t.End(); NeoDatis.Odb.ObjectValues ov = values.NextValues(); System.Decimal c = (System.Decimal)ov.GetByAlias("custom of int1"); Println(c); Println(" time for count = " + t.GetDurationInMiliseconds()); odb.Close(); }
/// <summary>Min</summary> /// <exception cref="System.IO.IOException"></exception> /// <exception cref="System.Exception"></exception> public virtual void Test9() { DeleteBase("valuesA2"); NeoDatis.Odb.ODB odb = Open("valuesA2"); int size = isLocal ? 100000 : 1000; long sum = 0; for (int i = 0; i < size; i++) { NeoDatis.Odb.Test.VO.Attribute.TestClass tc1 = new NeoDatis.Odb.Test.VO.Attribute.TestClass (); tc1.SetInt1(i); odb.Store(tc1); sum += i; } odb.Close(); odb = Open("valuesA2"); NeoDatis.Odb.Values values = odb.GetValues(new NeoDatis.Odb.Impl.Core.Query.Values.ValuesCriteriaQuery (typeof(NeoDatis.Odb.Test.VO.Attribute.TestClass)).Min("int1", "min of int1").Avg ("int1", "avg of int1").Sum("int1", "sum of int1")); NeoDatis.Odb.ObjectValues ov = values.NextValues(); System.Decimal min = (System.Decimal)ov.GetByAlias("min of int1"); System.Decimal avg = (System.Decimal)ov.GetByAlias("avg of int1"); System.Decimal bsum = (System.Decimal)ov.GetByAlias("sum of int1"); Println(min); Println(avg); Println(bsum); odb.Close(); AssertEquals(new System.Decimal(sum), bsum); AssertEquals(new System.Decimal(0), min); AssertEquals(bsum/2, avg); }