Ecto Extras

Simple helper functions for Ecto.Repo and Ecto.Query that I find missing from the default implementation.

Ecto.Repo helpers (API docs)

first first! last last! count min max avg sum

Setup:

defmodule YourApp.Repo do
  use EctoExtras.Repo
  # ...
end

Example usage:

Repo.count(User)

# instead of

Repo.one(from u in User, select: count(u.id))

Ecto.Query helpers (API docs)

lower upper

Example usage:

import EctoExtras.Query

Repo.one(from u in User, where: lower(u.email) == "[email protected]")

# instead of

Repo.one(from u in User, where: fragment("lower(?)", u.email) == "[email protected]")