QueryPagingSource
Create a PagingSource that pages through all results from the database
.
Queries will be executed without JOIN, WHERE, ORDER BY, or GROUP BY clauses. Call the version of QueryPagingSource
that takes a queryProvider
in order to append these clauses to the paging queries.
The PagingSource will do SQL offset/limit based paging. Use the select
statement and mapper
to map paged documents to objects.
Queries will be executed on context
.
Parameters
CoroutineContext
to execute queries on
query Select
statement
database to query
mapping function from JSON query results to objects
Create a PagingSource that pages through results according to queries generated by queryProvider
. queryProvider
receives a SELECT FROM database
and should append any necessary SQL JOIN, WHERE, ORDER BY, and GROUP BY clauses.
Queries returned by queryProvider
should expect the PagingSource to do SQL offset/limit based paging. queryProvider
will be called multiple times both as a count query for total records as well as with the select
statement with page offsets to retrieve documents, which are mapped to objects via the provided mapper
.
Queries will be executed on context
.
Parameters
CoroutineContext
to execute queries on
query Select
statement
database to query
mapping function from JSON query results to objects
query provider function