public void Insert_value_success() { var query = Prepare.SqlQuery(); var result = query.Execute("insert into author (name, description) values (@name, @description)", SqlHelper.Parameters.Get("@name", "Isaac"), SqlHelper.Parameters.Get("@description", "sci-fi")); Assert.True(result); }
public void Create_success() { var query = Prepare.SchemaQuery(); var result = query.CreateSchema(); Assert.True(result); }
public void Alter_success() { var query = Prepare.SchemaQuery(); var result = query.UpdateSchema(); Assert.True(result); }
public void Drop_success() { var query = Prepare.SchemaQuery(); var result = query.DeleteSchema(); Assert.True(result); }
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 GetFirst_not_null_value_match() { var query = Prepare.SqlQuery(); var result = query.GetFirst <AuthorObj>("select Id, name from author where Id > 5"); Assert.NotNull(result); Assert.Equal(6, result.Id); }
public void GetList_not_null_count() { var query = Prepare.SqlQuery(); var result = query.GetList <AuthorObj>("select Id, name from author where Id >= 3 and Id <= 12"); Assert.NotNull(result); Assert.Equal(10, result.Count); }
public void Insert_Delete_success() { var query = Prepare.SetQuery(); var result = query.Insert(new Author { index = 99, Name = "New insert", amount = 88, datemod = DateTime.Now }); Assert.True(result); result = query.Delete(a => a.index == 99); Assert.True(result); }
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 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 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); }
public void InsertBulk_success() { var query = Prepare.SetQuery(); var newList = new List <Author> { new Author { index = DateTime.Now.Day, description = $"Inserted (1) on {DateTime.Now}", datemod = DateTime.Now, amount = DateTime.Now.DayOfYear }, new Author { index = DateTime.Now.Day, description = $"Inserted (2) on {DateTime.Now}", datemod = DateTime.Now, amount = DateTime.Now.DayOfYear } }; var result = query.InsertBulk(newList); Assert.True(result); }