public async Task ListAsync()
{
var db = new Database(this.DbSettings, this.DbTrait, null);
//ifdb.CheckTableExists<Article>()
await db.DropTableIfExistsAsync <Article>();
await db.CreateTableAsync <Article>();
var repo = db.Repository <Article>();
var article2 = new Article()
{
Id = 1,
Name = "yy01",
Description = "yy Desc01",
Age = 30
};
for (var i = 0; i < 12; i++)
{
article2.Id = i;
article2.Name = "yy" + article2.Id.ToString("00");
article2.Description = "yy Desc" + article2.Id.ToString("00");
article2.Age = i + 20;
repo.Insert(article2, new RepoOptions()
{
AllowedFields = "Name,Age"
});
}
var pageable = new Pageable <Article>();
pageable.AndAlso(p => p.Age < 30).Descending(p => p.Age).Skip(3).Take(2);
var list = await repo.ListAsync(pageable);
Fact.Equal(2, list.Count);
Fact.Equal(list[0].Id, 6, "第一个实体.Id应该等于6");
Fact.Equal(list[1].Id, 5, "第一个实体.Id应该等于5");
}
public async void Basic()
{
using (var context = new BlogRepository()) {
var id1 = Guid.NewGuid();
var id2 = Guid.NewGuid();
var list = context.DbSet.ToList();
foreach (var e in list)
{
//context.DbSet.Attach(e);
context.DbSet.Remove(e);
}
context.DbContext.SaveChanges();
}
using (var context = new BlogRepository())
{
var ids = new List <Guid>();
for (var i = 0; i < 15; i++)
{
var id = Guid.NewGuid();
await context.CreateAsync(new Blog(id)
{
Url = i % 2 == 0?"http://" + i.ToString() + ".test": "ftp://" + i.ToString() + ".test"
});
ids.Add(id);
}
var entity = await context.GetByIdAsync(ids[0].ToString());
Assert.Equal(entity.Id, ids[0].ToString());
Assert.Equal("http://0.test", entity.Url);
entity.Url = "http://x.test";
await context.ModifyAsync(entity);
entity = await context.GetByIdAsync(entity.Id);
Assert.Equal("http://x.test", entity.Url);
var pageable = new Pageable <Blog>();
pageable.AndAlso(p => p.Url.StartsWith("http://"));
pageable.Desc = p => p.Url;
pageable.PageSize = 3;
pageable.PageIndex = 2;
await context.ListAsync(pageable);
Assert.Equal(8, pageable.RecordCount);
Assert.Equal(3, pageable.PageCount);
Assert.Equal("http://4.test", pageable.Items[0].Url);
Assert.Equal("http://2.test", pageable.Items[1].Url);
Assert.Equal("http://14.test", pageable.Items[2].Url);
await context.DeleteAsync(entity);
entity = await context.GetByIdAsync(entity.Id);
Assert.Null(entity);
}
}