public void Update_all_one_success() { var query = Prepare.SetQuery(); var allProperty = Prepare.GetQuery().GetFirst(a => a.Id == 7); allProperty.index = DateTime.Now.Day; allProperty.description = $"Updated on {DateTime.Now}"; allProperty.datemod = DateTime.Now; allProperty.amount = DateTime.Now.DayOfYear; var result = query.Update(allProperty); Assert.True(result); var oneProperty = Prepare.GetQuery().GetFirst(a => a.Id == 9); oneProperty.index = DateTime.Now.Day; oneProperty.description = $"Updated on {DateTime.Now}"; oneProperty.datemod = DateTime.Now; oneProperty.amount = DateTime.Now.DayOfYear; result = query.Update(oneProperty, p => p.description); Assert.True(result); }
public void GetBottom_not_null_value_match_dto() { var query = Prepare.GetQuery(); var result = query.GetBottom(a => a.Id >= 5, k => k.Id); var dto = query.GetBottom(a => a.Id >= 5, k => k.Id, s => new AuthorDto { Id = s.Id, name = s.Name }); Assert.NotNull(result); Assert.Equal(5, result.Id); Assert.NotNull(dto); Assert.Equal(5, dto.Id); }
public void GetFirst_not_null_value_match_dto() { var query = Prepare.GetQuery(); var result = query.GetFirst(a => a.Id > 2); var dto = query.GetFirst(a => a.Id > 2, s => new AuthorDto { Id = s.Id, name = s.Name }); Assert.NotNull(result); Assert.Equal(3, result.Id); Assert.NotNull(dto); Assert.Equal(3, dto.Id); }
public void GetOrderedList_not_null_count_dto() { var query = Prepare.GetQuery(); var all = query.GetOrderedList(k => k.Name); var notall = query.GetOrderedList(k => k.Name, a => a.index > 0 && a.index <= 11); var dto = query.GetOrderedList(k => k.Name, s => new AuthorDto { Id = s.Id, name = s.Name }, a => a.index > 0 && a.index <= 11); Assert.NotNull(all); Assert.True(all.Count > 10); Assert.NotNull(notall); Assert.Equal(6, notall.Count); Assert.NotNull(dto); Assert.Equal(6, dto.Count); }
public void GetRangeOrderBy_not_null_count_dto() { var query = Prepare.GetQuery(); var all = query.GetRangeOrderBy((0, 3), k => k.Id); var notall = query.GetRangeOrderBy((2, 3), k => k.Id, a => a.index > 0 && a.index <= 11); var dto = query.GetRangeOrderBy((2, 3), k => k.Id, s => new AuthorDto { Id = s.Id, name = s.Name }, a => a.index > 0 && a.index <= 11); Assert.NotNull(all); Assert.Equal(3, all.Count); Assert.NotNull(notall); Assert.Equal(3, notall.Count); Assert.NotNull(dto); Assert.Equal(3, dto.Count); }