public void can_set_query_pagination(int page, int size)
{
FakeQuery query;
query = new FakeQuery()
.setPage(page, size);
query.Pagination.Should().NotBeNull();
query.Pagination.Page.Should().Be(page);
query.Pagination.Size.Should().Be(size);
}
public void can_set_query_order(string column, OrderDirection direction)
{
FakeQuery query;
query = new FakeQuery()
.setOrder(column, direction);
query.Order.Should().NotBeNull();
query.Order.Should().HaveCount(1);
query.Order.First().Column.Should().Be(column);
query.Order.First().Direction.Should().Be(direction);
}
public void can_add_tables_to_query(string table1, string table2, string table3)
{
IQuery query;
query = new FakeQuery();
query
.addTables(table1)
.addTables(table2)
.addTables(table3);
query.Tables.ToString().Should().Be(@$ "{table1}
{table2}
{table3}
");
}
public void can_add_columns_to_query(string column1, string column2, string column3)
{
IQuery query;
query = new FakeQuery();
query
.addColumns(column1)
.addColumns(column2)
.addColumns(column3);
query.Columns.ToString().Should().Be(@$ "{column1}
{column2}
{column3}
");
}
public void can_set_query_parameters_from_object(Product product)
{
FakeQuery query;
query = new FakeQuery().setParameters(product);
query.Parameters.Should().HaveCount(3);
query.Parameters
.Single(p => p.ParameterName == nameof(Product.Id))
.Value.Should().Be(product.Id);
query.Parameters
.Single(p => p.ParameterName == nameof(Product.Name))
.Value.Should().Be(product.Name);
query.Parameters
.Single(p => p.ParameterName == nameof(Product.Price))
.Value.Should().Be(product.Price);
}
