public async Task TestStoreDictionaryTransactional()
{
Siaqodb s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
await s_db.DropTypeAsync <WithDict>();
await s_db.DropTypeAsync <JaggedTy>();
await s_db.DropTypeAsync <NMatrixTy>();
ITransaction transaction = s_db.BeginTransaction();
for (int i = 0; i < 10; i++)
{
WithDict dict = new WithDict();
dict.DictInt = new Dictionary <int, int>();
dict.DictStr = new Dictionary <byte, string>();
dict.DictComplex = new Dictionary <JaggedTy, int>();
dict.ZuperDict = new Dictionary <uint, NMatrixTy>();
for (int j = 0; j < 5; j++)
{
dict.DictInt[j] = i + j;
dict.ZuperDict[(uint)j] = new NMatrixTy();
dict.DictStr[(byte)j] = "sss" + i.ToString();
JaggedTy jt = new JaggedTy();
dict.DictComplex[jt] = j + i;
}
await s_db.StoreObjectAsync(dict, transaction);
}
await transaction.CommitAsync();
bool mustRollBack = false;
try
{
transaction = s_db.BeginTransaction();
for (int i = 0; i < 10; i++)
{
WithDict dict = new WithDict();
dict.DictInt = new Dictionary <int, int>();
dict.DictStr = new Dictionary <byte, string>();
dict.DictComplex = new Dictionary <JaggedTy, int>();
dict.ZuperDict = new Dictionary <uint, NMatrixTy>();
for (int j = 0; j < 5; j++)
{
dict.DictInt[j] = i + j;
dict.ZuperDict[(uint)j] = new NMatrixTy();
dict.DictStr[(byte)j] = "sss" + i.ToString();
JaggedTy jt = new JaggedTy();
dict.DictComplex[jt] = j + i;
}
await s_db.StoreObjectAsync(dict, transaction);
if (i == 5)
{
throw new Exception("need some rollback");
}
}
await transaction.CommitAsync();
}
catch (Exception ex)
{
if (ex.Message == "need some rollback")
{
mustRollBack = true;
}
else
{
throw ex;
}
}
if (mustRollBack)
{
await transaction.RollbackAsync();
}
IList <WithDict> all = await s_db.LoadAllAsync <WithDict>();
Assert.AreEqual(10, all.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(5, all[i].DictInt.Keys.Count);
Assert.AreEqual(5, all[i].DictStr.Keys.Count);
Assert.AreEqual(5, all[i].DictComplex.Keys.Count);
Assert.AreEqual(5, all[i].ZuperDict.Keys.Count);
for (int j = 0; j < 5; j++)
{
Assert.AreEqual(i + j, all[i].DictInt[j]);
Assert.AreEqual("sss" + i, all[i].DictStr[(byte)j]);
Assert.IsNotNull(all[i].ZuperDict[(uint)j]);
}
}
s_db.Close();
s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
all = await s_db.LoadAllAsync <WithDict>();
Assert.AreEqual(10, all.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(5, all[i].DictInt.Keys.Count);
Assert.AreEqual(5, all[i].DictStr.Keys.Count);
Assert.AreEqual(5, all[i].DictComplex.Keys.Count);
Assert.AreEqual(5, all[i].ZuperDict.Keys.Count);
for (int j = 0; j < 5; j++)
{
Assert.AreEqual(i + j, all[i].DictInt[j]);
Assert.AreEqual("sss" + i, all[i].DictStr[(byte)j]);
Assert.IsTrue(all[i].ZuperDict[(uint)j].OID > 0);
}
}
var q = await(from WithDict d in s_db
where d.DictInt.ContainsKey(1)
select d).ToListAsync();
Assert.AreEqual(10, q.ToList().Count);
q = await(from WithDict d in s_db
where d.DictInt.ContainsValue(1)
select d).ToListAsync();
Assert.AreEqual(2, q.ToList().Count);
q = await(from WithDict d in s_db
where d.DictInt.ContainsKey(-1)
select d).ToListAsync();
Assert.AreEqual(0, q.ToList().Count);
}
public async Task TestStoreDictionaryAndShrink()
{
Siaqodb s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
await s_db.DropTypeAsync <WithDict>();
await s_db.DropTypeAsync <JaggedTy>();
await s_db.DropTypeAsync <NMatrixTy>();
for (int i = 0; i < 20; i++)
{
WithDict dict = new WithDict();
dict.DictInt = new Dictionary <int, int>();
dict.DictStr = new Dictionary <byte, string>();
dict.DictComplex = new Dictionary <JaggedTy, int>();
dict.ZuperDict = new Dictionary <uint, NMatrixTy>();
for (int j = 0; j < 5; j++)
{
dict.DictInt[j] = i + j;
dict.ZuperDict[(uint)j] = new NMatrixTy();
dict.DictStr[(byte)j] = "sss" + i.ToString();
JaggedTy jt = new JaggedTy();
dict.DictComplex[jt] = j + i;
}
await s_db.StoreObjectAsync(dict);
}
await s_db.FlushAsync();
IList <WithDict> all = await s_db.LoadAllAsync <WithDict>();
for (int i = 0; i < 10; i++)
{
await s_db.DeleteAsync(all[i]);
}
await s_db.FlushAsync();
s_db.Close();
await SiaqodbUtil.ShrinkAsync(dbFolder, ShrinkType.Normal);
await SiaqodbUtil.ShrinkAsync(dbFolder, ShrinkType.ForceClaimSpace);
s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
all = await s_db.LoadAllAsync <WithDict>();
for (int i = 10; i < 20; i++)
{
int j = i - 10;
Assert.AreEqual(5, all[j].DictInt.Keys.Count);
Assert.AreEqual(5, all[j].DictStr.Keys.Count);
Assert.AreEqual(5, all[j].DictComplex.Keys.Count);
Assert.AreEqual(5, all[j].ZuperDict.Keys.Count);
for (int k = 0; k < 5; k++)
{
Assert.AreEqual(i + k, all[j].DictInt[k]);
Assert.AreEqual("sss" + i, all[j].DictStr[(byte)k]);
Assert.IsNotNull(all[j].ZuperDict[(uint)k]);
}
}
var q = await(from WithDict d in s_db
where d.DictInt.ContainsKey(1)
select d).ToListAsync();
Assert.AreEqual(10, q.Count);
q = await(from WithDict d in s_db
where d.DictInt.ContainsValue(11)
select d).ToListAsync();
Assert.AreEqual(2, q.Count);
q = await(from WithDict d in s_db
where d.DictInt.ContainsKey(-1)
select d).ToListAsync();
Assert.AreEqual(0, q.Count);
}
public async Task TestUpdateDictionary()
{
Siaqodb s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
await s_db.DropTypeAsync <WithDict>();
await s_db.DropTypeAsync <JaggedTy>();
await s_db.DropTypeAsync <NMatrixTy>();
for (int i = 0; i < 10; i++)
{
WithDict dict = new WithDict();
dict.DictInt = new Dictionary <int, int>();
dict.DictStr = new Dictionary <byte, string>();
dict.DictComplex = new Dictionary <JaggedTy, int>();
dict.ZuperDict = new Dictionary <uint, NMatrixTy>();
for (int j = 0; j < 5; j++)
{
dict.DictInt[j] = i + j;
dict.ZuperDict[(uint)j] = new NMatrixTy();
dict.DictStr[(byte)j] = "sss" + i.ToString();
JaggedTy jt = new JaggedTy();
dict.DictComplex[jt] = j + i;
}
await s_db.StoreObjectAsync(dict);
}
await s_db.FlushAsync();
IList <WithDict> all = await s_db.LoadAllAsync <WithDict>();
for (int i = 0; i < 10; i++)
{
for (int j = 0; j < 5; j++)
{
all[i].DictInt[j] = i + j + 10;
all[i].DictStr[(byte)j] = "updated test";
all[i].ZuperDict[(uint)j] = new NMatrixTy();
}
await s_db.StoreObjectAsync(all[i]);
}
await s_db.FlushAsync();
all = await s_db.LoadAllAsync <WithDict>();
Assert.AreEqual(10, all.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(5, all[i].DictInt.Keys.Count);
Assert.AreEqual(5, all[i].DictStr.Keys.Count);
Assert.AreEqual(5, all[i].DictComplex.Keys.Count);
Assert.AreEqual(5, all[i].ZuperDict.Keys.Count);
for (int j = 0; j < 5; j++)
{
Assert.AreEqual(i + j + 10, all[i].DictInt[j]);
Assert.AreEqual("updated test", all[i].DictStr[(byte)j]);
Assert.IsNotNull(all[i].ZuperDict[(uint)j]);
}
}
s_db.Close();
s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
all = await s_db.LoadAllAsync <WithDict>();
Assert.AreEqual(10, all.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual(5, all[i].DictInt.Keys.Count);
Assert.AreEqual(5, all[i].DictStr.Keys.Count);
Assert.AreEqual(5, all[i].DictComplex.Keys.Count);
Assert.AreEqual(5, all[i].ZuperDict.Keys.Count);
for (int j = 0; j < 5; j++)
{
Assert.AreEqual(i + j + 10, all[i].DictInt[j]);
Assert.AreEqual("updated test", all[i].DictStr[(byte)j]);
Assert.IsNotNull(all[i].ZuperDict[(uint)j]);
}
}
var q = await(from WithDict d in s_db
where d.DictInt.ContainsKey(1)
select d).ToListAsync();
Assert.AreEqual(10, q.ToList().Count);
q = await(from WithDict d in s_db
where d.DictInt.ContainsValue(11)
select d).ToListAsync();
Assert.AreEqual(2, q.ToList().Count);
q = await(from WithDict d in s_db
where d.DictInt.ContainsKey(-1)
select d).ToListAsync();
Assert.AreEqual(0, q.ToList().Count);
}
public async Task TestStoreSimpleJagged()
{
Siaqodb s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
await s_db.DropTypeAsync <JaggedTy>();
for (int i = 0; i < 10; i++)
{
JaggedTy jg = new JaggedTy();
jg.jaggedByte = new byte[2][];
jg.jaggedByte[0] = new byte[2];
jg.jaggedByte[0][0] = (byte)i;
jg.jaggedByte[0][1] = (byte)(i + 1);
jg.jaggedByte[1] = new byte[2];
jg.jaggedByte[1][0] = (byte)(i + 2);
jg.jaggedByte[1][1] = (byte)(i + 3);
jg.jaggedInt = new int[2][];
jg.jaggedInt[0] = new int[2];
jg.jaggedInt[0][0] = i;
jg.jaggedInt[0][1] = (i + 1);
jg.jaggedInt[1] = new int[2];
jg.jaggedInt[1][0] = (i + 2);
jg.jaggedInt[1][1] = (i + 3);
jg.jaggedList = new List <List <int> >();
List <int> myList = new List <int>();
myList.Add(i);
myList.Add(i + 1);
List <int> myList2 = new List <int>();
myList2.Add(i * 10);
myList2.Add(i * 100);
jg.jaggedList.Add(myList);
jg.jaggedList.Add(myList2);
jg.jaggedListStr = new List <List <string> >();
List <string> myListStr = new List <string>();
myListStr.Add("ws" + i.ToString());
myListStr.Add("second" + i.ToString());
jg.jaggedListStr.Add(myListStr);
SimpleClass simple = new SimpleClass();
simple.Name = "ssss";
jg.complexJaggedList = new List <List <SimpleClass> >();
List <SimpleClass> listSimple = new List <SimpleClass>();
listSimple.Add(simple);
jg.complexJaggedList.Add(listSimple);
jg.complexJaggedList.Add(listSimple);
await s_db.StoreObjectAsync(jg);
}
await s_db.FlushAsync();
IList <JaggedTy> all = await s_db.LoadAllAsync <JaggedTy>();
Assert.AreEqual(10, all.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual((byte)i, all[i].jaggedByte[0][0]);
Assert.AreEqual((byte)(i + 1), all[i].jaggedByte[0][1]);
Assert.AreEqual((byte)(i + 2), all[i].jaggedByte[1][0]);
Assert.AreEqual((byte)(i + 3), all[i].jaggedByte[1][1]);
Assert.AreEqual(i, all[i].jaggedInt[0][0]);
Assert.AreEqual((i + 1), all[i].jaggedInt[0][1]);
Assert.AreEqual((i + 2), all[i].jaggedInt[1][0]);
Assert.AreEqual((i + 3), all[i].jaggedInt[1][1]);
Assert.AreEqual(2, all[i].jaggedList[0].Count);
Assert.AreEqual(2, all[i].jaggedList.Count);
Assert.AreEqual(i, all[i].jaggedList[0][0]);
Assert.AreEqual(i + 1, all[i].jaggedList[0][1]);
Assert.AreEqual(i * 10, all[i].jaggedList[1][0]);
Assert.AreEqual(i * 100, all[i].jaggedList[1][1]);
Assert.AreEqual(1, all[i].jaggedListStr.Count);
Assert.AreEqual(2, all[i].jaggedListStr[0].Count);
Assert.AreEqual("ws" + i, all[i].jaggedListStr[0][0]);
Assert.AreEqual("second" + i, all[i].jaggedListStr[0][1]);
Assert.AreEqual(2, all[i].complexJaggedList.Count);
Assert.IsNotNull(all[i].complexJaggedList[0][0]);
}
s_db.Close();
s_db = new Siaqodb(); await s_db.OpenAsync(dbFolder);
all = await s_db.LoadAllAsync <JaggedTy>();
Assert.AreEqual(10, all.Count);
for (int i = 0; i < 10; i++)
{
Assert.AreEqual((byte)i, all[i].jaggedByte[0][0]);
Assert.AreEqual((byte)(i + 1), all[i].jaggedByte[0][1]);
Assert.AreEqual((byte)(i + 2), all[i].jaggedByte[1][0]);
Assert.AreEqual((byte)(i + 3), all[i].jaggedByte[1][1]);
Assert.AreEqual(i, all[i].jaggedInt[0][0]);
Assert.AreEqual((i + 1), all[i].jaggedInt[0][1]);
Assert.AreEqual((i + 2), all[i].jaggedInt[1][0]);
Assert.AreEqual((i + 3), all[i].jaggedInt[1][1]);
Assert.AreEqual(2, all[i].jaggedList[0].Count);
Assert.AreEqual(2, all[i].jaggedList.Count);
Assert.AreEqual(i, all[i].jaggedList[0][0]);
Assert.AreEqual(i + 1, all[i].jaggedList[0][1]);
Assert.AreEqual(i * 10, all[i].jaggedList[1][0]);
Assert.AreEqual(i * 100, all[i].jaggedList[1][1]);
Assert.AreEqual(1, all[i].jaggedListStr.Count);
Assert.AreEqual(2, all[i].jaggedListStr[0].Count);
Assert.AreEqual("ws" + i, all[i].jaggedListStr[0][0]);
Assert.AreEqual("second" + i, all[i].jaggedListStr[0][1]);
Assert.AreEqual(2, all[i].complexJaggedList.Count);
Assert.IsNotNull(all[i].complexJaggedList[0][0]);
}
var q = await(from JaggedTy jgd in s_db
where jgd.jaggedInt.Length == 2
select jgd).ToListAsync();
Assert.AreEqual(10, q.Count);
List <int> myInList = new List <int>();
myInList.Add(0);
myInList.Add(1);
var q2 = await(from JaggedTy jgd in s_db
where jgd.jaggedList.Contains(myInList)
select jgd).ToListAsync();
Assert.AreEqual(1, q2.Count);
}