public async Task Returns_empty_set_past_last_page(IDialect dialect)
{
using (var database = BlankDatabaseFactory.MakeDatabase(dialect))
{
// Arrange
database.Insert(new Dog {
Name = "Some Name 1", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 2", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 3", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 4", Age = 11
});
// Act
var pageBuilder = new PageIndexPageBuilder(3, 2);
var page = await database.GetPageAsync <Dog>(pageBuilder, "Age DESC", new { Age = 10 });
var entities = page.Items;
// Assert
entities.Should().BeEmpty();
}
}
public async Task Gets_second_page(IDialect dialect)
{
using (var database = BlankDatabaseFactory.MakeDatabase(dialect))
{
// Arrange
database.Insert(new Dog {
Name = "Some Name 1", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 2", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 3", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 4", Age = 11
});
// Act
var pageBuilder = new PageIndexPageBuilder(2, 2);
var page = await database.GetPageAsync <Dog>(pageBuilder, "Age DESC", new { Age = 10 });
var entities = page.Items;
// Assert
entities.Count().Should().Be(1);
entities[0].Name.Should().Be("Some Name 3");
}
}
public async Task Filters_result_by_conditions(IDialect dialect)
{
using (var database = BlankDatabaseFactory.MakeDatabase(dialect))
{
// Arrange
database.Insert(new Dog {
Name = "Some Name 1", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 2", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 3", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 4", Age = 11
});
// Act
var pageBuilder = new PageIndexPageBuilder(1, 10);
var entities = await database.GetPageAsync <Dog>(pageBuilder, "Age", new { Age = 10 });
// Assert
entities.Items.Count().Should().Be(3);
}
}
public void Gets_first_page(IDialect dialect)
{
using (var database = BlankDatabaseFactory.MakeDatabase(dialect))
{
// Arrange
database.Insert(new Dog {
Name = "Some Name 1", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 2", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 3", Age = 10
});
database.Insert(new Dog {
Name = "Some Name 4", Age = 11
});
// Act
var pageBuilder = new PageIndexPageBuilder(1, 2);
var page = database.GetPage <Dog>(pageBuilder, "Age", new { Age = 10 });
var entities = page.Items;
// Assert
entities.Count().Should().Be(2);
entities[0].Name.Should().Be("Some Name 1");
entities[1].Name.Should().Be("Some Name 2");
}
}
public async Task Returns_empty_list_when_there_are_no_entities(IDialect dialect)
{
using (var database = BlankDatabaseFactory.MakeDatabase(dialect))
{
// Act
var pageBuilder = new PageIndexPageBuilder(1, 10);
var entities = await database.GetPageAsync <Dog>(pageBuilder, null, "Age");
// Assert
entities.Items.Count().Should().Be(0);
}
}
public void Returns_empty_list_when_there_are_no_entities(IDialect dialect)
{
using (var database = BlankDatabaseFactory.MakeDatabase(dialect))
{
// Arrange
// Act
var pageBuilder = new PageIndexPageBuilder(1, 10);
var entities = database.GetPage <Dog>(pageBuilder, "Age", new { Age = 10 });
// Assert
entities.Items.Should().BeEmpty();
}
}
