hi all, when using paging on sqldelight, how can w...

# squarelibraries

[brabo-hi]

hi all, when using paging on sqldelight, how can we handle query filtered?

countPlayers:
SELECT count(*) FROM hockeyPlayer WHERE full_name = ?;

players:
SELECT *
FROM hockeyPlayer WHERE full_name = ?
LIMIT :limit OFFSET :offset;

val pagingSource: PagingSource = QueryPagingSource(
  countQuery = playerQueries.countPlayers(full_name),
  transacter = playerQueries,
  dispatcher = <http://Dispatchers.IO|Dispatchers.IO>,
  queryProvider = playerQueries.players(full_name), // <---- issue
)

[alec]

val pagingSource: PagingSource = QueryPagingSource(
  countQuery = playerQueries.countPlayers(full_name),
  transacter = playerQueries,
  dispatcher = <http://Dispatchers.IO|Dispatchers.IO>,
  queryProvider = { limit, offset ->
      playerQueries.players(full_name, limit, offset) // <---- issue
  }
)

[brabo-hi]

@alec thanks you saved my weekend