Packages

kaffy

0.1.1
0.11.0 0.10.3 0.10.2 0.10.1 retired 0.10.0 0.10.0-rc.3 0.10.0-rc.2 0.10.0-rc.1 0.10.0-rc.0 0.9.4 0.9.3 0.9.2 0.9.1 0.9.0 0.8.1 0.8.0 0.7.1 0.7.0 0.6.2 0.6.1 0.6.0 0.5.1 0.5.0 0.4.1 0.4.0 0.3.2 0.3.1 0.3.0 0.2.1 0.2.0 0.1.2 0.1.1 0.1.0

Powerfully simple admin package for phoenix applications

HexDocs

Current section

Files

Jump to
Readme
33 Versions
3 Dependencies
Dependants
Files
Activity
kaffy lib kaffy resource_query.ex
Raw

lib/kaffy/resource_query.ex 

defmodule Kaffy.ResourceQuery do

  import Ecto.Query



  def list_resource(resource, params \\ %{}) do

    per_page = Map.get(params, "limit", "100") |> String.to_integer()

    page = Map.get(params, "page", "1") |> String.to_integer()

    default_ordering = Kaffy.ResourceAdmin.ordering(resource)

    ordering = Map.get(params, "ordering", default_ordering)

    current_offset = (page - 1) * per_page

    schema = resource[:schema]



    from(s in schema, limit: ^per_page, offset: ^current_offset, order_by: ^ordering)

    |> Kaffy.Utils.repo().all()

  end



  def fetch_resource(resource, id) do

    schema = resource[:schema]

    Kaffy.Utils.repo().get(schema, id)

  end



  def total_pages(resource, params \\ %{}) do

    schema = resource[:schema]

    per_page = Map.get(params, "limit", "100") |> String.to_integer()



    total =

      from(s in schema, select: count(s.id))

      |> Kaffy.Utils.repo().one()



    :math.ceil(total / per_page)

  end

end