Current section

Files

Jump to
scrivener_ecto lib scrivener paginater ecto query.ex
Raw

lib/scrivener/paginater/ecto/query.ex

defimpl Scrivener.Paginater, for: Ecto.Query do
import Ecto.Query
alias Scrivener.{Config, Page}
@moduledoc false
@spec paginate(Ecto.Query.t, Scrivener.Config.t) :: Scrivener.Page.t
def paginate(query, %Config{page_size: page_size, page_number: page_number, module: repo, caller: caller}) do
total_entries = total_entries(query, repo, caller)
%Page{
page_size: page_size,
page_number: page_number,
entries: entries(query, repo, page_number, page_size, caller),
total_entries: total_entries,
total_pages: total_pages(total_entries, page_size)
}
end
defp entries(query, repo, page_number, page_size, caller) do
offset = page_size * (page_number - 1)
query
|> limit(^page_size)
|> offset(^offset)
|> repo.all(caller: caller)
end
defp total_entries(query, repo, caller) do
total_entries =
query
|> exclude(:preload)
|> exclude(:select)
|> exclude(:order_by)
|> subquery
|> select(count("*"))
|> repo.one(caller: caller)
total_entries || 0
end
defp total_pages(total_entries, page_size) do
(total_entries / page_size) |> Float.ceil |> round
end
end