senconscious
Package for sorting ecto query
EctoJuno is a package that provides parsing, validation and applying sorting parameters for your ecto queries on models. Currently sorting by joint query is not implemented, as well as custom validators for your parameters. Also you need elixir 1.14 to use this package. Hope this package will help someone not just me ). Looking for a feedback, so if you have any thoughts, please share.
Below is a sample usage of library (assuming you have User ecto schema and Repo module):
alias EctoJuno.Query.Sorting
def list_sorted_users_for_admin(params) do
User
|> Sorting.sort_query(User, params)
|> Repo.all()
end
def list_sorted_users_for_manager(params) do
User
|> Sorting.sort_query([:id, :inserted_at], params)
|> Repo.all()
end
First Post!
senconscious
Released v0.2.0 version in which added sorting by joint query.
Let’s assume you have User and Post schemas, Repo module. And users has many posts. If you need sort users by post’s titles than your code will look like:
alias EctoJuno.Query.Sorting
def sort_users_by_posts do
params = %{"sort_by" => "title", "sort_direction" => "desc"}
User
|> join(:left, [u], p in assoc(u, :posts), as: :posts)
|> Sorting.sort_query(User, params, :posts)
|> Repo.all()
end
In the next version there’ll be sorting templates: you can define which schema and or binding will be used based on sorting field you passing by
Popular in RFCs
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Producing high quality Elixir screencasts since 2017.
Categories:
Sub Categories:
Forums
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"