Packages

selecto

0.2.4
0.4.6 0.4.5 0.4.3 0.4.1 0.4.0 0.3.16 0.3.15 0.3.14 0.3.13 0.3.12 0.3.11 0.3.10 0.3.8 0.3.5 0.3.4 0.3.3 0.3.2 0.3.1 0.3.0 0.2.6 0.2.4 0.2.3 0.2.2 0.2.1 0.2.0 0.1.3 0.1.2 0.1.0

Alpha: composable SQL query builder for Elixir domains with joins, CTEs, OLAP, and hierarchical patterns

HexDocs

Current section

Files

Jump to
Readme
28 Versions
3 Dependencies
Dependants
Files
Activity
selecto lib selecto builder sql order.ex
Raw

lib/selecto/builder/sql/order.ex 

defmodule Selecto.Builder.Sql.Order do

  @dirs %{

    asc: "asc",

    desc: "desc",

    asc_nulls_first: "asc nulls first",

    asc_nulls_last: "asc nulls last",

    desc_nulls_first: "desc nulls first",

    desc_nulls_last: "desc nulls last"

  }



  @dir_list [

    :asc,

    :desc,

    :asc_nulls_first,

    :asc_nulls_last,

    :desc_nulls_first,

    :desc_nulls_last

  ]



  def order(selecto, {dir, order}) when dir in @dir_list do

    {c, j, p, a} = Selecto.Builder.Sql.Select.build(selecto, order)

    {j, "#{c} #{@dirs[dir]}", p}

  end



  def order(selecto, order_by) do

    order(selecto, {:asc_nulls_first, order_by})

  end



  def build(selecto) do

    {joins, clauses, params} =

      selecto.set.order_by

      |> Enum.reduce(

        {[], [], []},

        fn g, {joins, clauses, params} ->

          {j, c, p} = order(selecto, g)

          {joins ++ [j], clauses ++ [c], params ++ p}

        end

      )



    {joins, Enum.join(clauses, ", "), params}

  end

end