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