acrolink
How to pass "asc" or "desc" to the Ecto.query function
I have created some basic select list (asc, desc). I want to pass either strings to Ecto.query.
# order by order_by_expires
def order_by_expires(query, nil), do: query
def order_by_expires(query, direction) do
query |> order_by(direction: :expires)
end
The above does not work, I get the error:
Ecto.Query.CompileError) expected :asc, :desc or interpolated value in order_by, got: :direction
Marked As Solved
t0t0
I think you need to write:
order_by({direction, :expires})
Else direction: is the atom :direction.
I guess direction has to be converted to atom first:
if direction in ~W[asc desc], do: String.to_existing_atom(direction), else: :asc
Or much better, do pattern matching on direction:
defp do_order_by_expires(query, direction) do
query |> order_by({direction, :expires})
end
def order_by_expires(query, "desc") do
do_order_by_expires(query, :desc)
end
def order_by_expires(query, _) do
do_order_by_expires(query, :asc)
end
Also Liked
josevalim
Move the assignment out of the if:
def order_by_expires(query, direction) do
direction = if direction in ~W[asc desc], do: String.to_existing_atom(direction), else: :asc
query |> order_by({^direction, :expires})
end
You can also simplify it to:
def order_by_expires(query, direction) do
direction = if direction == "desc", do: :desc, else: :asc
query |> order_by({^direction, :expires})
end
acrolink
A little modification was needed to get it to work:
defp do_order_by_expires(query, direction) do
query |> order_by({^direction, :expires})
end
Thank you.
Popular in Questions
Other popular topics
Latest on Elixir Forum
Sponsor Spotlight
Enabling companies to succeed by building software people love.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #blog-post
- #graphql
- #genstage
- #ai
- #websockets
- #supervisor
- #advent-of-code
- #elixirconf-us
- #distillery
- #processes
- #forms
- #api
- #metaprogramming
- #security
- #performance
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.
Error tracking for Elixir devs who love to ship. Start your free account.
Practical resources that improve the lives of professional developers.
Producing high quality Elixir screencasts since 2017.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"