lib/ecto/queryable.ex

defprotocol Ecto.Queryable do
  @moduledoc """
  Converts a data structure into an `Ecto.Query`.

  This is used by `Ecto.Repo` and also `from` macro. For example, `Repo.all`
  expects any queryable as argument, which is why you can do `Repo.all(MySchema)`
  or `Repo.all(query)`. Furthermore, when you write `from ALIAS in QUERYABLE`,
  `QUERYABLE` accepts any data structure that implements `Ecto.Queryable`.

  This module defines a few default implementations so let us go over each and
  how to use them.

  ## Atom

  The most common use case for this protocol is to convert atoms representing
  an `Ecto.Schema` module into a query. This is what happens when you write:

      query = from(p in Person)

  Or when you directly pass a schema to a repository:

      Repo.all(Person)

  In case you did not know, Elixir modules are just atoms. This implementation
  takes the provided module name and then tries to load the associated schema.
  If no schema exists, it will raise `Protocol.UndefinedError`.

  ## BitString

  This implementation allows you to directly specify a table that you would like
  to query from:

      from(
        p in "people",
        select: {p.first_name, p.last_name}
      )

  Or:

      Repo.delete_all("people")

  While this is quite simple to use, some repository operations, such as
  `Repo.all`, require a `select` clause. When you query a schema, the
  select is automatically defined for you based on the schema fields,
  but when you pass a table directly, you need to explicitly list them.
  This limitation now brings us to our next implementation!

  ## Tuple

  Similar to the `BitString` implementation, this allows you to specify the
  underlying table that you would like to query; however, this additionally
  allows you to specify the schema you would like to use:

      from(p in {"filtered_people", Person})

  This can be particularly useful if you have database views that filter or
  aggregate the underlying data of a table but share the same schema. This means
  that you can reuse the same schema while specifying a separate "source" for
  the data.

  ## Ecto.Query

  This is a simple pass through. After all, all `Ecto.Query` instances
  can be converted into `Ecto.Query`:

      Repo.all(from u in User, where: u.active)

  This also enables Ecto queries to compose, since we can pass one query
  as the source of another:

      active_users = from u in User, where: u.active
      ordered_active_users = from u in active_users, order_by: u.created_at

  ## Ecto.SubQuery

  Ecto also allows you to compose queries using subqueries.  Imagine you
  have a table of "people". Now imagine that you want to do something with
  people with the most common last names. To get that list, you could write
  something like:

      sub = from(
        p in Person,
        group_by: p.last_name,
        having: count(p.last_name) > 1,
        select: %{last_name: p.last_name, count: count(p.last_name)}
      )

  Now if you want to do something else with this data, perhaps join on
  additional tables and perform some calculations, you can do that as so:

      from(
        p in subquery(sub),
        # other filtering etc here
      )

  Please note that the `Ecto.Query.subquery/2` is needed here to convert the
  `Ecto.Query` into an instance of `Ecto.SubQuery`. This protocol then wraps
  it into an `Ecto.Query`, but using the provided subquery in the FROM clause.
  Please see `Ecto.Query.subquery/2` for more information.
  """

  @doc """
  Converts the given `data` into an `Ecto.Query`.
  """
  def to_query(data)
end

defimpl Ecto.Queryable, for: Ecto.Query do
  def to_query(query), do: query
end

defimpl Ecto.Queryable, for: Ecto.SubQuery do
  def to_query(subquery) do
    %Ecto.Query{from: %Ecto.Query.FromExpr{source: subquery}}
  end
end

defimpl Ecto.Queryable, for: BitString do
  def to_query(source) when is_binary(source) do
    %Ecto.Query{from: %Ecto.Query.FromExpr{source: {source, nil}}}
  end
end

defimpl Ecto.Queryable, for: Atom do
  def to_query(module) do
    try do
      module.__schema__(:query)
    rescue
      UndefinedFunctionError ->
        message =
          if :code.is_loaded(module) do
            "the given module does not provide a schema"
          else
            "the given module does not exist"
          end

        raise Protocol.UndefinedError, protocol: @protocol, value: module, description: message

      FunctionClauseError ->
        raise Protocol.UndefinedError, protocol: @protocol, value: module, description: "the given module is an embedded schema"
    end
  end
end

defimpl Ecto.Queryable, for: Tuple do
  def to_query({source, schema} = from)
      when is_binary(source) and is_atom(schema) and not is_nil(schema) do
    %Ecto.Query{from: %Ecto.Query.FromExpr{source: from, prefix: schema.__schema__(:prefix)}}
  end
end