Packages

ecto_extras

0.1.0
0.1.3 0.1.2 0.1.1 0.1.0 0.0.1

Ecto helper functions.

HexDocs

Current section

Files

Jump to
Readme
5 Versions
1 Dependency
0 Dependants
Files
Activity
ecto_extras README.md
Raw

README.md 

# Ecto Extras [![Hex.pm](https://img.shields.io/hexpm/v/ecto_extras.svg)](https://hex.pm/packages/ecto_extras) [![Hex.pm](https://img.shields.io/hexpm/l/ecto_extras.svg)](https://github.com/pawurb/ecto_extras/blob/master/LICENSE) [![CI](https://github.com/pawurb/ecto_extras/workflows/CI/badge.svg)](https://github.com/pawurb/ecto_extras/actions)
A set of helper functions for `Ecto.Repo` and `Ecto.Query`
### `Ecto.Repo` helpers
`first` `first!` `last` `last!` `count` `min` `max` `avg` `sum`
Setup:
```elixir
defmodule YourApp.Repo do
  use EctoExtras.Repo
  # ...
end
```
Example usage:
```elixir
Repo.count(User)
# instead of
Repo.one(from u in User, select: count(u.id))
```
### `Ecto.Query` helpers
`lower` `upper`
Example usage:
```elixir
import EctoExtras.Query
Repo.one(from u in User, where: lower(u.email) == "email@example.com")
# instead of
Repo.one(from u in User, where: fragment("lower(?)", u.email) == "email@example.com")
```