private void VerifyDocuments(QueryWithUrlPagingCommand command, int startInclusive, int lastIdInclusive, int?cappedMaxResults)
{
var expectedCount = lastIdInclusive - startInclusive + 1;
Assert.Equal(expectedCount, command.Result.Results.Length);
Assert.Equal(cappedMaxResults, command.Result.CappedMaxResults);
if (expectedCount > 0)
{
var firstObjectId = ((BlittableJsonReaderObject)((BlittableJsonReaderObject)command.Result.Results[0])["@metadata"])["@id"] as LazyStringValue;
Assert.Equal("users/" + startInclusive, firstObjectId.ToString());
var lastObjectId = ((BlittableJsonReaderObject)((BlittableJsonReaderObject)command.Result.Results[command.Result.Results.Length - 1])["@metadata"])["@id"] as LazyStringValue;
Assert.Equal("users/" + lastIdInclusive, lastObjectId.ToString());
}
}
public void CanLimitOffsetCollectionQuery()
{
using (var store = GetDocumentStore())
{
InsertUsers(store);
var requestExecutor = store.GetRequestExecutor();
QueryWithUrlPagingCommand command;
using (var session = store.OpenSession())
{
// without offset
{
// try to get all users
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users", 0, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 101, 300, null);
// try to get with RQL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 20", 0, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 101, 120, 20);
// try to get with URL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users", 0, 20), session.Advanced.Context);
VerifyDocuments(command, 101, 120, null);
// try to get with both limits RQL > URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 20", 0, 10), session.Advanced.Context);
VerifyDocuments(command, 101, 110, 20);
// try to get with both limits RQL < URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 5", 0, 10), session.Advanced.Context);
VerifyDocuments(command, 101, 105, 5);
}
// with URL offset
{
// try to get all users
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users", 10, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 111, 300, null);
// try to get with RQL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 20", 20, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 121, 140, 20);
// try to get with URL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users", 30, 20), session.Advanced.Context);
VerifyDocuments(command, 131, 150, null);
// try to get with both limits RQL > URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 20", 40, 10), session.Advanced.Context);
VerifyDocuments(command, 141, 150, 20);
// try to get with both limits RQL < URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 5", 50, 10), session.Advanced.Context);
VerifyDocuments(command, 151, 155, 5);
}
// with RQL offset
{
// try to get all users
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users offset 10", 0, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 111, 300, 190);
// try to get with RQL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 20, 20", 0, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 121, 140, 20);
// try to get with URL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users offset 30", 0, 20), session.Advanced.Context);
VerifyDocuments(command, 131, 150, 170);
// try to get with both limits RQL > URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 40, 20", 0, 10), session.Advanced.Context);
VerifyDocuments(command, 141, 150, 20);
// try to get with both limits RQL < URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 50, 5", 0, 10), session.Advanced.Context);
VerifyDocuments(command, 151, 155, 5);
}
// with RQL & URL offset
{
// try to get all users
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users offset 10", 1, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 112, 300, 190);
// try to get with RQL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 20, 20", 2, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 123, 142, 20);
// try to get with URL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users offset 30", 3, 20), session.Advanced.Context);
VerifyDocuments(command, 134, 153, 170);
// try to get with both limits RQL > URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 40, 20", 4, 10), session.Advanced.Context);
VerifyDocuments(command, 145, 154, 20);
// try to get with both limits RQL < URL
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 50, 5", 5, 10), session.Advanced.Context);
VerifyDocuments(command, 156, 160, 5);
}
// capping to query limit
{
// try to get all users
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 1000", 0, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 101, 300, 200);
// huge URL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 50", 0, 1000), session.Advanced.Context);
VerifyDocuments(command, 101, 150, 50);
// huge RQL limit
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 1000", 0, 50), session.Advanced.Context);
VerifyDocuments(command, 101, 150, 200);
// huge URL & RQL limits
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 1000", 0, 2000), session.Advanced.Context);
VerifyDocuments(command, 101, 300, 200);
// try to get all users with offset
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 1000", 10, Int32.MaxValue), session.Advanced.Context);
VerifyDocuments(command, 111, 300, 200);
// huge URL limit with offset
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 50", 10, 1000), session.Advanced.Context);
VerifyDocuments(command, 111, 160, 50);
// huge RQL limit with offset
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 1000", 10, 50), session.Advanced.Context);
VerifyDocuments(command, 111, 160, 200);
// huge URL & RQL limits with offset
requestExecutor.Execute(command = new QueryWithUrlPagingCommand("from Users limit 1000", 10, 2000), session.Advanced.Context);
VerifyDocuments(command, 111, 300, 200);
}
}
}
}
