public void TestCase_Single_Relate2() { var listA = InitialRelateTableA(20); var listB = InitialRelateTableB(20); var listC = InitialRelateTableC(20); var listD = InitialRelateTableD(20); var listE = InitialRelateTableE(20); var list = context.Query <TeRelateA_BX>().ToList(); Assert.Equal(listA.Count, list.Count); int i = 0; foreach (var item in list) { AssertExtend.Equal(listA[i], item); AssertExtend.Equal(listB[i], item.RelateB); AssertExtend.Equal(listC[i], item.RelateB.RelateC); AssertExtend.Equal(listD[i], item.RelateB.RelateD); AssertExtend.Equal(listE[i], item.RelateB.RelateE); AssertExtend.Equal(listE[i], item.RelateE); Assert.Equal(item, item.RelateE.RelateA); Assert.NotEqual(item.RelateE, item.RelateB.RelateE); Assert.Equal(item, item.RelateB.RelateC.RelateA); i++; } }
public void TestCase_Base_Single_Collection() { var listA = InitialRelateTableA(20); var listB = InitialRelateTableB(18); var listCollection = InitialRelateTableCollection(15); { var listEx = (from x in listA join y in listB on x.Id equals y.RelateAId into ps from p in ps.DefaultIfEmpty() select new TeRelateA_B { Id = x.Id, RelateBId = x.RelateBId, RelateCId = x.RelateCId, RelateDId = x.RelateDId, RelateEId = x.RelateEId, RelateFId = x.RelateFId, DecimalField = x.DecimalField, VarcharField = x.VarcharField, DateTimeField = x.DateTimeField, RelateB = p }).ToList(); var listAc = context.Query <TeRelateA_B_Collection>().ToList(); AssertExtend.Equal(listA, listAc); for (int i = 0; i < listAc.Count; i++) { var item = listAc[i]; AssertExtend.Equal(listEx[i], item); var collectionEx = listCollection.Where(x => x.RelateAId == item.Id).ToList(); var collectionAc = item.RelateCollection.ToList(); AssertExtend.StrictEqual(collectionEx, collectionAc); } } }
public void TestCase_DefalutValue_Refresh() { context.TruncateTable <TeBaseFieldDefaultValue>(); var value = context.CreateNew <TeBaseFieldDefaultValue>(); context.Insert(value, true); var ac = context.SelectById <TeBaseFieldDefaultValue>(value.Id); AssertExtend.Equal(value, ac); }
public async Task TestCase_MiniValue_Refresh_Async() { await context.TruncateTableAsync <TeBaseFieldNullMiniValue>(CancellationToken.None); var value = context.CreateNew <TeBaseFieldNullMiniValue>(); await context.InsertAsync(value, true, CancellationToken.None); var ac = await context.SelectByIdAsync <TeBaseFieldNullMiniValue>(value.Id, CancellationToken.None); AssertExtend.Equal(value, ac); }
public void TestCase_DefaultValue_BulkInsert_Refresh() { context.TruncateTable <TeBaseFieldDefaultValue>(); var list = new List <TeBaseFieldDefaultValue>(); for (int i = 0; i < 10; i++) { var value = context.CreateNew <TeBaseFieldDefaultValue>(); list.Add(value); } context.BatchInsert(list, true, true); var listAc = context.Query <TeBaseFieldDefaultValue>().ToList(); AssertExtend.Equal(list, listAc); }
public async Task TestCase_MiniValue_BulkInsert_Refresh_Async() { await context.TruncateTableAsync <TeBaseFieldNullMiniValue>(CancellationToken.None); var list = new List <TeBaseFieldNullMiniValue>(); for (int i = 0; i < 10; i++) { var value = context.CreateNew <TeBaseFieldNullMiniValue>(); list.Add(value); } await context.BatchInsertAsync(list, true, true, CancellationToken.None); var listAc = await context.Query <TeBaseFieldNullMiniValue>().ToListAsync(CancellationToken.None); AssertExtend.Equal(list, listAc); }
public void TestCase_Single_Relate1() { var listA = InitialRelateTableA(20); var listB = InitialRelateTableB(20); var list = context.Query <TeRelateA_B_A>().ToList(); Assert.Equal(listA.Count, list.Count); int i = 0; foreach (var item in list) { AssertExtend.Equal(listA[i], item); AssertExtend.Equal(listB[i], item.RelateB); Assert.Equal(item, item.RelateB.RelateA); i++; } }
public async Task TestCase_CUD_Bulk_Async() { const int count = 33; var listEx = CreateBaseFieldEntityTableList(count); List <TeBaseFieldEntity> listAc; await context.TruncateTableAsync <TeBaseFieldEntity>(CancellationToken.None); var retInsert = await context.BatchInsertAsync(listEx, CancellationToken.None); Assert.Equal(count, retInsert); listAc = await context.Query <TeBaseFieldEntity>().ToListAsync(CancellationToken.None); AssertExtend.Equal(listEx, listAc); DateTime d = GetNow(); listEx.ForEach(x => { x.DateTimeField = d; x.DateTimeFieldNull = null; x.Int32Field = 2; x.Int32FieldNull = null; x.DoubleField = 2.0d; x.DoubleFieldNull = null; x.VarcharField = "abc"; x.VarcharFieldNull = null; x.EnumInt32Field = EnumInt32Type.Zero; x.EnumInt32FieldNull = null; x.EnumInt64Field = EnumInt64Type.Zero; x.EnumInt64FieldNull = null; }); var retUpdate = await context.BatchUpdateAsync(listEx, CancellationToken.None); Assert.Equal(count, retUpdate); listAc = await context.Query <TeBaseFieldEntity>().ToListAsync(CancellationToken.None); AssertExtend.Equal(listEx, listAc); var retDelete = await context.BatchDeleteAsync(listEx, CancellationToken.None); Assert.Equal(count, retDelete); listAc = await context.Query <TeBaseFieldEntity>().ToListAsync(CancellationToken.None); AssertExtend.Equal(0, listAc.Count); }
public void TestCase_CUD_Bulk() { const int count = 33; var listEx = CreateBaseFieldEntityTableList(count); List <TeBaseFieldEntity> listAc; context.TruncateTable <TeBaseFieldEntity>(); var retInsert = context.BatchInsert(listEx); Assert.Equal(count, retInsert); listAc = context.Query <TeBaseFieldEntity>().ToList(); AssertExtend.Equal(listEx, listAc); DateTime d = GetNow(); listEx.ForEach(x => { x.DateTimeField = d; x.DateTimeFieldNull = null; x.Int32Field = 2; x.Int32FieldNull = null; x.DoubleField = 2.0d; x.DoubleFieldNull = null; x.VarcharField = "abc"; x.VarcharFieldNull = null; x.EnumInt32Field = EnumInt32Type.Zero; x.EnumInt32FieldNull = null; x.EnumInt64Field = EnumInt64Type.Zero; x.EnumInt64FieldNull = null; }); var retUpdate = context.BatchUpdate(listEx); Assert.Equal(count, retUpdate); listAc = context.Query <TeBaseFieldEntity>().ToList(); AssertExtend.Equal(listEx, listAc); var retDelete = context.BatchDelete(listEx); Assert.Equal(count, retDelete); listAc = context.Query <TeBaseFieldEntity>().ToList(); AssertExtend.Equal(0, listAc.Count); }
public void TestCase_Base_Collection() { var listA = InitialRelateTableA(20); var listCollection = InitialRelateTableCollection(15); { var listAc = context.Query <TeRelateA_LCollection>().ToList(); AssertExtend.Equal(listA, listAc); for (int i = 0; i < listAc.Count; i++) { var item = listAc[i]; var collectionEx = listCollection.Where(x => x.RelateAId == item.Id).ToList(); var collectionAc = item.RelateCollection.ToList(); AssertExtend.StrictEqual(collectionEx, collectionAc); } } { var listAc = context.Query <TeRelateA_ICollection>().ToList(); AssertExtend.Equal(listA, listAc); for (int i = 0; i < listAc.Count; i++) { var item = listAc[i]; var collectionEx = listCollection.Where(x => x.RelateAId == item.Id).ToList(); var collectionAc = item.RelateCollection.ToList(); AssertExtend.StrictEqual(collectionEx, collectionAc); } } { var listAc = context.Query <TeRelateA_2Collection>().ToList(); AssertExtend.Equal(listA, listAc); for (int i = 0; i < listAc.Count; i++) { var item = listAc[i]; var collectionEx = listCollection.Where(x => x.RelateAId == item.Id).ToList(); var collectionLAc = item.RelateLCollection.ToList(); AssertExtend.StrictEqual(collectionEx, collectionLAc); var collectionIAc = item.RelateICollection.ToList(); AssertExtend.StrictEqual(collectionEx, collectionIAc); } } }