public virtual void TestArray61() { IOdb odb = null; var size = 50; try { DeleteBase("array9.ndb"); odb = Open("array9.ndb"); var array = new int[size]; for (var i = 0; i < size; i++) { array[i] = i; } var owna = new ObjectWithNativeArrayOfInt("t1", array); odb.Store(owna); odb.Close(); odb = Open("array9.ndb"); var query = odb.Query <ObjectWithNativeArrayOfInt>(); var l = query.Execute <ObjectWithNativeArrayOfInt>(); var owna2 = l.GetFirst(); owna2.SetNumber(1, 78); odb.Store <ObjectWithNativeArrayOfInt>(owna2); odb.Close(); odb = Open("array9.ndb"); var query1 = odb.Query <ObjectWithNativeArrayOfInt>(); l = query1.Execute <ObjectWithNativeArrayOfInt>(); var o = l.GetFirst(); AssertEquals((int)0, (int)o.GetNumber(0)); AssertEquals((int)78, (int)o.GetNumber(1)); } catch (Exception) { if (odb != null) { odb.Rollback(); odb = null; } throw; } finally { if (odb != null) { odb.Close(); } DeleteBase("array9.ndb"); } }
public virtual void TestArray2() { IOdb odb = null; var size = 50; try { DeleteBase("array2.ndb"); odb = Open("array2.ndb"); var intArray = new int[size]; for (var i = 0; i < size; i++) { intArray[i] = i; } var owna = new ObjectWithNativeArrayOfInt("t1", intArray); odb.Store(owna); odb.Close(); odb = Open("array2.ndb"); var query = odb.Query <ObjectWithNativeArrayOfInt>(); var l = query.Execute <ObjectWithNativeArrayOfInt>(); var owna2 = l.GetFirst(); AssertEquals(owna.GetName(), (string)owna2.GetName()); for (var i = 0; i < size; i++) { AssertEquals(owna.GetNumbers()[i], (int)owna2.GetNumbers()[i]); } odb.Close(); odb = null; } catch (Exception) { if (odb != null) { odb.Rollback(); odb = null; } throw; } finally { if (odb != null) { odb.Close(); } DeleteBase("array2.ndb"); } }
public virtual void TestArray6UpdateIncreasingArraySize() { IOdb odb = null; var size = 50; try { DeleteBase("array10.ndb"); odb = Open("array10.ndb"); var array = new Decimal[size]; var array2 = new Decimal[size + 1]; for (var i = 0; i < size; i++) { array[i] = new Decimal(((double)i) * 78954545 / 89); array2[i] = new Decimal(((double)i) * 78954545 / 89); } array2[size] = new Decimal(100); var owna = new ObjectWithNativeArrayOfBigDecimal("t1", array); odb.Store(owna); odb.Close(); odb = Open("array10.ndb"); var query = odb.Query <ObjectWithNativeArrayOfBigDecimal>(); var l = query.Execute <ObjectWithNativeArrayOfBigDecimal>(); var owna2 = l.GetFirst(); owna2.SetNumbers(array2); odb.Store <ObjectWithNativeArrayOfBigDecimal>(owna2); odb.Close(); odb = Open("array10.ndb"); var query1 = odb.Query <ObjectWithNativeArrayOfBigDecimal>(); l = query1.Execute <ObjectWithNativeArrayOfBigDecimal>(); var o = l.GetFirst(); AssertEquals(size + 1, (int)o.GetNumbers().Length); AssertEquals(new Decimal(100), o.GetNumber(size)); AssertEquals((object)owna2.GetNumber(1), (object)o.GetNumber(1)); odb.Close(); DeleteBase("array10.ndb"); } catch (Exception) { if (odb != null) { odb.Rollback(); } throw; } }
public virtual void TestArray5() { IOdb odb = null; var size = 50; try { DeleteBase("array7.ndb"); odb = Open("array7.ndb"); var array = new Decimal[size]; for (var i = 0; i < size; i++) { array[i] = new Decimal(((double)i) * 78954545 / 89); } var owna = new ObjectWithNativeArrayOfBigDecimal("t1", array); odb.Store(owna); odb.Close(); odb = Open("array7.ndb"); var query = odb.Query <ObjectWithNativeArrayOfBigDecimal>(); var l = query.Execute <ObjectWithNativeArrayOfBigDecimal>(); var owna2 = l.GetFirst(); owna2.SetNumber(0, new Decimal(1)); odb.Store <ObjectWithNativeArrayOfBigDecimal>(owna2); odb.Close(); odb = Open("array7.ndb"); var query1 = odb.Query <ObjectWithNativeArrayOfBigDecimal>(); l = query1.Execute <ObjectWithNativeArrayOfBigDecimal>(); var o = l.GetFirst(); AssertEquals((object)owna2.GetNumber(0), (object)o.GetNumber(0)); AssertEquals((object)owna2.GetNumber(1), (object)o.GetNumber(1)); odb.Close(); DeleteBase("array7.ndb"); } catch (Exception) { if (odb != null) { odb.Rollback(); } throw; } }
public virtual void TestArray1() { IOdb odb = null; try { DeleteBase("array1.ndb"); odb = Open("array1.ndb"); decimal nb = odb.Query <PlayerWithArray>().Count(); var player = new PlayerWithArray("kiko"); player.AddGame("volley-ball"); player.AddGame("squash"); player.AddGame("tennis"); player.AddGame("ping-pong"); odb.Store(player); odb.Close(); odb = Open("array1.ndb"); var query = odb.Query <PlayerWithArray>(); var l = query.Execute <PlayerWithArray>(true); AssertEquals(nb + 1, l.Count); // gets first player var player2 = l.GetFirst(); AssertEquals(player.ToString(), (string)player2.ToString()); } catch (Exception e) { if (odb != null) { odb.Rollback(); odb = null; } Console.WriteLine(e); throw e; } finally { if (odb != null) { odb.Close(); } DeleteBase("array1.ndb"); } }
public virtual void TestArrayOfDate() { IOdb odb = null; var size = 50; try { DeleteBase("array6.ndb"); odb = Open("array6.ndb"); var array = new DateTime[size]; var now = new DateTime(); for (var i = 0; i < size; i++) { array[i] = new DateTime(now.Millisecond + i); } var owna = new ObjectWithNativeArrayOfDate("t1", array); odb.Store(owna); odb.Close(); odb = Open("array6.ndb"); var query = odb.Query <ObjectWithNativeArrayOfDate>(); var l = query.Execute <ObjectWithNativeArrayOfDate>(); var owna2 = l.GetFirst(); AssertEquals(owna.GetName(), (string)owna2.GetName()); for (var i = 0; i < size; i++) { AssertEquals(owna.GetNumbers()[i], owna2.GetNumbers()[i]); } odb.Close(); odb = null; DeleteBase("array6.ndb"); } catch (Exception) { if (odb != null) { odb.Rollback(); } throw; } }
public virtual void TestCollectionWithContain() { IOdb odb = null; var baseName = GetBaseName(); try { odb = Open(baseName); var nb = odb.Query <PlayerWithList>().Count(); var player = new PlayerWithList("kiko"); player.AddGame("volley-ball"); player.AddGame("squash"); player.AddGame("tennis"); player.AddGame("ping-pong"); odb.Store(player); odb.Close(); odb = Open(baseName); var query = odb.Query <PlayerWithList>(); query.Descend("games").Constrain("tennis").Contains(); var l = query.Execute <PlayerWithList>(); AssertEquals(nb + 1, l.Count); } catch (Exception) { if (odb != null) { odb.Rollback(); odb = null; } throw; } finally { if (odb != null) { odb.Close(); } } }
public virtual void TestArray4() { DeleteBase("array5.ndb"); IOdb odb = null; var size = 50; try { odb = Open("array5.ndb"); var array = new Decimal[size]; for (var i = 0; i < size; i++) { array[i] = new Decimal(((double)i) * 78954545 / 89); } var owna = new ObjectWithNativeArrayOfBigDecimal("t1", array); odb.Store(owna); odb.Close(); odb = Open("array5.ndb"); var query = odb.Query <ObjectWithNativeArrayOfBigDecimal>(); var l = query.Execute <ObjectWithNativeArrayOfBigDecimal>(); var owna2 = l.GetFirst(); AssertEquals(owna.GetName(), (string)owna2.GetName()); for (var i = 0; i < size; i++) { AssertEquals(owna.GetNumbers()[i], owna2.GetNumbers()[i]); } odb.Close(); odb = null; DeleteBase("array5.ndb"); } catch (Exception) { if (odb != null) { odb.Rollback(); odb = null; } throw; } }