Comparison operators.

Examples:

With "equal" condition

iex> Repo.insert!(%User{email: "bob@example.com"})
iex> Repo.insert!(%User{email: "alice@example.com"})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:email, :equal, "alice@example.com"}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).email
"alice@example.com"

Comparison with nil are supported:

iex> Repo.insert!(%User{email: "bob@example.com"})
iex> Repo.insert!(%User{email: nil})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:email, :equal, nil}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).email
nil

With "not equal" condition

iex> Repo.insert!(%User{email: "bob@example.com"})
iex> Repo.insert!(%User{email: "alice@example.com"})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:email, :not_equal, "alice@example.com"}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).email
"bob@example.com"

Comparison with nil are also supported:

iex> Repo.insert!(%User{email: "bob@example.com"})
iex> Repo.insert!(%User{email: nil})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:email, :not_equal, nil}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).email
"bob@example.com"

With "equal_one_of" condition

iex> Repo.insert!(%User{email: "bob@example.com"})
iex> Repo.insert!(%User{email: "alice@example.com"})
iex> Repo.insert!(%User{email: "eve@example.com"})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:email, :equal_one_of, ["alice@example.com", "bob@example.com"]}])
...>   |> Repo.all()
iex> length(result)
2
iex> Enum.map(result, fn user -> user.email end)
["bob@example.com", "alice@example.com"]

With "less than or equal" condition

iex> Repo.insert!(%User{age: 17})
iex> Repo.insert!(%User{age: 18})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:age, :less_than_or_equal, 17}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).age
17

With "greater than or equal" condition

iex> Repo.insert!(%User{age: 17})
iex> Repo.insert!(%User{age: 18})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:age, :greater_than_or_equal, 18}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).age
18

With "less than" condition

iex> Repo.insert!(%User{age: 17})
iex> Repo.insert!(%User{age: 21})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:age, :less_than, 20}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).age
17

With "greater than" condition

iex> Repo.insert!(%User{age: 17})
iex> Repo.insert!(%User{age: 21})
iex> result =
...>   User
...>   |> EctoFilter.filter([{:age, :greater_than, 18}])
...>   |> Repo.all()
iex> length(result)
1
iex> hd(result).age
21