bluzky
A small library to build Ecto query from map
I have just released a small library that help to build query from a map with structure similar to Mongo DB filter like this:
Filtery.apply(Post, %{name: {:like, "elixir"}, is_draft: false, tags: {:has, "ecto"} })
Here is the repo:
It’s quite simple and supports filtering on a single table only.
It supports basic operators eq, :gt, :gte, :in, :lt, :lte, :ne, :nin, :and, :or and some other helpful operators. And you can define your own operators too.
Please try and leave your feedback. Thank you.
Update v0.2.0
I have added a special operator ref to join multiple table
query = Filtery.apply(Post, %{comments: {:ref, %{
approved: true,
content: {:like, "filtery"}
}}})
comments field must be the association name in your Post schema
Most Liked
mathieuprog
This looks similar to my library QueryBuilder 
It’s possible to have joins.
Possible to make a query out of a keyword list with QueryBuilder.from_list/2.
marciol
It’s really nice to have ways of building queries using a more data-driven approach. It’s really awesome
bluzky
I have added new operator for querying join table. Please check update above.
subbu
This is neat. It will work well for simple use cases. Its also good in way that you can build filters progressively as its a map. But its use will be limited as most production use-cases will involve multi-table filtering.
bluzky
Filtery.apply return a query so you can chain as many time as you want like this
Post
|> Filtery.apply(%{title: {:not, {:like, "elixir"}}})
|> Filtery.apply(%{is_draft: false, comment_count: {:gt, 10}})
|> Repo.all()
I have been thinking of a simple specification to define a join filter but there is not good enough solution.
Do you have any suggestion?
Popular in Libraries
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Practical resources that improve the lives of professional developers. By developers, for developers.
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.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
Courses that'll move you from confusion to "Aha, now I get it!"