public async Task All_WhereSpecification()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync(where : "WHERE rental_duration=@0", args: 5)).ToListAsync();
Assert.AreEqual(191, allRows.Count);
}
public async Task All_NoParameters()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync()).ToListAsync();
Assert.AreEqual(1000, allRows.Count);
}
public async Task All_LimitSpecification()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync(limit: 10)).ToListAsync();
Assert.AreEqual(10, allRows.Count);
}
public async Task All_WhereSpecification_ColumnsSpecification_LimitSpecification()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync(limit: 2, columns: "film_id, description, language_id", where : "WHERE rental_duration=@0", args: 5)).ToListAsync();
Assert.AreEqual(2, allRows.Count);
var firstRow = allRows[0];
Assert.Greater(firstRow.film_id, 0);
Assert.AreNotEqual(firstRow.description, "");
Assert.Greater(firstRow.language_id, 0);
}
public async Task All_ColumnSpecification()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync(columns: "film_id, description, language_id")).ToListAsync();
Assert.AreEqual(1000, allRows.Count);
var firstRow = allRows[0];
Assert.Greater(firstRow.film_id, 0);
Assert.AreNotEqual("", firstRow.description);
Assert.Greater(firstRow.language_id, 0);
}
public async Task All_WhereSpecification_OrderBySpecification()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync(orderBy: "film_id DESC", where : "WHERE rental_duration=@0", args: 5)).ToListAsync();
Assert.AreEqual(191, allRows.Count);
int previous = int.MaxValue;
foreach (var r in allRows)
{
int current = r.film_id;
Assert.IsTrue(current <= previous);
previous = current;
}
}
public async Task All_OrderBySpecification()
{
var films = new Films(ProviderName);
var allRows = await(await films.AllAsync(orderBy: "rental_duration DESC")).ToListAsync();
Assert.AreEqual(1000, allRows.Count);
int previous = int.MaxValue;
foreach (var r in allRows)
{
int current = r.rental_duration;
Assert.IsTrue(current <= previous);
previous = current;
}
}
public async Task All_NoParameters_Streaming()
{
var films = new Films(ProviderName);
var allRows = await films.AllAsync();
var count = 0;
await allRows.ForEachAsync(r => {
count++;
Assert.Greater(r.film_id, 0);
Assert.Greater(r.last_update, DateTime.MinValue);
Assert.Greater(r.language_id, 0);
Assert.Greater(r.rental_duration, 0);
Assert.AreNotEqual(r.description, "");
});
Assert.AreEqual(1000, count);
}