public void GetFirst_not_null_value_match()
{
var query = Prepare.GetQuery();
var result = query.GetFirst(a => a.Index > 2);
Assert.NotNull(result);
Assert.Equal(3, result.Index);
}
public void Delete_all_success()
{
var query = Prepare.SetQuery();
var result = query.Delete(a => a.Index < 100);
Assert.True(result);
}
public void GetBottom_not_null_value_match()
{
var query = Prepare.GetQuery();
var result = query.GetBottom(a => a.Index >= 5, k => k.Index);
Assert.NotNull(result);
Assert.Equal(5, result.Index);
}
public void GetTop_not_null_value_match()
{
var query = Prepare.GetQuery();
var result = query.GetTop(a => a.Index >= 5 && a.Index < 12, k => k.Index);
Assert.NotNull(result);
Assert.Equal(11, result.Index);
}
public void Insert_success()
{
var query = Prepare.SetQuery();
var result = query.Insert(
new Author {
Name = "Isaac Asimov", Description = "Sci-fi", Index = 4
});
Assert.True(result);
}
public void Update_all_one_success()
{
var query = Prepare.SetQuery();
var newAuthor = Prepare.GetQuery().GetFirst(a => a.Index == 11);
newAuthor.Description = "Greg Bear changed";
newAuthor.Name = "James Patterson";
var result = query.Update(a => a.Index == 11, newAuthor);
Assert.True(result);
}
public void GetRange_not_null_count()
{
var query = Prepare.GetQuery();
var all = query.GetRange((2, 3));
var notall = query.GetRange((2, 3), a => a.Index > 0 && a.Index <= 6);
Assert.NotNull(all);
Assert.Equal(3, all.Count);
Assert.NotNull(notall);
Assert.Equal(3, notall.Count);
}
public void GetDescendingOrderedList_not_null_count()
{
var query = Prepare.GetQuery();
var all = query.GetDescendingOrderedList(k => k.Name);
var notall = query.GetDescendingOrderedList(k => k.Name, a => a.Index > 0 && a.Index <= 6);
Assert.NotNull(all);
Assert.True(all.Count >= 10);
Assert.NotNull(notall);
Assert.Equal(6, notall.Count);
}
public void GetList_not_null_count()
{
var query = Prepare.GetQuery();
var all = query.GetList();
var notall = query.GetList(a => a.Name.Contains("Isaac Asimov"));
Assert.NotNull(all);
Assert.True(all.Count >= 11);
Assert.NotNull(notall);
Assert.Equal(2, notall.Count);
}
public void InsertBulk_success()
{
var query = Prepare.SetQuery();
var newList = new List <Author> {
new Author {
Name = "Frank Herbert",
Index = 1,
Description = "SciFi"
},
new Author {
Name = "Isaac Asimov",
Index = 2,
Description = "SciFi"
},
new Author {
Name = "Robert A Heinlein",
Index = 3,
Description = "SciFi"
},
new Author {
Name = "Rebert Silverberg",
Index = 4,
Description = "SciFi"
},
new Author {
Name = "Greg Bear",
Index = 5,
Description = "SciFi"
},
new Author {
Name = "Greg Bear",
Index = 6,
Description = "SciFi"
},
new Author {
Name = "Frank Herbert",
Index = 7,
Description = "SciFi"
},
new Author {
Name = "Isaac Asimov",
Index = 8,
Description = "SciFi"
},
new Author {
Name = "Robert A Heinlein",
Index = 9,
Description = "SciFi"
},
new Author {
Name = "Rebert Silverberg",
Index = 10,
Description = "SciFi"
},
new Author {
Name = "Greg Bear",
Index = 11,
Description = "SciFi"
}
};
var result = query.InsertBulk(newList);
Assert.True(result);
}