Useful Ecto extensions:
SortablePageableSearchableValidators
Documentation: https://hexdocs.pm/ecto_extensions
Please note: this project is a work-in-progress. Breaking changes may occur.
Add EctoExtensions to mix.exs:
[{:ecto_extensions, "~> 0.0.2"}]Repomodule:
defmodule BlogApp.Repo do
# ...
use EctoExtensions # <- add this!
endSchemamodule:
defmodule BlogApp.Post do
use Ecto.Schema
use EctoExtensions.Sortable, fields: [:title, :published_at],
default: {:published_at, :desc}
use EctoExtensions.Searchable, fields: [:title, :content]
schema "posts" do
field :title
field :content
field :published_at, :utc_datetime
end
endContextmodule:
defmodule BlogApp.Posts do
@doc """
## Params
* :search - search query string
* :sort_by - field to sort by
* :sort_order - :asc or :desc
* :page - integer
* :page_size - integer
"""
def list_posts(params) do
Post
|> Repo.search(Post, params)
|> Repo.sort(Post, params)
|> Repo.paginate(params)
end
endControllerandView:
defmodule BlogAppWeb.PostController do
def index(conn, params) do
page = Posts.list_posts(params)
render(conn, "index.json", %{page: page})
end
end
defmodule BlogAppWeb.PostView do
def render("index.json", %{page: page}) do
%{
page: page.page,
page_size: page.page_size,
total_pages: page.total_pages,
total_entries: page.total_entries,
posts: render_many(page.entries, PostView, "post.json")
}
end
def render("post.json", %{post: post}) do
# ...
end
endSchemamodule:
defmodule BlogApp.User do
use Ecto.Schema
import EctoExtensions.Validators # <- add this!
schema "users" do
field :email
end
def changeset(struct, params) do
struct
|> cast(params, [:email])
|> validate_email()
end
end- Fork it
mix deps.getmix ecto.reset- Make your changes
mix test- Create a pull-request
EctoExtensions is released under the MIT license. See LICENSE file for details.
EctoExtensions package is maintained by MLSDev, Inc. We specialize in providing all-in-one solution in mobile and web development. Our team follows Lean principles and works according to agile methodologies to deliver the best results reducing the budget for development and its timeline.
Find out more here and don't hesitate to contact us!
