Packages

selecto

0.2.2
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
2 Dependencies
Dependants
Files
Activity
selecto lib selecto builder sql group.ex
Raw

lib/selecto/builder/sql/group.ex 

defmodule Selecto.Builder.Sql.Group do

  def group(selecto, rollup: groups) do

    {joins, clauses, params} = group(selecto, groups)

    {joins, "rollup( #{clauses} )", params}

  end



  def group(selecto, groups) when is_list(groups) do

    {joins, clauses, params} =

      groups

      |> Enum.reduce(

        {[], [], []},

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

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

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

        end

      )



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

  end



  def group(selecto, group_by) do

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

    {j, c, p}

  end



  def build(selecto) do

    group(selecto, selecto.set.group_by)

  end

end