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;
}
}
