| public PageQuery ( SqlQuery sqlQuery, PagingOptions pagingOptions ) : SqlQuery | ||
| sqlQuery | SqlQuery | |
| pagingOptions | PagingOptions | |
| return | SqlQuery | |
public void PageWithNoWhereOrOrderBySecondResultsPage()
{
var sqlDialect = new FirebirdSqlDialect();
var sqlQuery = new SqlQuery("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers");
var paged = sqlDialect.PageQuery(sqlQuery, PagingOptions.ForPage(page: 2, resultsPerPage: 25));
Assert.Equal("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers ROWS @p0 TO @p1", paged.CommandText);
Assert.Equal(DbType.Int32, paged.Arguments[0].DbType);
Assert.Equal(26, paged.Arguments[0].Value);
Assert.Equal(DbType.Int32, paged.Arguments[1].DbType);
Assert.Equal(50, paged.Arguments[1].Value);
}
public void PageWithWhereButNoOrderBy()
{
var sqlDialect = new FirebirdSqlDialect();
var sqlQuery = new SqlQuery("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers WHERE CustomerStatusId = @p0", CustomerStatus.Active);
var paged = sqlDialect.PageQuery(sqlQuery, PagingOptions.ForPage(page: 1, resultsPerPage: 25));
Assert.Equal("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers WHERE CustomerStatusId = @p0 ROWS @p1 TO @p2", paged.CommandText);
Assert.Equal(sqlQuery.Arguments[0], paged.Arguments[0]);
Assert.Equal(DbType.Int32, paged.Arguments[1].DbType);
Assert.Equal(1, paged.Arguments[1].Value);
Assert.Equal(DbType.Int32, paged.Arguments[2].DbType);
Assert.Equal(25, paged.Arguments[2].Value);
}
public void PageWithMultiWhereAndMultiOrderByMultiLine()
{
var sqlDialect = new FirebirdSqlDialect();
var sqlQuery = new SqlQuery(@"SELECT
CustomerId,
Name,
DateOfBirth,
CustomerStatusId
FROM
Customers
WHERE
(CustomerStatusId = @p0 AND DoB > @p1)
ORDER BY
Name ASC,
DoB ASC", CustomerStatus.Active, new DateTime(1980, 01, 01));
var paged = sqlDialect.PageQuery(sqlQuery, PagingOptions.ForPage(page: 1, resultsPerPage: 25));
Assert.Equal("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers WHERE (CustomerStatusId = @p0 AND DoB > @p1) ORDER BY Name ASC, DoB ASC ROWS @p2 TO @p3", paged.CommandText);
Assert.Equal(sqlQuery.Arguments[0], paged.Arguments[0]);
Assert.Equal(sqlQuery.Arguments[1], paged.Arguments[1]);
Assert.Equal(DbType.Int32, paged.Arguments[2].DbType);
Assert.Equal(1, paged.Arguments[2].Value);
Assert.Equal(DbType.Int32, paged.Arguments[3].DbType);
Assert.Equal(25, paged.Arguments[3].Value);
}
public void PageQueryThrowsArgumentNullExceptionForNullSqlCharacters()
{
var sqlDialect = new FirebirdSqlDialect();
var exception = Assert.Throws<ArgumentNullException>(
() => sqlDialect.PageQuery(null, PagingOptions.None));
}
public void PageNonQualifiedWildcardQuery()
{
var sqlDialect = new FirebirdSqlDialect();
var sqlQuery = new SqlQuery("SELECT * FROM Customers");
var paged = sqlDialect.PageQuery(sqlQuery, PagingOptions.ForPage(page: 1, resultsPerPage: 25));
Assert.Equal("SELECT * FROM Customers ROWS @p0 TO @p1", paged.CommandText);
Assert.Equal(DbType.Int32, paged.Arguments[0].DbType);
Assert.Equal(1, paged.Arguments[0].Value);
Assert.Equal(DbType.Int32, paged.Arguments[1].DbType);
Assert.Equal(25, paged.Arguments[1].Value);
}
public void PageNonQualifiedQuery()
{
var sqlQuery = new SqlQuery("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers");
var sqlDialect = new FirebirdSqlDialect();
var paged = sqlDialect.PageQuery(sqlQuery, PagingOptions.ForPage(page: 1, resultsPerPage: 25));
Assert.Equal("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers ROWS @p0 TO @p1", paged.CommandText);
Assert.Equal(1, paged.Arguments[0]);
Assert.Equal(25, paged.Arguments[1]);
}
public void PageWithWhereAndOrderByMultiLine()
{
var sqlQuery = new SqlQuery(@"SELECT
CustomerId,
Name,
DateOfBirth,
CustomerStatusId
FROM
Customers
WHERE
CustomerStatusId = @p0
ORDER BY
Name ASC", new object[] { CustomerStatus.Active });
var sqlDialect = new FirebirdSqlDialect();
var paged = sqlDialect.PageQuery(sqlQuery, PagingOptions.ForPage(page: 1, resultsPerPage: 25));
Assert.Equal("SELECT CustomerId, Name, DateOfBirth, CustomerStatusId FROM Customers WHERE CustomerStatusId = @p0 ORDER BY Name ASC ROWS @p1 TO @p2", paged.CommandText);
Assert.Equal(sqlQuery.Arguments[0], paged.Arguments[0]);
Assert.Equal(1, paged.Arguments[1]);
Assert.Equal(25, paged.Arguments[2]);
}
